Oracle Receivables - Period Close Checklist

Period Close Processing

Oracle Receivables -- Period Close Checklist

Period Name: ___________ Period Close Date: ________________

TASK	DESCRIPTION	PROCESSED BY
1.	Complete the manual payments and adjustments for the period (including cleanup of "Out of Balance" batches).
2.	Complete the final Lockbox process.
3.	Complete the manual invoices, credit memos and corrections.
4.	Run the final AutoInvoice process.
5.	Correct ALL AutoInvoice rejects and re-run.
6.	Confirm that there are no unapproved adjustments.
7.	Complete or delete ALL "Incomplete" transactions.
8.	Notify all users that the system is not available.
9.	Run the Journal Entries Reports.
10.	Review the Journal Entries Reports for "unusual" accounts and correct as needed. If possible, have someone in General Ledger verify also.
11.	Run Period End Reports.
12.	Balance to the Aged Trial Balance. See Exhibit A.
13.	Transfer transactions to the General Ledger.
14.	Close the period. Verify that there are no unposted items.
15.	Open the new period.
16.	Notify users that the Receivables system is available.
17.	Notify General Ledger that they can now post the Receivables Journal Entries.
18.	Balance the key accounts to the General Ledger. See Exhibit B.

Oracle Receivables Period Close Checklist Detailed Instructions

		1) Complete the manual payments and adjustments for the period.

		2) Complete the final Lockbox process for the period. Correct and re-run as needed.
		*Interfaces à Lockbox*

		3) Complete the manual invoices, credit memos and corrections for the period.

		4) Run the final AutoInvoice Process (this includes inputs from Projects, Order Entry and other billing
		systems). *Interfaces à AutoInvoice*

		*5) Correct all* AutoInvoice rejects and re-run (as needed).**

		6) Confirm that no unapproved adjustments appear on the Adjustment Approval Report.
		*Reports à Accounting*

		Type Request
		Name Adjustment Approval Report
		Order By Customer Name
		Status Waiting Approval

		[skip the rest of the parameters]

		There should be no data on this report. If there is, contact your manager to approve these adjustments.

		7) Check for incomplete transactions.
		*Transactions à Transactions Summary*
		Query - Enter
		Click on Complete
		Click on Complete again (to uncheck the box)
		Query - Run
		You should see a message "Query caused no records to be retrieved." If you do, get out of Query Mode (Query - Cancel). You are done (this is the desired condition).

		If some records are retrieved, work with the appropriate department to complete or delete. Then re-query to ensure that there are no longer any incomplete invoices.

		8) Notify all users that the system is now available for inquires only. No updates may be made until the close is complete.

		9) Run the Journal Entries reports (to verify what the journal entries will look like).
		*Reports à Accounting (Print Accounting Reports)*

		Type Request
		Name Journal Entries Report
		Detail By Account No
		Detail By Category No
		Summary By Account Yes
		Summary By Category Yes
		GL Posting Status Posted and Unposted
		Beginning GL Date Period start date (e.g., 30-SEP-99)
		Ending GL Date Period end date (e.g., 03-NOV-99)
		Use the defaults ("Yes" for all record types).
		[Skip the rest of the parameters.]

		10) Review the Journal Entries reports. Check to see if any unusual accounts were used.
		If found, run the Journal Entries Report again, specifying: "Yes" to Detail by Category and "Yes" only for the categories where you found problems.
		Review the results. Find the item that has the problem. Direct the responsible individual to correct the problem. Repeat steps 9 and 10.

		11) Run the Period End Reports. *Reports à Accounting (Print Accounting Reports)*

		a) Aged Trial Balance - 7 Buckets - By Account
		Report Summary Invoice Summary
		Report Format Brief
		As of Date period end date
		Aging Bucket Name the standard "bucket" name
		Show On Account Age

		b) Transaction Register
		Order By Customer
		GL Date Low period start date
		GL Date High period end date

		c) Unapplied Receipts Register
		Format Option Detailed
		Receipt GL Date Low period start date
		Receipt GL Date High period end date

		d) Applied Receipts Register
		Order By Customer
		Receipt GL Date Low period start date
		Receipt GL Date High period end date

		e) Adjustment Register
		Order By Customer
		GL Date Low period start date
		GL Date High period end date

		f) Invoice Exception Report
		GL Date Low period start date
		GL Date High period end date
		Order By Customer

		12) Balance to the Aged Trial Balance. Note the results from the above reports on the Balancing AR to the Aged Trial Balance spreadsheet (see Exhibit A). Confirm balances. Correct as needed.
		Watch for activity in other companies and be sure to include this information in your totals.

		13) Transfer transactions to the General Ledger. Interfaces *à General Ledger (Run General Ledger Interface)*

		Summary or Detail Summary
		GL Posted Date today’s date
		GL Start Date period start date (e.g., 30-SEP-99)
		GL End Date period end date (e.g., 03-NOV-99)
		Run Journal Import Yes

		Note that this interface submits multiple processes; verify that they all finished successfully. Confirm that the Unposted/Unbalanced Items Report does not actually include any data. If it does, contact your System Administrator for assistance.

		The processes and what to look for:
		General Ledger Transfer Program
		- review the report
		- verify the debit total = the credit total
		- check for reasonableness
		Revenue Recognition from GL Transfer Program
		- review the report for reasonableness (it may be headings only)
		Update Posting Control
		- no report
		Collections Effectiveness Indicators (if it runs)
		- no report
		- Status may = Warning (this is okay)
		Unposted Items Report (if it runs)
		- review each page to ensure no unposted items exist
		Journal Import Execution Report
		- ensure that you have a Status of "SUCCESS"

		14) Close the period. Control *à Accounting à Open/Close Periods*

		Click on the Accounting Periods region.
		Scroll down to the line for the current period.
		Change the status to "Closed."
		Oracle then checks for unposted items. There shouldn’t be any. If there are none, SAVE.

		If there are unposted items, this is due to problems in the General Ledger Interface. STOP and contact your System Administrator for assistance.

		15) Open the new period. *Control à Accounting à Open/Close Periods*

		Click on the Accounting Periods region.
		Scroll down to the line for the new period (or Query it).
		Change the status to "Open."
		Save.

		Note that you should never have more than one Oracle Receivables period open at one time. If you are using Deferred Revenue Recognition, you will also need to open the next "Future" period.

		Click on the Accounting Periods region.
		Scroll down to the line for the new future period (or query it).
		Change the status to "Future."
		Save.

		16) You are now ready to start work in the new period. Good Luck! Notify everyone that they can use the Receivables system again.

		17) Notify General Ledger that they can import and post the Accounts Receivable Journal Entries or post yourself.

		18) Balance to the General Ledger. Create the Reconciling AR and GL spreadsheet indicating the distribution of the critical accounts (Accounts Receivable and the cash accounts). Ensure that these numbers balance.

		When General Ledger has completed its posting and/or close for the period:
		Run the Account Analysis Report for each of the critical accounts.
		Determine the totals by source and category.
		Compare the totals to those on the Reconciling AR and GL spreadsheet, and correct as needed. See below for detailed instructions.

		19) (Optional) If you do separate balancing for Cash Accounts, refer to Exhibits C and D.

