Shulou(Shulou.com)06/03 Report--

Oracle ERP system loan relationship table

Summary of accounting information of cost accounting

Summarized by the source type of the transaction.

I. Purchasing, receiving and returning goods:

1. Receive: borrow: material purchase (order price)

Loan: accrued liability (order price)

two。 Storage: borrow: raw materials (standard cost)

Loan: material purchase (order price)

Borrow or loan: material cost difference _ material order price

3. The entry opposite to step 2 above is generated when the goods are returned to reception, and the entry opposite to step 1 above is generated when the goods are returned to the supplier.

Second, sub-inventory transfer: only transfer out of the sub-database to generate entries.

Borrow: raw materials (self-made semi-finished products, stock goods)

Loan: raw materials (self-made semi-finished products, stock goods)

III. Miscellaneous transactions:

1. Inventory increase: borrow: raw materials (self-made semi-finished products, inventory goods)

Loan: account alias (or custom account)

two。 Inventory reduction: entries contrary to the above

Fourth, purchase invoice matching: borrowing: accrued liabilities (order price)

Tax payable _ VAT _ input tax

Loan: accounts payable (invoice price)

Debit or loan: material cost difference _ material invoice price difference

5. Production links:

1. Standard work order:

① standard work order picking: borrowing: production cost _ direct production cost _ material

Loan: raw materials (self-made semi-finished products, stock goods)

② standard work order return: the entry opposite to the above

③ standard work order resource transaction (that is, labor): although we do not carry out actual labor cost accounting in the WIP module, the system will automatically calculate a sum of money. Based on the absorption account when defining resources as "production cost _ direct production cost _ direct labor", the system produces the following entries:

Borrowing: production cost _ direct production cost _ direct labor (including cost center information)

Loan: production cost _ direct production cost _ direct labor

(the value is zero, and only work orders with resources and process routes defined by assemblies will produce this entry)

Therefore, when the general ledger module deals with actual labor and manufacturing costs, it is recommended that:

Borrow: production cost _ production cost variance _ labor (actual wages)

Loan: wages payable

Borrowing: production cost _ production cost variance _ expense (actual manufacturing expenses)

Loan: manufacturing cost

④ standard work order completed and put into storage: borrow: raw materials (self-made semi-finished products, stock goods)

Loan: production cost _ direct production cost _ direct material

Production cost _ direct production cost _ direct labor

Production cost _ direct production cost _ direct expense

(only goods in stock will have labor and expense subjects)

If ⑤ is produced according to the standard cost, that is, the incurred cost is the same as the deduction cost, there is no difference when the work order is closed.

When the ⑥ work order is closed, if the cost of the material is greater than the deduction cost, that is, more materials are consumed:

Borrow: production cost _ production cost variance _ material

Loan: production cost _ direct production cost _ direct material

If less material is consumed, the opposite entry is produced.

The production process only produces a difference in quantity and does not produce a price difference.

When the ⑦ work order is closed, the entries for labor and expenses are always:

Borrow: production cost _ direct production cost _ direct labor (standard)

Production cost _ direct production cost _ direct expense (standard)

Loan: production cost _ production cost variance _ labor

Production cost _ production cost variance _ expense

two。 Non-standard work orders: (general entries are not summarized, such as materials, etc.)

① has non-disassembly work orders for completion and storage.

When sending out the finished product: borrow: production cost _ direct production cost _ direct material (standard)

Production cost _ direct production cost _ direct labor (standard)

Production cost _ direct production cost _ direct expense (standard)

Loan: finished products

When it is finished and put into storage: borrow: goods in stock

Loan: production cost _ direct production cost _ direct material (standard)

Production cost _ direct production cost _ direct labor (standard)

Production cost _ direct production cost _ direct expense (standard)

When closed: borrow: production cost _ direct production cost _ direct labor (standard)

Production cost _ direct production cost _ direct expense (standard)

Loan: production cost _ production cost variance _ labor

Production cost _ production cost variance _ expense

Borrow: production cost _ production cost variance _ material

Loan: production cost _ direct production cost _ direct labor (standard)

Production cost _ direct production cost _ direct expense (standard)

② disassembly work order:

Send out the finished product, as above

Distribution of negative components: borrow: raw materials (self-made semi-finished products)

Loan: production cost _ direct production cost _ direct material

Return the negative component to produce the opposite entry

When closed: borrow: production cost _ production cost variance _ material

Loan: production cost _ direct production cost _ direct material (standard)

Production cost _ direct production cost _ direct labor (standard)

Production cost _ direct production cost _ direct expense (standard)

3. Other types of outsourcing processing, coprocessing, coding splitting, etc., are similar to work order processing (because the subject setting is the same).

