Book · Julian R. Sterling
ASC 330 for Controllers and Preparers: Capitalizable Costs and Normal Capacity, FIFO, Average Cost and LIFO, Standard Cost Variances, Lower of Cost and Net Realizable Value, Excess and Obsolete Reserves, Counts and Cut-Off, with IAS 2 Comparisons
Inventory is counted, costed and defended once a year, and every step can move the margin. For one fictional manufacturer and distributor, a plant that ran below normal capacity sends $1,500,000 of fixed overhead to the period instead of the shelf, a LIFO liquidation releases old layers, a discontinued model is written down by $46,464, and the count has to decide whose goods are on the floor before it can say how many there are. Total inventories close at $5,081,736, every line rolled forward in units and in dollars.
The Inventory Accounting Handbook is a practitioner's guide to inventory under ASC 330, with IAS 2 compared side by side: what enters cost and what stays out, normal capacity and abnormal costs, standard costs and the variances that are capitalized, FIFO, weighted average and LIFO with the reserve, liquidations and the conformity rule, the lower of cost and net realizable value and the LIFO market test, excess and obsolete reserves by age, cycle counts and the year-end count, cut-off, consignment and bill-and-hold, purchase commitments, section 263A in principle, analytics, controls and the inventory note. One company is followed through 2025 and 2026, and every figure comes from one model.
What you will be able to do:
Nineteen chapters and four appendices: a guide to the companion workbook with three exercises, the preparer's toolkit, twenty review questions with answers, and a glossary.
Written for controllers, cost accountants, senior accountants, financial reporting managers, auditors and lenders' field examiners who close, review or rely on an inventory balance. The case, its company, its people and its places are fictional, and its figures are teaching assumptions; the standards are paraphrased as read in November 2026. This book is for education only. It is not accounting, legal, tax or investment advice. Part of The Private Markets Career Guides.
How this book was made: written with the help of artificial intelligence tools, under the author's direction; every figure was computed by a model and every rule was checked against its source.
FIFO, weighted average and LIFO side by side with the LIFO reserve, a lower of cost and net realizable value test, and an excess and obsolete reserve by aging with its roll-forward. Live formulas, no macros, nothing locked.
The workbook that rebuilds every figure of the book, free, no sign-up. It closes Kellowyn's standard cost variances into inventory and cost of sales, rolls finished goods forward on FIFO through the count, keeps the blade LIFO layers, reserve and liquidation, sets FIFO, weighted average and LIFO side by side, ages the service parts into their reserve, builds the inventory note and ends with a Checks tab that must read ALL PASS.
Appendix A
Tabs: Inputs, Variances, Finished goods, LIFO, Methods, Reserve, Note, Checks. With the case typed in, total inventories come to $5,081,736 at 31 December 2026.
Download the workbook30 KBRead first
What each tab holds, the case figures to reproduce first, and the conventions behind every number.
Workbook and read-me, one archive28 KB| Wrench unit cost, 2026 | $100.00 standard + $542,400 of capitalizable variances / 150,000 units = $103.616; the $1,500,000 of fixed overhead the plant could not carry below normal capacity goes to the period, not to the units |
| LIFO reserve, blades | FIFO cost $585,000 - LIFO cost $367,500 = $217,500 at 31 December 2026, after a liquidation of old layers |
| TW-200 write-down | cost $414,464 - net realizable value $368,000 = $46,464, booked to 2026 cost of sales and never reversed |
| Class | 2025 | 2026 |
| Raw materials | $688,800 | $556,800 |
| Work in process | $496,000 | $496,000 |
| Finished goods (wrenches) | $3,557,260 | $2,543,936 |
| Distributed goods (blades), at LIFO | $624,000 | $367,500 |
| Service parts, net of reserve | $1,020,000 | $1,117,500 |
| Total inventories | $6,386,060 | $5,081,736 |
Related titles. The full list is on the author page.
The workbook is provided as it is, without warranty of any kind. Kellowyn Tool Works, Inc. and its people are fictional; prices, costs, rates and tax amounts are the book’s teaching assumptions, not market data. Not accounting, legal, tax or investment advice.