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. 

  1. Go to Administration > Reports > Accounting > Any GL Account - Quick Reconcile.
  2. Enter a date. The report will only include balances prior to the selected date.
  3. Enter a GL account number.
  4. The application generates the MS Excel spreadsheet.