This article provides steps to run a Reconciliation Report.
Reconciliation reports provide a detail of all the batches in Giving.
Steps to run the report:
1. From Giving go to Reporting.
2. At Select Report Type, from the dropdown select the Report Name as Reconciliation.
3. Select the Report Timeframe. (Select from either the Last 7 Days, Last 30 Days, Year To Date, Last Year or choose a Custom Date Range and use the calendar to set the dates.)
4. Currently, the only option to Report On is the Transaction Date of the batches.
5. Specify what to Include in the Report and the types of batches to view by selecting or deselecting the ACH Batches, Credit Card Batches, Fund Summary, and Batch Transaction Detail boxes.
6. Click Run Report to process and see a list of the batches within the time frame and payment types selected.
The results will provide the Batches, Batch Date, Type, Total and Fund Number and Grand Total of all batches. If desired, change the report time frame and select the Update Report icon on the top right corner of the card to refresh the information on the page.
Select the cloud drop down menu and choose which report to view and print or export.
- A PDF is available for printing a Grand Total, Batch Totals, Fund /Form Totals and Individual Batch Fund/Form Totals.
- A CSV is available to export the Batch Date, Batch ID, Batch Type, Payment Type, Fund Name, Fund Type, Donor Name, Envelope Number, Amount and Fund Number.
- An Excel Worksheet is available to export the Batch Totals, Batches, Batch Date, Type, and Grand Total.
Click here for information on how to reconcile a batch against a bank statement.
Note* Visual steps are best viewed at full screen. Click Esc on your keyboard when you are finished viewing.
Need additional resources? Please see the below steps and videos on tips to recreate our classic reconciliation form.
Summary
1. Run Reconciliation in the Hub – Select whichever date range and batch types you would like to include (ACH and/or CC) and Fund Summary
2. From export dropdown Select CSV
3. Highlight all columns
4. Select Insert and then Pivot Table
5. Drag Batch Date and Batch Type into Row
6. Drag Fund into Column
7. Drag Total into Values
Detail
1. Run Reconciliation in the Hub – Select whichever date range and batch types you would like to include (ACH and/or CC) and Fund Summary
2. From export dropdown Select CSV
3. Highlight all columns
4. Select Insert and then Pivot Table
5. Drag Batch Date, Batch Type and Name into Row (in that order)
6. Drag Fund into Column
7. Drag Total into Values
