QuickBooks for E-Commerce Sellers: A Practical Bookkeeping Workflow

QuickBooks can be the place you organize an online store’s financial records, but it is not a substitute for the source reports that explain what happened in Shopify, a marketplace, a payment processor, or your bank. The practical goal is to make those records agree without turning every order, payout, and bank deposit into a separate version of the same sale.

This is a workflow guide, not an official QuickBooks or Intuit partnership or endorsement. QuickBooks editions, account setups, connected apps, and available automation vary. Treat the account groupings below as a bookkeeping design to discuss with your bookkeeper or accountant, not menu-by-menu product instructions. This article is general educational information—not individualized accounting, tax, or sales-tax advice.

Start with three different records

For each sales channel, keep these records conceptually separate:

• Order or channel activity: what customers bought, discounts applied, shipping charged, refunds issued, and any tax shown in the channel records.
• Processor settlement activity: how customer charges moved through a processor, including fees, disputes, reserves, adjustments, and payouts.
• Bank activity: the deposits and withdrawals that actually cleared the business bank account.

They describe connected stages, not three sets of new revenue. One store’s order report can include transactions paid by different methods; one processor payout can combine activity from several order dates; and one bank deposit may arrive after a processor has deducted fees or refunds. The payout is a settlement of earlier activity, not automatically a fresh sale.

Choose one path for getting sales into QuickBooks

Before importing anything, find out how your current Shopify or marketplace connection—or any third-party connector—actually posts data. It may bring over detailed transactions, daily summaries, or only some parts of activity. Do not assume that a connector captures every fee, refund, tax component, channel, or payout correctly. Compare its output with source reports for a test period and document what it does and does not record.

A practical setup typically follows one of two paths:

1. Detailed transaction approach: customer sales and related activity are already entered from a connected source or deliberate import. Confirm those entries are not duplicated by a second summary entry. When a bank deposit arrives, match it to the relevant payout or processor-clearing balance rather than categorizing it as sales income again.
2. Periodic summary approach: use a reviewed channel or settlement report to record one supported summary for the period, with the sales, discounts, refunds, tax components, fees, and payout amounts separated as your agreed bookkeeping process requires. Do not also post the same underlying orders as separate sales entries.

Either approach can be workable when it is complete, traceable, and used consistently. Mixing them is where duplicate revenue often appears: for example, an integration records order sales, then a monthly journal entry adds the same gross sales, and the bank-feed deposit is categorized as income once more. A useful control is to write down which source creates each accounting entry and which other reports are used only to verify or reconcile it.

Keep channel detail useful without overbuilding the chart

Use a manageable set of income and expense categories that lets you understand the store: product sales, customer shipping charged if tracked separately, discounts and returns, processor fees, marketplace or platform fees, advertising, fulfillment, and inventory-related costs may need to be distinguishable in your reports. Keep customer-collected tax amounts identifiable apart from sales revenue when appropriate to your setup. The right account names and level of detail depend on your existing chart of accounts and reporting needs.

For Shopify plus Amazon, Etsy, wholesale, or another channel, choose a consistent way to identify the source—such as supported tracking dimensions in your current setup or a carefully maintained channel schedule. Avoid creating a separate account for every tiny variation unless your reporting actually needs it. The goal is to answer useful questions, such as which channels generated sales and which fees belong to them, while keeping month-end review manageable.

Processor fees and marketplace fees are not the same thing. A payment processor may charge for moving money; a marketplace or storefront platform may separately charge selling, subscription, advertising, fulfillment, or other service fees. Use the statements that describe each charge and record it under the categories in your established process. If a charge is bundled or unclear, keep the statement and ask the bookkeeper or accountant rather than guessing from the deposit amount.

Use a clearing-account bridge to reconcile payouts

A separate clearing balance for each payment processor can make the path from customer activity to cash easier to follow. In your chosen bookkeeping process, sales and adjustments flow into the processor’s clearing balance; the net payout reduces that balance; and the matching bank deposit confirms the cash arrived. A remaining balance should have an explanation, such as sales still settling, a reserve held by the processor, a payout in transit, or an identified open dispute.

As a reconciliation check, bridge the processor report’s customer charges to refunds, fees, dispute or chargeback activity, reserve movements, other adjustments, and payouts. Use the report’s own dates and identifiers: a payout paid this month can include sales from an earlier period, while late-month sales may not reach the bank until next month. Match deposits by payout reference where available and keep a short list of deposits that are split, combined, delayed, or unmatched.

