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.
Any GL Account - Quick Reconcile
-
Go to Administration > Reports > Accounting > Any GL Account - Quick Reconcile.
-
Enter a date. The report will only include balances prior to the selected date.
-
Enter a GL account number.
-
The application generates the MS Excel spreadsheet.