Sunday, September 2, 2018

Accounting and Reconciliation Reports in Oracle Payables

 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 ledge.

Payables Account Analysis Report:-  Use this report to review and analyze accounting entries in Payables. You can use the report parameters to limit the report to just the accounting information you want to review. This report is helpful when you reconcile your accounts with your general ledger. For example, you can reconcile the prepaid expense account between Payables and your general ledger. You can submit this report in detail and compare it to an account analysis report in your general  ledger.

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 set of books, the following exceptions:
• Outstanding Payment Batches
• Accounting Entries not Transferred to General Ledger
• Future Dated Payments 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 set of books.

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 set of books. You can submit the
Posted Payment Register for one payment journal entry batch or all payment journal entry batches.

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.

No comments:

Post a Comment

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)