Gl_oracle ERP Monthly statement and festival process discussion (concept)

First, what is the monthly knot processing

Usually, the business finance department at the end of each month to check the monthly accounts, to carry out settlement processing. For example, the current month's manufacturing costs are converted into production costs, the sharing of public fees between departments, etc., and the production and printing of related reports and analysis reports. Finally, the current period of the opening of the next month, the beginning of the next month's account processing.

Oracle ERP is a multi-functional module composed of e-commerce system, including account processing and transaction processing two parts, of which the general Ledger is called the accounting processing system, and other modules, such as: Receivables, Payables, assets, inventory, called the business Processing system, is customary called: subsystems. Due to the large number of business data in the subsystem, the Oracle monthly junction process has not only stayed at the general ledger system level, so in a certain order to check the subsystem's accounts, and shut down the subsystem accounting period, finally closed the general ledger period. The monthly clearance process is usually recommended in the following order:

Close purchase period >> Close Inventory period >> Close Payables period >> Close assets period >> Close receivable period >> close General Ledger period bbs.bitsCN.com China Network Management Forum

Second, monthly knot processing and period closure

The sub-module of the monthly business, is usually to ensure that all the month the business has been completed, the sub-module to run the corresponding report, and the corresponding accounts in the general ledger reconciliation. To find the reasons for the difference, reasonable in the general ledger to adjust, so that the accounts are consistent.

Here's a look at how to close the subsystem in order:

A) closing the purchase accounting period

1. Run the "Purchase Order Detail Report", "Purchase order and issuance Detail report", "Open purchase Subscribe table (by Buyer)", and Report on "Opening Purchase order report (by cost center)" To display the quantity and quantity of the order and check It (path: report >> run);

2, run "Not invoiced receive report", view and check the data (path: report >> run);

3, for the end-of-term accrual accounting of the cost procurement category, run the "Receive accruals-end" process, import the purchase journal into the General Ledger (path: report >> run);

4. And close the purchase period (path: Setup >> financial Systems >> Accounting >> Control purchase period).

II) closing the inventory accounting period

1, ensure that the current month all transaction processing has been completed, and import General Ledger;

2. Check if there are pending transactions in the month, and ask the person concerned to process (path: View transaction processing >> pending item transactions);

3. Close the inventory accounting period (path: Fiscal closing period >> Inventory accounting period).

III) Closure of the receivable accounting period

Most of the business of the receivable module is based on the operations of the Order Management module and the Inventory module, so the monthly closing of the receivable module should be closed after the Order Management module and the Inventory module month.

1, submit the "Incomplete Invoice report", "not write off the collection registration form" and other procedures, check whether there is an incomplete status of invoices, credit memo and "accounting" status of the collection, etc. (Path: report >> accounting);

2, run automatic invoicing, to ensure that the current month invoice has been fully imported from the Order system (path: interface >> automatic invoicing);

3, the operation of import General ledger system procedures to ensure that the month invoices, receipts, etc. have been fully imported to the General Ledger system (Path: Interface >> General ledger management System);

4. Close the receivable Accounting period (path: control >> Accounting >> Open/close period).

(iv) Closure of the accounts payable period

Most of the business of the coping module is based on the operation of the procurement module and the Inventory module, so the monthly closing of the coping module should be closed after the purchase module and the Inventory module month to close the accounting period.

1, run the "Invoice registration" program, check whether there is unapproved, need to re-approval of invoices, credit memo, etc. (path: Other >> request >> run);

2, run the "Accounts Payable management System Accounting Process", "Transfer accounts payable to the general ledger" to ensure that the current month transaction processing is fully transferred to the General ledger (path: Other >> request >> run);

3, run "create mass increase" to ensure that the purchase of fixed assets, construction project invoice information to the Fixed Assets Module (path: Other >> request >> operation);

4. Close the Payables Fiscal period (path: Accounting >> Control Payables period).

(v) Closing of fixed asset accounting periods

The asset module period is generally closed after the period of the payables to prevent the acquisition of fixed assets in the current period not created capitalization.

1, please check whether there is a new fixed asset or the project is not imported (path: Batch increase >> prepare batch increase);

2. Confirm that all assets are assigned a row, and if the asset is not assigned to the allocation line, the depreciation procedure for the end of the term cannot be completed and the period cannot be closed. Run the asset list report that is not assigned to any cost center to determine which assets are not assigned to the allocation line. For these assets, specify their allocation line information. (Path: Other >> request >> run)

3. Depreciation during operation not closed, ensure that the journal accounts for depreciation are correct, and have been imported into the general ledger (path: depreciation >> running depreciation);

4. Run depreciation Close period (path: depreciation >> run depreciation).

(vi) Processing of monthly carry-over gains and losses (optional)

