How to create a batch transaction report with Reconciliation Mode
We've made it easier for bookkeepers and parish business managers to reconcile their bank statements with data in the eCatholic Payments Center. The new Reconciliation Mode clearly groups batches by settlement date and also provides a convenient total batch amount with each grouping.
Here's how to generate a batch transaction PDF report with Reconciliation Mode!
Go to the Payments Center > Transactions / Reporting
Log in to your eCatholic-powered website and click Payments in the blue Admin Toolbar to access your Payments Center (pictured below). Once in the Payments Center, the Transactions / Reporting tab will display your Transactions List for all accounts and subaccounts within the current month by default.
NOTE: Only users assigned FULL Payment Security will have access to run reports as described in this article.
Filter your transactions (if desired)
In the Transactions / Reporting tab, use the Filter & Search Options to include/exclude specific transactions, account, and subaccounts from your report if desired. You can also generate a report based on a custom date range. (Learn more: How to search and filter your transactions to run reports)
Turn on Reconciliation Mode
After you've filtered your Transactions List as desired, toggle on Reconciliation Mode.
Then, the list will re-load and your transactions will be sorted into batch groupings.
For easier reconciliation with your bank statement:
- Credit card transactions will be organized into batches grouped by Settlement ID.
- ACH transactions will be organized into batches grouped by Reserve ID.
Export your Reconciliation Mode batch report as a PDF
As a final step, you may export your batch transaction report as a PDF file or a CSV file by selecting the appropriate option from the Download options in the top right area of your Transactions List.
When you use the PDF option, it will export a file that includes the settlement information (example below)