Reconciling Receivables Transactions, Receipts

This forum is to discuss different features/issues of Oracle Financials modules ( GL - General Ledger, AP - Accounts Payable, AR - Accounts Receivable, FA - Fixed Assets & CM - Cash Management ).
Post Reply
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Reconciling Receivables Transactions, Receipts

Post by ahmadbilal »

Use the <b>AR Reconciliation Report </b> to start the reconciliation process. It will provide a summary of your customer, transaction, receipt, and account balances for the period that you specify. It can give you a starting point to identify areas that need research. Use these reports to get the detailed information:
<b>Sales Journal By Customer </b> ? Use to review all transactions.
<b>Transaction Register </b> ? Use to check that all items that can be posted are reflected on the Sales Journal. The Sales Journal balance should match the total of the transactions here after adding the credit memo total twice (because it is a negative on the Transaction Register and a positive on the Sales Journal).
<b>Receipts Register</b> ? Use to review a list of receipts.
<b>Sales Journal By GL Acco</b>unt ? Use to ensure that the Transaction Register matches the Sales Journal.
<b>Journal Entries Report </b> ? Use to review the details that make up the general ledger journal entries.
<b>Receipts Journal Report</b> ? Use to review details of receipts that appear in the Journal Entries report.
<b>Aging Report</b> ? Use the last day of the prior month to get the outstanding opening balance.
<b>Transaction Detail Report</b> ? Use to identify transactions that increase the outstanding opening balance.
<b>Adjustments Register</b> ? Use to identify any adjustments that affect the transactions for the month.
<b>Unapplied Receipts Register </b> ? Use to determine customer balance after taking into account all on-account and unapplied amounts
<b>Applied Receipts Register</b> ? Use to identify receipts that reduce the outstanding opening balance.
<b>Invoice Exceptions Report </b> ? Use to identify transactions that reduce the outstanding opening balance. This report shows all transactions where the Open Receivables flag is set to No. Therefore, the transactions do not display on the aging but do show in the Transaction Register. This can occur when an item can be ordered in Order Management but not invoiced, such as an internal item.
Post Reply

Who is online

Users browsing this forum: Ahrefs [Bot] and 22 guests