When a deposit appears in the bank feed, first identify what it represents. If the related sales have already been recorded, the deposit generally clears the processor balance; it should not be treated as new gross sales. If the activity has not been recorded yet, follow the summary method you selected and reconcile the report before posting. The bank statement is evidence that money moved—it is not a replacement for order or settlement detail. See the separate guide to reconciling Stripe, PayPal, and Shopify Payments payouts for more on the payout bridge.

Record refunds and chargebacks with their context

A refund reduces or reverses customer activity, but its timing may differ from the original order. Link it to the source transaction when possible, retain the processor confirmation, and distinguish it in the books under the returns or refund treatment used for your business. Avoid reducing a later bank deposit without also retaining enough detail to show which refund caused the difference.

For a dispute or chargeback, save the case notice, transaction reference, amount, fee, response deadline, and eventual outcome. The disputed amount, any separate dispute fee, and a later reversal or refund may occur on different dates. Keep them identifiable rather than burying them in generic bank adjustments. If the matter affects a customer obligation, accounting treatment, or tax reporting, ask an appropriately qualified professional how to handle it.

Keep inventory purchases distinct from cost of goods sold

For sellers carrying physical stock, cash paid to a supplier and the cost of products sold are related but not necessarily the same period’s expense. A common inventory-based workflow tracks goods still on hand separately and recognizes their cost as items are sold under the method selected for the business. The details depend on the seller’s records, reporting needs, accounting method, and applicable requirements; have a qualified accounting or tax professional confirm what is appropriate for your situation.

Keep supplier invoices, receiving records, purchase returns, freight and other relevant cost documents, inventory counts or reports, and notes for damaged, missing, or written-off items. Compare the inventory detail you maintain with the accounting balance on a regular schedule. Use one consistent costing process and document how you handled timing differences, bundles, returns, and stock adjustments. Read more about inventory costing methods for e-commerce sellers before changing a method or interpreting margins.

A repeatable month-end QuickBooks review

1. Save the source records. Retain the month’s Shopify and other channel activity, processor transactions and settlement reports, bank and card statements, supplier bills, and inventory records in an organized, access-controlled folder.
2. Confirm what was entered. Compare order-level totals and any channel summaries to the accounting records. Check the agreed workflow and look for duplicate sales entries, duplicated imports, or revenue categorized directly from deposits.
3. Reconcile processor activity. For each processor, bridge charges, refunds, fees, disputes, reserves, and other adjustments to payouts. Match payout identifiers to deposits and carry forward explainable amounts still in transit.
4. Review expenses and exceptions. Separate processor charges from platform or marketplace fees where your records support the distinction. Investigate unusual adjustments, chargebacks, unmatched deposits, and old clearing balances; assign each open item a next step.
5. Check inventory and cost records. Match purchases to supplier documentation, review available inventory movements or counts, and confirm the period’s inventory and cost entries follow the process selected for the business.
6. Reconcile bank and cards; then review reports. Complete statement reconciliations and scan the Profit and Loss and Balance Sheet for unexpected changes, negative clearing balances, unexplained inventory movements, or stale uncategorized items. Save the reconciliations and a concise close note.
7. Prepare tax and sales-tax questions for a professional. Preserve channel, destination, tax-collected, marketplace, and filing records that may help assess obligations. Do not treat bookkeeping categories as a determination of where to register, collect, file, or remit; rules and treatment depend on the business and jurisdiction.

A short close note can list what reconciled, what remains in transit, any refunds or disputes still open, inventory questions, and documents still needed. That creates a handoff another person can follow without relying on memory or a bank balance alone.

Keep the workflow consistent—and know when to ask

QuickBooks account labels, available reporting, and the behavior of integrations differ by edition, settings, and connected applications. Confirm that the reports you rely on provide the level of detail your process requires, and review changes to an integration before they affect a closed period. Do not switch accounting methods or make tax and sales-tax decisions solely to make a report look cleaner; take those questions to a qualified professional familiar with your facts.

If your current process is mostly matching deposits to sales, start by mapping one channel and one processor for a single month. Identify which record creates revenue, how fees and refunds appear, and how the net payout clears to the bank. Linked-do-Books shares the broader approach on its E-Commerce Bookkeeping page; the free Bookkeeping Health Score can help you reflect on your current process. For a consultation, use the contact form to describe your store and bookkeeping needs—please do not include passwords, bank credentials, tax IDs, or sensitive customer records.

QuickBooks is a trademark of Intuit Inc. This independent educational article is not affiliated with, sponsored by, or endorsed by Intuit or QuickBooks.