Year-End Inventory & Cost of Goods Sold Checklist for Small Businesses

Published
Read time
17 min

A year-end inventory and cost of goods sold review involves verifying stock quantities, reconciling inventory differences, calculating COGS, and checking the results against financial statements. Accounting software and AI-assisted analysis can help identify discrepancies, but the underlying records still need verification.

Cost of goods sold (COGS) represents the cost of products sold during the year, rather than everything a business purchased. For small retailers and other inventory-based businesses, an accurate calculation depends on reliable beginning and ending inventory values.

I recommend completing five tasks in order: prepare inventory records, conduct a physical count, investigate differences, calculate COGS, and review the financial statements. This checklist explains each task, highlights common mistakes, and identifies where technology can reduce manual work.

Expert Note: Inventory tracking is available in QuickBooks Online Plus and Advanced. Other plans may require an eligible add-on or upgrade.

Year-end inventory and COGS checklist at a glance

A year-end inventory review should establish what the business owns, what it sold, and what remains in stock. These figures help determine ending inventory and the cost of goods sold.

I recommend using the following checklist to organize the process before closing your books.


Year-end task

What to verify

Completed

1. Prepare inventory recordsBeginning balances, purchases, returns, and transaction dates

☐

2. Conduct a physical inventory countActual quantities, inventory locations, and damaged items

☐

3. Reconcile inventory differencesMissing stock, unrecorded transactions, and incorrect quantities

☐

4. Calculate COGSInventory values, applicable costs, and the accounting method

☐

5. Review financial statementsInventory assets, COGS, and gross profit

☐

Improve ongoing inventory controlRegular counts, purchasing practices, and stock monitoring

☐

Step 1: Prepare your inventory records before year-end

Preparing inventory records means gathering the transactions needed to explain how stock quantities and values changed during the year.

For small businesses, this may involve reviewing a spreadsheet, supplier invoices, point-of-sale (POS) reports, and accounting records.

I would prioritize missing transactions that affect inventory ownership, quantities, or costs before the count, especially unrecorded receipts, goods in transit, and returns. Routine paperwork that does not change those figures can be completed afterward if the underlying transaction is documented. That helps separate bookkeeping gaps from actual stock differences.

Confirm your beginning inventory balance

Beginning inventory represents the value of goods available for sale at the start of the accounting period. Under traditional inventory accounting, beginning inventory should ordinarily match the previous year's ending inventory.

For example, if your 2025 ending inventory was $15,000, your 2026 beginning inventory would normally also be $15,000. If the figures differ, investigate the reason before proceeding.

The IRS explains in Publication 334's COGS guidance that opening inventory will usually match the previous year's closing inventory. For Schedule C reporting, differences require an explanation.

Review purchases, supplier invoices, and returns

Inventory purchases determine how much merchandise was available for sale during the accounting period.

Before calculating COGS, check whether your records include:

  • Merchandise purchased for resale
  • Purchase returns and allowances
  • Applicable purchase discounts
  • Freight-in and other properly allocable acquisition costs
  • Merchandise withdrawn for personal or other non-sale purposes

These details affect the cost assigned to inventory.

For example, suppose a retailer purchased $5,000 in merchandise during December but sold only $2,000 of that merchandise at cost before year-end.

Under traditional inventory accounting, the remaining $3,000 would generally be included in ending inventory, assuming the goods are still owned and properly valued.

Recording the entire $5,000 as current-year COGS would overstate the cost of goods sold.

Check year-end transaction cutoffs

A year-end transaction cutoff establishes whether purchases, sales, and inventory movements belong in the current accounting period or the next.

The date an invoice is paid, or merchandise physically arrives, does not always determine when inventory should be recorded. Ownership and the applicable shipping terms can affect the treatment.

Consider this hypothetical situation.

A retailer purchases $800 worth of merchandise on December 29, 2026. The merchandise arrives on January 3, 2027.

If ownership passed to the retailer before December 31, the merchandise may belong in the retailer's 2026 ending inventory, even though it was not physically present during the count.

