How to reconcile your financials as an accountant

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

IMPORTANT

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

Comments

Powered by Zendesk