Cost flow analysis: tracing production costs

Cost flow analysis traces production costs through raw materials, work in process, finished goods, and cost of goods sold. Build it from opening balances, period movements, and closing balances, then prove that every dollar ends in inventory or expense. The result explains where costs sit before you ask why they changed.

Start with the inventory records you already have

Use a raw-materials valuation report, a production cost report, a finished-goods valuation report, and the corresponding general ledger accounts. Export the same accounting period and retain plant, product, account, posting date, transaction reference, and amount. Include inventory adjustment journals separately so they remain visible.

Costs move between accounts even when no new payment occurs. Direct materials enter production, labor and overhead are added, completed production moves into finished goods, and sold production moves into expense. IRS Publication 538 identifies direct materials, direct labor, and certain indirect costs among the cost elements of manufactured inventories; use your controller's approved book-costing policy for this management schedule.

This is different from funds flow analysis, which addresses funding movements. It also stops before a detailed investigation of plant performance: manufacturing cost analysis owns that comparison.

Set up the inputs and transfers

An Ohio manufacturer closes September with the following balances and activity. All figures are USD. Assume the exports contain no returns, inventory write-downs, or separate adjustment entries; a real schedule needs explicit lines for those movements.

Create an Inputs worksheet with these labels in column A and amounts in column B. Purchases include the acquisition costs recognized in the inventory ledger. Labor and overhead are the amounts assigned to production for this period.

Use the same valuation method for every balance. FIFO, LIFO, or an average-cost assumption assigns costs; it does not prove which physical items left a warehouse. Publication 538 discusses inventory identification and valuation methods, but selecting or changing an accounting policy is a separate controller decision.

Calculate each stage in order

Materials issued = Opening raw materials + Purchases − Closing raw materials

Completed production = Opening work in process + Materials issued + Labor + Overhead − Closing work in process

Cost of goods sold = Opening finished goods + Completed production − Closing finished goods

Create a Calc worksheet. Put materials issued in B2, completed production in B3, and cost of goods sold in B4. These Excel formulas follow the input rows above:

=SUM(Inputs!B2:B3)-Inputs!B4
=SUM(Inputs!B5,B2,Inputs!B6:B7)-Inputs!B8
=SUM(Inputs!B9,B3)-Inputs!B10

The formulas use Microsoft's documented SUM function, which adds individual references and ranges. Covirage is not affiliated with Microsoft.

The company incurred $470,000 of production costs but completed $460,000 of production. Those amounts differ because work in process increased. Completed production and cost of goods sold also differ because some completed goods remain unsold. All amounts here are whole dollars; no rounding adjustment is needed.

Prove the whole flow without counting transfers twice

First compare calculated materials issued, completed production, and cost of goods sold with their separately exported ledger postings. Calculating a transfer from closing inventory does not independently prove the closing inventory is correct. The inventory subledger and ledger balances must agree too.

Then reconcile the entire system:

Materials issued and completed production are internal transfers. Adding them again to external costs would count the same dollars repeatedly. The overall check, entered outside the input range, is:

=SUM(Inputs!B2:B3,Inputs!B5:B7,Inputs!B9)-SUM(Inputs!B4,Inputs!B8,Inputs!B10)-Calc!B4

A zero proves this schedule balances; it does not prove every valuation or posting is right. Retain the document references behind each reported amount. When finished goods build, compare the product balances with demand using revenue concentration by product line before concluding that inventory is productive.

Where cost flow analysis goes wrong

• Mixed cutoffs. A shipment posted after the warehouse count can create an apparent inventory loss. Align transaction and accounting dates before comparing balances.
• Purchases counted as consumption. Materials purchased can remain unused. Production needs issued materials, adjusted for documented returns, rather than the supplier invoice total.
• Adjustments hidden in transfers. Write-downs, count corrections, and abnormal losses need identifiable lines. Otherwise a transfer calculation conceals their effect.
• Applied overhead confused with actual spending. Reconcile the overhead assigned to inventory with the policy and any period-end variance treatment. Do not silently substitute the factory expense total.
• Consolidated totals used too soon. Opposing errors between plants can cancel. Check each plant and transfer counterpart before relying on the company total.

Trace the costs in your own inventory file

Bring your inventory valuation workbook and production cost export to Covirage. Covirage maps the columns, its tools compute and check the cost movements, and the external AI model explains the result with every figure traced to its rows. Create a free Covirage account, which takes about a minute, then set up your business and bring a sample of your own data.

See Covirage for industrial manufacturers for the manufacturing context.