If ownership had not yet passed, the treatment would differ. The IRS discusses the treatment of goods in transit and merchandise held on consignment in Publication 538.

I recommend reviewing transactions involving goods in transit, unrecorded deliveries, customer returns, and inventory stored with third parties before finalizing the year-end balances.

AI assist: Check invoice records

AI-assisted document processing can help extract transaction information from supplier invoices and highlight potentially missing or duplicated records.

For example, an AI-enabled workflow could compare invoice numbers, supplier names, dates, and amounts across a transaction export.

However, identifying a possible duplicate does not establish that the transaction was recorded incorrectly. I would verify flagged items against the original purchase documents before adjusting the books.

Step 2: Conduct a physical inventory count

A physical inventory count verifies the actual quantity of products on hand and helps identify differences between recorded and available stock.

Inventory software may update quantities when purchases and sales are recorded. However, these updates depend on the transactions entered into the system.

Physical counting helps identify missing or misplaced units and unrecorded movements. Damaged goods still physically on hand should remain in the quantity count; their valuation is a separate question.

Organize your inventory before counting

Start by identifying all inventory locations, including shelves, storage areas, warehouses, and any off-site locations.

Prepare a count sheet containing the following information:

  • Product name or stock-keeping unit (SKU)
  • Storage location
  • Recorded quantity
  • Actual counted quantity
  • Difference between the two amounts

I recommend organizing the count by storage location or product category. This reduces the likelihood of counting the same product twice or overlooking an entire area.

Also establish how to handle stock movements during the count. For example, a small retailer could temporarily pause receiving and stock transfers or maintain a separate record of movements while counting.

If the count happens before or after the reporting date, reconcile sales, receipts, returns, and transfers between those dates. For example, a count on December 29 needs the movements through December 31 reflected in the December 31 inventory balance.

Count stock and compare quantities

After organizing inventory, count each product and record the actual quantity.

A physical count comparison might look like this:

ProductRecorded quantityPhysical countDifference
Product A10098-2
Product B75750
Product C5053+3

Product A has two fewer units than recorded, while Product C has three additional units.

These differences should be investigated before finalizing adjustments.

For businesses with limited staff, I recommend recounting products with significant discrepancies. If another employee is available, having that person verify the count can provide an additional check.

The IRS explains in Publication 538 that businesses maintaining perpetual or book inventories under the relevant rules must conduct physical inventories at reasonable intervals and adjust their records to agree with actual inventory.

Identify damaged, expired, or obsolete inventory

The physical count is also an opportunity to identify inventory that may no longer be saleable at its recorded value.

Examples include damaged merchandise, expired products, defective goods, and items that have become obsolete.

I recommend counting any damaged items still on hand and listing them separately for valuation review, rather than immediately removing their quantity or cost from inventory. A quantity reduction is appropriate only when the goods are actually absent or have been properly disposed of.

A slow-moving product is not necessarily worthless. Similarly, a damaged product may still have some recoverable value.

Document the quantity, condition, original cost, and available evidence supporting any proposed valuation adjustment.

The proper accounting and tax treatment depends on the inventory valuation method and applicable rules.

AI assist: Flag count variances

AI-assisted analysis can help identify unusual discrepancies after physical counts are entered into a spreadsheet or inventory system.

For instance, a tool could flag products with repeated negative count differences or unusually large changes from their recorded quantities.

The AI output should serve as an investigation list. It cannot independently confirm whether a product was lost, damaged, misplaced, or recorded incorrectly.

Step 3: Reconcile inventory records and investigate differences

Inventory reconciliation is the process of comparing physical stock quantities with recorded inventory balances and explaining any differences.

The purpose is to establish a reliable inventory quantity and value before calculating year-end COGS.

Match physical inventory with accounting records

Compare your count sheets against inventory reports, POS records, or inventory spreadsheets. For products with differences, review related purchase, sales, return, and transfer transactions. I recommend keeping a reconciliation log that documents each discrepancy and the action taken.

