Reconciling Payments Hub Deposit Amounts in Cloud Retailer

Modified on Thu, 27 Jun at 8:24 AM

Overview

This article will outline the elements that can affect your deposit and how to best reconcile those deposit amounts with your sales data in Cloud Retailer.



Reconciling Deposits

Cloud Retailer can not access your Payments Hub data but reconciling the deposit amount in Cloud Retailer is simple.


Viewing your deposit amount in Payments Hub

  1. Log into your Payments Hub portal
  2. Navigate to Deposits
  3. Select the day/dates to view your deposit amounts
  4. Click on the deposit to open a window on the right side.  This window will show all the deposit information in detail, including the total sales amount and any fees removed prior to the deposit.
    1. Take note of the total transaction amount
    2. Take note of the total fee amount.  This total will likely always be $0.00 unless you are processing with Dual Pricing.



Using an example from Payments Hub:


Viewing your credit card sales amount in Cloud Retailer

  1. Log into your Cloud Retailer back office
  2. Navigate to Tools -> End of day reconciliation
  3. Set the Start Time and End Time to the correct date
    1. Set a specific location if you are attempting to reconcile a deposit for a specific location
  4. Click Search


On the Cloud Retailer End of Day Report:


Split Deposits

If you notice split deposits where you only receive a portion of yesterday's sales, then this section is for you.  When a terminal is batched, any transactions completed after 9:00 PM EST will not be eligible for next-day deposit.  This article will assist in reconciling the deposit amount with the sales in Cloud Retailer using the Advanced Credit Card Processing Details report.  


Feel free to contact us if you have questions related to the split.  



Matching your split deposit amount in Cloud Retailer

  1. Log into your Back Office
  2. Navigate to the Advanced Credit Card processing Details report
  3. Set the Trans Start Time
    1. Example: If you want to reconcile the deposit on 1/11/2024 and are located in the Central Time Zone, the Trans Start Time would be set to 1/9/2024 8:00 PM
  4. Set the Trans End Time
    1. Example: If you want to reconcile the deposit on 1/11/2024 and are located in the Central Time Zone, the Trans End Time would be set to 1/10/2024 7:59 PM 
  5. Click the magnifying glass to run the report
  6. Compare the report results total with the total transaction amount from your Payments Hub portal, Step 5 in the previous section.


This process will also help reconcile specific card type amounts as the report can sort by card type and the NAB monthly statements provide a detailed breakdown by card type as well.


Other Related References

Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article