How to create a Batch Reconciliation Report
If you need to reconcile a batch to a bank deposit you may produce an IQ Batch Report with total contributions broken out by fund and payment type, using the following Conditions and Results:
Conditions: Add "Batch: Batch ID: is equal to: Batch ID" (Where Batch ID is from the Batch ID column on the Batch Management screen as shown in screen A below)"; see screen B below see see where conditions are added.
Results: Add "Funds: Fund Name," "Contributions: Payment Amount," and "Contributions: Payment Type" (in addition to whatever else you want)
Output: Export the results of the query to a CSV file
(A)
(B)
This will produce a batch report with total contributions broken out by fund and payment type.
Related Articles
How to create a batch detail report in IQ sorted alphabetically
How to create a contribution query for a date range with envelope numbers
Comments
Please sign in to leave a comment.