CardPointe Batch ID and Settlement Date are available as fields in Reporting. This lets you reconcile the deposits that land in your bank account against the individual iDonate transactions that make up each deposit, without leaving Reporting.
Note: These fields will only populate for organizations that use CardConnect (CardPointe) as their payment gateway.
How Reconciliation Works
When CardPointe settles a batch of transactions, it groups them under a single Batch ID and assigns a Settlement Date. That batch corresponds to a single deposit in your bank account. By adding these two fields to your Donations report, you can group iDonate transactions by batch and confirm that the total of each batch matches the deposit you received.
Keep in mind that CardConnect deposits may appear on your bank statement under a processor descriptor rather than your organization's name. If you are unsure which line item corresponds to a batch, see Identifying Charges on Your Bank Statement.
Adding the Batch Fields to a Report
- Navigate to Reporting > Donations.
- Click the Columns icon to open the Edit Table Columns panel.
- In the Transaction Info section or via search, select Batch ID and Settlement Date.
- Close the panel. Both fields now appear as columns in your table and as filter options.
Once added, you can sort and filter either field just like any other column. To compare a batch against a bank deposit, filter by Batch ID and review the transaction totals for that batch.
Recommended Saved View
To make reconciliation a repeatable routine, save a view with the Batch fields displayed and filtered to a recent period. A common setup is Created Date = Last month, which keeps the view focused on the transactions you are most likely to be reconciling.
- Add Batch ID and Settlement Date as described above.
- Apply a Created Date filter set to Last month.
- Click Create New View, name it, and save.
For full details on creating, sharing, and managing views, see Working with Saved Views.