Reconcile Accounts Payable to the General Ledger

 

Expand/Collapse all Show/Hide All

Expand/Collapse item  Overview

As with any reconciliation, you may encounter situations where the Trial Balance report in the Accounts Payable module does not balance to the corresponding account in the general ledger. There are several reports that can help you determine what caused the balances to be different.

 

To reconcile Accounts Payable to the General Ledger

  1. In the Accounts Payable module, verify that the following journals have been updated:

  2. Invoice Register (accessed from the Main menu)

  3. Manual Check and Payment Register (accessed from the Main menu)

  4. Check and Electronic Payment Register (accessed from the Check Printing and Electronic Payment menu)

  5. A/P from A/R Clearing Register (accessed from the Period End menu)

  1. Select Accounts Payable Main menu > Daily Transaction Register. Verify that the Daily Transaction Register has been updated to the general ledger.

  2. Select General Ledger Reports menu > General Ledger Detail Report. Print the General Ledger Detail Report for the current period and only include the accounts payable account.

  3. Verify that no entries were posted to the account that did not originate from the Accounts Payable or Purchase Order modules.

  4. If a transaction was posted that did not come from the Accounts Payable or Purchase Order modules, reverse the entry and reenter the transaction in the appropriate module.

  5. Use original hard copies of the register, journals, and the Daily Transaction Register to verify that the entries are not missing from the general ledger.

  6. If a transaction does not appear in the general ledger, verify that the postings were made to the correct accounts.

  7. Create a journal entry in the general ledger for any transactions that do not appear. Verify that the correct posting date, amount, and accounts are used.

Your accounts payable are reconciled to the general ledger.

© Sage Group plc 2019. Privacy Policy | Copyright/Trademarks