Accounts Payable File Reconciliation

A file reconciliation (file rec) issue is a discrepancy between the sum of the detail for an account and the same account's balance in the general ledger. An Accounts Payable file reconciliation occurs when the sum of the general ledger accounts set up as Liability Codes do not agree with the balance on the Voucher Schedule report.

To determine whether a file reconciliation issue exists, run the File Reconciliation Report. To run the report, select Utilities > Advanced Utilities > File Reconciliation from the Vision Navigation menu.

If an Accounts Payable file reconciliation exists, the amount displays in the Accounts Payable > Difference column on the File Reconciliation report.

Diagnose an Accounts Payable File Reconciliation Issue

If a file reconciliation issue occurs, perform these diagnostic steps:

• Verify that all the balance sheet accounts you are comparing are associated with a Liability Code on the Liability Codes tab of Configuration > Accounting > Company AP.
• Determine the period in which the difference first appeared. To do this, open each prior period and compare the general ledger balances with the balances on the Voucher Schedule report.
• When you find the period in which the difference first appeared, run the Account Analysis report.
• Look for entries to your Liability accounts that are not Accounts Payable Voucher or Payment Processing transactions.

Common Causes of Accounts Payable File Reconciliation Issues

Some common causes of file reconciliation errors are:

• Entering a journal entry in Transaction Entry that updates the general ledger, but does not update the Voucher Schedule.
• Entering a voucher in Accounts Payable History without entering the voucher amount in Account Balances History.
• Entering an amount in Account Balances History for a liability account without entering an offsetting voucher in Accounts Payable History.
• Entering an Accounts Payable Voucher that debits a liability account associated with a liability code.
• Entering an Accounts Payable Disbursement that debits a liability account associated with a liability code.
• Changing an existing voucher's liability code.