Convert a Shopify payout transactions CSV to QuickBooks or Xero

Including multi-year catch-up - with the footing check that proves the conversion is right.

Why Shopify settlements resist clean bookkeeping

Shopify's payout transactions export is the cleanest file of the five platforms, and it still defeats naive imports. Each row carries a gross Amount, a processing Fee, and a Net - but charges, refunds, and disputes interleave by transaction date while the deposit lands on the payout date, and dispute rows pull both the contested amount and a separate dispute fee out of the same payout. Import the file raw and your register fills with hundreds of order-level lines that don't match any bank line; book only the net and your fee expense disappears.

How the Shopify file maps to your books

Multi-year catch-up on Shopify

Shopify payout exports cover whatever range you select, so older periods convert file by file. One catch-up wrinkle unique to Shopify: very old payouts sometimes predate the current export format's columns, and the converter fails loudly on those rather than guessing - those files get flagged for a manual look instead of silently producing wrong books.

Importing into QuickBooks Online

1. In QBO, go to Banking → Upload transactions and choose the FootingKit QuickBooks CSV.
2. Select the 3-column layout (Date, Description, Amount) - the file is already in that layout.
3. Map each summarized line to your accounts: Sales to income, Platform fees to merchant fees expense, Refunds against income.
4. Match each payout's lines against the corresponding bank deposit. Because every payout foots to the cent, the match is exact - no plug entries.

QuickBooks bank feeds want one line per money movement against a deposit, so FootingKit summarizes each payout into category lines dated to the deposit date; order-level detail stays in the reconciliation report, out of your register.

Importing into Xero

1. In Xero, open the bank account, choose Import a statement, and upload the FootingKit Xero CSV.
2. The file uses Xero's statement layout (*Date, *Amount, Payee, Description, Reference) - no column mapping needed.
3. Create bank rules once for the Payee names and Xero codes recurring lines automatically from then on.
4. Reconcile each payout group against the real deposit; the Reference column carries the payout id so groups filter cleanly.

Xero statement imports work best when each payout arrives as a small set of coded lines, so FootingKit groups by payout and carries the payout id in the Reference field - bank rules handle the recurring coding from the second month on.

Does this work with Shopify Payments payouts?

Yes - the payout transactions export is exactly what the converter reads, grouping rows by payout id and footing each payout against its own Net column.

How are chargebacks handled?

Dispute rows map to adjustments with the dispute fee as a separate fee line, so you can see both the contested principal and what the dispute cost you.

Convert your Shopify file - done-for-you from $149

FootingKit converts marketplace settlement reports into QuickBooks- and Xero-ready books, footed to the penny.