Straight into the service manual page
WrenchQuarry
More

Periodic inventory adjustment: the 2 amounts to post

WrenchQuarry Editorial Team · Published · 10 min read · How these guides are written

At period end, a small service firm running parts stock on the periodic method posts exactly two amounts: the new ending inventory balance, and the cost of goods sold for the period. Both come from one calculation, and they move through the books together. Get the pair right and the period closes cleanly. Get one wrong and the books drift until the next count catches up.

This note walks through the calculation using one worked example, then shows how to write the adjusting entries, how to keep the count honest, and where customer estimates fit in when a part goes back on the shelf.

The periodic method in one pass

Under the periodic method you do not track a running inventory balance. You let the inventory account sit untouched all period. When the period closes, you count stock on hand, value that count, and record the results in a single adjusting entry pair.

The method rests on one equation: what you started with, plus what you bought, equals what you had available. Subtract what you still have and the rest is what you sold. The OpenStax teaching module states the logic plainly: the units that remain under FIFO are those that were purchased last, given the earliest acquisitions are treated as sold first (OpenStax, Principles of Financial Accounting, 10.2).

In the worked example the firm carries a product line called The Spy Who Loves You. During the period 585 units were available for sale. The firm sold 300 of them. Working FIFO from the front of the purchase list, 300 units come off the oldest layers, and the units still sitting on the shelf are the newest ones. That leaves the firm with 210 units purchased at $33 and 75 units purchased at $27 each, for a total FIFO periodic ending inventory value of $8,955.

Total goods available for sale during the period came to $16,155. Subtracting the $8,955 ending inventory leaves $7,200 in cost of goods sold for the period (OpenStax, Principles of Financial Accounting, 10.2).

Those are the two amounts. Everything else in the close flows from them.

The arithmetic also tells you why the two amounts are inseparable. The same ending inventory figure that raises the balance sheet account to the counted value is the figure you subtract from goods available to produce the expense. Move one and the other moves with it. That is why the periodic close is taught as a pair rather than as two independent postings.

One more piece of the equation lives in the pre-adjustment balance. The worked example opened the period with a merchandise inventory balance of $3,150 before adjustment (OpenStax, Principles of Financial Accounting, 10.2). That opening figure is the starting point you carry forward when you write the entry, and the difference between it and the counted ending balance is the amount you actually post to the inventory account.

Counting stock before you value it

The count comes first. A periodic close that starts with a valuation instead of a physical walk through the shelves will drift. Walk every bin, every shelf, every cage. Write the quantity for each part on a count sheet. Mark the sheet with the date of the count so later adjustments can be traced back to it.

While you count, note anything that looks off. A bin with more units than the last record suggests. A unit with a damaged box. A part that was pulled for a job and never returned to stock. These observations do not change the count total on their own, but they will explain variances after you value the count.

Once the count sheet is complete, price each line using the layer rules of your costing method. Under FIFO, ending inventory is priced from the most recent purchases backward until the counted quantity is covered; the older layers belong to cost of goods sold. The count times its priced layers gives you the ending inventory balance.

Two totals fall out of this: total goods available for sale for the period, and the value of what is still on the shelf. Their difference is cost of goods sold. Keep both figures on the count sheet itself. They are the two numbers you will post.

Here are the two amounts from the worked example side by side:

AmountValueWhere it goes
Ending merchandise inventory balance (target balance after the adjustment)$8,955Balance sheet asset account
Cost of goods sold for the period$7,200Record as an expense

Writing the two entries

The worked example began with a merchandise inventory balance of $3,150 before adjustment. The count valued stock at $8,955.

In plain double-entry terms, the closing pair does two things. It raises the inventory account to the counted value, and it books the period's parts cost as an expense on the income statement. Together they move the old balance out of inventory, into expense, and leave the new balance sitting in inventory.

The two amounts are linked. If you post the inventory side and leave the expense side short, cost of goods sold understates and the period's profit overstates by the same amount. Post both, at the amounts from the calculation, and the books hold.

Notice where each figure lands. The $7,200 posts to cost of goods sold on the income statement, where it matches the revenue from the parts that were sold. One movement restates an asset; the other recognizes an expense. Neither is optional.

The pair also fixes your gross margin for the period. Because goods available for sale splits into exactly two pieces, ending inventory and cost of goods sold, any error you leave in one piece distorts the other. Understating ending inventory pushes cost of goods sold up and margin down. Overstating ending inventory does the reverse. The calculation only balances when both sides come from the same count sheet and the same purchase records.

