Skip to content
CalculatorZilo Logo
  • Home
  • CalculatorsExpand
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
CalculatorZilo Logo
Home / Periodic Inventory Calculator
Accounting Calculators

Periodic Inventory Calculator

Published onSeptember 27, 2025 Updated onOctober 25, 2026 8:53 am

This calculator solves the periodic inventory system in both directions: give it a physical count and it backs into your cost of goods sold, or give it a COGS figure and it tells you what the shelves should hold. It builds net purchases from gross purchases, freight-in, returns and discounts, then shows goods available for sale, the average-inventory turnover ratio, and a step-by-step audit trail. The example below is pre-filled: beginning inventory $50,000, net purchases $120,000, ending inventory $60,000, giving COGS of $110,000.

Periodic Inventory Calculator
COGS and ending-inventory solver with net-purchases breakdown
Inventory results
Net purchases:
Goods available for sale:
Cost of goods sold:
Ending inventory:
Inventory turnover:

Ending inventory comes from your physical count; the calculator never estimates it. Turnover uses average inventory, (beginning + ending) / 2.

Quick Answer

Start with $50,000 of inventory, buy a net $120,000 of goods ($120,000 + $5,000 freight − $3,000 returns − $2,000 discounts), and count $60,000 left at period end: COGS is $110,000 and inventory turned 2.00 times. The formula is COGS = beginning inventory + net purchases − ending inventory, and it runs in reverse just as well.

Key takeaways

  • Net purchases, not gross purchases, feed the formula: freight-in adds to cost, returns and discounts subtract.
  • Ending inventory is never estimated by the calculator; it comes from your physical count. If it exceeds goods available, something is wrong and the tool says so.
  • The same equation solves both ways: count → COGS, or a known COGS → the ending inventory the shelves should hold.
  • Your cost-flow method (FIFO, LIFO, weighted average) decides the dollar value of the ending inventory you enter; use the valuation widget below before the main calculator.
On this page
  • Quick Answer
  • How to use the periodic inventory calculator
  • The formulas
  • Worked example, checked against this exact tool
  • Cost-flow valuation: FIFO, LIFO, weighted average
  • How ending inventory is valued: FIFO, LIFO, and weighted average
  • Periodic vs perpetual: which fits your business?
  • Tips for accurate counts
  • What competing calculators miss
  • Frequently asked questions
  • Add This Calculator to Your Website
  • References

How to use the periodic inventory calculator

Choose what to solve for, enter the period's numbers, and click Calculate. The results stay hidden until you calculate, and the steps line shows the full audit trail from net purchases to the answer.

  1. Pick the solve direction: "COGS (I know ending inventory)" is the default; switch to "Ending inventory (I know COGS)" when your accountant hands you a COGS figure and you want to verify the count. The unused field hides itself.
  2. Enter the five purchase lines: beginning inventory and gross purchases are required; freight-in, returns and discounts can be left blank (they count as zero). Commas are fine: 120,000 works.
  3. Enter the count or the COGS: for the COGS direction, type the ending inventory from your physical count; for the reverse direction, type the known COGS. The calculator refuses impossible combinations, like an ending inventory larger than the goods available.
  4. Read all five outputs: net purchases, goods available for sale, COGS, ending inventory, and the turnover ratio, with a plain-language reading of how much of the period's goods came from new purchases.

If your ending inventory is a unit count rather than a dollar value, value it first with the FIFO/LIFO/weighted-average widget below, then enter the dollar figure here.

The formulas

The periodic system runs on one flow equation. Start with what you had, add what you bought at true cost, subtract what remains; what is gone must have been sold:

Net purchases = gross purchases + freight-in − purchase returns − purchase discounts
Goods available for sale = beginning inventory + net purchases
COGS = goods available for sale − ending inventory
Inventory turnover = COGS ÷ average inventory, where average inventory = (beginning + ending) ÷ 2

Rearranged, the same equation solves for a missing ending inventory: ending inventory = goods available for sale − COGS. That is the second mode in the calculator above. The turnover ratio tells you how many times the stock cycled: 2.00 times means the average dollar of inventory sold twice in the period. For the COGS-to-gross-profit step that follows this calculation, the gross profit rate calculator picks up where this page leaves off.

Worked example, checked against this exact tool

A wholesaler starts the quarter with $50,000 of inventory. During the quarter it buys $120,000 of goods, pays $5,000 freight, returns $3,000 of damaged stock, and earns $2,000 in early-payment discounts. The physical count values ending inventory at $60,000.

1. Net purchases: 120,000 + 5,000 − 3,000 − 2,000 = $120,000→ 2. Goods available: 50,000 + 120,000 = $170,000→ 3. COGS: 170,000 − 60,000 = $110,000→ 4. Turnover: 110,000 ÷ 55,000 = 2.00 times