Exhibit A: Balancing AR to the Aged Trial Balance (Spreadsheet)

MONTH: ________________

PREPARED BY: ______________________

ACTIVITY

REPORT SOURCE

Starting Balance

Aged Trial Balance - Old

Invoices

Transaction Register

Debit Memos

Transaction Register

Credit Memos

( )

Transaction Register

Chargebacks

(either + or -)

Transaction Register

Transaction Register Subtotal

Applied Receipts

( )

Applied Receipts Register (Applied Amount Total)

Discounts Taken

( )

Applied Receipts Register (Earned Discount + Unearned Discount)

Unapplied Activity

( )

Unapplied Receipts Register

(On-Account Amount + Unapplied Amount) * -1

Adjustments

Adjustments Register (may be + or -)

Items Not Aged

( )

Invoice Exceptions Report

TOTAL

Sum of all of the above

Ending Balance

Aged Trial Balance - New

Difference

Total - Ending Balance

(Should be -0-)

Balancing AR to the Aged Trial Balance

Using the reports listed above, fill in the values on the Balancing to the Aged Trial Balance spreadsheet (Exhibit A).

Aged Trial Balance -- Use the Grand Total Amount for the Outstanding Amount Column

Transaction Register -- Use the "Sum for ______ Class" total for the "Functional Currency" for each Class of transactions (Credit Memos, Debit Memos, Invoices, Chargebacks) - WATCH OUT: the "Sum for Invoice Class" is before the last total on the report. On the spreadsheet, sum the amounts for each of these transactions and compare to the "Grand Total in Functional Currency" on the final page of the report. They should be identical -- if not, correct as needed. Use the signs as they appear on the report (Credit Memos are negative -- the rest are positive).

Applied Receipts Register -- Use the "Grand Total For Functional Currency" for the "Total" Column. Enter as a negative number.

Unapplied Receipts Register -- Use the "Total for Report" values. Add the "On Account Amount" to the "Unapplied Amount" and multiply the sum by -1. ((On Account + Unapplied) * (-1)). Enter as the sign you get as a result of this calculation.

Adjustment Register -- Use the "Total for Report" for the Functional Amount column. Enter as whatever sign appears on this report.

Invoice Exception Report -- Use the "Grand Total" for the Functional Amount column. Enter as whatever sign appears on the report.

