Reconciling Accounts Payable

Description of Issue

Need to reconcile accounts payable for year end

Context

Invoice History by GL Account and Account Trial Balance report

Cause

Reconcile AP by comparing the Invoice History by GL Account report to the Account Trial Balance for the AP Control Account.

Resolution
  1. Goto Accounts Payable>Invoice Inquiry and Reports>Iinvoice History by GL Account
  2. Select History by Fund
  3. Select Define
  4. Select Fund range
  5. Select Only Open Invoices
  6. Select Current Fiscal Month
  7. Select Year & Period of choice
  8. Input Last Check date that corresponds to the Period being closed
  9. Select any additional applicable options
  10. Select Accept
  11. Select Output 
  12. Save/Print
  13. Compare the Open Invoice amount on this report to the Account Trial Balance for the AP Control Account
Additional Information

If balances do Not match between Open Invoices and Account Trial Balance make a General Journal entry for the difference and post