ProductRecorded quantityActual quantityFindingRecommended action
Product A10098Two-unit shortage; cause unverifiedRecount and investigate shortage
Product B7575No discrepancyNo action
Product C5053Receiving transaction not recordedVerify delivery records

The explanation is just as important as the corrected quantity.

Without documentation, an inventory adjustment may resolve the numerical difference while leaving the underlying problem unidentified.

Prioritize discrepancies based on financial impact

Not all inventory differences deserve the same level of attention.

I recommend reviewing high-value discrepancies first, especially when a small business has limited time to complete its year-end close.

A simple method is to estimate the value of the quantity difference:

Estimated discrepancy value = Quantity difference × Verified unit cost

For example, consider two inventory discrepancies.

ProductQuantity differenceUnit costEstimated discrepancy value
Product A2 units$125$250
Product B5 units$4$20

Although Product B has a larger quantity difference, Product A has the greater financial impact.

I would investigate Product A first while retaining Product B on the reconciliation list.

This is a practical prioritization method, not an accounting materiality threshold. Repeated discrepancies involving low-value items can still indicate significant inventory control problems.

Investigate discrepancies before posting adjustments

Common causes of inventory discrepancies include:

  • Purchases or deliveries not recorded.
  • Sales and customer returns entered incorrectly.
  • Products placed in the wrong storage location.
  • Damage, spoilage, or expired inventory.
  • Theft or other unexplained shrinkage.

I recommend documenting the cause whenever possible before adjusting recorded quantities.

For example, a physical count showing 53 units when the system records 50 may result from three received units that were never entered into inventory.

Simply increasing the quantity to 53 without recording the related purchase correctly could leave other accounting balances inaccurate.

Review and document inventory adjustments

Once the cause of a discrepancy has been established, prepare the necessary adjustment using the appropriate accounting treatment. Keep the original count, recount results, supporting transactions, and adjustment explanation together.

Illustrative completed adjustment record: Product A; recorded quantity 100; verified recount 98; variance minus two units; cause confirmed after investigation as an unrecorded disposal; supporting evidence: a disposal log; approved action: record the disposal once and reduce inventory quantity by two units; reviewer: business owner. 

This is a hypothetical example, not a reason to assume every shortage was disposed of.

For QuickBooks Online users, Intuit's August 5, 2026 inventory adjustment guidance explains how quantity adjustments affect inventory asset and shrinkage-related accounts.

Because inventory adjustments can affect financial statements, I recommend having the owner, bookkeeper, or accountant review significant changes before finalizing them.

AI assist: Review reconciliation exceptions

For a repeatable AI-assisted review, export the SKU-level stock report, physical count results, and purchase, sales, and returns data. Use a spreadsheet to calculate quantity differences and their value from verified unit costs. Then ask an AI tool approved for business financial data to summarize unusual differences and identify supporting transactions to inspect. In the example above, the two-unit, $250 discrepancy takes priority over the five-unit, $20 discrepancy, but both stay on the investigation list.

For example, a business using an approved AI tool could enter this prompt:

Using the attached count sheet, variance worksheet, and transaction export, list potential transactions that could explain each difference. Use only the verified quantities, costs, and discrepancy values provided. Flag possible duplicates as unconfirmed, identify missing supporting records, and prioritize cases for manual review. Do not invent figures or post inventory adjustments.

I recommend removing unnecessary confidential information before submitting records to an external AI system and checking the tool's data handling requirements.

Use the AI-generated results to guide your review, not to automatically change accounting balances.

Step 4: Calculate your year-end cost of goods sold

Cost of goods sold measures the cost attributable to products sold during the accounting period.

For a retailer using traditional inventory accounting, the simplified formula is:

COGS = Beginning inventory + Net purchases and applicable costs - Ending inventory

The calculation starts with the cost of goods available for sale and subtracts the cost of goods remaining at year-end.

The IRS explanation of COGS in Publication 334 identifies the relevant inventory and cost components for businesses using this approach.

