Module 07 · Inventory Accounting and COGS in Practice

Inventory and COGS Month-End Checks: A Reconciliation Checklist

A month-end closing checklist for inventory and COGS: cut-off, GRNI, stock counts, write-downs and a gross margin check, with worked numbers and journals.

13 min readLesson 10 of 10 in this moduleUpdated 2026-11-09

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.

  1. Cut-off: did every purchase and sale land in the month in which the goods moved?
  2. Clearing accounts: are the goods-received and goods-shipped clearing balances explained line by line?
  3. Sub-ledger to ledger: does the Inventory account equal the stock records?
  4. Counts: does physical stock match the records, and are differences booked?
  5. Valuation: is any stock carried above what you can recover from selling it?
  6. Special stock: is consigned stock in the right place, and is anything in transit counted twice?
  7. Margin test: does gross margin make sense against recent months?
  8. 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.

AccountDebitCredit
Inventory1,800
Goods received not invoiced (GRNI)1,800
Total1,8001,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.

LineAmount ($)
Inventory account in the general ledger21,450
Stock records valued at unit cost21,000
Difference to explain450
Explained: supplier bill for goods shipped straight to a customer, debited to Inventory although the goods were already sold450
Unexplained0

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:

AccountDebitCredit
Cost of goods sold450
Inventory450
Total450450

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.

ItemBook qtyCounted qtyDifferenceUnit cost ($)Value ($)
Oak side table1211-138.00-38.00
Ceramic lamp3030014.500.00
Linen cushion8076-46.25-25.00
Wall clock2527+29.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:

AccountDebitCredit
Inventory shrinkage expense63
Inventory18
Inventory63
Inventory gain18
Total8181

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.

AccountDebitCredit
Inventory impairment expense210
Inventory obsolescence allowance210
Total210210

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.

LineAmount ($)
Net sales (72,000 gross less 2,000 returns)70,000
Opening inventory18,000
Purchases, net of returns and discounts44,000
Freight in2,000
Goods available for sale64,000
Closing inventory21,000
Cost of goods sold43,000
Gross profit27,000
Gross margin38.6%

Now put it beside the previous months. The January and February figures are illustrative.

MonthNet sales ($)COGS ($)Gross profit ($)Gross margin
January60,00036,00024,00040.0%
February64,00038,72025,28039.5%
March70,00043,00027,00038.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.

A margin that looks right can still be wrong

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.

How Reyuko supports these checks

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.

Frequently asked questions

What should be on a month-end closing checklist for inventory?

At minimum: check cut-off for receipts and shipments, explain the goods-received and goods-shipped clearing balances, reconcile the Inventory account to your stock records, book the results of any stock count, review stock for write-downs, and test gross margin against prior months. Then lock the period and keep your working notes for next month.

How do you reconcile inventory to the general ledger?

Total the quantity times unit cost for every item in your stock records and compare it with the Inventory account balance. List each difference and match it to a cause, such as a manual journal posted straight to Inventory or a stock movement with no ledger entry. Correct the source entry, and only investigate further if something remains unexplained.

Why does gross margin change at month-end?

Margin moves for real reasons such as price changes, product mix, supplier costs and freight. It also moves for accounting reasons such as a wrong closing stock count, a missed purchase return, a cut-off error or unrecorded shrinkage. Compare the month with recent months and explain the gap before you accept the figure.

How often should you count inventory?

There is no single rule. Many small businesses do a full count once a year and cycle-count a sample each month, counting high-value and fast-moving items more often. Count more frequently if differences keep appearing. If you use the periodic method, a count at each period end is essential because it sets COGS.

What is GRNI and why check it at month-end?

GRNI stands for goods received not invoiced. It is a liability recorded when stock arrives before the supplier bill does, and it is cleared when the bill is entered. At month-end, each GRNI line should be a genuine receipt awaiting an invoice. Old or duplicated lines mean billing or recording errors that distort inventory and payables.

Can you change inventory figures after the month is closed?

You can, but it should be deliberate. In most systems you reopen the period, post the correction, re-run your checks and close it again, and you note the reason. Changing closed figures quietly makes earlier reports unreliable, so many businesses book late corrections in the current month instead, unless the amount is material.

Put this into practice in Reyuko

Reyuko posts inventory, cost of goods sold and gross profit from the same ledger, so the numbers in this lesson are the numbers on your reports.

Download Reyuko freeSee what's included