Inventory Costing & Valuation

A written stock valuation policy and cost formula, ledgers that reconcile, cycle and year-end counts, obsolescence and net realisable value reviews, and costing rules that keep cost of goods sold right.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Inventory Costing & Valuation, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help your team organise its work. It is not financial, investment, tax, accounting or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with qualified, licensed advisers in the countries concerned. Investing can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

202

Starter tasks

🧾 Finance & Accounting

Inventory Costing & Valuation

Valuing stock correctly, choosing costing methods, handling write-offs and stock counts so the cost of goods and margins in the accounts are right.

  1. Inventory valuation policy on one page
  2. Choosing between FIFO, weighted average and specific cost
  3. Periodic or perpetual inventory recording decision
  4. Item master clean-up before costing
  5. Cost inclusion rules for purchased stock
  6. Inventory account and posting map
  7. Stock ledger to general ledger tie-out
  8. Register of stock locations and ownership
  9. First full wall-to-wall stock count
  10. Monthly inventory valuation reconciliation
  11. Cycle counting programme by ABC class
  12. Goods received not invoiced review
  13. Inventory cut-off checks at each month end
  14. Quarterly slow-moving and obsolete stock review
  15. Net realisable value test for key lines
  16. Stock adjustment and write-off approval log
  17. Purchase price variance review
  18. Inventory accounting KPI log
  19. Shrinkage tracking by location
  20. Weekly costing exceptions sweep
  21. Annual standard cost roll
  22. Inventory accounting standard essentials
  23. Cost formula worked examples in a spreadsheet
  24. Net realisable value and write-down reversals
  25. Standard costing and the main variances
  26. Absorbing production overheads into stock at normal capacity
  27. Reading your system's inventory valuation report
  28. Gross profit and retail methods for estimating stock
  29. Landed cost allocation for imported goods
  30. Written provision matrix for slow and obsolete stock
  31. Supplier rebates and settlement discounts in stock cost
  32. Count variance root cause and remediation
  33. Bill of materials and routing accuracy for costing
  34. Valuing customer returns and refurbished stock
  35. Stock valuation questions for your tax adviser
  36. Year-end stock count plan and count instructions
  37. Auditor attendance at the year-end count
  38. Post-count adjustments and sign-off
  39. Year-end inventory valuation pack
  40. Valuing damaged stock for an insurance claim
  41. Retail shop stock valuation from till and purchase records
  42. Stock held at a third-party fulfilment warehouse
  43. Work in progress and finished goods for a small manufacturer
  44. Perishable and expiry-dated stock valuation
  45. Inheriting an inventory balance as a new finance manager
  46. Consistent costing across sites and warehouses
  47. Consignment stock agreements and accounting
  48. Period-end treatment of standard cost variances
  49. Joint and by-product cost allocation
  50. Item cost change audit trail

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Inventory valuation policy on one page

Ask three people how stock is valued in a typical small or mid-sized business and you will hear three answers, which is why year-end adjustments surprise everyone. A one-page policy stating the cost formula, what goes into cost, how counts and write-offs are approved and when provisions are made gives the bookkeeper, the warehouse and the auditor one reference.

First tasks

  • Write down how stock is valued today, as you understand it
  • Ask the agent to draft a one-page policy outline from your notes
  • Send the draft to your accountant for comment
  • Re-read the policy and update anything that has changed @recurring(yearly)

Choosing between FIFO, weighted average and specific cost

The cost formula decides which purchase price ends up in cost of goods sold and which stays on the balance sheet, so in a year of rising supplier prices two businesses with identical sales can report different margins.

First tasks

  • Find the costing method setting in your inventory or accounting system
  • Export last year's purchases and sales for your top 20 items
  • Compare cost of sales under FIFO and weighted average for those items
  • Record the chosen formula and the reason in the valuation policy

Periodic or perpetual inventory recording decision

A periodic system counts stock at the end of each period and treats cost of sales as the balancing figure; a perpetual system updates quantity and value with every receipt and sale. Small shops often run periodic recording without realising it, then wonder why monthly margins swing. Deciding which you run, and whether it suits your volume and reporting needs, sets the shape of every monthly entry.

First tasks

  • Look at last month's cost of sales journal to see how it was calculated
  • Ask the owner or managers how often they need a reliable margin
  • Estimate the weekly hours a perpetual system would need to stay accurate
  • Note the decision and its start month for the finance team

Make it yours.

Install Inventory Costing & Valuation, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.