The calculator reproduces these figures exactly, and the steps line under the results repeats the same chain. In reverse mode, entering COGS of $110,000 returns the $60,000 ending inventory. Two more real runs of this tool for spot-checking:

Inputs (begin / gross / freight / returns / discounts / ending)Net purchasesCOGSTurnover
10,000 / 25,000 / 800 / 1,200 / 600 / 8,000$24,000.00$26,000.002.89 times
20,000 / 80,000 / 0 / 0 / 0 / 30,000$80,000.00$70,000.002.80 times
0 / 1,000 / 0 / 0 / 0 / 400$1,000.00$600.003.00 times

Cost-flow valuation: FIFO, LIFO, weighted average

The main calculator needs the dollar value of your ending inventory. A physical count tells you how many units remain, but when unit costs changed between purchases, the dollar value depends on your cost-flow method. Work it out here first, then carry the ending inventory figure into the main calculator above.

Worked example, pre-filled: start with 10 units at $5, buy 10 more at $6, then sell 12 units. Under FIFO the oldest units sell first: COGS is 10 × $5 + 2 × $6 = $62 and ending inventory is 8 × $6 = $48. Under LIFO the newest sell first: COGS is 10 × $6 + 2 × $5 = $70 and ending inventory is 8 × $5 = $40. Weighted average blends everything to $5.50 per unit: COGS $66, ending inventory $44.

FIFO / LIFO / Weighted Average Valuation
Value ending inventory from purchase batches, then use it in the main calculator
Batch 1 (oldest)
Batch 2
Batch 3 (newest, optional)

Take the ending inventory from your chosen method and enter it in the main calculator above. Method choice changes reported profit and tax: apply it consistently period to period.

How ending inventory is valued: FIFO, LIFO, and weighted average

Your cost-flow method decides which purchase prices sit in ending inventory and which flow to COGS. FIFO (first in, first out) sells the oldest units first, so ending inventory carries the newest costs, which raises reported profit when prices are rising. LIFO (last in, first out) sells the newest first, so ending inventory carries the oldest costs, which lowers taxable income when prices rise; it is not allowed under IFRS, though US GAAP still permits it, and the IRS requires you to use LIFO on your financial statements too if you use it for tax (the conformity rule). Weighted average blends every unit into one per-unit cost.

The choice changes both COGS and taxable income, so apply it consistently period to period. Use the widget above for the arithmetic, then carry the ending inventory value into the main calculator. If you keep inventory records continuously instead of counting periodically, the companion perpetual inventory calculator is the right page.

Periodic vs perpetual: which fits your business?

In a perpetual system, every sale updates the inventory record immediately. In a periodic system, purchases sit in a separate purchases account during the period and the inventory account is untouched until period end; then you count everything, value the ending inventory, and back into COGS with one formula. The trade is simple: periodic is cheaper to run and easier to understand, but between counts you do not know your exact stock levels or your shrinkage. It suits retailers and wholesalers of finished goods; manufacturers tracking raw materials, work in process and finished goods need perpetual records. Track the ratios this page produces over time with the inventory ratio calculator, and watch for losses with the inventory shrinkage percent calculator.

Tips for accurate counts

The whole method stands or falls on the physical count, because COGS is whatever the count leaves behind. Count at least at each reporting period: monthly for management accounts, and always at fiscal year end. High-shrinkage businesses count quarterly. Cut off purchases and sales cleanly at the count date, because goods in transit on count day are the classic source of a count that will not reconcile. And when the calculator tells you ending inventory exceeds goods available, believe it: the usual culprits are a miscount, a missed purchase entry, or returns recorded twice.

What competing calculators miss

Inventory tools split into three camps, and each leaves something on the table:

  • Dollar-only solvers (Calculator Ultra and similar): the COGS equation with gross purchases only, no freight-in, returns or discounts broken out, so net purchases is a black box.
  • Ending-inventory tools (akynocalculator, bizcalcs): they ask for net purchases as one number, which means you must compute it yourself first, and most skip the turnover ratio.
  • Costing suites (Pearson): proper FIFO, LIFO and weighted-average tools with formulas, but a separate page per method and no link back to the periodic COGS equation the valuation feeds into.
  • The gap this page fills: one page that runs the whole chain: the five-line net-purchases build, the COGS/ending-inventory solver in both directions, the turnover ratio, a step-by-step audit trail, and the FIFO/LIFO/weighted-average valuation widget whose ending inventory feeds straight into the main calculator.

Frequently asked questions

