Shopify Accounting: How Sales Land in Your Books

Your dashboard says you sold one number this month. Your bank shows another. The gap is different every month, nobody can say exactly what it is made of, and the person who keeps your books has started asking which figure they are supposed to use. Nothing is broken — you are looking at two different things that were never going to be equal.

Shopify counts revenue from orders. Your bank receives payouts, which are what is left after fees, refunds, chargebacks, reserves and the occasional hold. So the real question is not where the difference went. It is the shape your store's money should take on the way into your books: one ledger line for every order, or one summary entry for every payout.

That single choice decides which app can help you, how big your ledger gets, and which date every entry carries — and it is usually made backwards, by installing something first. This page settles it in the right order, using Shopify's own documentation and the vendors' own, read on August 6, 2026.

The Quick Verdict

Find your own situation in column one. Everything after this table is the reasoning underneath it — what shrinks a payout, what each level does to your ledger, and what a connector will and will not do once it is running.

Why your payout never equals your sales

Merchants usually go looking for one missing percentage. The card fee is one, and it is never the whole gap. What sits between the sale and the deposit is a set of independent mechanisms, each triggered by something different and each landing on a different day. Two of them can move money that was never deducted at all — it is simply being held. Learning to name them in the right order is most of what monthly reconciliation is.

The timing of the deposits themselves is its own subject — daily versus weekly schedules, settlement windows by country — and it is covered in our guide to how Shopify pays you. What matters here is only that the deposit arrives carrying deductions, so it can never be the number your revenue line is built from.

What Shopify takes out before the money lands

The one that surprises people most is the refund. It does not reverse the original payout; it is taken out of the next available one, which means a sale and its refund routinely sit in two different deposits — and often two different months. On top of that, Shopify is explicit that the original credit card transaction fee isn't refunded to you when issuing a refund, so a fully refunded order still costs you money. Card rates themselves are covered in our Shopify Payments guide.

When the money is held rather than taken

A reserve is, in Shopify's words, a temporary hold on a portion, in some cases a full amount, of transactions processed through Shopify Payments for a specified period, applied after a risk assessment. Shopify's own illustrations of the two shapes are a fixed sum — $1,000 set aside for 120 days — and a percentage, 10% of each transaction held for 120 days. Those are examples on Shopify's page, not rates: your figures come from your own notification. At the end of the period, remaining reserve funds no longer needed are returned in full.

Two clocks: the order date and the payout date

Everything above has a second dimension: when. A sale is an event on the day the order is placed. The deposit for it is an event days later, bundled with other orders and reduced by whatever happened in between. Shopify does not treat those as the same record, and the payout reconciliation report says so on its own page rather than leaving you to discover it.

This is where your accounting basis stops being an abstraction. Accrual bookkeeping records the sale when it is earned — the order date. Cash-basis bookkeeping records it when the money arrives — the payout date. A2X puts the everyday version of the problem plainly, using a marketplace example: a sale on 5 June that settles on 10 June belongs to the 5th under accrual and the 10th under cash. Cross a month-end with that gap and the same sale belongs to two different months depending on which clock you run on.

One entry per order, or one entry per payout?

There are only two honest answers to “how should this land in the books”, and they differ on almost every axis that matters. Read the table for the row that describes your actual problem — for most stores it is either the date each entry carries or what the bank line has to match — and let that row decide, rather than deciding on feature lists.

The level is built into the connector you install

Merchants tend to assume the posting level is a preference they will find in settings after installing. It is closer to the opposite: each of these connectors was built around one answer to this question, and the vendors say so in their own marketing. Intuit's documentation describes a Payment received transaction per individual sale, with a deposit that groups them at payout time. A2X describes the other shape as the whole point of the product.

Link My Books describes the same shape — one clean summary entry per payout, breaking down sales, refunds, fees and taxes. So the practical order of operations is: decide the level, then pick from the tools that do that level. Doing it the other way round is how a store ends up with thousands of ledger lines a month it never wanted, or with a summary entry that its accrual books cannot date correctly. Cost is the smaller half of the decision, but it is worth knowing before you weigh it: Intuit's connector is free to install — the listing adds that additional charges may apply and that the connector is included with your QuickBooks subscription — while the payout-level products are subscriptions of their own. A2X's entry tier is $29 a month for up to 200 orders a month. The level is the expensive half, because it sets the date on every entry you post from here on.

If something is already connected, read that table as a diagnosis before you read it as a choice. Open last month in your books and check two things: which date the entries carry, and what the bank line is matched to. Entries dated when orders were placed in books kept on a cash basis, or one journal per deposit where your bookkeeper expects to see each sale, both mean the same thing — the level was chosen by the tool rather than by you. The form of an entry is a product decision, so historical postings stay in the shape they were written in; whether and when to change anything going forward belongs with the three questions for your bookkeeper in the next section, not with a setting you flip on your own.

What to settle with your bookkeeper first