Fill in the spreadsheet. The derived total should equal the new aging total. If it doesn’t, possible reasons are that you:

Did not use the same dates for every report;
Used dates other than the GL dates (or in addition to the GL dates) for the selection. Always use the full period even if you don’t expect activity on certain days.
Entered the wrong amounts from the various reports onto the spreadsheet;
Used the wrong sign (credit memos, applied receipts should be negative, adjustments, unapplied activity and ‘invoices exceptions’ may be negative or positive);

Have overlapping dates in the aging bucket definitions;
Have the buggy version of the Applied Receipts Register that does not include the reversed and reapplied receipts;
Used custom reports that do not use the same selection criteria as the standard Oracle Reports;
Have the bug in the Unapplied Receipts Register that does not include the reversed items;
You restricted the values that appeared on the reports using something other than the GL date ranges.

Correct as needed. You should now be in balance for Accounts Receivable.

Exhibit B: Reconciling AR and GL (Spreadsheet)

MONTH: ________________

PREPARED BY: ______________________

ACTIVITY

Balance to Aging

Journal Entries

AR1

AR2

Cash1

Cash2

Unapplied

Report Totals

Starting Balance

Invoices

Debit Memos

Credit Memos

Chargebacks

CM Applications

Applied Receipts

Discounts Taken

Unapplied Activity1

Adjustments

Items Not Aged

Manual JE’s:

Cash-AR

Cash-Misc.

Unapplied Cash

NEW BALANCE

NEW REPORTS2 TOTALS

Difference

Current JE's

JE's To Date3

TOTAL

ATB - By Account

Difference

1) Note - Unapplied activity impacts the Aged Trial Balance but is included in the applied receipts total when posted to the General Ledger.

2) New Report Totals from the New Aging and the Account Analysis Reports (gray areas) are from the Account Analysis Report.

3) Add NEW BALANCE to the amounts of journal entries (current and to date). These should equal the Aged Trial Balance 7 Bucket by Account totals.

RECONCILING AR AND GL

Create the "Reconciling AR and GL" spreadsheet (Exhibit B) indicating the distribution of the critical accounts (Accounts Receivable accounts and the "cash" accounts). Ensure that these numbers balance.

Start with the values from the spreadsheet that you created in the prior step (Exhibit A) in the Balance to Aging column.

Include a column for each "Accounts Receivable," unapplied and cash account you will be reconciling. For example, the AR, unapplied and cash accounts for every company.

Use the Journal Entries Report - Summary by Category:

This report shows one line per Accounting Flexfield per Category (type of AR Activity). Enter the net values for the applicable accounts in the appropriate columns on the spreadsheet. If the net value is a debit, enter a positive amount. Otherwise, enter a negative amount.

Look for the key accounts in every category listing, even if they are not "logical" for that activity type. The following lists the proper and improper usage of accounts for each category and how to enter the data into the spreadsheet to indicate how the data was accounted for.

Category	Where to Add
Adjustment	There should be no AR account activity in this category. If AR activity occurs, add a special line for each and add to the column for the applicable AR account.
Adjustment (AR)	There should only be AR account activity in this category. For each account add to the Adjustment activity line, split by AR account. If non-AR account activity occurs, add a special line and notation for each and add a new column for the non-AR account.
CM Applications and CM Applications (AR)	The activity for these accounts should net to zero and should include only AR Accounts. If non-AR account activity occurs, add a special line for each and add a new column to the spreadsheet for each account. If each account does not net to zero, enter the amount for each account in the proper column on the CM Applications line of the spreadsheet.
Credit Memos	There should be no AR account activity in this category. If AR activity occurs, add a special line for each and add to the column for the applicable AR account.
Credit Memos (AR)	There should only be AR account activity in this category. For each account, add to the Credit Memos activity line, split by AR account. If non-AR account activity occurs, add a special line for each and add a new column for the non-AR account.
Misc Receipts and Misc Receipts (Distributions)	There should be no AR account activity in these categories. If AR account activity occurs, add a special line for each and add to the column for the applicable AR account. Add the cash amount to the appropriate column on the Cash-Misc. activity line.
Sales Invoices	There should be no AR account activity in this category. If AR account activity occurs, add a special line for each and add to the column for the applicable AR account.
Sales Invoices (AR)	There should only be AR account activity in this category. For each account add to the Invoices activity line, split by AR account. If non-AR account activity occurs, add a special line for each and add a column for the applicable non-AR account.
Trade Receipts (AR)	There should only be AR account activity in this category. For each account, add to the Applied Receipts activity line, split by AR account. If non-AR account activity occurs, add a special line for each and add a column for the non- AR account. Add unapplied amounts to the appropriate columns.
Trade Remittances	There should be no AR account activity in this category. If AR account activity occurs, add a special line for each and add to the column for the applicable AR account. This should represent your Cash Account(s) only. Add cash amounts to the appropriate columns on the Cash-AR account line.

