The standard month-end closing procedures should include a reconciliation between the Accounts Payable files and the corresponding General Ledger Control accounts. Whether you have one G/L account to reconcile or many, the steps to reconcile the accounts are the same. Deltek recommends that you complete the reconciliation process on a monthly basis.
When you enter vouchers into Costpoint on the Manage Accounts Payable Vouchers screen or Manage Purchase Order Vouchers screen, the vouchers are held in temporary files until you post them. These unposted vouchers are not contained in the Open A/P files or the General Ledger.
After you post the vouchers, they are recorded concurrently in the Open Accounts Payable files and the General Ledger. The entry made by the posting is:
A debit to the expense accounts entered on the voucher and
A credit to the A/P Account/Organization/Ref1/Ref2 combination assigned to the voucher.
This is done with an Accounts Payable account description. The description is assigned to a unique Acct/Org/Ref1/Ref2 combination to identify the unique combination. You can then enter the description, which is easier than entering the Acct/Org/Ref1/Ref2 combination. Costpoint looks up the Acct/Org/Ref1/Ref2 combination and the description to which it is assigned. After you post the vouchers, the Accounts Payable Account usually has a credit balance. This credit is relieved when you post the Cash Disbursements Journal after you create the check. The Open A/P files are updated as soon as the check is printed, but the G/L is not updated until the Cash Disbursements journal is posted. The Cash Disbursements journal makes a debit to the A/P Account and a credit to the Cash Account. The Cash Account has a description assigned to it using the same method as A/P Account Description.
Because the posting of the Voucher Distribution and the Cash Disbursements journals creates entries in both the Open A/P files and the G/L, these postings keep the two journals in balance. If you make an entry in the G/L using any other journal (such as a journal entry from the General Ledger), the two reports are thrown out of balance. For this reason, you should change the balance in the A/P Account only through the use of vouchers.
To reconcile Accounts Payable with the GL, complete the following steps:
Post cash disbursements in Accounts Payable.
Print the Open Accounts Payable Report for all the A/P Account/Organizations, selecting the Page Break option to produce multiple reports for all the A/P Account/Organizations in your database. You can run the report for any period.
Print the General Ledger Posting Summary Report for the same period and compare the balance of the two reports. If the balance does not tie, use the following steps to find the difference.
Check to see whether any unposted Cash Disbursements records were created by another user between steps 1 and 2. A voucher is treated as paid on the Open Accounts Payable report as soon as it is printed, but it is not reflected in the G/L account until the Cash Disbursements journal is posted. Post any unposted records and rerun the General Ledger Posting Summary report.
Print the General Ledger Detail report for the A/P account(s) and review the activity in the account(s). Check for journals other than A/P (the voucher distribution) or CD (the cash disbursements journal). Entries from any other journals, such as G/L journal entries, labor, or billing, affect the balance in the G/L account but not the Open A/P report, thus rendering the two reports out of balance. If you find a non-A/P or non-cash entry, it should be reversed and the original entry made through the vouchering process.
Review the General Ledger Detail report for vouchers that were charged to the A/P Account on the expense side of the voucher. You should do this only during Costpoint initialization. If you discover an entry that was charged to the A/P Account, reverse it using either a journal entry or a voucher.
Verify that the reports were reconciled in previous periods. If the reports were out of balance at the beginning of the period that you are trying to reconcile, the entry that threw them off is in an earlier period. Perform steps 1 and 2 for earlier periods until you find a period that does balance. Then complete steps 4 through 6 for the earliest period that is out of balance, working your way back to the present.