Review which costs belong in COGS

For a retail business, COGS generally includes the cost of merchandise purchased for resale and properly allocable acquisition costs.

Freight-in is one example.

Manufacturers may have additional costs, including direct production labor, materials, and applicable manufacturing overhead.

Selling and administrative expenses generally require separate treatment.

For example, a retailer's merchandise acquisition costs may contribute to COGS, while an advertising campaign promoting that merchandise is generally a selling expense.

I recommend reviewing cost classifications before calculating COGS. Incorrectly classifying operating expenses as product costs can distort both inventory values and gross profit.

Confirm your inventory valuation method

Inventory valuation determines the cost assigned to products remaining in stock and those sold during the period.

Businesses may use methods such as first in, first out (FIFO) or weighted average cost for financial records, depending on their accounting framework. QuickBooks Online uses average cost for its inventory tracking, but a software calculation does not by itself establish the method applicable to the business's federal tax return. IRS inventory valuation rules and accounting-method requirements must be considered separately.

Consider a simplified weighted average example:

PurchaseQuantityCost per unitTotal cost
First purchase10$8$80
Second purchase10$12$120
Total20
$200

The weighted average unit cost is:

$200 ÷ 20 units = $10 per unit

If the retailer sells five units after both purchases, the simplified weighted average cost assigned to those sales would be $50.

I recommend confirming the inventory method used in the financial records and any separately applicable tax method before preparing the final year-end figures.

Under the applicable tax rules, changing an inventory accounting method may require filing IRS Form 3115. A business should not switch methods simply to produce a more favorable year-end result.

Calculate COGS using a retail example

Suppose a small retail store has the following year-end records.

Inventory and purchase informationAmount
Beginning inventory$15,000
Purchases$48,000
Freight-in$2,000
Purchase returns and allowances($1,000)
Ending inventory($18,000)
Cost of goods sold$46,000

Using the simplified formula:

COGS = $15,000 + $48,000 + $2,000 - $1,000 - $18,000

COGS = $46,000

Based on these hypothetical figures and the assumed traditional inventory method, the store's cost of goods sold is $46,000.

This calculation demonstrates why a business needs reliable purchase records and ending inventory values.

Understand how inventory errors affect profit

An incorrect ending inventory amount changes the reported COGS.

Using the same example, suppose the store mistakenly values ending inventory at $20,000 instead of $18,000.

The calculation becomes:

COGS = $15,000 + $48,000 + $2,000 - $1,000 - $20,000

COGS = $44,000

The business would understate COGS by $2,000.

Assuming net sales and all other figures remain unchanged, gross profit would be overstated by the same $2,000.

Financial measureCorrect calculationIncorrect calculation
Ending inventory$18,000$20,000
COGS$46,000$44,000
Difference in reported gross profitBaseline$2,000 too high

AI assist: Check unusual unit costs

An AI-assisted cost review can compare unit costs in an inventory export with the supplier invoices supporting them, then list unusually large changes or inconsistent expense classifications. The business still needs to verify the invoices and the relevant accounting treatment before changing COGS.

For example, a review tool could highlight a product whose recorded unit cost increased sharply compared with earlier purchases.

However, the cost may have increased legitimately because of supplier pricing or freight charges.

I recommend verifying any flagged difference against actual purchase records rather than accepting an AI-generated explanation.

Step 5: Review COGS and finalize your financial statements

The final year-end review should confirm that inventory values and COGS agree with the supporting records and appear appropriately in the financial statements.

I recommend reviewing three areas: inventory assets on the balance sheet, COGS on the profit and loss statement, and the resulting gross profit.

Reconcile ending inventory with the balance sheet

Under traditional inventory accounting, ending inventory represents goods that remain unsold and are properly included in the business's inventory.

The inventory asset balance should be reconciled with the finalized inventory valuation records.

For example, if the inventory valuation report shows $18,000 but the balance sheet shows $19,500, the $1,500 difference requires investigation.