VI. Sales:

1. Pick the treasury: borrow: to send out goods by installment.

Loan: goods in stock (self-made semi-finished products, raw materials)

two。 To send out goods by installment.

Loan: to send out goods by installments.

7. Cost update:

1. Impact on inventory:

If the unit cost increases, then borrow: raw materials (self-made semi-finished products, inventory goods)

Loan: material cost difference _ material cost update difference

If the unit cost is reduced, the opposite entry is produced.

two。 For the impact on work-in-process, it is necessary to distinguish different work order states.

① work order has been issued, components have not been issued, assemblies have not been stored, assembly materials, labor and manufacturing costs and assembly updates have no impact.

② work order has been issued, components have been issued, there are no assembly parts in storage, the update of assembly materials, labor and manufacturing costs will not have an impact, the cost update of a component will have an impact.

Borrow (loan): production cost _ direct production cost _ direct material

Loan (borrowing): production cost _ production cost variance _ work-in-process cost

The ③ work order has been issued, the assembly has been issued, and the assembly part is stored in storage. If the assembly cost update is caused by the update of a component of the assembly, the update of the assembly and assembly will have an impact:

(increased component costs) the impact of components:

Borrowing: production cost _ direct production cost _ direct material (quantity sent * updated value)

Loan: production cost _ production cost variance _ work-in-process cost

The impact of assemblies:

Borrowing: production cost _ production cost variance _ work-in-process cost

Loan: production cost _ direct production cost _ direct material (quantity in storage * updated value)

The cost of new assemblies will be deducted for later restocking.

The reduction in component costs produces the opposite entry.

④ work order issued status, components issued, assembly parts stored, materials not updated, assembly resources or manufacturing cost updates (manually defined non-cumulative updates) have an impact on the parts that have been stored:

Cost increase: borrowing: production cost _ production cost variance _ work-in-process cost

Loan: production cost _ direct production cost _ direct labor (quantity in storage * updated value)

(or loan: production cost _ direct production cost _ direct expense)

The cost reduction produces the opposite entry.

The ⑤ work order has been completed, the component has been issued, and a component has been updated (but the assembly has not been updated), which will have an impact on the delivery of the component:

Cost increase: borrowing: production cost _ direct production cost _ direct material (quantity of sent material * updated value)

Loan: production cost _ production cost variance _ work-in-process cost

The cost reduction produces the opposite entry.

⑥ work order has been completed, components have been issued, and a component update causes an update of assembly material cost, which will have an impact on assembly distribution and assembly storage:

Cost increase: borrowing: production cost _ direct production cost _ direct material (quantity of sent material * updated value)

Loan: production cost _ production cost variance _ work-in-process cost

Borrowing: production cost _ production cost variance _ work-in-process cost

Loan: production cost _ direct production cost _ direct material (quantity in storage * updated value)

The cost reduction produces the opposite entry.

⑦ work order completed status, components issued, material not updated, resources or manufacturing expenses updated (manual definition non-cumulative):

Cost increase: borrowing: production cost _ production cost variance _ work-in-process cost

Loan: production cost _ direct production cost _ direct labor (direct cost)

The cost reduction produces the opposite entry.

8. Carry forward the cost of sales in the general ledger according to the billing information:

Borrow: main business cost (other business expenses _ materials)

Loan: to send out goods by installments.

Summarize the differential accounts and apportion them in the general ledger in accordance with the rules.

