CNFS- IQ: How to Create A Batch Reconciliation Report

 

If you need to reconcile your batch to your bank deposit based on total contributions to fund, and by payment type, this report could be produced in the IQ module by adding "Batch: Batch ID: is equal to: (Batch ID from Batch Management screen below)" to the conditions:

 

 

... then adding "Funds: Fund Name," "Contributions: Payment Amount," and "Contributions: Payment Type" to the result columns (in addition to whatever else you want) and then exporting the results of the query to a CSV.

 

 

This will produce a batch report with total contributions broken out by fund and payment type.

 

Have more questions? Submit a request

Comments

0 comments

Please sign in to leave a comment.