PSFS IQ - Offering: How to create a Batch Reconciliation Report

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)

2018-04-24_10-18-06.png

  

(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

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.