Gross purchases is the invoice total of everything you bought. Net purchases subtracts returns and discounts and adds freight-in, giving the true cost of goods that became available for sale.

No, and if your numbers say so, something is wrong: a miscount, a missed purchase entry, or returns recorded twice. The calculator flags this for you.

Mostly no. Manufacturers track raw materials, work in process, and finished goods separately, which needs the continuous records of a perpetual system. Periodic suits retailers and wholesalers of finished goods.

At least at each reporting period: monthly for management accounts, and always at fiscal year end for the financial statements. High-shrinkage businesses often count quarterly.

It depends on the industry. Grocery stores turn stock weekly; furniture stores may turn it twice a year. Compare against your own history and industry benchmarks rather than chasing a universal number.

There is no universally best method; the right choice depends on your prices and your reporting. FIFO raises reported profit when prices rise, LIFO lowers taxable income when prices rise but is banned under IFRS and locks you into the IRS conformity rule, and weighted average sits between the two. Whatever you choose, apply it consistently period to period.

Because net purchases is where most COGS errors hide. Freight-in is part of what the goods cost you and adds to purchases; returns and discounts reduce them. Entering the five lines separately makes the audit trail visible instead of trusting one lumped number.

Add This Calculator to Your Website

Embed this calculator on your own site with the code below. Pick a size to preview it live, then copy the code.

Powered by Calculator Zilo

References

  1. IFRS Foundation. IAS 2 Inventories. Accessed October 23, 2026.
  2. Internal Revenue Service. Publication 538: Accounting Periods and Methods (inventory identification methods, including the LIFO conformity rule). Accessed October 23, 2026.
  3. Internal Revenue Service. Publication 334: Tax Guide for Small Business (inventory and cost of goods sold rules). Accessed October 23, 2026.
  4. Internal Revenue Service. About Form 1125-A: Cost of Goods Sold. Accessed October 23, 2026.
  5. OpenStax. Principles of Financial Accounting (periodic vs perpetual systems; FIFO, LIFO, and weighted-average cost flows). Accessed October 23, 2026.
  6. Financial Accounting Standards Board. FASB Staff Q&A: Accounting Standards Update No. 2015-11, Inventory (Topic 330). Accessed October 23, 2026.
  7. U.S. Small Business Administration. Manage Your Finances (business finance guidance). Accessed October 23, 2026.
  8. Journal of Accountancy (AICPA). FASB simplifies inventory measurement guidance (ASU 2015-11, lower of cost and net realizable value). Accessed October 23, 2026.
  9. Journal of Accountancy (AICPA). Taking the Complexity Out of Simplified Lifo. Accessed October 23, 2026.
  10. Journal of Accountancy (AICPA). Simplified accounting rules issued for small businesses (Section 471(c) inventory methods). Accessed October 23, 2026.

Related calculators

Accounting CalculatorsSales to Working Capital Ratio CalculatorEvery dollar of sales a business makes has to be carried for a while by money tied up in stock, unpaid customer invoices and the gap before suppliers are paid.Accounting Calculators Mca Calculator Give this calculator four numbers: the advance amount, the factor rate, the payback period and the payment...Accounting CalculatorsUnderpayment Penalty Calculator An underpayment penalty calculator answers two questions in order: do you actually owe the IRS a penalty for paying too little during the year, and if so, roughly how much?Accounting CalculatorsForm 2210 Penalty CalculatorA Form 2210 penalty calculator figures the IRS underpayment penalty the same way the form itself does: quarter by quarter, at the IRS rate in effect for each period.Accounting CalculatorsDiminishing Value Depreciation Calculator Straight-line depreciation spreads an asset’s cost evenly, but most assets lose value fastest in their first years.Accounting CalculatorsPercentage Profit CalculatorMargin and markup describe the same profit with different denominators, and confusing them is one of the most expensive pricing mistakes a seller can make.

We use cookies to analyze traffic. You can accept or decline cookies below. Learn more

calculatorzilo

CalculatorZilo

Free calculators for everyday life. No signup, no cost, just answers.

Categories

Finance Math Health & Fitness Education Science Real Estate Chemistry Browse all calculators

Popular tools

Mortgage Payment Calculator BMI Walking Calculator Salary Per Minute Calculator Percentage Off Calculator

Company

About Us Contact Us Privacy Policy Terms and Conditions
Disclaimer Cookie Policy DMCA Policy Affiliate Disclosure FAQ Accessibility Statement

© 2026 CalculatorZilo • Free calculators for everyone

  • Home
  • Calculators
    • Browse all calculators
    • Education
    • Real Estate
    • Chemistry
  • Finance
  • Math
  • Health & Fitness
  • Science
  • About
  • Contact
Search