Use this MS Excel report to quickly reconcile any GL account. This spreadsheet displays the balance of a GL account for each day, and it includes a summary of the journal entries if there is a change in balance. The tool provides data in 6 months increments. For example - Using the date 9/10/2018 would provide data from 3/10/2018 to 9/10/2018 only, so the 6 month date parameters to reconcile should be considered when entering a date to reconcile.

Step by Step:

Step 1: Go to Administration > Reports > Accounting > Any GL Account - Quick Reconcile.

Step 2: Enter a date. The report will only include balances prior to the selected date.

Step 3: Enter a GL account number.

Step 4: The application generates the MS Excel spreadsheet.