If the enterprise needs to carry over the profit and loss at the end of the month, the revenue and expenses will be carried over to this year's profit account. Usually we do it in manual journals or recurring journals. Note that because the balance for each account needs to be maintained for the report to be generated, it is common to define a virtual revenue account, a virtual expense account method, and generate the following entry in the General Ledger module:

Borrowing: Virtual revenue account revenue for the month

Credit: Virtual expense account Total cost this month www_bitscn_com China. Network Management Alliance

Borrowing/lending: This year's profit account monthly revenue-Total cost of the Month |

VII) Cost Variance allocation

Prerequisites: Make sure that the sub-module accounts have been imported into the general ledger and that all manual/import journals have been posted.

The following is an example of cost variance allocation under the standard Cost method, which gives a common approach:

For the purchase price difference, the invoice price difference, at the end of each month according to raw materials, self-products, inventory goods, sales cost of the month value of the weight allocation, in the general ledger for the following apportionment treatment:

Borrowing: Cost of sales-products

Finished Products-differences

Semi-Finished products-differences

Raw materials-Differences

Credit: Cost Variance-Material spreads

Cost Variance-Invoice spreads

For WIP material usage, resource efficiency, manufacturing cost variance, the monthly end of the month by the completion of the product value of the allocation, in the general ledger for the following apportionment treatment:

Borrowing: Cost of sales-products

Finished Products-differences

Semi-Finished products-differences

Credit: Cost Variance – Material weight difference

Cost Variance – Resource efficiency variance

Cost Variance – Manufacturing cost variance

For the standard cost adjustment differences, in the raw materials, self-made parts, finished products, sales cost month-end value of weight allocation, in the general ledger for the following allocation treatment:

Borrowing: Cost of sales-products

Finished Products-differences

Semi-Finished products-differences

Raw materials-Differences

Credit: Cost Variance – Cost adjustment variance

Using the average cost method, generally the difference is relatively small, can be directly carried forward to the current month of the cost of sales. If allocations are indeed required, they can also be apportioned according to the principle of a similar standard cost variance.

VIII) Closing the general ledger accounting period

1, ensure that all the journals are posted, run the "Trial Balance-Details", check the balances, to ensure that the correct (path: other >> request);

2. Close the general Ledger accounting period (path: Set >> on/off). Bitscn~com

Usually, the end of the month by the form of the method (that is, only out of the report and not the actual profit and loss carry-over) to checkout work, all revenue and expenses will be carried over to this year's profit account.

If we do not need any year-end entries, we open the first phase of the new fiscal year directly to initiate the concurrent process to update the account balances. When the first period of a new fiscal year is opened, the profit and loss statement is automatically settled and the difference is posted to the retained earnings account specified in the accounts set.

If we need to generate annual transactions, please refer to the following procedure:

In order to facilitate the period balance after the annual knot is not affected by the annual transaction, we typically set the fiscal period to 13 periods per year (1 adjustment periods at year-end), 14 periods (1 adjustment periods at the beginning and the end of the year). Year-end entries are completed within the adjustment period.

By the end of December, all accounts processing is completed, the December period is closed, and the year-end adjustment period is opened. If you need to create an actual settlement journal entry to display a record of closing the profit and loss account to retained earnings, submit a "close process-create profit and loss statement to close the journal" program, which creates an auditable closing journal entry. If your local accounting rules require you to settle your balance sheet, submit a "close process-create balance sheet to close the journal" program.

In addition, year-end retention processing can be performed to identify outstanding purchase orders and request retention monies, cancel some or all of the encumbrance, and carry forward the retention, budget, and available funds balances to the new fiscal year. If you do not carry over the encumbrance, you may need to cancel existing requisitions and purchase orders that contain the encumbrance.

Three kinds of surplus carry-over amount of three-year knot processing

a) How to carry out year-end profit and loss

When we open the first period of the new fiscal year, the system will automatically carry the balance of all revenue and expense accounts to the retained earnings account. This is not going to generate any credentials.

If you need to generate the corresponding closing voucher, you will need to submit the "close process-create profit and loss statement to close the journal" program to automatically create the required vouchers.

Path: (GL) Other >> requests >> standards

The program generates a journal to settle the actual balance of the year-to-date (YTD) in the range of an income and expense account. This program can be submitted for any open period, in other words, this program can also be used to do the profit and loss of the monthly knot processing.

1, Period: The default is the most recently opened period, which is typically specified as the adjustment period for the last day of the fiscal year.

2, account from, to: This range can cover multiple balance segments, and can include a complete list of chart of accounts. The system only extracts the balances of the revenue and expense accounts in the specified range.

3. Settlement account: Usually the retained earnings account in the balance sheet. If you want to settle multiple balance segments, a separate billing account is created for each balance segment.

4. Income offset account (optional): You can enter your profit and loss account.

5, Category: If you do not enter the income offset account, the system defaults to "off the profit and loss statement", if you enter the income offset account, the system defaults to "income offset."

