Getting Started with QuickBooks for E-commerce Businesses
Running an online store means juggling sales from multiple platforms—Shopify, Amazon, eBay, Stripe, PayPal, and more. QuickBooks can bring all of that activity into one set of books, but only if it is set up to handle the realities of e-commerce accounting. Here is how we recommend getting started.
Choose Between QuickBooks Online and Desktop
For most e-commerce sellers, QuickBooks Online is the natural fit because it integrates directly with virtually every major shopping cart and payment processor. If you carry heavy inventory and prefer a desktop environment, QuickBooks Desktop Enterprise may be worth considering for its advanced inventory center and assembly tracking.
Connect Your Sales Channels
Use the official integrations or a third-party connector (like A2X or Webgility) to sync data from your store into QuickBooks. Avoid importing every single individual order as a separate transaction, which clutters your register and slows down file performance. Instead, schedule daily or weekly summary entries that post gross sales, refunds, fees, and net deposits in batches.
Map Income and Expense Accounts Correctly
E-commerce deposits rarely equal gross sales. Marketplaces deduct fees, shipping, and sometimes reserves before the money hits your bank. Map your accounts so that:
- Gross sales post to a revenue account.
- Merchant and marketplace fees post to a separate expense account.
- Shipping income and costs are tracked individually if you want accurate margin data.
This separation is what allows you to see true profitability rather than just net cash flow.
Track Inventory Accurately
If you hold physical stock, inventory is usually your largest asset. Decide whether you are tracking inventory in QuickBooks itself or relying on your e-commerce platform’s built-in system. If you use an external system, make sure cost of goods sold (COGS) and inventory asset adjustments sync into QuickBooks at month-end so your balance sheet stays accurate.
Reconcile Payouts, Not Just the Bank Account
Marketplace payouts (such as Amazon seller disbursements or Shopify payouts) often hit your bank as a single lump sum. Reconcile those payouts against the detailed settlement reports inside QuickBooks. This ensures that every fee, refund, and adjustment is accounted for before the money reaches your checking account.
Keep an Eye on Sales Tax
Sales tax in e-commerce is collected by the platform in many cases, but you still owe it to the states. Set up a sales tax payable liability account rather than recording collected tax as income. When you remit tax to the state, it clears the liability instead of looking like an expense.
Next Step
Pick one sales channel to connect first—ideally your highest-volume store—and run a two-week test sync. Compare the summary entries in QuickBooks against your actual bank deposits to verify the mapping is correct before rolling out the remaining channels.