On the Journal Entries Report - Summary By Category, the "Total for Currency" debit and credit amounts should be equal, but the "Total for AR" debit and credit amounts may not be equal.

Determine the net amounts for each category and compare to the totals on the Balancing AR to the Aging spreadsheet. They should match.

Note that the Unapplied Amount plus the Unapplied Activity (from the Journal Entries Report) should equal the Applied Payment and Unapplied Activity totals from the reports.

Cross foot amounts by account in the Journal Entries Report Totals column. They should be identical to the amounts you used when balancing to the Aged Trial Balance with the exceptions noted above.

After GL has posted the Accounts Receivables entries, run the Account Analysis Report (from GL) for the period you just closed for each of the key accounts. Select:

Type Source Item

Currency USD

Balance Type Actual

Order by Account Segment.

Your key accounts should include all Accounts Receivable, Cash, Unapplied Cash and AP/AR Clearing accounts.

If any items are shown under the "Manual" Category or the Source is not "Receivables," add a line to the spreadsheet for that item, note the Batch Name, and add the amount to the proper column for the GL account. Add these items to the JE’s to-date line amounts by account.

Enter the "Beginning Balance" for each applicable account (from the Account Analysis Report) in the top gray line. Include this in your total activity calculation on the spreadsheet.

Enter the "Ending Balance" (from the Account Analysis Report) in the bottom gray line.

Add a new line for each manual journal entry and record the amount in the proper column for the account.
Derive the total for each account including the beginning balance and all activity.
Confirm that the "Ending Balance" on the Account Analysis Report is equal to the total you calculated on the spreadsheet.

Subtract the current period journal entry amounts from each total by account.

Subtract the period to date journal entry amounts from each total by account.

Calculate the new total. This should be identical to the totals on the Aged Trial Balance - 7 Buckets by Account (by account).

If you are not in balance, possible reasons are:

Manual Journal Entries may not be documented on the spreadsheet. Add to the spreadsheet. Also, find out why these manual journal entries are being done. If you are using the system properly, there should never be manual journal entries.
Activity from Sources other than AR. Add to the spreadsheet. Only Accounts Receivable should be using AR accounts. Find out why this activity is happening and get the practice stopped now.
Your posting did not complete successfully. Verify that you had no unposted items in the General Ledger Interface. Complete, post, and then try again.
You restricted the accounts to appear on the Journal Entries report. Do not select specific accounts. Allow for all accounts and see what you get. If necessary, re-run for all accounts.
You have changed the standard accounts used for Unapplied, Unidentified, and On-Account receipts, or for Accounts Receivable. Even if you change the defaults for these accounts, the original accounts are retained on the records and used if you have any subsequent activity against them. Run the reports for both the new and old accounts.
The dates you used for the Account Analysis report are not consistent with the dates you used for the Receivables reports. Re-run with consistent dates.

You have more than one accounting period open in Receivables so activity went to a period other than what you had expected.

The posting has not yet been completed in Oracle General Ledger (Journal Post). Complete and re-run the Account Analysis Reports.

Note that if you perform this reconciliation prior to the final close of the General Ledger period (a good idea), you will want to run the Account Analysis reports again after the period is closed to ensure that no additional manual journal entries have snuck in.

Exhibit C: BALANCING CASH IN ORACLE RECEIVABLES

1.	Complete all receipt entry and re-applications for the period
2.	View open batches using the Receipt Batches Summary form to see if you have any out-of-balance batches (Status = "Out of Balance"). Query each batch that appears on this form and determine why it is out of balance. Usually changing the control count and amount to equal the actual count and amount and will bring the batch into balance, but you should research why this happened to prevent it in the future.
3.	Run Period End reports:
	Reports à Other
	Deposited Cash - Applied Detail
	Deposited Cash - Open Detail
	Reports à Accounting
	Receipt Register
	Reversed Receipts Report (Order By "Remittance Bank")
	Journal Entries Report - Summary by Category (for Trade Receipts and Misc. Receipts categories only)
	Miscellaneous Transactions Report
4.	Compare totals on the individual reports to the Journal Entries report to see if they match, including:
	The net amount for Misc Remittance (on the Journal Entries Report) should equal the Misc Applied total (in the Deposited Cash - Applied Details Report);
	The net amount for Trade Remittances (on the Journal Entries Report) should equal the AR Applied Total (in the Deposited Cash - Applied Details Report);
	The Credit amount for Misc Remittance (on the Journal Entries Report) should equal the Total For Miscellaneous Cash Receipts (in the Reversed Receipts Report);
	The Credit amount for Trade Remittances (on the Journal Entries Report) should equal the Total For Invoice Related Cash Receipts (in the Reversed Receipts Report).