Setting up QuickBooks Online correctly from the start saves you hundreds of hours of cleanup later. Most e-commerce sellers either use the default settings (which are designed for service businesses) or skip setup entirely and start entering transactions with no structure.
This guide walks you through the essential setup steps for a product-based online business. Follow these in order and you will have a clean, functional system from day one.
Step 1: Choose the Right Plan
For most e-commerce sellers, QuickBooks Online Plus is the right plan. It includes inventory tracking, project profitability, and class tracking, all of which are valuable for product-based businesses. The Simple Start plan works if you are just getting started with a handful of products and no inventory to track.
Step 2: Customize Your Chart of Accounts
The default chart of accounts in QuickBooks is built for generic small businesses. You need to customize it for e-commerce. Here are the key accounts to add or rename:
- Revenue: Product Sales (or break it out by channel: Shopify Sales, Amazon Sales, Etsy Sales)
- COGS: Cost of Goods Sold (include purchase cost, freight-in, customs/duties)
- COGS: Shipping and Fulfillment Costs
- Expenses: Advertising and Marketing (consider sub-accounts for Facebook Ads, Google Ads)
- Expenses: Platform Fees (Shopify subscription, app fees, listing fees)
- Expenses: Payment Processing Fees
- Expenses: Packaging and Supplies
- Liability: Sales Tax Payable
Delete or hide any accounts you will never use. A clean chart of accounts makes everything downstream easier.
Step 3: Connect Your Bank Accounts
Go to Banking and connect your business checking account and all business credit cards. QuickBooks will begin downloading transactions automatically. Do not connect personal accounts. Only business accounts belong in your business books.
Once connected, set up bank rules for your most common recurring transactions. For example, create a rule that automatically categorizes your monthly Shopify subscription fee every time it appears.
Step 4: Set Up Sales Tax
Go to Taxes and configure your sales tax settings. Add every state where you have nexus. QuickBooks can automate some of the calculation, but you should verify the rates and filing frequencies for each jurisdiction.
If you use a tool like TaxJar, you may handle sales tax remittance outside of QuickBooks, but you still need the liability tracked in your books.
Step 5: Configure Inventory (If Applicable)
If you hold physical inventory, turn on inventory tracking in your QuickBooks settings. Create an inventory item for each product or product category. Enter your starting quantities and costs.
For sellers with large catalogs, consider using a connector like A2X or Webgility to sync inventory data from Shopify automatically rather than entering everything manually.
Step 6: Connect Your E-Commerce Platform
Use an integration tool to connect Shopify (or your selling platform) to QuickBooks. A2X is the gold standard for this. It creates summary journal entries from your Shopify payouts that break down sales, fees, shipping, refunds, and taxes into the correct accounts.
This single step eliminates the biggest pain point in e-commerce bookkeeping: reconciling platform payouts.
Step 7: Set Up Recurring Transactions
Any expense that repeats monthly should be set up as a recurring transaction. This includes your Shopify subscription, app fees, software subscriptions, and your own invoicing if you bill clients. Recurring transactions save time and reduce the chance of missed entries.
Step 8: Run Your First Reports
Once you have a month of data, run a Profit and Loss report and a Balance Sheet. These two reports tell you everything you need to know about your financial health. Make it a habit to run them on the first of every month.
A clean QuickBooks setup is the foundation of every financial decision you will make in your business. Take the time to do it right now, and every month going forward gets easier.
Schedule a free consultation — no pressure, just a conversation about where your business is and where you want it to go.