Key takeaway: Reliable inventory accounting reconciles quantities, ownership, valuation and the general ledger separately. Use a documented cost method, prevent duplicate receiving entries, and review book-to-tax differences before preparing the return.
This article is part of our guide to industry accounting specialties.
A shop’s sales dashboard can show strong demand while its stock records contain duplicate receipts, missing transfers or obsolete items. Inventory accounting connects those operational facts to the cost of goods sold and the value carried on the books.
For a retail or e-commerce business in South Florida, the aim is a close process that can explain each material balance. The examples below assume a resale business with inventory-based accrual management records. Tax reporting may use a different permissible method.
Define what each inventory record proves
An item master should identify the product, unit of measure and relevant locations. Add lot, serial or expiry tracking where useful. Keep acquisition cost separate from selling price; changing a product’s listed retail price does not automatically change its inventory carrying value.
A purchase order records an order, a receiving record documents an arrival, and an invoice records a supplier charge. Bank or card evidence establishes payment. A physical count establishes observed quantity at a place and time, but it does not establish ownership, cost or tax deductibility on its own.
Before posting a correction, decide which layer is wrong. An item report can contain the right number of units at the wrong cost. The item valuation can be right while an unrelated manual journal entry makes the general-ledger inventory account wrong. These situations need different fixes.
For related guidance, our article on E-Commerce Cost of Goods Sold walks through this in “E-Commerce Cost of Goods Sold: Reconciling Purchases, Freight, and Inventory.”
Separate cost-flow methods from physical handling
IRS Publication 538 describes FIFO and specific identification among inventory cost methods. FIFO assigns earlier acquisition or production costs to goods disposed of first; it does not require staff to select a particular physical unit from a shelf.
- FIFO: assign the oldest applicable cost layers to units sold, leaving more recent costs in ending inventory.
- Periodic weighted average: calculate an average from the period’s goods available for sale and use it to allocate cost between units sold and units remaining.
- Perpetual moving average: recalculate average unit cost after qualifying receipts, then use the current average for subsequent sales. Sales between purchases can make the result differ from a periodic average.
- Specific identification: trace the actual cost of an identifiable unit, such as a serialized high-value item, where that method is appropriate.
The choice must fit the reporting framework, goods, system and tax requirements. FIFO shelf rotation or first-expiring-first-out picking can support product quality without dictating the accounting cost-flow method. Do not switch methods merely to obtain a preferred month’s profit.
A small comparison that shows the difference
Assume opening stock is 10 identical units at $10 each. Sell 5 units, purchase 10 more at $14 each, then sell another 5. All acquisition costs are included in those prices, and there are no returns, losses or valuation adjustments. Twenty units costing $240 were available; 10 remain.
| Method | Total cost assigned to the 10 units sold | Ending inventory |
|---|---|---|
| FIFO | $100.00 | $140.00 |
| Periodic weighted average | $120.00 | $120.00 |
| Perpetual moving average | $113.33 | $126.67 |
For periodic average, $240 divided by 20 units gives $12 each. For moving average, the first sale costs $50. The remaining $50 plus the $140 purchase gives 15 units costing $190, or approximately $12.6667 each; the second five-unit sale costs approximately $63.33. Retain enough precision in the system and apply consistent rounding.
Each row reconciles to the same $240 total. A cost-flow choice changes the allocation between COGS and ending stock in this example; it does not create or remove cash.
Confirm the QuickBooks product and enabled features
For the U.S. edition, Intuit identifies FIFO inventory valuation in QuickBooks Online. Its inventory setup guidance covers Plus and Advanced. Intuit also has current instructions for an inventory add-on for Simple Start and Essentials.
Confirm availability and price within the actual account before subscribing or changing a workflow. QuickBooks Desktop, Intuit Enterprise Suite, other country editions and connected inventory apps are separate products or configurations. Do not assume a native QuickBooks Online setting can freely switch FIFO to weighted average.
If an external inventory system values stock, define whether it sends individual transactions or summary entries to QuickBooks. Decide which system controls quantities and costs, and reconcile that system’s valuation to the ledger. Two apps should not both post the same sale, receipt or COGS adjustment.
Record purchases and receiving only once
A purchase order is generally a non-posting transaction. Creating one does not by itself add an inventory asset or supplier liability to the financial statements. The accounting entry arises from the transaction’s facts and the configured receipt/bill workflow.
Some Intuit configurations record inventory through bills; others use item receipts linked to later bills. See Intuit’s item-receipt guidance and verify which workflow is enabled. Do not import an independent receipt and then a second inventory purchase when the bill arrives for the same goods.
For example, assume 100 units costing $20 each are owned and received, and the $2,000 payable is properly recognized. The economic entry increases inventory $2,000 and increases the liability $2,000. If a later bill merely confirms that same amount, it should link or replace the accrual through the system’s workflow, not create another $2,000 of inventory. Paying the supplier then reduces the liability and cash.
Capture eligible freight, duties and acquisition charges once, including the portion assigned to units still on hand. Keep customer delivery costs, marketplace charges and general operating costs separately identifiable so their treatment can be reviewed.
Apply ownership and cutoff across locations
Goods in transit belong in the reconciliation when the business owns them under the relevant contract and shipping terms. Do not include every unfilled purchase order or exclude every item outside the warehouse. Publication 538’s merchandise guidance addresses title, goods in transit and consignment for tax inventory.
A movement from your warehouse to your own fulfillment-center stock is a location transfer, not a new purchase or sale. Count it once in total owned inventory, with an in-transit location where needed. Goods held on behalf of another owner require separate identification.
For sales, use the recognition rules of the reporting basis and the contract. Shipment alone does not determine every revenue date: transfer of control, delivery terms, acceptance provisions or other relevant facts may matter. Match the associated inventory cost to the recognized sale under the adopted method.
Keep processor payouts separate from sales recognition. Reconcile orders, refunds, taxes, fees, reserves and settlements; a transfer from processor clearing to bank should not create a second sale. Supported unsettled amounts can remain in the clearing account at period-end.
Review returns, losses and stock condition
A customer refund and recovery of merchandise are separate events. Record the sales-side adjustment or settlement of an existing liability, then establish the cost-side treatment from ownership, receipt, condition and any recovery asset already recorded. A returned product’s selling price is not its inventory cost.
Investigate count shortages before calling them shrinkage. A wrong unit of measure, delayed transfer, unrecorded sale or duplicate receipt can create an apparent shortage without any missing physical stock. Record approved corrections with a reason and the underlying evidence.
Damaged or obsolete goods may require a book valuation adjustment, but a photo and manager approval do not automatically create a tax deduction. Apply the business’s permitted tax method and the rules relevant to the goods.
For inventories covered by the traditional rules, Treasury Regulation 1.471-2(c) addresses goods unsalable at normal prices or unusable normally because of specified conditions. Its subnormal-goods rule uses bona fide selling prices less direct disposition costs, with actual offering and recordkeeping requirements; the offering period ends no later than 30 days after the inventory date. Raw or partly finished goods have separate usability and scrap-value considerations. Review completely worthless goods and other exceptions on their facts.
A blanket reserve such as “write down all stock older than six months by 25%” is not a substitute for the required tax analysis. Keep book and tax adjustments separately supported and avoid deducting an item twice when it is later sold or disposed of.
Choose a tax method deliberately
Section 471(c) provides specified inventory alternatives for eligible small businesses, including non-incidental materials and supplies or qualifying financial-statement/book treatment. The exception depends on the applicable gross-receipts test, tax-shelter exclusion and other requirements. It is not a universal permission to expense every stock purchase immediately.
For tax years beginning in 2026, the section 448(c) three-year average gross-receipts threshold is $32 million under Revenue Procedure 2025-32, section 3.30. Apply aggregation and special rules where relevant. Inventory controls remain useful even when the tax method differs from management reporting.
Changing the tax treatment of a material inventory item generally requires the applicable method-change procedures, commonly Form 3115. A new warehouse, new software or changing management preference does not itself authorize a tax-method switch. Review the existing method and current consent procedures before conversion, and preserve the opening-balance reconciliation.
Run one close process and retain the evidence
- Set a common cutoff. Capture purchases, receiving, sales, returns and transfers through the reporting date.
- Count and investigate. Choose a count schedule based on value, turnover, loss risk and system reliability. Review material discrepancies promptly.
- Reconcile quantities. Tie each product’s movement across locations, including owned goods in transit and consignment.
- Reconcile valuation. Apply the documented costs and allocations; review unusual margins, negative quantities and condition adjustments.
- Tie to the ledger. Compare inventory and COGS reports with control accounts. Investigate manual entries and duplicate integrations.
- Preserve the close. Retain reports, source records, approvals, method notes and unresolved items for the preparer.
Cycle counts and an annual stock review are internal controls, not a formal financial statement audit. Whether a formal audit is needed depends on separate contractual, regulatory or other requirements; it is not established by a recommendation to count stock.
Use the resulting reports to review reorders alongside supplier lead times and a cash forecast. Unsold stock can absorb cash while reported margins look healthy. Inventory value is not money available for payroll or owner withdrawals.
CPA Firm South Florida’s published preparation pricing includes cleanup needed for the quoted return. Confirm the scope of inventory reconciliation and any additional ongoing bookkeeping, system migration, planning or other work. Contact the firm with your current systems and the balances needing review.
Frequently asked questions
Does FIFO require employees to ship the oldest physical unit?
No. FIFO is a cost-flow assumption that assigns the oldest applicable costs to units sold. Physical picking rules, such as selecting the earliest expiry date, are a separate operational decision.
Can I select average costing in QuickBooks Online?
Do not assume so. Intuit identifies FIFO for native QuickBooks Online inventory. Confirm the U.S. product, subscription, enabled features and any connected inventory application before deciding how to maintain a different costing method.
Is a documented stock write-down automatically deductible?
No. A supported book adjustment and a tax deduction are separate determinations. Apply the business’s permitted tax inventory method and any specific evidence requirements for damaged or subnormal goods.
Does a stock count count as a financial statement audit?
No. An internal inventory count or reconciliation is an operating control. A formal financial statement audit is a separate professional engagement with different objectives and procedures.