Monday, November 23, 2009

Accounting and Reconciliation Reports in AP

• Accounts Payable Trial Balance Report
• Accounts Payable Negative Supplier Balance Report
• Period Close Exceptions Report
• Posted Invoice Register
• Posted Payment Register
• Unaccounted Transactions Report

Accounts Payable Trial Balance Report
Use the Accounts Payable Trial Balance Report to verify that total accounts payable liabilities in Payables equal those in the general ledger. To reconcile these balances you can compare the cumulative total liability provided by this report with the total liability provided by your general ledger. The Accounts Payable Trial Balance report is a Payables-specific version of the Open Account Balances Listing report. By running this report from Payables, you can run this report for a specific operating unit.

Accounts Payable Negative Supplier Balance Report
The Accounts Payable Negative Supplier Balance report allows you to run a Payables-specific version of the Open Account Balances Listing report. By running this report from Payables, you can view the negative supplier balances for a specific operating unit.

Period Close Exceptions Report
Submit this report to review a complete list of exceptions that are preventing you from closing a Payables accounting period. This report lists, for each organization within the ledger, the following exceptions:
• Outstanding Payment Batches
• Accounting Entries not Transferred to General Ledger
• Bills Payable Requiring Maturity Event and Accounting
• Unaccounted Invoices
• Unaccounted Payments

Posted Invoice Register
Use the Posted Invoice Register to review accounting lines for invoices that have been transferred to your general ledger. Because it presents amounts that have been charged to liability accounts, this report is valid only for an accrual ledger.

The Posted Invoice Register is primarily a reconciliation tool. Use this report along with the Posted Payment Register and the Accounts Payable Trial Balance Report to reconcile balances between Payables and your general ledger. To make their output easier to read, each of these reports can be generated for a single liability account. For example, if you are using Automatic Offsets and the liability for your invoices is allocated across multiple balancing segments, then you can use the Liability Account parameter to limit your reports to a single balancing organization.

You can generate the report in summary or in detail. When generated in detail, the report displays invoices charged to liability accounts and the accounting information that has been transferred to the general ledger. Also included is the supplier and amount information for each invoice listed. Payables displays the total invoice amount in the invoice currency, and the transferred distribution amount in both the invoice currency and accounted currency for easier reconciliation with your general ledger.

Posted Payment Register
Use the Posted Payment Register to review accounting lines for payments that have been transferred to general ledger. Because it presents amounts that have been charged to liability accounts, this report is valid only for an accrual ledger. You can submit the Posted Payment Register for one payment journal entry batch or all payment journal entry batches.

The Posted Payment Register is primarily a reconciliation tool. Use this report along with the Posted Invoice Register and the Accounts Payable Trial Balance Report to reconcile balances between Payables and your general ledger. To make the output easier to read, each of these reports can be generated for a single liability account. For example, if you are using Automatic Offsets and the liability for your invoices is allocated across multiple balancing segments, then you can use the Liability Account parameter to limit your reports to a single balancing organization.

You can generate the report in summary or in detail. When generated in detail, the report displays payments that relieve liability accounts and that have had their accounting information transferred to the general ledger. Also included is the supplier and amount information for each payment listed. Payables displays the payment amount in the entered currency and the liability amount relieved in the accounted currency. In detail mode, the report also displays the payment document and disbursement type for each batch of payments. It provides a report total and subtotals for each payment document and bank account.

Unaccounted Transactions Report
Use this report to identify and review all unaccounted invoice and payment transactions and see the reason that Payables cannot account for a transaction. Payables sorts the report by transaction type (invoice or payment), exception, supplier, transaction currency, and transaction number. Run this report after you create accounting entries. The report will then show only transactions that had problems that prevented accounting. You can then correct the problems and resubmit the accounting process. Note that this report does not include invoices that have no distributions.
Related Posts Plugin for WordPress, Blogger...