A summary of the monthly knot
1, what is called the month Knot: from the literal meaning, namely for the end of the month checkout.
2, the purpose of the monthly knot 1) Accounting instalment 2) Financial report 3, what is called reconciliation: will be two sets of accounts check. In Oracle, the main point is to reconcile the sub-module's account with the general ledger. 4, why to reconcile: General Ledger received financial information and sub-module business must be consistent, in order to ensure that the entire system of accounting is correct, so to be reconciled. In the daily transaction processing, there are errors caused by input or system anomalies, which can be found and resolved in time by reconciliation.
5. Relationship between monthly statement and reconciliation:
Reconciliation is an important issue in the process of monthly knot.
2. The relationship between the submodule and the General Ledger
N General ledger module is in the core position of financial accounting, it receives financial information from other modules N sub-modules include: Coping module, purchasing module, Inventory module, receivable module, Fixed assets, payroll module, etc.
3. Closing order: 1, which modules have period control: General Ledger, payables, receivables, assets, procurement, inventory, etc. 2, the closing sequence of each module is as follows:
Payables >> Purchases >> Inventory >> receivables >> Assets >> (PAC) >> General Ledger
N1, Payables module The fiscal period should be closed prior to the accounting period of the procurement module, since the matching of the response affects the accrual of the purchase module and the release of the encumbrance; N2, Oracle cost module, and Sales order module The fiscal period is the Inventory module accounting period, Inventory module accounting period closed, the Inventory module, The accounting period for the Oracle cost module and the sales order module is closed; N3, if PAC is used, the payables, Purchasing, inventory, and receivable accounting periods must be closed before the actual cost accounting period of the PAC can be closed; N4, receivable module The fiscal period must be closed after the Inventory module accounting period, Because the Inventory module sales out of the library needs to be transferred to the AR Invoice Interface table, N5, asset module Accounting period must be closed after the Purchase module and Inventory Module accounting period, because the fixed asset information or data may be derived from the Inventory module and procurement module; N6, the fiscal period for all submodules is closed, and the general ledger accounting period is closed.
II. detailed checkout process and reconciliation of each module
1\ Coping module:
1, check and confirm that all the purchase invoice and the cost invoice of this issue have been processed in the system
P check and confirm from the business that all the purchase invoice and invoice business in this issue have been processed in the system.
2. Check if there is an unverified, pending invoice
P Use the "Invoice registration form" (Invoice Register) (Note: Select "Yes" in the parameter limited to unverified invoices) to review details about unapproved invoices, re-validate invoices, and P submit "pending Invoice Report" (Invoice Check to see if there are pending invoices. When you submit the report, the report parameter does not need to enter a date range, because all invoice pending must be resolved before the accounting period is closed; p resolve all pending, resubmit the pending Invoice report to confirm that all pending are resolved.
3. Check and confirm that all payment services in this issue have been processed in the system.
P check and verify from the business that all payment services in this issue have been processed in the system.
4, check whether there are non-accounting transactions in the current period
P submits the "Unposted Transaction Report" (unaccounted transactions reports) to check whether there are unrecorded transactions in the current period. The report can display both A/p invoice and a payment, as long as it is not posted, all will be displayed, and the reason for it, and what status is currently being processed.
5. Create a ledger account
P Create a ledger account by submitting a request (create accounting), which will be payable for business creation (the parameter "End Date" is entered on the last day of the current period).
6, the delivery of business to the General Ledger
P If you submit "Create ledger account", "Transfer to Oracle General Ledger" Select Yes, the voucher is routed directly to the GL module. Otherwise, you need to submit a request to "transfer journal entries to GL"; p Note that you get the relevant information from the output file to help you review the build of the journal.
7. Post the voucher for the source in the general Ledger p in the general ledger, all transactions originating in the payables are posted to update the account balance.
8. Confirm and check supplier balance
P Run "Cux: Vendor Balance Sheet" (or "account Analyst report" in the Payables module), run "Trial calculation Trail Balance" in the General ledger module to check whether the balance of accounts payable and G/L Liability account balances are equal (if necessary, Can be reconciled with the supplier); P Note: It is recommended that reconciliation with the general ledger be performed when the general ledger is not in the final revaluation.
9, the delivery to the asset after the completion of the above-mentioned business transfer General Ledger, the content of the assets involved in the transaction to the asset interface, by submitting a request "Create a batch of add create massive addition"
10. Closing the period of the period of due
P by the end of the month or early next month, in order to prevent the user from dealing with the business errors, the corresponding accounting period should be closed. P selects the period status as "off" and then saves it, and when saved, the system automatically checks for an exception, including invoices and payments for non-raw ingredients, and payables for non-routed General ledger, if any, before the closing of the payables period.
11, check the binding status of the invoice for the current period (optional steps, depending on the specific voucher binding solution) p check the binding status of the invoice payable in this period, whether to organize and store by serial number.
12, check the binding of the current payment document (optional steps, depending on the specific voucher binding solution) p Check the binding of the current payment document, whether to organize and store by serial number.
Serial number |
Subjects to be checked |
Account examples |
The main standard reports available to |
Common Development Reports |
1 |
Accounts Payable classes |
such as Accounts payable, other payables |
Account Analysis Report |
Cux: Vendor Invoice Balance Schedule |
2 |
Prepaid account Category |
such as prepaid accounts, other receivables |
Account Analysis Report Prepayment Status Report |
Cux: Vendor Prepayment Balance Table |
3 |
Accrued liability |
such as Accounts payable-provisional estimate |
Receive report without invoicing |
Cux: Payables Balance Detail Report |
4 |
Carry out tax |
If tax payable-VAT payable-Input tax |
Account Analysis Report |
Cux: Purchase Tax Reconciliation report |
Reconciliation of payables Modules-Daily operational requirements
The following principles are required to ensure that the accounts payable and prepaid account accounts correctly reflect the vendor balances:
n Do not enter the Accounts payable account in the distribution line of the invoice;
n Do not enter the "prepaid accounts" account in the distribution line of the non-prepayment invoice, n check the "Payables" and "prepaid" accounts defined on the vendor, and suggest that the employee vendor differs from the external vendor's "Payables" and "prepaid" classes so that the accounts payable and prepaid accounts reflect the actual external debt obligations of the company.
Purchase module Detailed checkout process
1, the business to confirm whether the purchase order entry completed
2, business confirmed that the purchase order has been received on arrival
3. Check if there are items that have been received but not in storage
P finds items that have been received but not inbound in the Receive transaction processing (receiving transactions) interface.
4. Closing the purchase period
P if the current purchase and receipt business has been completed, the corresponding purchase accounting period is closed to prevent the continuation of the purchase order and the received business within the period of need to close.
Inventory module Detailed checkout process (under standard cost)
N1, enter all the inventory transactions p business, please ensure that all transactions within the input period, and the current month's inbound, outbound vouchers bound to a book, in order to review later.
N2, carry out the stock count p to ensure that all inventory transactions in the current period have been correctly entered into the system, and the warehouse is counted and adjusted according to the counting results (after approval) in the system. N3, manufactured parts cost convolution p run request, the standard cost of convolutional manufacturing parts.
N4, Standard Cost update p runs the request, updates the standard cost, and updates the pending cost to the frozen cost.
N5, check for 0 cost of material transactions (optional step, depending on solution) N6, modify cutoff setting (optional step, depending on solution) p modify the deadline for the inventory organization setting to change it to the last day of the checkout month, for example, when the month of May 2008 is closed, Change it to "2008-05-31 23:59:59" so that the system automatically generates inventory-related accounting entries.
N7, check inventory and transaction processing interface p Check inventory transaction processing open Interface, pending inventory transaction processing, non-accounting cost transaction processing and so on.
N8, transferring a transaction assignment to General Ledger and posting p transfers the summary inventory/WIP activity for a given period to the general ledger interface, and then uses journal import in the general Ledger module to transfer this information to the general ledger.
N9, check the final inventory value and general ledger related account value P use the "Cux: Send and Receive Report" (or Inventory Value report) and the general ledger raw material, inventory commodity account balance check.
N10, closing stock this period p before opening the next fiscal period, you need to close the inventory accounting period for the current period to avoid processing the inventory business into the wrong period. P The control of the inventory accounting period is controlled by the inventory organization, which is closed and opened separately according to the inventory organization. P before closing the inventory accounting period, you need to confirm that the inventory transaction for the current period has been fully completed and then closed. P Once the inventory accounting period is closed, it cannot be opened again. P Use the Inventory accounting period interface to close inventory periods, the system automatically transfers the aggregated transaction journal to the General Ledger interface table.
Reconciliation of Inventory module (under Standard Cost)
Serial number |
Subjects to be checked |
Account examples |
Standard reports available to |
Common Development Reports |
1 |
Inventory Valuation Account |
such as raw materials, inventory goods |
Inventory Value Report |
Cux: Receiving and depositing reports |
Inventory module detailed checkout process (PAC cost)
N1, enter all the inventory transactions p business, please ensure that all transactions within the input period, and the current month's inbound, outbound vouchers bound to a book, in order to review later.
N2, carry out the stock count p to ensure that all inventory transactions in the current period have been correctly entered into the system, and the warehouse is counted and adjusted according to the counting results (after approval) in the system. N3, check inventory and transaction processing interface p Check inventory transaction processing open Interface, pending inventory transaction processing, non-accounting cost transaction processing and so on.
Note: 1, the PAC's checkout process, in the "PAC Detailed checkout Process" part of the re-described;
2, because in the PAC, the general use of PAC Accounting Accounting, Inventory module (PAC cost) of the reconciliation in the PAC section is elaborated.
Receivable module Detailed Checkout process
N Run the Auto-invoicing program p to run the auto-invoicing program and import the non-invoiced records from the OM module.
N2, check the Automatic Invoicing interface table with or without error records p run automatic invoicing if an error record fails to import form an invoice, it will be persisted in the interface table and marked with an error. You need to view the interface table to see if there is an error record, modify the settings for the wrong reason, and then import the invoice again.
N3, confirm this issue manual invoice, collection business all completed p from the business confirmed that the manual invoice, collection, collection and write-off business has been completed. View the invoice used this month: Transaction processing registration form, to view the current month input collection use: Collection registration form. N4, check if there is an outstanding status of a/R invoice p to check for outstanding invoices by submitting the outstanding Invoice report. N5, create ledger account P Create a ledger account by submitting a request to create a ledger account (the parameter "End Date" enters the last day of the current period).
N6, transfer of receivables to General Ledger p if you submit "Create ledger account", "Transfer to Oracle Ledger" Select Yes, the voucher will be routed directly to the GL module. Otherwise, you need to submit a request to "transfer journal entries to GL"; p Note that you get the relevant information from the output file to help you review the build of the journal.
N7, check the non-recorded receivable transactions p after the receivable business to the general ledger, to check for the existence of non-recorded receivables transactions. The method of checking is to submit a "non-posted Item report".
N8, receivable and General Ledger reconciliation p in the total receivable business to the general ledger, pending the corresponding voucher in the general ledger after the reconciliation, to ensure that the general ledger and sub-modules are consistent; P reconciliation method is: In the general ledger run "Trial Balance", view accounts receivable balances; Submit "Cux: Customer balance Detail Report" in the receivable module (or Account Analysis report), which is used to check the breakdown of Accounts receivable balances; P Note: It is recommended that the reconciliation of the receivables to the general ledger be carried out when the general ledger is not in the final revaluation.
9. Closing the receivable period
N10, check the binding of the current receivable invoice (optional steps, depending on the specific voucher binding solution) p Check the binding of this month's receivable invoice, whether to organize and store by serial number.
N11, check the binding status of the payment document (optional steps, depending on the specific voucher binding solution) p Check this month's collection document binding situation, whether by serial number sorting and storage.
Serial number |
Subjects to be checked |
Account examples |
Standard reports available to |
Common Development Reports |
1 |
Accounts receivable category Account |
such as accounts receivable, other receivables |
Account Analysis Report |
Cux: Customer Balance Detail Report |
2 |
Income class Account |
such as main business income, other revenue |
Account Analysis Report |
Cux: Sales Tax Reconciliation Report |
3 |
Notes Receivable Related Subjects |
such as notes receivable |
Incoming payment report Awaiting remittance Receipts awaiting Bank settlement report |
|
4 |
Sales tax Account |
If tax payable-VAT payable-sales tax |
Account Analysis Report |
Cux: Sales Tax Reconciliation Report |
In order to ensure that the accounts receivable account accurately reflects the customer balance, the following principles apply:
n When you enter an invoice, you must not manually enter the accounts receivable account in the allocation line; N guarantees that the accounts maintained at the "non-write-off", "accounting", "not identified" types are subject to the accounts receivable, or to the current account, and if other accounts are set up for special business needs, Please be sure to check that there is no non-write-off at the end of the month;
n Check the relevant account at the source of the automatic accounting definition, such as "Accounts receivable" from the customer location, you must strictly ensure that the "accounts receivable" maintained at the customer's location is correct.
Asset module Detailed checkout process
N1, complete all transactions during the checkout period p determines that all transactions are accounted for during the checkout period. Once an Oracle asset closes a depreciation period, the period cannot be opened again. Check that the transaction is no longer transacted and that the Oracle asset does not allow transactional data entry when it runs "depreciation."
N2, assign all assets to distribution line p 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 list of assets not assigned to any cost center report to determine which assets were not assigned to the allocation line. N3, running depreciation p for each depreciation book, the process of running depreciation is performed independently. When you run the program, the Oracle asset automatically calculates the depreciation for all assets, and after the depreciation runs, Oracle runs the journal Entry Reserve Ledger report, which is the equivalent of the depreciation report for the current period; P can choose whether to turn off depreciation periods when running depreciation. If you select close Fiscal period, once you start to run depreciation, the current depreciation period is automatically closed and the next period is opened (see 2nd above) However, if an asset is not assigned, the run depreciation ends and an error message appears. By viewing the log file that runs the output of the depreciation request, you can know which asset is not assigned, or view the depreciation program report by viewing the request table. Then assign the unassigned assets and rerun the depreciation process. Depreciation will only be for assets that are not part of the run.
N4, raw ingredient p by using Create accounting, a depreciation fee entry can be generated for the general ledger on the company account. Before use, determine that depreciation procedures have been run for the specified depreciation books and depreciation periods. The poracle asset uses account generator to generate a ledger account combination to produce an ingredient record in the general ledger. Oracle assets default to depreciation charges to generate full detail entries. The entire segment value of an assigned line named in the use of an asset transfer for an Oracle asset is a raw ingredient for the depreciation fee.
N5 The journal posting to the general Ledger P will post the transferred journal review after posting, check the balance of the interim account such as "fixed asset transit", "fixed asset cleanup" after posting, check whether it is flat; p run the "Cux: Fixed Assets Account" Report for this period to check for "fixed assets" and "accumulated depreciation" The balance of the account is equal.
Serial number |
Subjects to be checked |
Account examples |
Standard reports available to |
Common Development Reports |
1 |
Fixed asset cost account |
such as fixed assets |
Cost Detail Report Cost Summary Report |
Cux: Fixed asset ledger |
2 |
Accumulated Depreciation Account |
such as accumulated depreciation |
Reserve Details Report Reserve Summary Report |
Cux: Fixed asset ledger |
PAC Closing Process:
N1, check for non-recorded cost transactions p check for outstanding cost transactions, "calculated cost" in the material transaction interface Select "No" and "error", if there is a record you need to query cause N2, run PAC related request
The following requests or reports are run by the cost accounting member in turn:
P runs the periodic acquisition cost adjustment (optional) to adjust the costs variance due to cross-period invoice matching; P Run periodic acquisition the cost to get the total amount of material costs incurred P runs the periodic cost to calculate the material costs; p runs the periodic distributions, generating inventory transaction-related entries.
N3, update resources and manufacturing cost rate p to ensure that all the cost vouchers entered, run Cux: Manufacturing cost calculation table, according to the actual rate in the system to do the rate update.
N4, run sales cost confirmation related requests
Three requests related to the sales cost confirmation run by the cost accounting staff:
P Records the Order management transaction; P collects revenue acknowledgement information; p generates a sales cost confirmation event. N5, run PAC monthly statement request, review actual cost
The following requests or reports are run by the cost accounting member in turn:
P runs the periodic acquisition cost adjustment (optional) to adjust the costs variance due to cross-period invoice matching; P Run periodic acquisition the cost to get the total amount of material costs incurred P Run periodic cost to calculate material costs, p run periodic distributions, generate inventory transaction related ledger, p if there is material cost to be adjusted, the related item is cost updated, and then run the above request or report in sequence.
N6, check the final inventory value and general ledger related account value p run periodic items and receive distribution Summary report, check the current occurrence amount of inventory related account, p Run Periodic WIP distribution Summary Report, check the current occurrence amount of workshop related account;
N7, close the inventory during the current period N8, close the PAC during the transfer to GLP to confirm that the cost period is not a problem before the costs can be closed. Once the cost period is closed and cannot be opened again, adjustments can only be made during the next period. After closing, you need to pass the request to the General ledger module; p before closing the PAC period, the inventory period must be closed, the shutdown of the PAC is not organized in inventory, and is differentiated by the legal entity, so if you want to close the fiscal period for a legal entity, you must first close the period for all inventory organizations under that legal entity. PAC Module Reconciliation:
Serial number |
Subjects to be checked |
Account examples |
Standard reports available to |
Common Development Reports |
1 |
Inventory Valuation Class Account |
such as raw materials, inventory goods |
Periodic inventory Value Report Recurring item and receive Distribution Detail report Recurring item and receive distribution summary report |
Cux: Receiving and depositing reports |
2 |
Issue Commodity accounts |
If a product is issued |
|
Cux: Issue a product detail report |
3 |
WIP class Account |
such as production costs, resource absorption accounts, manufacturing costs to absorb accounts |
WIP Distribution Detail Report WIP Distribution Summary Report |
|
General Ledger module Detailed checkout process
N1, confirm this month manual certificate completion p confirmed this month manual voucher has been all input, review, posting.
N2, check whether the balance of the transfer account is zero p in the general Ledger module to submit the report "Trial Balance", the report parameters in the "Amount type" select "PTD". If you find that the interim account balance is not zero, submit the report "Trial count-Details", using the account balance query, query reason and adjust.
N3, confirming all voucher postings perp a series of standard statement balances that do not include unposted balances, you need to ensure that all journals have been posted before checking the general ledger balances, and that all vouchers are posted so that you can check the account balances and the amount of the occurrence. Check if there is an unposted method as follows: L1) through the gl> journal > postings Menu query for non-posting L2, enter through the gl> journal > Input menu, and select the Status field is not posted to see if there are no posted vouchers. N4, defining the period exchange rate and conducting the final exchange rate revaluation p after each business is completed, the final foreign currency revaluation shall be carried out. P Post the revaluation voucher after review. The revaluation voucher is then reversed for the following month.
5. Operating balance sheet and profit statement
P Submit FSG Statement "balance sheet" and "profit statement". and submit the standard report "Trial Balance", and check with sheet and profit statement.
N6, closing the general ledger period
N7, voucher printing and binding P basic ideas: the original document by the category of separate binding, General ledger entry voucher printed with the original document, sub-module voucher attached to the business data list.
Oracle EBS R12 Financial Monthly Statement basis (RPM)
