Our gateway Provider, USAEPAY, has some really great reports to help you audit your credit card deposits going into your business banking account.
If you have access to log into USAEPAY, they have some reports that will show you your batch history. Those will match up with your bank deposits. You can even get details of what transactions made up that batch. Let me show you:
In USAEPAY, go to Reports > Batch History
You will see the date of each batch and the total Sales Amount. Typically the Sales Amount will most likely match up with your deposit amount in your bank.
If you want to know the details of what transactions were in the batch, then double click on a batch to see the detail. This can be cross referenced with Spark transaction report.
Frequently Asked Questions
“Why does my dashboard say x and the deposits do not match?”
The Spark Dashboard shows a date range of this month only, and includes cash, credit card, checks and EFT/ACH. You would have to total all sources of deposits to match the numbers.
Second, understand how credit card batches work. If you have a transaction that happens after the current day’s batch has been closed, that transactions is assigned to the next day. Most businesses close their batches early each day to get next day or two day funding, so any transaction that is after the closing of the batch will be deposited on another day.
Third, if a transaction happens on the last day of the previous month, it takes a few days for that transaction to deposit, spilling over into the next month. Typically business owners run reports from the first of the month till the last day in a month not realizing that some of those transactions will spill into the next month, or from the previous month. Looking at per batch time will make this easier to reconcile.
"How can I get access to the USAEPAY Dashboard?”
Message us in our in-app chat and we can help you.