Question - Can I update my settings so batches settle at midnight in my time zone? My deposits are not matching my daily flash or ledger balance report.
Answer - You're right that our batch schedule doesn't exactly update following the calendar day. Your batches will typically close at midnight US Eastern time, so there will usually be a difference in the total between the batch and your Daily Flash report, which measures using a calendar day. Unfortunately, we are unable to change the reporting period for either the Daily Flash or the processing batch at this time.
If you're looking to anticipate future bank deposits or match deposit records against innRoad reporting, the Deposits tab screen within the Payments Dashboard (found in the Reports module) will show your deposits and allow you to export a list of transactions included in each batch.
If you'd like to see a full accounting including non-credit card payments, you can use our Ledger Balances report, which you can find in the Reports module. Choose the "Shift Report" type and update the times to match your batch schedule (E.g. June 20, 9:30 PM to June 21, 9:30 PM). Select "All Users" and scroll down to the Payment Method section and select all.
This will give you a record of all transactions of all types within the batch period. Please note that because of deductions due to fees and chargebacks, your deposit report in the Payments Dashboard is the only report that will actually match your bank deposit.
Daily Flash Reconciliation to Deposit Report
As you know, the Daily Flash Report’s Total Receipts number represents the sum of the payments, refunds, and cancellations taken on a given day.
You can take the Total Receipts for the day and compare that to the total of the transactions made on that day, to ensure all stays are accounted for in the deposit amounts.
Using the Deposit download, we can find the transactions for that same day, using the transaction Date, Time field. (Highlighted in yellow here)
By adding the values in the “Amount” column that match the Transaction Date, we can get a sum of transactions for that date - $8413.92 for 8/10/21. This matches the Total Receipts from the Daily Flash for that same day.
We can then look at the Expected Deposit Date for that same set of transactions. In this case, two occurred after the cutoff, and so will be included in the next bank deposit.
This leaves the Net amounts for the transactions in the batch (green highlight above), which should match the bank deposit for that day. In the example above, $7081.92 was in the deposit generated Aug 11, 2021 and landing in your account Aug 12, with the remaining $1059.33 going into the next deposit of $6136.50, generated on Aug 12 and landing Aug 13.
In this way, the Daily Flash Total Receipts can be accounted for in the Payments Dashboard Deposits, with an indication of which transactions have been rolled into the subsequent deposit.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article