Possible causes include an unrecorded adjustment, a transaction timing difference, or an incorrect cost.

I recommend tracing the difference to the supporting records before making changes.

Verify COGS on the profit and loss statement

The profit and loss statement reports COGS as a cost associated with goods sold during the period.

Compare the reported amount against the year-end calculation and supporting inventory records. Review inventory shrinkage, quantity corrections, and any valuation adjustments alongside the report. Check which accounts those entries affected, and make sure the same loss or adjustment is not counted twice.

If inventory software automatically records COGS as products are sold, verify that the underlying quantities and costs are correct.

For example, QuickBooks Online's inventory documentation updated August 5, 2026 explains how the software records inventory asset and COGS transactions and calculates costs using its documented average-cost method.

Intuit also explains how inventory transactions appear in balance sheet and profit and loss reports.

These records can simplify reconciliation, but incorrect source transactions can still result in incorrect financial reports.

Review gross profit for unusual changes

Gross profit represents the difference between net sales and COGS.

Gross profit = Net sales - COGS

Gross profit margin expresses that difference as a percentage of net sales:

Gross profit margin = (Net sales - COGS) ÷ Net sales × 100

Suppose a retailer reports $100,000 in net sales and $60,000 in COGS. Gross profit would be $40,000, and gross profit margin would be 40%. If the business previously reported a 45% margin, I would investigate what changed.

The lower margin could result from increased supplier costs, discounts, changes in the products sold, or inventory-related accounting errors.

I would not assume the difference represents poor performance or inaccurate bookkeeping without reviewing the underlying records.

The IRS also discusses comparing gross profit percentages with a retailer's markup practices as a way to identify figures that warrant further review.

AI assist: Review gross-margin movements

After calculating gross margin using verified financial data, an AI-assisted review may help summarize which product categories or periods contributed to unusual changes. It should point back to the underlying reports, not offer an unsupported explanation for the change.

For example, it could highlight product categories with rising acquisition costs or declining gross margins.

I recommend reviewing the underlying purchases, sales, and inventory transactions before treating these findings as financial conclusions.

Keep documentation supporting your year-end figures

Reliable year-end records should show how the business arrived at its ending inventory and COGS amounts.

Retain the relevant:

  • Physical count sheets and recount records.
  • Purchase invoices, returns, and freight documentation.
  • Inventory reconciliation logs.
  • Approved quantity and valuation adjustments.
  • Final inventory valuation and COGS calculations.
  • Balance sheet and profit and loss reconciliations.

For U.S. businesses, the accounting method matters when determining tax reporting requirements.

The IRS's 2025 Tax Guide for Small Business explains that qualifying small business taxpayers may use permitted alternatives to traditional inventory accounting, including treatment as non-incidental materials and supplies or an eligible financial accounting method. These are eligibility-based options, not automatic changes to a business's established tax method. Confirm the treatment and timing rules before claiming a deduction.

I recommend confirming which method applies to your business before preparing the year-end tax return. Changes involving inventory valuation, tax deductions, or accounting methods may require professional review.

Improve inventory control before the next year-end

Inventory control refers to the procedures a business uses to monitor stock quantities, record inventory movements, and maintain reliable product information.

The year-end review may reveal processes that need attention long before the next reporting deadline.

I recommend focusing on the recurring problems identified during reconciliation instead of immediately investing in more sophisticated inventory software.

Establish regular inventory checks

Cycle counting allows a business to verify selected inventory items periodically rather than waiting for a complete annual count.

For example, a retailer could review expensive or frequently sold products more often than low-value products with limited activity.

I recommend selecting the count frequency based on the importance of the products and the history of inventory differences.

Businesses with frequent discrepancies may benefit from more regular reviews until the causes are understood.

Review slow-moving and excess inventory

Inventory reports can identify products that remain unsold for extended periods.

These products may tie up money that could otherwise support more productive purchasing decisions.

I recommend distinguishing between slow-moving products, excess inventory, and products that are genuinely obsolete or damaged.

