1. Home
  2. UniformPay
  3. Sales and Deposit Reconciliation

Sales and Deposit Reconciliation

Sales Day vs Batch Day

Many of our merchants historically have used the Cash Flow Summary report to reconcile their credit card receipts for the day. If those totals match, they will then compare the total to their bank deposits.

The Sales Day in The Uniform Solution runs from 12:00 AM to 11:59 PM CT. This is the time frame that the Cash Flow Summary looks to for totals.

The Batch Day in the Merchant Portal runs from 8:06 PM to 8:05 PM CT. This encapsulates the sales that make up the daily deposit in the Funding Summary Report in MerchantTrack.

The difference in time frames can cause some confusion when trying to compare the Cash Flow Summary to the Funding Summary Report. Deposit Reconciliation can help you verify your sales totals are matching your deposits.

Daily Sales and Batch Times

In Deposit Reconciliation each row represents a 24 hour period that runs from 12:00 AM to 11:59 PM CT on a given date.

  • Payments: Contains the gross sales for the day.
  • Deposit #1: Contains the sales from 12:00 AM to 8:05 PM CT that day.
  • Deposit #2: Contains the sales from 8:06 PM to 11:59 PM CT that day.

Cash Flow vs Deposits

Comparing the Cash Flow Summary to the Sales Day is very straight forward. The total of Deposit #1 Gross and Deposit #2 Gross should equal the total amount of Credit and Debit Cards in the Cash Flow Summary run for the same date as date in the Payments section.

Reconciliation vs Funding Summary

Once you have verified that the Cash Flow Summary matches what is in Deposit Reconciliation, you can then calculate the deposit.

Add the current day’s Deposit #1 Gross to the previous day’s Deposit #2 Gross. The two gross amounts cover the Batch Day from 8:06 PM CT the previous evening to 8:05PM CT of the current evening. This should equal the gross amount in the Funding Summary Report for sales from that Batch Day.

The dates in the Deposit #2 and Deposit #1 sections reflect the date the deposit was made to your bank and recorded in the Funding Summary Report.

Please note that the final net deposit to your bank may differ from the gross based on your fee schedule. The net deposit and fees can be viewed in the Funding Summary Report.

Updated on November 30, 2021

Was this article helpful?

Related Articles