/
Reconciling Accounts Payable

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





Related content

Invoice History by GL report amount does not line up with amount in Account Inquiry
Invoice History by GL report amount does not line up with amount in Account Inquiry
More like this
Report on open AP invoices
Report on open AP invoices
More like this
AP Check Reconciliation Report - List of cleared checks for date range
AP Check Reconciliation Report - List of cleared checks for date range
More like this
Classic Bank Reconciliation - Calculating the GL Book Balance
Classic Bank Reconciliation - Calculating the GL Book Balance
More like this
Invoices and Checks Posted in the Wrong Fiscal Year and Period
Invoices and Checks Posted in the Wrong Fiscal Year and Period
More like this
Which reports should be used to reconcile the Accounts Receivable with the General Ledger
Which reports should be used to reconcile the Accounts Receivable with the General Ledger
More like this