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
- Goto Accounts Payable>Invoice Inquiry and Reports>Iinvoice History by GL Account
- Select History by Fund
- Select Define
- Select Fund range
- Select Only Open Invoices
- Select Current Fiscal Month
- Select Year & Period of choice
- Input Last Check date that corresponds to the Period being closed
- Select any additional applicable options
- Select Accept
- Select OutputÂ
- Save/Print
- 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