How to Record Inventory Purchases and COGS in QuickBooks

Convert a PDF bank statement to a QuickBooks file

Drop in a PDF statement and get a QBO (Web Connect) or IIF file you can import into QuickBooks Online or Desktop.

To record inventory and cost of goods sold in QuickBooks, treat a purchase of stock you will resell as an asset, not an expense, when you buy it. The cost stays on the balance sheet in an inventory asset account until the item sells. At the moment of sale, QuickBooks moves that cost out of inventory and into cost of goods sold, so your profit reflects what the sold items actually cost, not what you spent stocking up.

Getting this right depends on every supplier payment and card charge being in your books in the first place. If the bank and card statements behind your purchases are still PDFs, convert them to QuickBooks with the tool at the top of this page so each inventory buy is a real transaction you can match to a bill and a cost.

What is the difference between inventory and COGS?

Inventory is the value of the goods you are holding to sell, and it lives on your balance sheet as an asset. Cost of goods sold is the cost of the inventory you actually sold during a period, and it lives on your profit and loss as an expense. The two are linked: as inventory leaves the shelf, its cost leaves the inventory asset and becomes COGS. Money you spend on stock does not reduce your profit until the goods sell.

This is why buying a big batch of product does not create a loss and selling out does not look like pure profit. Your gross profit is revenue minus COGS, so the cost only counts against the sale it belongs to. Keeping inventory and COGS separate is what makes your margins meaningful instead of a cash-in, cash-out blur.

How do I record an inventory purchase in QuickBooks?

In QuickBooks Online Plus or Advanced, or QuickBooks Desktop, turn on inventory tracking and set up each product as an inventory item tied to an inventory asset account, an income account, and a COGS account. When you buy stock, enter a bill or an expense against the item and quantity. QuickBooks increases the inventory asset and the quantity on hand; it does not hit an expense account yet. Recording it as a bill also sets up the payable so you can match it to the payment when it clears your bank.

If you buy from a supplier who sends a detailed invoice, enter each product line so quantities and average cost stay accurate. It is far faster to pull the line items off each supplier invoice into a spreadsheet than to retype them, then bring the quantities into QuickBooks. The more accurate your item costs, the more trustworthy your COGS and margins are later.

When does inventory become cost of goods sold?

Inventory becomes COGS at the moment you sell it. When you create an invoice or sales receipt for an inventory item, QuickBooks records the revenue and, at the same time, posts a second entry moving that item's cost out of the inventory asset and into cost of goods sold. QuickBooks Online uses first-in, first-out costing, while Desktop uses average cost, so the exact figure depends on which layers or averages apply, but the timing is the same: cost follows the sale.

This automatic matching is the whole point of using inventory items. You do not manually calculate COGS each month; the software does it every time a tracked item sells. Your job is to keep purchases and sales entered accurately so the quantities and costs it is working from are right.

How do I record COGS in QuickBooks if I do not track item-level inventory?

Many small sellers do not use full inventory tracking, and that is fine when it fits your tax method. In that setup you post inventory purchases straight to a cost-of-goods or supplies expense account, and you do not carry an asset balance. If you want an accurate profit at year end, you count your remaining stock and make a journal entry to move the unsold portion back into inventory, then reverse it next period. This is the periodic method: expense as you buy, then adjust for what is left.

Whichever method you use, be consistent, because switching mid-year makes your margins impossible to compare. If you are unsure which is allowed for your business, that is a question for your tax preparer, since it ties to your accounting method and gross receipts.

Cash basis versus accrual: can I expense inventory when I buy it?

Sometimes, yes. Under the Tax Cuts and Jobs Act rules, a small business whose average annual gross receipts are under roughly $30 million, a figure the IRS adjusts for inflation each year, can use the cash method and treat inventory as non-incidental materials and supplies. That lets you deduct the cost when the items are purchased or used rather than waiting until they sell. It simplifies the books, but it also means you are no longer tracking a stock asset, so you lose the automatic COGS and on-hand quantities.

There is a real trade-off. Expensing at purchase can defer tax when you are growing and buying ahead, but it hides your true margin during the year and can distort a month where you stocked up heavily. Because this is a tax-method choice with filing consequences, confirm it with your accountant before you flip your QuickBooks setup; do not change it just to make a quarter look better.

How do I handle inventory adjustments and shrinkage?

Real stock never matches the system perfectly. Breakage, theft, spoilage, and miscounts mean the quantity QuickBooks thinks you have will drift from what is on the shelf. Fix it with an inventory quantity adjustment: count what you actually have, enter the new quantity, and post the difference to an inventory shrinkage or COGS account. That writes down the asset to reality and records the loss as a cost.

Do a physical count at least once a year, and more often for high-value or fast-moving goods. Regular adjustments keep your inventory asset honest, which keeps your balance sheet and your COGS honest. A big unexplained adjustment is also a flag worth investigating, since it can point to theft, receiving errors, or items that were sold but never rung up.

How do inventory purchases show up on my bank statement?

Every inventory buy eventually shows on a statement as a supplier payment, an ACH draft, or a card charge, and matching those to your bills is how you confirm the purchases are real and complete. A charge with no matching bill means an inventory purchase never got entered, which understates both your asset and, later, your COGS. A bill with no matching payment means something is still owed.

When those statements are PDFs, convert them so each supplier payment is a line you can match against the bills in QuickBooks. Reconciling this way catches the buy you forgot to record and the duplicate you entered twice, both of which quietly distort your margins. Once purchases, sales, and payments all tie out, your inventory value and cost of goods sold are numbers you can price and plan against. For coding the imported charges, see the guide on categorizing bank transactions in QuickBooks.

Z tej samej rodziny narzędzi