Accounts Receivables Period Close Check list

Following steps need to follow before the Receivable period closure

 

Check Details
Product	Period Close Phase		Description		Standard Oracle/ Custom process		Action Item Details
AR	1: Evaluate and Prepare		Apply Recommended Patches		Oracle
AR	1: Evaluate and Prepare		Apply Recommended Patches		Oracle
AR	1: Evaluate and Prepare		Ensure Data Consistency		Oracle
AR	1: Evaluate and Prepare		Ensure Data Consistency		Oracle
AR	2: Process Transactions		Complete Invoicing, Credits and Adjustments		Oracle
AR	2: Process Transactions		Complete Receipts and Reversals		Oracle
AR	2: Process Transactions		Complete Invoice and Customer Import		Oracle
AR	2: Process Transactions		Complete Lock Box Processing		Oracle
AR	2: Process Transactions		Run the revenue recognition program (Optional; required if OM & Shipping is used)		Oracle
AR	2: Process Transactions		Print Invoices		Oracle
AR	3: Create Accounting		Run Create Accounting		Oracle
AR	3: Create Accounting		Review the Transfer Journal Entries to GL		Oracle
AR	4: Reconcile		Reconcile Transaction Activity for the Period		Oracle		Run the Transaction Register for the same accounting period date range
AR	4: Reconcile		Reconcile Transaction Activity for the Period		Oracle		Run the Sales Journal by Customer Report and the Sales Journal by GL Account Report for the same accounting period date range
AR	4: Reconcile		Reconcile Transaction Activity for the Period		Oracle		Run the Journal Entries Report for the same accounting period date range
AR	4: Reconcile		Reconcile Transaction Activity for the Period		Oracle		Run the AR to GL Reconciliation Report for the same accounting period date range
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Beginning Balance - Aging reports
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Transactions - Transaction Register
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Adjustments - Adjustment Register
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Exceptions- Invoice Exceptions Report
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Applied Receipts - Applied Receipts Register (Identify payments received from customers)
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Unapplied Receipts - Unapplied and Unresolved Receipts Register (identify payments received from customers)
AR	4: Reconcile		Reconcile Outstanding Customer Balances		Oracle		Run Ending Balance - Aging report (as of the last day of the accounting period)
AR	4: Reconcile		Reconcile Receipts		Oracle		Run Receipts Journal Report
AR	4: Reconcile		Reconcile Receipts		Oracle		Run Receipt Register
AR	4: Reconcile		Reconcile Receipts to Bank Statement Activity for the Period		Oracle		Re0run the Create Accounting process for any miscellaneous accounting entries generated from the bank reconciliation, for transfer to the General Ledger
AR	4: Reconcile		Reconcile Posted Journal Entries		Oracle		Reconcile the Journal Import by manually reviewing the transactions in the Subledger Accounting Program Report, and comparing them with the Journal Entries Report output.
AR	5: Close Period		Close the Current Oracle Receivables Period		Oracle		Close the current period in Oracle Receivables using the Open/Close Accounting Periods window.
AR	5: Close Period		Review the Subledger Period Close Exceptions Report		Oracle
AR	5: Close Period		Third Party Balances Report		Oracle
AR	5: Close Period		Review the Unposted Items Report		Oracle
AR	5: Close Period		Review Account Analysis Report		Oracle
AR	5: Close Period		Open the Next Oracle Receivables Period		Oracle
AR	5: Close Period		Run Reports for Tax Reporting Purposes (Optional)		Oracle

 

Accounts Payable Period Close Checklist

Following steps need to follow before the payable period closure

Check Details     Product Period Close Phase Description Action Item   Pre-requisite Standard Oracle/ Custom process AP 1: Evaluate and Prepare Apply Recommended Patches EBS: R12.1 Oracle Financials Recommended Patches     Oracle               AP 1: Evaluate and Prepare Apply Recommended Patches R12 Troubleshooting Period Close in Payables     Oracle               AP 1: Evaluate and Prepare Ensure Data Consistency R12: Experience Smoother Accounting and Period Close By Proactively Eliminating Data Integrity Issues      Oracle               AP 1: Evaluate and Prepare Ensure Data Consistency R12: Master GDF Diagnostic to Validate Data Related to Invoices, Payments, Accounting and Suppliers      Oracle               AP 1: Evaluate and Prepare Ensure Data Consistency How to Register the Master GDF Diagnostic as a Concurrent Program      Oracle               AP 1: Evaluate and Prepare Ensure Data Consistency What is a Generic Datafix Patch (GDF) and what GDFs are available for Payables?      Oracle               AP 2: Process Transactions Complete Invoices and Credits       Oracle               AP 2: Process Transactions Complete Invoice Import        Oracle               AP 2: Process Transactions Import from external system or Internet Expenses       Oracle               AP 2: Process Transactions Run Invoice Validation        Oracle               AP 2: Process Transactions Review the Invoice on Hold Report        Oracle               AP 2: Process Transactions Complete Payments        Oracle               AP 2: Process Transactions Run a Payment Process Request at the month end (Optional)       Oracle               AP 2: Process Transactions Confirm all Payment Instructions       Oracle               AP 2: Process Transactions Reconcile Payments to Bank Statement Activity for the Period         Oracle               AP 2: Process Transactions Run the Payments Register (Optional)       Oracle               AP 2: Process Transactions Submit the Update Matured Bills Payables Status Process       Oracle               AP 3: Create Accounting Run Create Accounting       Oracle               AP 3: Create Accounting Review the Transfer Journal Entries to GL       Oracle               AP 3: Create Accounting Run and Review the Unaccounted Transactions Report       Oracle               AP 3: Create Accounting Transfer All accounted Invoices and Payments to the General Ledger       Oracle               AP 3: Create Accounting Review the Transfer Journal Entries to GL Report generated from step 4       Oracle               AP 3: Create Accounting Run the Posted Invoices Register       Oracle               AP 3: Create Accounting Run the Posted Payments Register       Oracle               AP 4: Reconcile Run the Accounts Payable Trial Balance Run the Payables Posted Invoice Register for this month   Keep the Last Months Accounts Payable Trial Balance handy as you would need this for Trial balance. Oracle               AP 4: Reconcile Run the Accounts Payable Trial Balance Run the Payables Posted Payment Register for this month     Oracle               AP 5: Close Period Close the Current Oracle Payables Period       Oracle               AP 5: Close Period Submit the Unaccounted Transactions Sweep Program     Before running the sweep program, you will need to open the next accounting period Oracle               AP 5: Close Period Accrue Uninvoiced Receipts       Oracle               AP 5: Close Period Run Mass Additions Transfer to Oracle Assets       Oracle               AP 5: Close Period Open the Next Oracle Payables Period Open the next accounting period by using the Control Payables Periods window to set the Period Status to Open.     Oracle