Bookkeeping, tax, and fractional CFO services for businesses in Franklin and across Greater Nashville.

Call or Text: (262) 237-9360

How do I track cost of goods sold for my online store?

The first step is knowing what actually belongs in COGS. It’s not just what you paid for the product. COGS includes the purchase price, inbound shipping and freight, customs duties if you’re importing, and packaging materials that go out with the order. If you’re only tracking the wholesale cost of the item, you’re understating your true cost and overstating your margins.

Pick an inventory costing method and stick with it. For most e-commerce businesses, FIFO (first in, first out) or weighted average cost works well. FIFO assumes you sell your oldest inventory first, which makes sense for most products and keeps your COGS aligned with actual purchase history. Weighted average is simpler if you reorder the same products frequently at slightly different prices. It smooths out cost fluctuations without requiring you to track individual purchase lots.

In QuickBooks Online, turn on inventory tracking and create inventory items with accurate cost fields. Every time you receive new inventory, enter a purchase order or bill that records the quantity and the cost per unit. When a sale happens, the software should reduce your inventory quantity and move the cost to COGS automatically. If you’re selling on Shopify, Amazon, or both, use an integration tool to sync sales into QuickBooks so you aren’t entering orders manually.

Where most online store owners lose track is with returns, damaged goods, and write-offs. A customer returns a product and you restock it. That needs to reverse the COGS entry and add the item back to inventory. If the item is damaged and can’t be resold, it stays in COGS but the inventory count needs to be adjusted. Ignoring these transactions creates a gap between your physical inventory and your books that grows over time.

Do a physical inventory count at least quarterly. Compare what you actually have on shelves to what your system says you have. Discrepancies happen from theft, damage, miscounts during receiving, or sync errors between platforms. Adjusting for these differences keeps your COGS accurate and your balance sheet honest.

Marketplace fees from Amazon, Etsy, or Shopify Payments are not COGS. Those are selling expenses and should be categorized separately. Mixing them into COGS inflates your cost of goods and hides your true gross margin, which makes it harder to evaluate product profitability or make pricing decisions.

Getting COGS right matters beyond just clean books. Your gross margin tells you whether your products are actually profitable before overhead. It also directly affects your small business tax returns because COGS reduces your taxable income. If you’re tracking it loosely or inconsistently, you could be overpaying on taxes or making business decisions based on margin numbers that aren’t real.

If your inventory is growing or you sell across multiple channels, the tracking gets complex fast. Setting up the system correctly from the start saves you from a painful cleanup later. The goal is a process where every product received, sold, returned, or written off flows through your books consistently so your numbers actually mean something.

Greater Nashville's Trusted Financial Partner

The Next Step:
A Quick Conversation

Tell us about your business and where you need support. We'll listen, figure out what makes sense for your situation, and give you a straightforward quote.

More Questions

How do I organize my financial records for a business loan application?

Lenders want current financial statements, two to three years of tax returns, recent bank statements, and a debt schedule. Clean, reconciled books that tell a consistent story are the foundation of a strong application.

Read answer

How do I file sales tax returns in Tennessee?

Register for a sales tax account through TNTAP, Tennessee's online portal, then file and pay by the 20th of the month following each reporting period. Your filing frequency depends on how much tax you collect.

Read answer

What's the best way to manage bookkeeping for a law firm?

Start by keeping client trust funds completely separate from operating funds in your accounting system. From there, integrate your billing software with your books, track earned revenue carefully, and reconcile everything monthly.

Read answer

How do business deductions affect my personal tax return?

For most small business owners, business deductions directly reduce the income reported on your personal tax return. The exact way it works depends on your entity structure.

Read answer

What records should I organize before tax season?

Gather your income records, expense documentation, payroll reports, asset purchases, loan statements, and prior year tax return. Having everything organized before filing starts saves time, reduces your preparation costs, and helps ensure you don't miss deductions.

Read answer

How do I know if I need to collect sales tax?

It depends on what you sell and where you sell it. Physical products are almost always taxable, while services vary by state. You also need nexus, a legal connection to the state, before you're required to collect.

Read answer

Revallo is a Franklin, Tennessee firm providing bookkeeping, tax, and financial advisory services to businesses across Greater Nashville. Founded by James Manring, who brings Big 4 rigor and years of accounting experience to every engagement.

  • QuickBooks Live ProAdvisor Level 1 badge
  • QuickBooks Live ProAdvisor Level 2 badge
  • QuickBooks Online ProAdvisor Payroll badge
  • IB Trained badge
  • Gusto Payroll Certification badge
  • BBB Accredited Business badge
  • Williamson, Inc. Chamber of Commerce badge

© 2026 Revallo LLC