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

Top