How to Record Inventory and COGS in QuickBooks Online

Jul 19, 2026

Convert your bank statement to Excel now

PDF, JPG, PNG, BMP, HEIC, TIFF, MT940

Upload your bank statement

Short answer: In QuickBooks Online you record inventory as an asset when you buy it, not as an expense. When you enter a bill, check, or expense for stock and categorize it to an inventory item, QuickBooks increases the Inventory Asset account. Nothing hits cost of goods sold yet. Cost of goods sold (COGS) is recorded automatically the moment you sell that item on an invoice or sales receipt: QuickBooks moves the item's cost out of Inventory Asset and into the Cost of Goods Sold account. You do not post a manual COGS journal entry for normal sales.

The mistake that throws off more small-business books than any other is expensing inventory the day it is bought. Money leaving the bank feels like an expense, so it gets coded straight to an expense account. But inventory you still hold is an asset, and its cost only becomes an expense when the item sells. Recording it correctly keeps your profit and loss honest and your balance sheet showing the stock you actually own.

Turn on inventory tracking first

Inventory tracking is available on QuickBooks Online Plus and Advanced, not Simple Start or Essentials. To switch it on, go to Settings, then Account and settings, open the Sales tab, edit the Products and services section, and turn on both Track inventory quantity on hand and Show Product/Service column on sales forms. Once it is on, every inventory item you create is linked to three accounts: an income account for sales, Inventory Asset for the stock you hold, and Cost of Goods Sold for the cost that flows out when you sell.

How to record an inventory purchase

Record the purchase against the inventory item, not against an expense account. If you will pay the vendor later, enter a Bill; if you paid on the spot, enter an Expense or Check. On the Item details line, pick the inventory product and enter the quantity and cost. QuickBooks then increases Inventory Asset and either Accounts Payable (for a bill) or your bank account (for a check or expense). Your profit and loss does not change at all, because you have swapped cash or a payable for an asset of equal value.

The accounts that move on a $2,000 inventory purchase on a bill look like this:

AccountDebitCredit
Inventory Asset$2,000
Accounts Payable$2,000

Notice there is no expense here. That is the whole point: buying stock is an even trade, not a cost.

How COGS gets recorded when you sell

When you sell an inventory item on an invoice or sales receipt, QuickBooks does two things at once. It records the sale to your income account, and it records the item's cost to Cost of Goods Sold while reducing Inventory Asset by the same amount. QuickBooks Online uses first-in, first-out (FIFO) to decide which units' cost to release. You do not create a journal entry; the sales form drives it. Sell an item that cost you $12 for $30 and the books show $30 of income and $12 of COGS, leaving $18 of gross profit on that line.

EventAccountDebitCredit
SaleBank or Accounts Receivable$30
SaleSales Income$30
CostCost of Goods Sold$12
CostInventory Asset$12

When you do need a manual COGS entry

Automatic COGS only works for items you set up as inventory products and sell through QuickBooks. You will record cost of goods sold manually in a few situations: you track inventory outside QuickBooks and only book a periodic adjustment, you need to write down damaged or shrunk stock with an Inventory Quantity Adjustment, or you buy materials that are consumed rather than resold. For a periodic method, the classic month-end entry debits Cost of Goods Sold and credits Inventory Asset for the cost of what sold, calculated as beginning inventory plus purchases minus ending inventory.

Why your bank feed makes this harder

The bank feed shows one lump payment to a supplier. It cannot tell that the payment bought stock rather than office supplies, so if you accept the feed's guess it will often expense the whole thing. When you buy inventory, match the downloaded payment to the bill or expense you entered against the inventory item, rather than adding it as a fresh expense. If your supplier statements arrive as PDFs, you can convert a bank statement PDF to Excel to see every purchase in dated rows before you decide which ones were inventory. To keep the receipts and packing slips behind each stock purchase in one place, an expense and receipt tracker ties the paper to the transaction so the cost basis holds up later.

Reconcile inventory at least quarterly

Run the Inventory Valuation Summary report and compare its total to the Inventory Asset balance on your balance sheet; they should match to the penny. If they drift, the usual causes are inventory items sold before any were received (which creates negative quantities and odd average costs), items bought on an expense account instead of the item line, or manual journal entries touching Inventory Asset. Fix those at the source rather than plugging the difference, and count physical stock at least once a year to true up the quantity on hand with an adjustment.

Get these two habits right, record purchases to the item and let sales drive COGS, and your gross margin will be trustworthy every month instead of swinging wildly between a big purchase month and a big sales month. Once the statements behind those purchases are in a spreadsheet, importing the cleaned data into QuickBooks with a QuickBooks bank statement converter keeps the whole loop consistent.

Ready to convert your bank statement?

Upload a PDF and get clean Excel or CSV in seconds. Works with statements from any bank.

Convert to Excel now

Free to try, no credit card required

From the same family of tools