QuickBooks for Ecommerce: Setup and Best Practices
Before You Start
You need a QuickBooks Online Plus subscription ($90/month) or higher for inventory tracking capabilities. The Simple Start and Essentials plans lack inventory features, which means you cannot track cost of goods sold properly within QuickBooks on those plans. If you sell physical products, the Plus plan is the minimum viable option. You also need a dedicated business bank account already set up, because connecting personal accounts to business accounting software creates organizational problems that compound over time.
Gather your business details before starting: EIN or SSN for business identification, your business bank account login credentials for the bank feed connection, login credentials for your sales platforms (Shopify, Amazon Seller Central, Stripe, PayPal), and a list of your product lines with approximate costs and selling prices. Having this information ready lets you complete the full setup in one session rather than starting and stopping as you track down credentials.
Step-by-Step QuickBooks Setup for Ecommerce
Sign up for QuickBooks Online Plus at $90 per month. QuickBooks frequently offers promotional pricing of 50% off for the first three months, so check for current promotions. During account creation, select your business type (LLC, sole proprietor, S-corp, etc.) and industry. Select "Retail" or "Ecommerce" as your industry to get a more relevant default chart of accounts. If you work with an accountant, invite them during setup so they have access from day one.
Navigate to Settings, then Chart of Accounts. The default chart needs significant customization for ecommerce. Add these income accounts: Shopify Sales, Amazon Sales, Etsy Sales (or whatever channels you use), and Wholesale Revenue. Under Cost of Goods Sold, create sub-accounts for Product Purchases, Inbound Freight, Import Duties, and Packaging Materials. Under Expenses, add Payment Processing Fees (with sub-accounts for Stripe Fees, PayPal Fees, Amazon Fees), Shipping and Postage, Advertising by Platform, Software Subscriptions, and any other categories specific to your business. Delete or inactivate default accounts you will never use to keep the interface clean.
Go to Banking, then Add Account. Search for your bank and sign in to establish the automatic feed. Connect your business checking account, business savings account, and any business credit cards. QuickBooks will begin importing recent transactions, typically going back 90 days. The bank feed updates automatically each day, pulling in new transactions for categorization. If your bank connection uses token-based authentication, you may need to reconnect periodically when the token expires.
Go to Apps, then Find Apps, and search for your ecommerce connector. A2X is the most widely recommended integration for Shopify and Amazon because it creates proper accrual accounting entries with daily summary journal entries that break payouts into gross sales, fees, refunds, shipping, and tax. A2X costs $19 to $99 per month depending on your volume. Synder is an alternative that posts individual transactions rather than daily summaries and starts at $15 per month. Connect the integration to your sales platforms and map each revenue and fee component to the corresponding account in your chart of accounts.
After a week of transactions flowing in, you will see patterns. Go to Banking, then Rules. Create rules for recurring transactions: "If description contains STRIPE TRANSFER, categorize as Stripe Sales Revenue." "If description contains SHOPIFY, categorize as Software Subscriptions." "If description contains FACEBOOK ADS, categorize as Advertising, Facebook." Each rule saves you manual categorization on every future occurrence. Start with your ten most common recurring transactions and add rules as new patterns emerge. Well-configured rules handle 70% to 90% of your transactions automatically.
Go to Settings, then Account and Settings, then Sales, and enable "Track inventory quantity on hand." Then go to Sales, then Products and Services, and create your products. For each product, enter the SKU, description, sale price, and cost. QuickBooks tracks inventory using FIFO (first in, first out), assigning the oldest purchase cost to each sale. When you receive inventory, create a purchase order or bill that adds units to your inventory count. When products sell, the integration app or a manual journal entry reduces inventory and records COGS.
Recording Ecommerce Sales Correctly
The Payout Reconciliation Problem
The biggest challenge in ecommerce accounting is that the amount deposited to your bank is not the same as your gross sales. A Shopify store that processes $10,000 in gross sales during a payout period might have $300 in processing fees, $150 in refunds, $400 in sales tax collected, and a $50 Shopify subscription charge deducted, resulting in a $9,100 bank deposit. If you record $9,100 as revenue, you understate your gross sales by $900 and miss recording the individual fee components as expenses.
This matters for two reasons. First, your 1099-K from Stripe or Shopify reports gross payment volume, not net deposits. If your books show $109,200 in annual revenue but your 1099-K shows $120,000 in gross volume, the IRS sees a $10,800 discrepancy and may flag your return. Second, you lose visibility into your actual costs. If processing fees are lumped into reduced revenue rather than tracked as a separate expense, you cannot see that payment processing costs you $3,600 per year or evaluate whether switching processors would save money.
Using A2X for Automated Sales Recording
A2X solves this by creating a daily journal entry for each payout that breaks down every component. A single Shopify payout entry in QuickBooks looks like this: debit bank account $9,100 (the net deposit), debit processing fees $300, debit refunds $150, credit sales revenue $9,550 (net of refunds), and handle tax collected as a separate liability entry. A2X does this automatically for every payout, keeping your books accurate without manual intervention.
For Amazon sellers, A2X goes further by breaking down Amazon's complex fee structure into separate line items: referral fees, FBA fulfillment fees, storage fees, advertising costs, and reimbursements all post to their own accounts. This gives you clear visibility into Amazon's true cost structure, which many sellers underestimate because the net deposit disguises how much Amazon takes from each sale.
Manual Recording Without Integration Apps
If you choose not to use an integration app, you can record sales manually using journal entries based on platform payout reports. Download the payout report from Shopify, Amazon, or Stripe for each settlement period. Create a journal entry in QuickBooks that debits your bank account for the net deposit amount, debits individual expense accounts for each fee type, and credits revenue for the gross sales amount. This approach works for low-volume sellers but becomes impractical above 100 to 200 orders per month and is more prone to errors than automated integration.
Managing Inventory in QuickBooks
QuickBooks Plus inventory tracking is adequate for most ecommerce sellers with up to a few hundred SKUs. It tracks quantities on hand, calculates COGS using FIFO, generates inventory valuation reports, and alerts you when stock levels drop below reorder points. For each product, QuickBooks maintains the purchase history so it can assign the correct cost to each unit sold.
Record inventory purchases through Bills or Expenses. When you receive a shipment from your supplier, create a bill that increases inventory quantity and records the per-unit cost. Include freight and duty costs in the landed cost per unit to keep your COGS calculations accurate. If you pay $8.00 per unit for product and $2.00 per unit for shipping to your warehouse, your inventory cost should be $10.00 per unit, not $8.00.
If your product catalog exceeds 500 SKUs or you need advanced features like lot tracking, multi-warehouse management, or manufacturing bill of materials, QuickBooks Advanced Inventory ($80/month add-on for Plus) or a dedicated inventory management system like Cin7, inFlow, or Katana may be more appropriate. These systems sync with QuickBooks to keep financial records accurate while providing operational inventory features that QuickBooks alone cannot match.
Monthly Reconciliation Process
Monthly reconciliation in QuickBooks verifies that your recorded transactions match reality. At month end, go to Accounting, then Reconcile, select each bank account, enter the ending balance from your bank statement, and match each QuickBooks transaction to a corresponding bank transaction. QuickBooks shows you the difference between your book balance and the statement balance, and reconciliation is complete when that difference reaches zero.
After bank reconciliation, verify that your ecommerce integration entries match platform reports. Pull payout reports from Shopify, Amazon, and Stripe for the month and compare totals against QuickBooks. Gross revenue, total fees, total refunds, and net deposits should all match within a few cents. Investigate any discrepancy greater than $1 because small rounding differences are normal, but larger gaps indicate a missed or duplicated entry.
Review your profit and loss statement for the month. Check that gross margin percentages are in the expected range for your products. Look for unusually high or low expense categories that might indicate miscategorized transactions. Verify that the COGS figure makes sense given your sales volume and average product cost. Monthly financial review takes 30 to 60 minutes and is the best way to catch problems early.
Common QuickBooks Mistakes for Ecommerce
Using the wrong plan. Simple Start and Essentials do not track inventory. If you sell physical products and use these plans, you cannot properly manage COGS or inventory valuation in QuickBooks. Upgrade to Plus immediately if you are on a lower plan with inventory.
Not using an integration app. Manually recording every sale as an individual invoice or sales receipt creates thousands of unnecessary transactions, slows QuickBooks performance, and makes reconciliation extremely difficult. Use A2X or Synder to post daily summaries instead of individual transactions.
Categorizing Amazon deposits as a single revenue entry. Amazon settlement deposits include sales revenue, shipping collected, tax collected, referral fees, FBA fees, advertising costs, and various other charges all netted together. Recording the net deposit as revenue misrepresents your financials and creates 1099-K discrepancies.
Duplicating transactions. If both your bank feed and your ecommerce integration app record the same deposit, you get a duplicate that overstates revenue. When using A2X or Synder, match (do not add) bank feed entries against the journal entries created by the integration app. The bank feed confirms the deposit, while the integration provides the detailed breakdown.
Ignoring the reconciliation process. Unreconciled accounts drift out of accuracy over time. Small errors accumulate into large discrepancies that are painful to investigate months later. Reconcile every account every month, even if it takes extra time in the beginning while you learn the process.