The setup

Maria runs a four-person bookkeeping shop. Fourteen of her clients sell on Shopify; all fourteen have their books in QuickBooks Online. Closing each client's month means reconciling Shopify payouts to QBO sales — fourteen times over.

For three years she used A2X. Every client paid $29–$49/mo for the subscription depending on transaction volume; Maria added a £40 monthly reconciliation review on top. The setup worked, mostly. Each client took about 45 minutes of cleanup and journal review after A2X had done its mapping. Across the book, that's 10.5 hours a month of post-A2X work.

The breaking point

Last quarter, one of Maria's clients ran a 14-day Black Friday discount. The promotion straddled a Shopify settlement boundary — some discounted orders settled on one payout, the rest on the next.

A2X booked the discount on both sides. Net result: discounts appeared twice on the books, gross sales were correct, and the P&L silently understated revenue by £4,200 for the month. Maria didn't catch it until the client's accountant flagged it during the next quarter's review. It took a Saturday to unwind.

She wasn't alone in finding this kind of thing. The Finaloop team — accountants who specifically advise Shopify sellers — had been telling bookkeepers the same thing for years:

"Translation issues...result in missing transactions or double counted transactions." — Finaloop, on why the Shopify-QBO setup may not be right for you

Their explicit recommendation: skip the integration. Use monthly CSV journal entries instead. Most bookkeepers don't, because the manual route — 5,000 to 10,000 people a month search "shopify to quickbooks" — is itself a Sunday's worth of work per client.

What a Shopify payout CSV actually looks like

Shopify exports a payout report that bundles everything that happened in that payout window — sales, refunds, processing fees, shipping, taxes, discounts, gift cards, chargebacks. For QBO to accept it as a clean journal entry, each category has to land in a different account: 

payout_date, order_number, type, amount, fee, net, presentment_currency, ...
2026-04-30, 10421, charge,   164.00,  4.50, 159.50, GBP, ...
2026-04-30, 10421, discount,  -16.00,  0.00, -16.00, GBP, ...
2026-04-30, 10421, shipping,   12.00,  0.00,  12.00, GBP, ...
2026-04-30, 10422, charge,    89.00,  2.80,  86.20, GBP, ...
2026-04-30, 10422, refund,   -89.00, -2.80, -86.20, GBP, ...

Five categories on two orders, all in one file. A QBO journal entry needs each category aggregated, totals tied out, and one line per account.

The Mappd recipe

Maria configured one Mappd recipe — about five minutes — that does exactly what Finaloop's article recommends: groups the payout rows by category, sums each, builds the QBO journal entry, and writes the export. She built it for the most complex client first, then duplicated and tweaked for the other thirteen.

Now her month-end across all fourteen clients looks like this:

  • Download each client's Shopify payout CSV (Shopify export, three clicks).
  • Drag the file onto the matching client's saved recipe in Mappd.
  • Review the diff — Mappd shows category totals on screen before export.
  • Export to CSV, import into QBO as a journal entry.

Per client: about 15 seconds of Mappd-time, plus 4–5 minutes of review and import. Across the book: 3 minutes of Mappd-time, ~70 minutes of review. The diff is the review — A2X never showed her one.

Before (A2X)
~10.5 hrs / month
14 × 45 min cleanup after A2X. £400+/mo in client subs. Silent-sync failures twice a year.
After (Mappd)
~70 min / month
14 recipes, one per client. Diff catches what A2X hid. Free tier covers most clients.

The math, three months in

Time back / month
~9 hrs
Roughly one extra client's capacity
Client subs avoided
£400/mo
A2X charges discontinued across the book
Silent-sync errors
0
The diff is the review

The honest bit

What Mappd doesn't do: it won't catch a Shopify discount that straddles a settlement boundary either — that's a Shopify export quirk, not a Mappd one. What changes is that Mappd surfaces the daily category totals in its sign-off diff before you export. Maria's eye now lands on the discount line when it looks wrong. A2X's silent sync didn't give her that line to look at.

If your book has more than a couple of Shopify clients

The Shopify → QuickBooks preset is one of Mappd's six launch recipes. Configure it once per client (about five minutes); after that, every monthly close is a 15-second job per book. Files under 5 MB are free — that covers a lot of monthly payouts. Pro (£12/mo for one bookkeeper) unlocks bigger files, ten saved recipes, and Excel export.

Names changed for anonymity. Quotes, search-volume figures, and workflow described are real and sourced from forum evidence.