Inventory and COGS month-end checks are a short set of tests you run before you lock a period: confirm that the Inventory account agrees with the stock you actually hold, that purchases and sales landed in the right month, and that the gross margin looks believable. Example: if opening stock is $18,000, net purchases including freight are $46,000 and closing stock is $21,000, COGS is $43,000. If the closing figure is wrong by $1,000, COGS and gross profit are wrong by $1,000 too.
Key takeaways
- Every dollar of closing inventory you overstate is a dollar of COGS you understate, so a stock error flows straight into gross profit.
- Run the checks in a fixed order: cut-off, balances, counts, valuation, then a reasonableness test on margin.
- Goods received but not yet invoiced, and goods shipped but not yet invoiced, are the most common cut-off gaps. Both should sit in a clearing account that you can list line by line.
- A gross margin that moves by more than you can explain with prices, mix or cost changes is a prompt to investigate, not proof of an error.
- Lock the period only after the checks are signed off, and write down what you checked so next month starts faster.
Why inventory needs its own month-end checks
Inventory is harder to prove than a bank balance because it is built from quantities and costs, and the quantities sit on a shelf the ledger cannot see. Meanwhile the number feeds the income statement directly. As the cost of goods sold lesson shows, COGS is opening stock plus purchases minus closing stock, so the closing figure is half of the answer.
The checks below are written for a small business, with a general ledger and some form of stock records (a spreadsheet, a stock list or inventory software). They sit inside the wider routine in the month-end close checklist; this lesson zooms in on the inventory and COGS lines of that routine. Month-end closing mistakes lists what goes wrong when a close is rushed.
The inventory and COGS month-end checklist
Work through these in order. Each step answers one question, and the later steps assume the earlier ones are clean.
- Cut-off: did every purchase and sale land in the month in which the goods moved?
- Clearing accounts: are the goods-received and goods-shipped clearing balances explained line by line?
- Sub-ledger to ledger: does the Inventory account equal the stock records?
- Counts: does physical stock match the records, and are differences booked?
- Valuation: is any stock carried above what you can recover from selling it?
- Special stock: is consigned stock in the right place, and is anything in transit counted twice?
- Margin test: does gross margin make sense against recent months?
- Lock and document: have you closed the period and kept your working notes?
Step 1: Check cut-off
Cut-off asks whether a transaction belongs to this month or next. For inventory, the rule of thumb is that ownership moves when the goods move, so a purchase belongs to the month in which you received the goods and a sale to the month in which the customer took delivery, whatever the invoice date says. Delivery terms can change who owns goods in transit, so read them on large shipments.
Look at the last few days of the month and the first few days of the next:
- Receiving notes dated in the closing days, with the matching supplier invoice dated after month-end.
- Delivery notes dated in the closing days, with the sales invoice raised afterwards.
- Supplier invoices dated in the closing days for goods that have not arrived.
- Returns handled physically in one month and entered in the next.
Step 2: Explain the goods-received and goods-shipped clearing balances
In a perpetual system you usually record stock when the goods arrive, not when the bill does. That needs a temporary liability, often called goods received not invoiced (GRNI). The reverse exists on the sales side for deliveries that have left but have not been invoiced; Reyuko calls it GSNI. These accounts should never be a mystery total. Each balance should list as a short set of open documents.
Suppose that on 31 March Lakeside Home Goods received a pallet of lamps worth $1,800 and the supplier's invoice has not arrived.
| Account | Debit | Credit |
|---|---|---|
| Inventory | 1,800 | |
| Goods received not invoiced (GRNI) | 1,800 | |
| Total | 1,800 | 1,800 |
When the invoice arrives in April, the GRNI line is cleared and the payable is created, so the liability is not counted twice. At month-end, list the open GRNI items and confirm each one is a real receipt without an invoice. A line that has sat there for months is usually a duplicated bill, an unmatched invoice or a receipt that never happened. Our glossary of inventory and costing terms defines these accounts if the vocabulary is new.
Step 3: Reconcile the stock records to the Inventory account
In a perpetual system the Inventory account in the ledger should equal the total of quantity times unit cost across your stock records. The two are fed by different entries, so they drift apart when someone posts a manual journal straight to the Inventory account, or posts a stock movement without a matching ledger line.
This illustrative reconciliation is for a separate month, not Lakeside's March data.
| Line | Amount ($) |
|---|---|
| Inventory account in the general ledger | 21,450 |
| Stock records valued at unit cost | 21,000 |
| Difference to explain | 450 |
| Explained: supplier bill for goods shipped straight to a customer, debited to Inventory although the goods were already sold | 450 |
| Unexplained | 0 |
A difference that you can fully explain is a correcting entry. Here the goods were already sold, so the $450 belongs in COGS, not in stock:
| Account | Debit | Credit |
|---|---|---|
| Cost of goods sold | 450 | |
| Inventory | 450 | |
| Total | 450 | 450 |
Do not plug an unexplained difference into COGS to make the two agree; the cause will come back next month.
If you run a periodic system instead, there is no running stock record to compare against. The Inventory account holds last period's closing figure until you adjust it, so the reconciliation is the count itself: you record the counted closing stock and let COGS fall out of the formula. That is simpler, but losses are hidden in COGS, so the count matters even more.
Step 4: Count stock and book the differences
A stock-take compares what the records say with what is on the shelf. The method is covered in what a stock opname is and the step-by-step stock opname. You do not need to count everything every month: count a rotating sample, always include high-value and fast-moving lines, and do a full count once a year.
Here is an illustrative count of four lines, valued at unit cost.
| Item | Book qty | Counted qty | Difference | Unit cost ($) | Value ($) |
|---|---|---|---|---|---|
| Oak side table | 12 | 11 | -1 | 38.00 | -38.00 |
| Ceramic lamp | 30 | 30 | 0 | 14.50 | 0.00 |
| Linen cushion | 80 | 76 | -4 | 6.25 | -25.00 |
| Wall clock | 25 | 27 | +2 | 9.00 | +18.00 |
| Net | -45.00 |
The net effect is a $45 shortage, but the journal shows the gross figures so that losses and gains stay visible:
| Account | Debit | Credit |
|---|---|---|
| Inventory shrinkage expense | 63 | |
| Inventory | 18 | |
| Inventory | 63 | |
| Inventory gain | 18 | |
| Total | 81 | 81 |
Before booking a surplus, ask whether it is really a recording error, such as a delivery not yet received into the system. A surplus is as much a warning sign as a shortage. The module's lesson on inventory shrinkage and write-downs covers these entries in depth.
Step 5: Review valuation (lower of cost or net realizable value)
Inventory is carried at the lower of cost and net realizable value (NRV), which is the selling price you expect to get less the costs of completing and selling. At month-end, scan for stock that is slow, damaged, out of season or discontinued, and compare cost with what you can realistically recover.
Illustration: 30 units of a discontinued lamp cost $22 each, so $660 in total. After a clearance you expect to get $15 each, or $450, net of selling costs. The write-down is $210.
| Account | Debit | Credit |
|---|---|---|
| Inventory impairment expense | 210 | |
| Inventory obsolescence allowance | 210 | |
| Total | 210 | 210 |
The allowance is a contra-account: it reduces the net carrying value of inventory without changing the cost records. If the lamp later sells above the written-down value, you can reverse the write-down, but only up to the amount you wrote down. Accounting rules on write-downs and reversals vary by country and framework, so check local requirements.
Step 6: Treat special stock correctly
Two categories of stock cause repeated month-end errors.
- Consigned-in stock belongs to the supplier until you sell it, so it should not appear in your Inventory account or in your payables. Keep a memo list so you can still count and protect it. See consignment inventory explained and the module's consignment accounting lesson.
- Consigned-out stock and goods in transit are still yours. Make sure stock at an agent's premises is counted as your inventory (in a separate account if you can), and that goods you ordered under terms that make them yours are not left out just because they are on a truck.
Step 7: Test the gross margin
After the balances are clean, step back and look at the result. Gross margin is gross profit divided by net sales, and for Lakeside's March the dataset gives the following.
| Line | Amount ($) |
|---|---|
| Net sales (72,000 gross less 2,000 returns) | 70,000 |
| Opening inventory | 18,000 |
| Purchases, net of returns and discounts | 44,000 |
| Freight in | 2,000 |
| Goods available for sale | 64,000 |
| Closing inventory | 21,000 |
| Cost of goods sold | 43,000 |
| Gross profit | 27,000 |
| Gross margin | 38.6% |
Now put it beside the previous months. The January and February figures are illustrative.
| Month | Net sales ($) | COGS ($) | Gross profit ($) | Gross margin |
|---|---|---|---|---|
| January | 60,000 | 36,000 | 24,000 | 40.0% |
| February | 64,000 | 38,720 | 25,280 | 39.5% |
| March | 70,000 | 43,000 | 27,000 | 38.6% |
Expected gross profit = this month's net sales x last month's gross margin
Compare it with actual gross profit; the gap is what you need to explain.
At February's 39.5% margin, March sales of $70,000 would have produced $27,650 of gross profit. The actual figure is $650 lower, which is $650 of extra cost that the margin test asks you to account for. Innocent explanations include a promotion, a shift toward lower-margin lines, a supplier price rise or higher freight. Less innocent ones include an unbooked purchase return, a cut-off miss on closing stock, shrinkage absorbed by periodic COGS, or a mis-keyed cost.
A second quick test is stock turnover: COGS divided by average inventory. Here average inventory is ($18,000 + $21,000) / 2 = $19,500, so turnover is 43,000 / 19,500 = 2.21 times in the month, or roughly 14 days of stock on hand over a 31-day month. If that jumps without a reason, stock may be building up or the closing count may be off.
Two errors can offset each other. A closing count that is too high and an unrecorded purchase can both push the margin back towards normal. Use the margin test to find problems, never to prove there are none.
Step 8: Lock the period and keep your notes
Once the checks are done, post any adjustments, then close the period so nobody changes figures that you have already reported. Write down who did each check, the reconciliation figures and any open items carried forward. For the entries around the close, see adjusting journal entries; bank reconciliation follows the same compare-and-explain logic.
Reyuko posts inventory on the perpetual method, with each product set to Average, FIFO, LIFO or FEFO costing. A delivery receipt posts Inventory against GRNI, and the purchase bill clears GRNI and creates the payable, so GRNI nets to zero when receipts and bills match. A sales invoice posts revenue and also Dr COGS / Cr Inventory, or GSNI when a delivery order has not yet been invoiced. Stock adjustments and stock-takes book shortages to inventory shrinkage expense and surpluses to inventory gain at the product's unit cost. Write-downs post to impairment expense against an obsolescence allowance. Closing a period locks it against edits; to change it you reopen it.
What to do when a check fails
Do not skip a failed check, and do not hide it. Work out which of three groups it falls into.
- Timing: the transaction is correct but sits in the wrong month. Fix it with a cut-off entry or move the document date, and note it.
- Recording: a number was keyed wrongly or a manual journal bypassed the stock records. Correct the entry at source so the records and ledger agree again.
- Real loss: the stock is gone, damaged or worth less. Book the expense now, in the month you discovered it, and look at the process that let it happen.
If you cannot tell which group applies, carry the item forward as an open query and say so in your notes rather than forcing the totals to agree. The summary of repeated errors in common mistakes in inventory and costing is a good list to check yourself against.
How the checks feed the financial statements
Inventory sits on the balance sheet and COGS on the income statement, so a clean month-end here supports both. The link between them is covered in the three financial statements, and the margin lines are discussed in the four layers of profit. Gross profit is only the first of those layers, so an error here carries through to operating profit and net profit.
The figures in this example are fictional. Rules for inventory valuation, write-downs and period locking differ by country and by accounting framework, so confirm the local requirements with a qualified adviser.
Reyuko