A connector asks you to commit to answers you may never have been asked for. None of these are Shopify questions, and none of them are ours to answer for you — but all three change which route above is correct, so they belong before the install, not after it. The separate question of what your bookkeeper should be able to see inside the admin, and through which mechanism, is settled in our guide to Shopify store access and permissions.

1. Is the business eligible for the cash method, or required to use accrual? The US definitions are the IRS's own: under the cash method you generally report income in the tax year you receive it; under an accrual method you generally report income in the year it is earned.
2. Which date should each entry carry? The order date matches accrual bookkeeping and the order-level route; the payout date is cash-like and matches the payout-level route. Vendors treat this as a configuration choice — Webgility, for instance, states that when you configure your integrations you specify whether to post transactions on a cash or accrual basis, and the setting is applied uniformly to every order, payout and fee.
3. Who actually performs the monthly match? You, your bookkeeper, or nobody — and if the answer is nobody, no connector fixes it. Automated posting still leaves a human deciding that the bank feed has been matched rather than duplicated.

Which level is yours?

Five questions, and no wrong route among them. Answer for the store as it runs today rather than as you hope it will run next year — the routes below are cheap to move between, and the expensive mistake is buying software to solve a problem you have not had yet.

What a connector actually moves

The clearest way to see the boundary is to read one connector's documented behaviour object by object, rather than a feature list. Intuit's is the most fully documented of the routes here, and its defaults are also the clearest example of order-level posting in practice.

Read the table below as the anatomy of both routes, not just this one. On a payout-level route the middle column collapses: the same events still happen, but they arrive as summary lines inside one journal per deposit instead of a transaction each. The table's right-hand column — what the connector leaves to you — is very nearly the same either way, which is the real point of the table.

What the Intuit connector posts, object by object

Source: Intuit — Connect Shopify to QuickBooks Online, read August 6, 2026.

What no connector decides for you

Cost of goods is the clearest case. A2X's own support documentation states that the COGS feature requires the A2X for Shopify Basic plan or higher, that you also need an Inventory Current Asset account and a Cost of Goods Sold Expense account created in your accounting system before the feature does anything, that historical COGS must be posted manually, and that a payout with a missing SKU cost requires you to add the cost and refresh that payout. Intuit's connector has the matching gap on the product side: if no match is found, the product is not added automatically and you create it in QuickBooks Online yourself.

The rest of the manual list is short but permanent:

• Account mapping. Which accounts fees, reserves and held funds post to is your decision before the first month syncs, and it is the one that quietly shapes every report afterwards.
• Exclusions. Intuit states the app does not automatically exclude transactions, so anything that should not reach the ledger is removed by a person, every time.
• The monthly match. Somebody still confirms that each deposit was matched rather than added a second time — no connector owns that step.

If your real problem is inventory, purchasing and fulfilment moving between systems rather than money landing in a ledger, you are in different territory — our ERP integration guide draws that boundary and scopes the wider job.

If your payouts arrive in more than one currency

Multi-currency is where accounting sync stops being a data problem. Every converted order carries a currency conversion fee, and Shopify changed how it is computed: starting on April 6, 2026, currency conversion fees and Multi-Currency Payout fees on Shopify Payments orders are calculated directly on the gross order amount, without deducting any fees first — a change Shopify says makes them easier to understand and reconcile with your payouts and reports.

The rate itself did not move with the base. It remains 1.5% for merchants in the United States and 2% in France and other Shopify Payments regions, per Shopify's international fees table. Shopify publishes a second conversion table for PayPal Wallet: if you activate PayPal Wallet for Shopify Payments in the United States or Shopify Payments France, the currency conversion fee is 3%; for all other Shopify Payments regions that table lists it as Not available. What is genuinely uncertain is what your connector does with any of it.

Neither of the two official Intuit pages we read on August 6, 2026 mentions currency handling for its Shopify connector — not as a feature and not as a limitation. That is not evidence it fails; it is evidence you cannot plan around it from the documentation. If you are paid in more than one currency, ask the vendor directly before subscribing, and ask specifically which account the conversion fee lands in. The boundary of that search — every page we read, and when — is in the box below.

Gift cards: money you took that isn't a sale yet

Sell a gift card and Shopify deliberately keeps the money out of your sales figures. Its documentation is explicit that the sale isn't included in any sales reports, nor the total sales number in the Home analytics card, and that it is included in the Net sales from gift cards finance report instead. When the card is later spent, the amount paid appears in the Payments report as a gift card entry, and is subtracted from the balance shown in the Outstanding gift card balance report.

Accountants have a name for money you hold against a future obligation, and your bookkeeper will use it.Shopify's own finance-report documentation uses the accounting term directly: Liabilities such as gift cards often require special treatment in accounting. What matters operationally is that gift cards need a line of their own at every posting level, because no sales report will hand them to you. The full treatment — expiry rules, balances and what a store owes on cards sold — is in our Shopify gift cards guide.

