How to reconcile your financials as an accountant

Use these three reports to tie transactions to your banking activities.


Run all reports on the exact same time and date ranges 

  1. 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

  1. Same date range and Group By: GL Code. Use no other filters
  2. Export Total to excel.  Save
  3. Filters - drill down to time periods, etc. in Excel for total accuracy



Have more questions? Submit a request


Powered by Zendesk