If the income statement balance uses both the standard currency and the foreign currency, the settlement process generates a journal batch that contains separate journals for each processing currency. For the standard currency, the journal will have only the input amount because no discount is applied. In the case of foreign currency, the journal will have both an input amount and a discounted amount.

If the income offset account is not entered, the system adjusts the YTD balance of each income and expense account within the account to zero, and the amount posted to the retained earnings account will be the total net of the YTD balance of the income and expense account. The resulting settlement entry is as follows

Borrowing: Revenue Detail Account

Credit: Expense Detail Account

Credit: Retained Earnings

Note that, in fact, the ledger transactions, the retained income line is the borrower has the number, no spread is net, and if the income, expense account lenders have the balance, the system generates the same ledger transaction line is also the borrower has a number.

If the income offset account is entered, the system does not adjust the revenue and expense accounts within the specified account to zero. However, the total net amount of the program accounting income and expense account (this total includes the balance in the offset account). It then posts the total net amount to the corresponding credit column of the income offset account, if the income is greater than the cost. The resulting settlement entry is as follows

Borrowing: Income offset account

Credit: Retained Earnings

The effective date for the settlement journal entry is the last day of the period you specify in the Parameters window, usually the last day of the fiscal year, which is the adjustment period. We post a review of the system-generated journal, with zero revenue and expense account balances transferred to the retained earnings account.

When we open the first period of the new fiscal year, the system will automatically carry the balance of all revenue and expense accounts to the retained earnings account. However, because the income and expense account balances transferred to the retained earnings account have been zero after posting the settlement journal, the process during the opening of the new fiscal year does not transfer the balance and has no other impact on retained earnings.

If you need to make revenue and expense adjustments after opening a new fiscal year, posting retroactive adjustments automatically updates the opening balances for the retained earnings account for all open fiscal periods in the new fiscal year. However, the amount in the settlement journal does not reflect the adjustment. For the sake of accuracy, you must first reverse the settlement journal, make postings, enter adjustments, and then run the create profit and Loss Statement settlement Journal program and post it. Bitscn~com

II) How to carry out the year-end closing of the balance sheet (not recommended)

If local accounting rules require that the balance sheet be settled, it is best to define a fiscal calendar that includes two adjustment periods: one is the last day to settle the fiscal year, and the other is the first day of the new fiscal year. Run and post during the final adjustment period for the fiscal year to be settled, and during the first adjustment period of the new fiscal year, reverse the settlement Journal of the balance sheet to re-fill the balance sheet account. This will not affect the account balances in the reporting period.

Note: The system only settles the balance of the standard currency and foreign currency, and the foreign currency balance will be ignored.

Path: (GL) reports >> requests >> standards

1, period: The default most recently opened period, usually specifies the adjustment period that represents the last day of the fiscal year.

2, account from, to: can cover multiple balance segments, and can include a complete list of chart of accounts. The system only extracts balance sheet account balances within a specified range.

3. Settlement Account: Balance sheet settlement account.

4. Category: Default "Close Balance Sheet".

If you do not need to settle your balance sheet, you usually close this issue directly and open a new fiscal year.

III) end-of-year encumbrance carry-over processing

First, in the procurement module, run a batch Cancel to cancel the selected open purchase order and apply the encumbrance.

Then, all retention, budget, and actual journal entries are posted in the general ledger, and the retention balances and activities for the general ledger account are reviewed in detail prior to year-end closing through the Encumbrance Trial table report.

After verification, close the last period of the year, open the first period of the next fiscal year, open the next retention year, and open the next budget year. Then carry out the encumbrance carry-over (otherwise all the encumbrance will automatically change to 0):

Path: (GL) Journal >> build >> Carry

1. Carry-over rules: limited to encumbrance only-system accounting calculates the balance as of the beginning of the year to date, and carries the balance to the beginning of the first period of the next fiscal year, the retention and retention budgets-system accounting balances are retained at the beginning of the year to date, and the retained balances are added to the budget balances. The total amount is then carried over to the opening balance of the first period of the next fiscal year, and the available funds-the system calculates the available funds by subtracting the year-to-date budget balances from the actual and retained balances of the year to date. The calculated amount is then carried over to the opening balance of the first period of the next fiscal year.

2. Type of encumbrance: Please enter the type of encumbrance to be carried over. Select all to carry forward the amounts for all encumbrance types.

3. Budget: Enter the budget name and the budget organization.

4, period from, to: The system will calculate the year-to-date amount according to the starting period, but will not update the balance of the existing starting period.

5. Carry-Over scope: The system only carries the balance for the account within the input range and the account assigned to the designated budget organization.

Abalone New ********************

Reprint: I don't sell tofu-http://www.cnblogs.com/toowang/archive/2012/12/14/2818644.html