Sales tax lands as an object, not a decision

Tax moves with the data: Intuit's connector states it automatically tracks and records taxes collected by Shopify on your behalf, and handles separately the cases where the liability is yours, while Shopify's own Taxes finance report displays the sales taxes applied to your sales in the period you select. What none of that answers is where you are registered or who remits — different questions with different answers. Where the obligation starts and what you switch on for it is covered in our guide to US sales tax for Shopify merchants, and who actually files each return in does Shopify file sales tax for you.

How to reconcile a payout to your books

Whatever level you post at, the monthly job has the same spine, and the failure mode is always the same: the deposit gets entered twice — once as the sales activity behind it, once as itself. Intuit is blunt about the discipline that prevents it.

The checklist below is one routine for both levels. Steps 1 to 4 are identical whichever way you post; step 5 is where they part — at payout level you are checking one summary journal against one deposit, at order level you are checking that the deposit grouping that payout's payments is the thing your bank line matches. Worth noting before you start: no Shopify page we checked on August 6, 2026 describes reconciling a general ledger — what its documentation covers is matching a payout to a bank deposit, which is the narrower half of this job. The boundary of that search is in the box above.

Do you even need a connector?

This is the section vendor blogs tend to skip. No vendor page we checked on August 6, 2026 — A2X's marketing and pricing pages, Link My Books' seller pages, or Shopify's own blog post on small-business accounting tools — publishes a minimum number of orders or revenue at which a connector makes sense. Pricing tiers exist, but a tier ceiling is a billing boundary, not a recommendation. So the honest test is structural, not numeric:

• Payouts arrive in more than one currency. Every converted order carries a conversion fee that has to be explained and posted somewhere.
• Refunds, chargebacks or a reserve are a normal month. Each has its own timing, so each breaks the assumption that a deposit relates to the sales beside it.
• Gift cards sell in real volume. They are excluded from your sales reports by design, so nothing will remind you they exist.
• A second sales channel settles into the same books. A marketplace pays on its own schedule — how that channel's settlements arrive is covered in our Shopify and Amazon guide.

If none of those apply, the manual route is genuinely fine, and it costs nothing. Shopify hands you four sources; the work is stitching them into one entry per period. One of them is named by Shopify for exactly this purpose.

For scale, the entry price of automating it: A2X's smallest Shopify tier is $29 a month for up to 200 orders a month, with higher tiers priced by order count. Treat that as the cost of entry to compare against the hours the routine above takes you — not as a threshold.

Which QuickBooks app is actually Intuit's?

This is the most expensive five seconds on the page. Several App Store listings carry the QuickBooks name, and they are not all published by the same company. The address that looks most official belongs to the one that is not. Once you know which posting level you want, the table below is how you reach the right listing for it.

Publishers, ratings and prices read from the App Store listings on August 7, 2026. App Store figures change; the publisher name is the durable check.

Between Intuit's two listings the choice is not close: qbconnector carries 4.8 stars across 3,177 reviews as of August 7, 2026, while Intuit's 2022 listing at apps.shopify.com/quickbooks carries 2.1 stars across 63. Bold's app on the quickbooks-online handle carries 3.2 stars across 158 and is a different product at a different price — it is not a cheaper way to get Intuit's connector.

Xero's own listing is gone: the page now states that this app is not currently available on the Shopify App Store and directs support questions to Xero directly. The payout-level route to Xero still exists through A2X's listing, which names both QuickBooks and Xero as destinations. If your question is the narrower one — whether Shopify integrates with QuickBooks at all, what the Desktop path is, and how we know no Shopify-built connector exists — that is answered in does Shopify integrate with QuickBooks.

What Shopify gives you without any app

Shopify publishes an index of the apps it builds itself, and no QuickBooks app appears on it as of August 2026 — which is the positive way to establish that the sales-side connector you are looking for comes from Intuit or a third party, not from Shopify. What Shopify does offer are narrower pieces, and each is easy to mistake for the thing you actually want.

Shopify Balance connects to QuickBooks Online without an app at all: as Shopify puts it, when you connect your Shopify Balance account to QuickBooks Online you can securely sync all your transactions on Shopify Balance into QuickBooks Online. Note the scope — Balance transactions, not your store's orders — and the connection is made from the QuickBooks side. Shopify Credit has its own version of the same connection: connect your Shopify Credit account to QuickBooks Online and you can securely sync all your transactions on Shopify Credit into QuickBooks Online — again, that account's transactions, not your store's sales.

The Bottom Line

Most of the pain merchants describe as “Shopify accounting” is one unmade decision showing up in twelve places. Sales will never equal deposits: on Shopify Payments the card processing fee comes out of every sale, and the rest of what sits between an order and a deposit lands on its own clock. Once you accept that and choose which of the two posting levels your ledger runs on, the rest of the stack follows almost mechanically — including whether you need to buy anything at all.

Frequently Asked Questions