1. For the purchase acceptance operation, the accounting entries are as follows: (

Borrow: receiving subject (Receiving Inventory) @ PO Price

(loan): inventory AP accruals (Inventory AP Accrual) @ PO Price

two。 In the storage operation, if there is account payable information, then follow the account information, no account information, then use the purchase order information to produce the following accounting entries (assuming there is account payable information):

(borrow): raw materials subject (Material Account) @ account payable amount in local currency

(loan): receiving subject (Receiving Inventory) @ PO Price

(borrowing or lending): commercial invoice price difference (Invoice Price Variance, IPV)

Purchase order difference gain / loss (Rate Variance Gain/Loss)

3. For the accounts payable operation, the accounting entries are as follows:

(borrowed): inventory AP accruals (Inventory AP Accrual) @ PO Price

(loan): accounts payable account @ local currency amount of accounts payable

(borrowing or lending): commercial invoice price difference (Invoice Price Variance, IPV)

Purchase order difference gain / loss (Rate Variance Gain/Loss)

4. Under the cyclical cost, if the invoice of the raw material purchase has the action of Match Receipt at the time of setting up the account, the periodic cost will convert the commercial invoice price difference (IPV) of this invoice into the raw material cost, but if the Receipt in the previous period of the invoice Match, the IPV generated by this invoice will not be included in the material cost calculation of the current period.

Accounting Classification of work-in-process (WIP Accounting Class)

1. The delivery of direct materials

The amount of the entry is "current cyclical cost".

(borrowed): WIP (WIP Valuation) @ current cyclical cost

(loan): inventory subject (MTL Account) @ current cyclical cost

two。 Direct labor cost processing

The amount of the entry is "wage rate for current maintenance"

(borrow): work in process (WIP Valuation) @ current maintenance wage rate

(loan): apportioned direct labor (Absorption) @ current maintenance wage rate

3. Cost treatment of manufacturing expenses / outsourced processing expenses

The cost response of manufacturing expenses will produce the following entry, the amount of which is "departmental assessment rate of current maintenance".

(borrow): work-in-process (WIP Valuation) @ current maintenance assessment rate

(loan): apportioned manufacturing costs (Absorption) @ current maintenance assessment rate

The cost response of outsourced processing costs will produce the following entries

The amount of the entry is "departmental assessment rate of current maintenance"

(borrow): work-in-process (WIP Valuation) @ current maintenance assessment rate

(loan): apportioned processing costs (Absorption) @ current maintenance assessment rate

If the standard outsourcing process is adopted, the following entries will be made at the time of acceptance:

(borrow): receiving subject (Receiving Inventory) @ PO Price

(loan): inventory AP accruals (Inventory AP Accrual) @ PO Price?

For the accounts payable operation, the accounting entries are as follows:

(borrowed): inventory AP accruals (Inventory AP Accrual) @ PO Price

(loan): accounts payable account @ local currency amount of accounts payable

(borrow or loan): commercial invoice price difference (Invoice Price Variance, IPV)

Purchase order difference gain / loss (Rate Variance Gain/Loss)

When the work order is recovered, if there is account payable information, then follow the account information, no account information, then use the purchase order information to produce the following accounting entries (assuming there is account payable information):

(borrowing): work-in-process (WIP-Outside Process) @ local currency amount of accounts payable

(loan): receiving subject (Receiving Inventory) @ PO Price

(borrow or loan): commercial invoice price difference (Invoice Price Variance, IPV)

Purchase order difference gain / loss (Rate Variance Gain/Loss)

When the work order is completed and put into storage, the following entries will be produced, in which the debit account will read the "cyclical account designation" credit account of "work-in-process accounting classification" according to the classification (Category) corresponding to the finished / semi-finished product material number completed and put into storage.

(borrow): inventory subject (MTL Valuation)

(loan): WIP valuation (WIP Valuation)

When the number of work order completed into the warehouse = the number of work order opened, the system will change the status to "Complete".

Before the health management checkout at the end of the month, you need to check whether there will still be transactions for all outstanding work orders. For work orders that can be closed, you need to change the work order status to "completion-No fee re-entry (Complete-No Charge)".

When the meeting checks out at the end of the month, query all work orders with the status of "completion-No fee reentry (Complete-No Charge)", and execute the work order cost closing action.

When the work order is closed, if there is still work-in-process value on the work order, it will be concluded to the corresponding "difference subject" of "work-in-process Accounting Classification" according to the cost elements, resulting in the following entries:

(borrow or loan): work-in-process valuation (WIP Valuation)

(or loan): work-in-process differences (WIP Variance)

RMA job

There are three types: "selling back", "returning repair" and "replacing goods".

The replacement operation is handled by order shipping and RMA receiving, and the outstanding parts are expressed by "temporarily receiving and returning materials". It is necessary to use auxiliary reports to help express whether there are differences in the returned parts, and if there are any differences, adjust them in the general ledger to the subject of "manufacturing expenses".

The occurrence of the above differences, on the one hand, may be different from the returned material number, this part does belong to the difference, on the other hand, even if the same material number, because of the different period of extraction and return, there will be differences, according to reason, this part of the difference should not occur.

Assuming that H exports the raw material to W and the assets in transit belong to recipient W, H will produce the following entry when it is shipped (Transfer Credit is the transfer profit):

(borrow) inventory in transit (Intransit, W) accounts receivable (Receivable, H)

(loan) raw material (Material, H) transfer write-off discount (Transfer Credit, H)

Accounts payable (Payable, W)?

When receiving the goods, W produces the following entries:

(borrow) raw materials (Material, W)

(loan) inventory in transit (Intransit, W)

Cyclical cost, calculation of the cost of finished or semi-finished products when they are completed and put into storage

According to the sum of the unit cost contribution of each station, there are differentiated cost elements (Cost Elements) in expression.

The unit contribution cost of the station = (cost incurred at the station-work order storage, when the station has Relief cost) / (station transfer-work order storage number).

[@ more@]

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.