How to Record Shopify Sales in QuickBooks Online (2026)

In this guide
The quick answer
How do you record Shopify sales in QuickBooks Online?
You can record Shopify sales in QuickBooks Online manually by breaking down each payout into sales, discounts, refunds, fees, and taxes, then matching the payout to your bank deposit. Or you can automate the process with Link My Books, which prepares categorized summaries and sends them to QuickBooks. Either way, the key is to record gross activity correctly—not treat the net bank deposit as sales revenue.
Shopify makes accepting orders easier, but the money arriving in your bank account is rarely the same as the sales number on your dashboard. Payment processing charges, refunds, discounts, shipping, and taxes can all affect the final amount.
If you enter that deposit as income without understanding its components, your QuickBooks Online reports may understate revenue, omit expenses, or misclassify taxes. The problem becomes more noticeable as order volume grows or you add PayPal and other payment providers.
In my short video, I explain the two routes: do the work manually, or use software to automate it. This guide adds practical steps, a worked example, and the checks I would make before trusting any integration with my books.
Affiliate disclosure
Some links in this article are affiliate links. If you subscribe through them, I may earn a commission at no extra cost to you. Read my full disclosure.
Why Shopify sales and bank payouts are different
A Shopify order is a sales event. A Shopify Payments payout is a transfer of funds after Shopify processes the transactions included in that payout. One deposit can represent many orders and several adjustments. That is why simply categorizing a $9,600 deposit as $9,600 in sales can produce the wrong accounting picture.
Here is a simplified illustration of one payout. The numbers are hypothetical, and the example assumes all listed amounts relate to the same settlement, with no separate currency conversion or reserve movements.
| Payout component | Example amount | Accounting treatment to consider |
|---|---|---|
| Gross product sales | $10,000 | Sales income before adjustments |
| Discounts | −$500 | Reduction of sales or contra-revenue |
| Shipping charged to customers | +$250 | Shipping income, as appropriate |
| Sales tax collected | +$650 | Tax liability, not ordinary revenue |
| Customer refunds | −$400 | Reverse relevant sales and taxes |
| Processing fees | −$300 | Payment processing expense |
| Other payout adjustments | −$100 | Classify after checking the reason |
| Net bank payout | $9,600 | Amount to reconcile with the bank |
The net payout is not your profit either. It still excludes costs that may sit outside Shopify, such as inventory, advertising, warehouse costs, and business overhead. If Shopify or another marketplace remits tax on your behalf, the tax treatment also needs to reflect that arrangement.
This distinction is the foundation of accurate Shopify accounting in QuickBooks Online. The goal is to explain the entire payout, not just make your bank balance look right.
Free trial and reader discount
Try Link My Books for Shopify and QuickBooks
14-day free trial
Connect your store, inspect the settlement breakdowns, and test whether the workflow fits your books.
Code VOVA20
50% off your first three paid months on an eligible new monthly subscription.
Start the free trial and claim the offer
Enter VOVA20 at checkout and verify the price before paying. The three-month promotion is for eligible new monthly subscriptions billed directly by Link My Books; annual plans and Shopify App Store billing have different terms.
Method 1: Record Shopify sales in QuickBooks Online manually
Manual bookkeeping can work when you have a small number of payouts, understand your chart of accounts, and are comfortable reconciling sales activity. It requires care, especially if you collect sales tax or operate across several jurisdictions. The precise entries should follow your accountant's method and your accounting basis.
- Choose a reporting period. Export the relevant Shopify Payments payout or transactions report and your bank deposit details. Check the payout date and transaction dates rather than assuming they match.
- Separate the components. Identify sales, discounts, shipping income, returns, payment fees, tax amounts, chargebacks, and reserves or adjustments where relevant.
- Map each category. Decide which QuickBooks income, expense, clearing, and tax-liability accounts should receive the amounts. Confirm tax codes rather than guessing.
- Post the appropriate summary. Create an accountant-approved sales summary or journal entry for the period. A Shopify Payments clearing account can help track money due before it reaches your bank.
- Match the deposit. Once the bank feed imports the transfer, reconcile it against the existing payout or clearing entry instead of adding a second sales transaction.
- Save your evidence. Keep payout exports, explanations of adjustments, and the reconciliation record available for month-end review.
Watch for double counting: If a connector has already created the sale or payout entry, adding the bank deposit as new income will overstate revenue. Match existing transactions whenever appropriate, and check historical periods before importing them again.
For a store processing only occasional orders, this routine may be manageable. But the work expands when refunds span different dates, multiple payment processors settle separately, or VAT and sales tax require different treatment.
Manual also does not have to mean entering every order individually. The best level of detail depends on whether you need customer-level invoicing, inventory tracking, or settlement-level financial reports.
Method 2: Automate Shopify bookkeeping with Link My Books
Link My Books takes a settlement-first approach. For Shopify Payments, it prepares summaries that separate sales, refunds, fees, and taxes by payout. For supported third-party gateways, it can prepare periodic summaries by gateway and currency. Those entries can then be posted to QuickBooks Online and reconciled against bank activity.
The advantage is consistency. Instead of rebuilding the same spreadsheet for each deposit, you set up the accounting categories once, review the first results, and let the tool handle routine posting once you are satisfied with the mappings.
- Begin your trial. Open the Link My Books free-trial offer and create an account.
- Connect Shopify. Select Shopify as your sales channel, enter a clear store name, and approve the app connection in your Shopify admin.
- Connect QuickBooks Online. Select QuickBooks as your bookkeeping platform and authorize the correct company file.
- Complete the setup wizard. Map sales, refunds, fees, payment-clearing accounts, and taxes to the accounts and tax codes appropriate for your business.
- Check payment gateways. Confirm that Shopify Payments and any other gateway you use are enabled and mapped. Different payment providers can have different settlement schedules.
- Review the first settlements. Compare the breakdown with Shopify reports, send one or two entries to QuickBooks, and confirm that bank reconciliation works as expected.
- Enable automation deliberately. Once the results are approved, switch on automatic posting for the correct starting date. Continue periodic reviews rather than assuming automation removes your oversight.
The official connection guide covers Shopify authorization and choosing QuickBooks. Complete the wizard in one session, and ask your accountant to verify tax mapping before activating ongoing posting.
I also recorded a full tutorial with Daniel Little, co-founder of Link My Books. It shows the settlement workflow in more detail, including setup, reviewing entries, and when to consider automatic posting.
Ready to test the workflow?
Free trial + 50% off with VOVA20
Use the trial to check a real Shopify payout against QuickBooks. When you choose an eligible new monthly plan, enter VOVA20 for 50% off the first three paid months, subject to the offer accepted at checkout.
Before subscribing, confirm the number of sales channels, order volume, currency, monthly price after the promotion, and whether you will be billed directly by Link My Books.
What about PayPal, taxes, and inventory costs?
Third-party payment gateways: A PayPal payment does not necessarily appear in your bank at the same time as a Shopify Payments payout. If you use multiple gateways, reconcile each settlement to the account that actually receives the money. Link My Books' payment-gateway instructions explain the gateway settings and monthly summaries.
Sales tax, VAT, and GST: These depend on your selling locations, product tax rules, and who is legally responsible for collecting or remitting the tax. Software can categorize amounts using your mappings, but it cannot decide your tax obligations for you. Review the tax setup with a qualified professional.
Gift cards and chargebacks: A gift card sale may create a liability rather than immediate product revenue. Disputed payments and reserves can also create timing differences. Keep these items separate from ordinary product sales.
Cost of goods sold: Reconciling a payout is not the same as calculating profit. Review your inventory and COGS method, advertising spend, software subscriptions, and other expenses separately. Add these to your monthly profit-and-loss review.
Manual entry, Link My Books, or the QuickBooks connector?
You have more than one legitimate route to Shopify–QuickBooks integration. Intuit also offers the Shopify Connector by QuickBooks, which imports individual sales, refunds, fees, and payouts and supports payout reconciliation. Choosing between tools depends on the detail you need and how you want your books organized.
Manual summaries
A possible fit for very low volume when you can reliably prepare entries and reconcile them each month.
Link My Books
Worth testing if you want categorized payout summaries and a repeatable reconciliation process across channels.
QuickBooks connector
Consider it when you prefer transaction-level imports and want to review Intuit's native integration settings.
Do not run two integrations that post the same Shopify transactions into the same QuickBooks company file without a deliberate exclusion plan. Compare a sample payout, check tax treatment, and ask your bookkeeper which transaction structure is right for your reporting.
A practical Shopify month-end reconciliation checklist
Whether you automate or handle the entries yourself, a short monthly review catches issues before they turn into a year-end cleanup project. My preferred approach is to reconcile evidence first and only then review profit.
- Confirm all expected Shopify and third-party payment settlements are recorded for the period.
- Match each bank deposit to the corresponding payout or clearing-account activity.
- Check that fees, refunds, returns, discounts, and tax liabilities were classified correctly.
- Investigate unmatched amounts, duplicate entries, and timing differences across month-end.
- Reconcile clearing accounts, then review inventory costs, operating expenses, and the profit-and-loss report.
If the Shopify Finance Summary and your accounting totals differ slightly, compare the dates used. Shopify reporting and payout-based bookkeeping can recognize transactions in different periods, especially when refunds are processed after the original purchase. The Link My Books reconciliation explanation outlines this timing issue.
Frequently asked questions
Can QuickBooks Online import Shopify sales automatically?
Yes. You can use a compatible connector, including the Shopify Connector by QuickBooks or Link My Books. Check whether it posts individual transactions or payout summaries and how it handles taxes, refunds, and bank reconciliation.
Should I record the Shopify payout as income?
Not as an unexplained lump sum. A payout is generally net of fees, refunds, and other adjustments. Record the underlying activity properly and match the deposit to the relevant bookkeeping entry.
Does Link My Books support Shopify Payments and PayPal?
Yes. It supports Shopify Payments and other Shopify payment gateways, including PayPal. Check that every used gateway is enabled in Settlement Settings and assigned to the appropriate clearing account.
Is Link My Books free, and how do I use VOVA20?
Link My Books advertises a 14-day trial, not an unrestricted free subscription. After trying it, eligible new customers choosing direct monthly billing can enter VOVA20 for 50% off their first three paid months. Check the discount and renewal total before subscribing.
Will automation replace my accountant or bookkeeper?
No. Automation handles repetitive data preparation and posting, but someone still needs to confirm tax treatment, inventory accounting, financial accuracy, and exceptions. A qualified accountant can help validate the setup.
Final thoughts: Make Shopify sales easy to reconcile
The best Shopify accounting process is one you can explain and repeat. You should know where each deposit came from, which charges reduced it, and whether the resulting entries reflect your actual business activity.
Manual reconciliation is possible, especially for a small store. If it is eating into your week, try an automated workflow on a single payout first. Confirm the numbers, check the account mappings, and only then expand the process.
For a deeper walkthrough, my complete Link My Books tutorial goes through the setup from A to Z. You can also explore my Link My Books pricing guide before choosing a paid plan.