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

What's the best way to handle bookkeeping for a landscaping company?

Separate your revenue by service type, track costs at the job level, and plan for seasonal cash flow swings. Landscaping has specific bookkeeping needs that generic approaches miss.

Read answer

How do I create a cash flow forecast for my small business?

Start with your current cash balance, then project money coming in and money going out week by week or month by month. The key is using realistic collection timing, not just revenue you expect to earn.

Read answer

What tax deductions do small business owners commonly miss?

The most frequently missed deductions aren't obscure loopholes. They're everyday expenses that business owners either don't track properly, don't realize qualify, or are too cautious to claim.

Read answer

When does my business need a fractional CFO?

Your business likely needs a fractional CFO when you're making financial decisions based on gut feeling instead of data, experiencing cash flow surprises, or approaching growth that requires strategic planning beyond what basic bookkeeping provides.

Read answer

What's a Schedule C and do I need to file one?

Schedule C is the IRS form that reports profit or loss from a business you run as a sole proprietor or single-member LLC. If you earned more than $400 in net self-employment income during the year, you're required to file one.

Read answer

Do I need catch-up bookkeeping before I can file my taxes?

In most cases, yes. Your tax preparer needs organized financial records to calculate income, identify deductions, and file an accurate return. Filing without clean books usually means overpaying or missing deductions.

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