Use these three reports to tie transactions to your banking activities.
Run all reports on the exact same time and date ranges
- What payments were processed? Cash Receipts Report
Use the Cash Receipts report to balance to the bank.
2. What did they pay for? Transaction Totals for All Activities report
Use to balance accounts. Use the same date range as #1 – Cash Receipts report and Group By: GLCode.
3. What was booked within that date range - Revenue Report with Grouping
- Same date range and Group By: GL Code. Use no other filters
- Export Total to excel. Save
- Filters - drill down to time periods, etc. in Excel for total accuracy