A year-end tie-out checks a client's inventory and property basis in three steps: cost method and ending stock, quantity roll-forward, and adjusted basis. In a small firm, the usual problem is not one large mistake. It is several small gaps that each look harmless: a count sheet that was never updated, a purchase booked in the wrong month, or an asset that was sold but never removed from the fixed asset register. Any one of these can shift the year's cost of goods sold or the gain on a sale.
Key takeaways
- Confirm the client's cost method from the written policy or software setting before any number is rebuilt.
- Recompute ending inventory from the count quantity and the year-end average cost, then compare it with the books.
- Roll quantities forward from opening to closing count, and name the cause of every gap rather than plugging it.
- Recompute property basis from cost, subtract any section 181 and additional first-year depreciation, and remove disposed assets from the register.
This post is for partners and operations leads who have to tie those numbers out before the books close. It walks through three checks. The first confirms the cost method and recomputes the ending inventory value. The second rolls quantities forward from the opening count to the closing count. The third adjusts property basis so that any gain or loss on a disposal starts from the right number. If you are the operations lead, these are the parts of the file you will hand to the partner. If you are the partner, they are the parts to ask about in review.
None of these steps replaces the client's own records or your professional judgment on a particular case. The goal is to make each number traceable to a count, a cost, or a document before you sign off on it. Plan to spend most of your time on the first two checks.
Check one: confirm the cost method and value the ending stock
Start with the question that decides how every other number gets built: which cost method does the client use? Ask for the written policy or a screenshot of the software setting. A verbal answer such as "we use the average" is not enough, because the method controls how the books, the count, and the workpapers should agree. Two methods come up most often in small businesses. The first is first in, first out, or FIFO. FreshBooks describes it as "a common method of business inventory valuation" in its guide to the FIFO method. The second is weighted average cost, where the firm blends the cost of the units on hand into a single figure for each unit.
Ask the client for the supporting records before you touch the numbers. For inventory that means the purchase records, the vendor bills, the sales register, and the year-end count sheets. Confirm that the count was taken on or near the last day of the year, and find out whether any location was counted on a different date. A count taken before the year actually ends is not a year-end count, and any gap between the two dates has to be explained rather than assumed away.
Once you know the method, recompute the ending balance yourself. Do not accept the report total as given. For a weighted average system, Zoho's valuation report gives the formula directly: inventory asset value equals stock on hand multiplied by the average cost price of each unit, as shown in its inventory valuation reports help page. Take the count quantity for stock on hand, pull the average cost of each unit as it stood after the last purchase before year-end, multiply the two, and compare the result to the inventory account on the balance sheet.
The average cost also drives the cost of goods sold, so it is not a standalone number. Zoho's weighted average report knowledge base article explains that "This average cost is then used to determine the Cost of Goods Sold (COGS) and the value of your remaining stock." That means an error in the average does not stay in the ending inventory. It also flows into the income statement. If the ending value is off, check the average first, then check the sales side against it.
When the recomputed value and the books disagree, sort the difference into one of three buckets before you adjust anything. The first is a count adjustment: the physical count differed from the system quantity, and nobody posted the change. The second is timing: a purchase or a shipment landed on the wrong side of the year-end cutoff. The third is costing: the average or the layer cost was calculated incorrectly. Each bucket has a different fix.
Write down the method and the test you ran. A one-page memo with the cost method, the count date, the recomputed value, the book balance, and the difference is enough. It turns a verbal assurance into a document the next person can follow, and it shows the reviewing partner exactly what was checked and what was not.
Check two: roll the quantities forward
The dollar figure tells you whether the total looks right. Quantities tell you whether the total can be right. Build a roll-forward for each major item or product group. Start with beginning units on hand. Add the units purchased and received during the year. Subtract units sold, used in production, written off, or lost to shrinkage. The result should equal the ending units on hand. Then compare that result to the physical count taken at year-end.
When the roll-forward and the count disagree, the cause is usually one of three things. Purchases may be missing from the records, which happens often when a vendor bill arrives weeks after the goods do. Sales or shrinkage may not be recorded, especially for items that were damaged, returned, or moved to another location. Or the units of measure may not match, such as cases in the purchase record and single units in the sales record. Track down the cause before you change any number. A plug that forces the roll-forward to balance hides the problem, and the same problem returns next year with a bigger gap.
Here is how a typical item group comes together. The opening units match last year's closing count. The purchases match the vendor bills, and each bill matches a receiving record. The sales match the shipping documents, not just the invoices, because an invoice can be raised for goods that have not left the warehouse. The remaining difference, if any, is the thing to explain. When the lines tie to documents this way, the final count is a confirmation rather than a surprise.
Illustrative example: a units roll-forward
Assume a hypothetical item group starts the year with 800 units on hand. During the year, 40 units are received and 800 units are sold, so the roll-forward expects 40 units at year-end. The count shows 30. The 10-unit gap is not forced to balance. Check the receiving records for a missing purchase, the shipping documents for unrecorded sales or write-offs, and the units of measure on both sides. If the shipping documents show 10 damaged units that were never written off, post the adjustment with that cause in the workpaper.
FIFO adds a layer to the roll-forward, because you must match units to cost layers as well as to quantities. FreshBooks uses a simple example to show the logic. In it, "Sal sold 600 sunglasses during this time, out of his stock of 1275." The same example then states that “The remaining unsold 675 sunglasses will be accounted for in ‘inventory’.” The arithmetic is easy: 1,275 units less 600 sold leaves 675 on hand. The harder question is what those 675 units cost. Under FIFO, the oldest costs leave the business first, so the units still on the shelf should carry the costs of the most recent purchases. If the leftover units are valued at the first purchase price, the sales side has been costed in the wrong order, and the error runs through both the ending inventory and the cost of goods sold.
Check the cutoff at the same time. Look at goods received in the last few days of the year but recorded after it, and at goods shipped before year-end but invoiced after it. Both move units across the year-end line. A roll-forward that ties to the count can still hide a cutoff error if two errors offset each other. Look at the largest purchases and the largest shipments individually rather than trusting the net figure.
Items that have not moved in a long time deserve a separate look. The count may be correct while the value is not, because an old item may have a cost that no longer reflects what the client could get for it. Note these items on the roll-forward and ask the client how they plan to handle them. You do not need to settle the valuation question in the tie-out itself, but the open item belongs in the file.
For the workpaper, keep the roll-forward by item group, the count sheets, and a short list of every adjustment with its cause. It is the column the reviewing partner will ask about first.
How the two cost methods change the tie-out
The two methods change what you test and where errors tend to hide. The table sets the main differences side by side. Use it to decide which test to run first, and remember that the client's actual method controls the work, not the method you expected when you opened the file.
| Tie-out point | FIFO | Weighted average |
|---|---|---|
| How ending value is built | Newest purchase layers remain on hand | One average cost applied to each unit on hand |
| What the roll-forward must match | Units by cost layer, and the total | Total units and total dollars |
| Typical error | Leftover units valued at old costs | Average not updated after a delayed purchase |
| First test to run | Trace the oldest layers used in sales | Multiply the count quantity by the year-end average |
| Main year-end risk | Purchases recorded in the wrong period | Cutoff errors that shift the average |
Under either method, the ending value should trace to a count, a cost, and a book balance, and every difference should be named. The FIFO and weighted average definitions linked in the first section are the right place to check the terms before you use them in a client file.
If the client changed methods during the year, treat that as a separate question from the tie-out. It needs a documented reason and a decision from the partner before the numbers are final. Do not let the workpaper carry two methods without saying so.
Check three: adjust property basis
Property basis is the starting figure for any gain or loss when an asset is sold, traded, or retired. It is rarely the original purchase price. Start with the fixed asset register, and walk each asset from its cost to its adjusted basis.
The IRS is specific about one adjustment. In Publication 544 (2025), Sales and Other Dispositions of Assets, it states that "The basis of such property must be reduced by the section 181 expense deduction and any additional first year depreciation claimed for such property." The sentence is written for the property it describes, so read the surrounding text in the publication before you apply it to a particular asset. Where the adjustment applies, pull the deduction history for that asset before you finalize its basis.
A practical sequence for the register looks like this:
- Start with the cost recorded for each asset, including any amounts capitalized after purchase.
- Subtract any section 181 deduction and additional first-year depreciation claimed on the asset.
- Compare the resulting adjusted basis to the register and to the tax depreciation schedule.
- Explain every difference. Do not net them.
- For each disposal, compute the gain or loss against the adjusted basis at the date of sale.
Step three is where most of the work is. The common causes of difference are a book depreciation method that does not match the tax method, an asset placed in service in a different year than the register shows, and improvements capitalized in one system but not the other. A single "other" figure hides the cause and makes the next year harder. For the depreciation method itself, see Depreciation methods: 3 rules for client assets.
Testing every asset line by line is rarely necessary in a small client file, but the additions made during the year deserve full attention. Pull the purchase invoices for every asset added in the year and confirm the cost, the date placed in service, and the classification on the register. Then sample the older assets and trace a few back to their original invoices. If the sample turns up no differences, the register is probably sound. If it turns up one, widen the test before you decide the register is wrong.
Disposals need more care than the rest of the register, because each one changes the return. Every asset sold, traded, or retired in the year needs three things: its adjusted basis on the date of disposal, the proceeds, and the character of the gain or loss. The character is the part that is easiest to overlook. Publication 544 notes for certain property that "If you dispose of qualified production property placed in service after July 4, 2025, the gain will be treated as section 1245 property." Classification affects how the gain is reported, so decide it deliberately for each asset rather than assuming it from the type of equipment.
Publication 544 says, "For more information, see Section 1231 Gains and Losses in chapter 3." Read that chapter before you classify a gain on the client's behalf, and do not rely on a rule of thumb carried over from a prior year.
Finally, remove each disposed asset from the register and stop depreciation on it. A sold asset that stays on the schedule keeps generating depreciation in later years and makes the basis figures wrong on every future return. Then check that the register ties to the fixed asset accounts on the balance sheet, and that the change in accumulated depreciation equals depreciation expense for the year minus the accumulated depreciation removed for assets disposed of in the year. If either figure is off, go back to the register before you blame the books.
Putting the year-end file together
A clean tie-out file usually has the same parts for inventory and for property. It includes a memo on the cost method and the basis approach, a recomputed balance with its source documents, a roll-forward or register walk with its adjustments and their causes, and a short list of open items, each with a named owner and a date. A reviewing partner should be able to read the file cold and reach the same numbers you did. For the intake side of the file, see the client intake checklist.
Before the file closes, walk the client through the open items in plain language. Explain what was counted, what was recomputed, and what still needs a document. Ask them to confirm in writing the cost method, the count date, and any disposals they made after the count. A short written confirmation from the client protects both the firm and the client when a question comes up a year later.
Try to finish the inventory checks before the client's year-end meeting. The questions the client needs to answer usually concern the cost method and the count, and those answers often take longer to gather than the depreciation schedule does.
Keep the roll-forward and the register walk as reusable layouts. Next year's tie-out goes faster when the layout is the same, the causes column is already there, and the disposal checklist is part of the standard file.
If a number cannot be traced, say so in the file. An open item with a clear description is more useful to the partner than a plug that makes the schedules balance. A good tie-out is not one with no differences. It is one where every difference has a cause, an owner, and a record of how it was resolved.
Next step for today
Pull the client's written cost method and the year-end count sheets, and confirm the count date. Those three items decide which check you run first.