How to Reconcile Inventory to the General Ledger in QuickBooks Online
Inventory records affect more than your stock count. They also change the Inventory Asset balance, cost of goods sold, gross profit, and the profit and loss report. If you need to reconcile inventory general ledger balances, the safest approach is to compare the right reports using the same cutoff date, accounting basis, and inventory method.
QuickBooks Online can show a clean-looking file even when purchases, sales, adjustments, or opening balances were entered out of order. The workflow below helps you find the first point where the records stopped agreeing, instead of forcing the numbers together with an unsupported journal entry.
What an inventory reconciliation should prove
A proper reconciliation connects three records:
- The physical quantity and value of products on hand.
- The product-level inventory records in QuickBooks Online.
- The Inventory Asset balance recorded in the general ledger.
The main comparison is:
Inventory Valuation Summary total = Balance Sheet Inventory Asset balance
That relationship should be tested as of the same date and under the same accounting basis. For most inventory tie-outs, use Accrual reports. A cash-basis Balance Sheet or Profit and Loss report can make timing differences look like inventory errors.
A difference does not automatically mean the physical count is wrong. It may point to a bill posted after the count, an invoice using the wrong item, an adjustment dated in another period, or an opening inventory balance that never matched the supporting records.
The IRS discusses inventory valuation and accrual accounting in Publication 538. Your tax treatment should match the method approved for your business and the records used by your tax preparer.
Reports and settings to compare
QuickBooks Online report names and customization options can vary by product version. Use the labels shown in your account, but keep the comparison consistent each time.
Inventory Valuation Summary
Run the Inventory Valuation Summary for the cutoff date. Review each inventory item, quantity on hand, average cost, and asset value. The report's total is the product-level amount you compare with the Balance Sheet.
Check for products with negative quantities, unusual costs, duplicate item names, or large changes from the prior period. A quantity may look reasonable while its cost is wrong, especially when a purchase was entered after a sale.
The inventory costing method also matters. QuickBooks Online materials can describe available costing methods differently, including references to FIFO and Moving Average Cost. Confirm the method that applies to your current QuickBooks Online file, subscription, and accounting policy before comparing periods or changing settings.
Balance Sheet and Inventory Asset
Run the Balance Sheet or Balance Sheet Standard as of the exact same date. Find the Inventory Asset account under current assets. That ending balance is the general ledger amount used for the tie-out.
Do not compare an Inventory Valuation Summary through December 31 with a Balance Sheet through December 30. Even one late bill, receipt, or sale can create a difference.
Next, review the Profit and Loss for the same period on the same accounting basis. Inventory purchases normally affect the asset account, while sales recognize revenue and cost of goods sold. A mismatch may therefore change gross profit even when total cash activity appears correct.
Inventory Valuation Detail and transaction reports
Use Inventory Valuation Detail to trace the transactions behind an item's quantity and value. Then run the General Ledger , Transaction by Account , or Transaction Detail by Account report, filtered to Inventory Asset and related accounts.
The detail reports help you locate:
- Bills, checks, or expenses that purchased inventory.
- Invoices and sales receipts that reduced inventory.
- Inventory quantity adjustments.
- Journal entries posted directly to Inventory Asset.
- Transactions that were edited, deleted, duplicated, or assigned to the wrong item.
How to reconcile inventory general ledger balances
1. Set the same date, basis, and method
Choose one cutoff date, such as the last day of the month. Use that date for the physical count, Inventory Valuation Summary, Balance Sheet, and transaction review.
For the General Ledger and Profit and Loss, use the same beginning and ending dates. Select Accrual when reviewing inventory activity unless your accountant has documented another basis for a particular purpose.
Write down the inventory method used in the file. If the method, item setup, or accounting basis changed during the period, stop and discuss the effect before relying on the comparison.
2. Compare the two ending balances
Record the Inventory Valuation Summary total and the Balance Sheet Inventory Asset balance. Subtract one from the other and save the difference for investigation.
Illustrative example: The Inventory Valuation Summary shows $18,400 on December 31, while Inventory Asset on the Balance Sheet shows $18,050. The $350 difference is the amount to trace. It is not a reason to post a $350 journal entry without identifying the cause.
Also compare the physical count with the quantity shown in QuickBooks Online. A report can agree with the general ledger and still contain incorrect quantities if the original item setup or opening balance was wrong.
3. Trace the difference through the detail
Start with the oldest unusual transaction, not the most recent one. Review the Inventory Valuation Detail and General Ledger around the first date the value changed.
Match each important entry to a vendor bill, packing slip, invoice, sales receipt, adjustment memo, or other source record. Check the transaction date, item name, quantity, rate, account, and posting period.
After each supported correction, rerun the Inventory Valuation Summary, Balance Sheet, and Profit and Loss. A change that fixes one month but distorts a prior month needs further review before you continue.
Common causes of inventory differences
Bills, purchases, invoices, and sales receipts
QuickBooks Online can record inventory purchases through bills, checks, or expenses. Sales may come through invoices or sales receipts. Problems arise when a purchase is recorded after the product was sold, when an item receipt is missing, or when the sale uses a similar but incorrect item.
The result may be negative inventory, an incorrect cost assigned to a sale, or a purchase posted to an expense account instead of Inventory Asset. Review the source document and transaction order before changing the account.
Inventory adjustments and negative quantities
An inventory adjustment can correct a verified physical difference caused by shrinkage, spoilage, damage, theft, or a counting error. It should follow a physical count, use the actual count date, and include a clear memo.
Negative inventory often means the sale was entered before the purchase or that the receipt date is wrong. It can make item reports unreliable, shift COGS between periods, and distort gross profit. Use this QuickBooks inventory adjustment guide when documenting a count-based correction.
If an item remains negative, review the first transaction that pushed it below zero. The QuickBooks negative inventory cleanup process can help organize that review before you edit older entries.
Opening balances and starting dates
An opening inventory balance may have been entered without a matching physical count, valuation report, or offsetting account. That error can remain hidden until a later reconciliation.
Review the date the business began using QuickBooks Online, the conversion balance, and any opening journal entry. Confirm whether the amount represented inventory on hand, inventory purchased before the conversion, or an estimate.
Do not replace an unexplained opening balance with a new adjustment simply to make the current report agree. The original entry may affect retained earnings, owner equity, or tax reporting.
Edited, deleted, duplicated, or direct journal entries
A changed or deleted bill, invoice, sales receipt, or adjustment can alter historical inventory values. Duplicates can inflate both quantity and cost. Direct journal entries to Inventory Asset can also bypass item-level inventory records.
Use the audit log and transaction-detail reports to identify changed dates, amounts, items, and accounts. If the entry affected a closed period or filed return, pause before editing it.
The IRS provides guidance on cost of goods sold and inventory reporting through Form 1125-A information. Coordinate corrections with the person responsible for the related tax return.
Discrepancy troubleshooting checklist
Work through the checklist in order:
- Confirm that the physical count date and report cutoff date match.
- Set every report to the same accounting basis, normally Accrual.
- Compare Inventory Valuation Summary with Inventory Asset on the Balance Sheet.
- Review negative quantities and unusually high or low item costs.
- Run Inventory Valuation Detail for the affected items.
- Filter the General Ledger to Inventory Asset, COGS, and relevant adjustment accounts.
- Check bills, purchases, item receipts, invoices, sales receipts, and returns for timing errors.
- Look for transactions assigned to the wrong product or duplicate item record.
- Review inventory adjustments, their dates, accounts, quantities, and memos.
- Check for deleted or edited transactions using the audit history.
- Verify opening inventory, conversion dates, and opening-balance entries.
- Rerun the Balance Sheet and Profit and Loss after each supported correction.
Keep the count sheet and source documents with the reconciliation. Good documentation makes the result easier to review during tax preparation, lender requests, or a later bookkeeping cleanup.
When to involve a bookkeeper or accountant
Get help before posting a journal entry
Consult an accountant before posting a correcting journal entry when the difference affects a closed month, a filed tax return, retained earnings, a large inventory write-off, or a prior-year balance.
A journal entry that makes two reports agree may still leave product quantities wrong. It can also move income or expenses into the wrong period. The correction should follow the underlying transaction and your accounting policy.
Bring in support when the issue keeps returning
Recurring differences usually point to a process problem. Receiving may happen after sales are entered, staff may use inconsistent item names, or a point-of-sale system may not send complete inventory information.
Small businesses with multiple sales channels, bundles, or several employees handling purchases and counts often benefit from regular review. General ledger and financial statement services can help connect transaction detail with reliable financial statements.
Key takeaways
- Compare Inventory Valuation Summary with Inventory Asset on the Balance Sheet.
- Use the same cutoff date, accounting basis, and inventory method.
- Review Profit and Loss because inventory timing changes COGS and gross profit.
- Trace the first unusual transaction instead of adjusting the latest report.
- Treat negative inventory as a timing and costing warning, not only a quantity issue.
- Support every adjustment with a count, source document, date, account, and memo.
- Ask an accountant before correcting closed periods or tax-related balances.
FAQ
Should the Inventory Valuation Summary always match the Balance Sheet?
They should generally agree when the reports use the same date, basis, and properly configured inventory records. A difference can occur when transactions post incorrectly, item-level records do not align with the ledger, or opening balances are wrong. Investigate the difference rather than assuming either report is automatically correct.
Which report shows the general ledger inventory balance?
The Balance Sheet shows the ending Inventory Asset balance. The General Ledger, Transaction by Account, or Transaction Detail by Account report shows the entries that created that balance. Use the Balance Sheet for the ending comparison and the detail reports for the explanation.
Can I fix an inventory difference with a journal entry?
Sometimes an accountant may approve a journal entry, but it should not be the first response. A journal entry does not correct an item quantity, product cost, or transaction sequence. First determine whether the issue came from a bill, invoice, sales receipt, adjustment, opening balance, or edited transaction.
Why does inventory affect the Profit and Loss?
When inventory is sold, QuickBooks Online records sales revenue and recognizes the related cost of goods sold. If the purchase cost arrives late or is assigned incorrectly, COGS may appear in the wrong period. That changes gross profit even when the total annual activity eventually looks closer.
Conclusion
To reconcile inventory general ledger balances in QuickBooks Online, compare the Inventory Valuation Summary with Inventory Asset on the Balance Sheet using matching dates, basis, and method. Then use Inventory Valuation Detail and the General Ledger to trace the first unsupported or unusual transaction.
A reliable reconciliation connects the shelf count, source documents, product records, and financial statements. When those records tell the same story, your inventory, gross profit, and tax reporting have a stronger foundation.