Before you post, check that the entry actually ties: the pre-adjustment inventory balance plus the increase equals the counted ending inventory, and cost of goods sold equals goods available for sale minus that same counted value. Two small checks on the calculator, done once at period end, confirm that both halves of the pair agree.

Keeping the count honest

A count that does not reconcile will produce two amounts that quietly absorb each other's errors. The remedy is in how you run the count itself.

Have one person count and a second person verify. The verifier walks the same bins afterward with the original sheet, checking quantities. Discrepancies get resolved on the spot with a re-count of that bin. This costs time on count day and saves far more during the next period, when nobody has to explain a variance that vanished between the shelf and the sheet.

Separate the count from the valuation. The counter writes quantities only. The person pricing the count works from a separate list of purchases and layers. This keeps a stray purchase price from bending a counted quantity.

If a part was received after the count date but before the books closed, leave it out of the count and add it to the purchases list for the next period. Mixing the two will double-count a layer and inflate both the ending balance and goods available for sale. The pair of amounts stays wrong together, which makes the error hard to spot.

When an owner or a reviewer wants to know why cost of goods sold moved, the folder answers the question without a reconstruction.

Run the second pass in a consistent direction as well. If the verifier walks the bins in reverse order from the counter, a systematic error in the layout of the sheet is more likely to show up. Agree on the direction before either person starts.

When a part goes back on the shelf

Service work sometimes puts a part back on the shelf after the count. A job was closed with a part pulled, then the part turned out to be wrong for the vehicle. It goes back into its bin.

Handle it by adjusting the count sheet, not by bending the valued total. Add the returned part to the quantity line for that part, re-price it using the layer it came from, and recompute the ending balance. A part that was not on the sheet understates what is really on the shelf, so the corrected sheet raises the ending balance. The cost of goods sold figure falls by the same amount. Post the pair at the revised amounts.

The reason for the discipline sits with the customer. If you request it, the repair shop must give you a written estimate of the parts and labor necessary for each specific repair (New York State Department of Motor Vehicles, Know Your Rights in Auto Repair). A part pulled off the shelf and returned to stock connects the customer's estimate to your inventory records. If the records show the part as consumed and the shelf holds it, the two sides will not agree when a customer asks.

Keep the returned-part note on the count sheet with the date it was returned. It gives a reviewer a trail from the customer's repair order to the bin to the adjusted count.

Watching the period close

The two amounts are posted once, at period end, and then the inventory account sits still again. That is the whole shape of the periodic method. The count gives you the ending balance. The arithmetic gives you cost of goods sold. The pair closes the period.

Run the close the same way every period. Count, price, compute, post both amounts, file the sheets. The repetition is what makes a variance in the next period meaningful instead of mysterious.

A reviewer opening the file later should be able to see the opening balance, the counted ending balance, the increase posted to inventory, and the expense booked, without opening a second workbook.

If your firm prices parts out to customers on work orders rather than a flat shelf price, the base price for a product or service sits in a price list (Microsoft, Use price lists - Dynamics 365 Field Service), and price list items define the base price for a product or service (Microsoft, Use price lists - Dynamics 365 Field Service). That customer-facing price is a separate figure from the layer cost you use when you value the count. Keeping the two straight on the count sheet stops a shelf price from leaking into the ending inventory total, and stops a layer cost from leaking into a customer's estimate.

One question the sources above leave open is what to do when a part's layer price has changed between the purchase and the close in a firm that mixes methods. Ask your accountant which layer rule governs that firm's parts stock before the next count, and write the answer on the count sheet itself so the next close starts from a settled rule.

That is the whole cycle: count the shelf, value the count, post the ending balance, post cost of goods sold, and keep the paperwork that ties every unit on the shelf back to the repair orders that put it there.

Worked example: closing the pair on one count

A shop counts parts at period end. Goods available for sale total $16,155. Ending inventory is counted and valued at $8,955. Subtract: cost of goods sold for the period is $7,200. The inventory account sat at $3,150 before adjustment, so the entry raises it to the counted $8,955 and books the period's parts cost as an expense on the income statement, with both figures pulled from the same count sheet.

Frequently asked questions

What two amounts does a periodic inventory adjustment post? The new ending inventory balance and the period's cost of goods sold, both derived from the same count and purchase records.

How do I check my entry before I post it? Confirm the pre-adjustment balance plus the increase equals the counted ending inventory, and that goods available for sale minus that same counted value equals cost of goods sold.

What should I do if a part returns to the shelf after the count? Add it to the count sheet for that part, re-price it from its original layer, recompute the ending balance, and post the pair at the revised amounts.

Sources

More field guides