Slow-moving inventory may call for purchasing or merchandising changes, while damaged or obsolete goods may require an accounting valuation review.

Improve purchasing and stock replenishment

Review sales and purchasing records to identify recurring overstocking or stock shortages.

For example, a retailer may repeatedly purchase too much of one product while running out of another.

Reorder points and regular stock reviews may help the business plan purchases more consistently.

On eligible QuickBooks Online plans, the Physical Inventory Worksheet can help with stock counts, while Inventory Valuation Summary and Inventory Valuation Detail reports help review quantities, costs, and values. Low-stock alerts support ongoing inventory control. These capabilities are described in Intuit's inventory reporting guidance updated August 3, 2026.

However, automated alerts should not be confused with AI-powered demand forecasting. The two capabilities work differently and should be evaluated separately.

Decide where AI can improve inventory control

AI-assisted inventory analysis may be useful when a business has enough historical data to make manual reviews time-consuming.

Potential applications include:

Inventory taskPossible AI assistanceWhat still needs verification
Inventory reconciliationFlag unusual quantity differencesActual counts and supporting transactions
Purchasing reviewIdentify changes in purchase patternsSupplier prices and purchase requirements
Stock monitoringHighlight potential demand changesSales trends and inventory availability
Cost analysisIdentify unusual unit costsPurchase invoices and cost allocations
Year-end reviewSummarize records requiring attentionAccounting adjustments and final balances

These are potential uses of appropriately configured AI tools, not a claim that every accounting or inventory platform offers these features.

For small businesses with limited inventory, a spreadsheet and regular manual reviews may remain sufficient. The best approach depends on how much inventory the business manages and how much time the current process requires.

Frequently asked questions (FAQs)

What is the formula for calculating cost of goods sold?

The traditional retailer's formula is beginning inventory plus net purchases and applicable costs, minus ending inventory. Manufacturers may need to include additional production costs. Qualifying U.S. small business taxpayers may use alternative inventory accounting methods under applicable IRS rules.

How does ending inventory affect cost of goods sold?

Ending inventory is subtracted when calculating COGS. If ending inventory is overstated, COGS will generally be understated and gross profit overstated, assuming all other figures remain unchanged. This makes accurate inventory quantities and valuations important.

What should I do if my physical inventory count does not match my records?

Recount the affected products and compare their purchase, sales, return, and transfer records. Investigate possible transaction errors or stock losses before recording an adjustment. Document the cause, corrected quantity, and supporting evidence.

Do small businesses have to count inventory at year-end?

Not every small business follows the same inventory accounting requirements. Businesses maintaining traditional inventory records generally need reliable quantities and values, and certain book inventory methods require physical counts at reasonable intervals. Qualifying small business taxpayers may use alternative accounting treatments. The applicable method determines the requirements.

How should damaged or obsolete inventory be handled?

Identify the affected products, document their condition, and review whether a valuation adjustment is appropriate under the business's accounting method. Slow-moving products should not automatically be written off. Tax and financial accounting treatment may differ.

Can AI calculate cost of goods sold accurately?

AI can assist with reviewing inventory records, identifying discrepancies, and checking calculations, but accurate COGS depends on verified quantities, eligible costs, and the correct accounting method. I recommend using supported accounting calculations and reviewing AI-generated findings before finalizing financial statements.

Eric Gerard Ruiz, CPA

Eric Gerard Ruiz, CPA

Accounting and Bookkeeping Expert at Fit Small Business

Eric Gerard Ruiz, a licensed CPA in the Philippines, specializes in financial accounting and reporting (IFRS), managerial accounting, and cost accounting. He has tested and review accounting software like QuickBooks and Xero, along with other small business tools. Eric also creates free accounting resources, including manuals, spreadsheet trackers, and templates, to support small business owners.

Fit Small Business Logo

Our mission is to provide small business owners with the information you need to succeed. Learn how to start, market, run, and grow your business today!

Property of TechnologyAdvice. © 2026 TechnologyAdvice. All Rights Reserved

Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.