Bookkeeping, accounting, and fractional CFO services for small businesses across Central Florida.

Call or Text: (813) 857-5169

What chart of accounts should an e-commerce seller use in QuickBooks Online?

The default chart of accounts in QuickBooks Online wasn’t built for e-commerce. It gives you generic categories like “Sales” and “Advertising” that don’t capture what’s actually happening in your business. An e-commerce business needs accounts structured around sales channels, marketplace fees, and inventory movement or the reports won’t tell you anything useful.

For income accounts, separate your revenue by channel. Create individual income accounts for Amazon Sales, Shopify Sales, Walmart Sales, or whatever platforms you sell on. You also want a Shipping Income account if you charge customers for shipping. Refunds and returns should be tracked as a contra-revenue account (something like Sales Returns and Allowances) rather than buried in expenses. This keeps your gross revenue accurate and lets you see your true return rate.

Cost of goods sold is where most e-commerce sellers get it wrong. You need accounts for Product Cost (what you actually paid for inventory), Shipping to Customers, Packaging and Supplies, and Marketplace Fees. Amazon seller fees, Shopify transaction fees, and payment processing fees all belong in COGS because they’re directly tied to generating revenue. Lumping them into general expenses makes your gross margin look better than it really is, which leads to bad pricing decisions.

For operating expenses, think about what you actually spend money on. Advertising should be broken out by channel so you can see what you’re spending on Amazon PPC versus Facebook ads versus Google Shopping. Other common accounts include Software and Subscriptions (for tools like inventory management or listing software), Storage and Warehousing (or FBA storage fees if you use Fulfillment by Amazon), and Office Supplies.

On the balance sheet side, your Inventory asset account is critical. If you’re selling physical products, inventory needs to be tracked as an asset that converts to COGS when sold. You’ll also want an account for Marketplace Payables or Funds in Transit to capture money that platforms owe you but haven’t deposited yet. Amazon and Shopify don’t pay you instantly, and that timing gap needs to be reflected in your books. Sales Tax Payable is another important liability account since e-commerce sellers often have nexus in multiple states.

Keep the chart of accounts as lean as possible. You don’t need 15 sub-accounts under office expenses, but you do need enough detail to answer the questions that matter. Which channel is most profitable? What’s my true cost per unit after fees and shipping? Are my ad costs actually generating enough margin to justify the spend?

If you’re not sure how to configure this in QuickBooks Online, getting the setup right from the start saves you from reclassifying hundreds of transactions later. Our bilingual bookkeeping services include QuickBooks configuration specifically for how your business operates so your chart of accounts actually reflects what you need to track, not just what came preloaded.

Central Florida's Trusted Bookkeeping Firm

Start Here:
A 30-Minute Consultation

Tell us about your business and what's going on with your books. We'll figure out exactly what you need, and give you a straightforward quote.

More Questions

What bookkeeping does a medical practice need that other small businesses don't?

The biggest difference is how revenue works. Medical practices don't get paid at the point of service. They bill insurance, wait for reimbursement, track contractual adjustments, and manage patient balances, all of which require specialized accounts receivable tracking that most small businesses never deal with.

Read answer

How does sales tax nexus work for a Florida-based e-commerce seller shipping to other states?

Your Florida location creates automatic nexus in the state, but you likely owe sales tax in other states too. Since the 2018 Wayfair ruling, any state where you exceed economic nexus thresholds can require you to collect and remit sales tax.

Read answer

What's the best way to connect Shopify to QuickBooks Online without double-counting sales?

Skip the native Shopify-QBO sync. Use a summarization tool like A2X or Klayena that posts daily sales summaries as clean journal entries, breaking out gross sales, discounts, refunds, shipping, taxes, and fees properly.

Read answer

How do I set up QuickBooks Online for a business that carries inventory?

You need QuickBooks Online Plus or Advanced since the lower tiers don't support inventory tracking. From there, enable inventory in your settings, set up each product with cost and sales price, and map the correct accounts. QBO uses FIFO automatically.

Read answer

How do I manage cash flow for a seasonal Orlando business during the slow months?

Build cash reserves during your peak months, forecast your slow periods using historical data, and reduce variable expenses before revenue dips. The goal is to enter your slow season with enough cash and a clear plan for what goes out each week.

Read answer

How does having a bilingual bookkeeper help with vendor and contractor communication?

A bilingual bookkeeper can communicate directly with Spanish-speaking vendors and contractors to resolve invoice questions, confirm payment terms, and collect accurate tax documents without delays or misunderstandings.

Read answer

Orlando bookkeeping firm serving small businesses across Central Florida. Full-service bookkeeping, accounting, and advisory services backed by 10+ years of accounting experience. QuickBooks ProAdvisor certified and bilingual in English and Spanish.

Service Area

Serving Orlando, Lake Nona, Avalon Park, Winter Park, Kissimmee and surrounding areas

Client Reviews

5-Star Rated Firm

Social

  • QuickBooks ProAdvisor badge
  • QuickBooks Online Certification Level 1 badge
  • QuickBooks Online Certification Level 2 badge
  • GDA Certificate badge

© 2026 Zacosta Bookkeeping Services