Your marketplace CSV doesn’t import into QuickBooks.
This fixes that.

Etsy, Shopify and eBay order exports don’t match what QuickBooks Online or Xero expect — so sellers retype orders by hand, or pay for a sync subscription they don’t need. Drop your orders CSV here and get back a profit-tracker sheet, a QuickBooks Online import file and a Xero import file. Seconds, not an evening.

Drop your Etsy, Shopify or eBay orders CSV here
Runs 100% in your browser — your file is never uploaded.
We detect the platform automatically. One file at a time.
or
new here?

You’ve used your free conversion

Unlock one more conversion for $9, or convert all year for $49 — still processed entirely in your browser. (Paid checkout opens at launch.)

Bookkeeping settings (account codes, tax, customer names)

Marketplace sales are booked under one customer per platform (not one per buyer) — that’s how bookkeepers keep QuickBooks and Xero tidy. The sales-tax line is the tax your marketplace already collected from buyers; point its Xero account code at your Sales Tax Payable liability account if you have one. Changed your mind after converting? Changing a setting re-issues your three downloads with the new values — free, and it never uses up a conversion. Settings are stored only in this browser.

Everything happens right here in your browser — your file is never uploaded, and this page even works offline. No account, no subscription, no sync to set up.

How it works

1

Export your orders. Etsy: Shop Manager → Settings → Options → Download Data. Shopify: Orders → Export. eBay: Seller Hub → Orders → Download report.

2

Drop the CSV here. The converter recognises the platform, groups multi-item orders back into one row per order, and does the discount and tax maths the same way the marketplaces report it.

3

Import the results. Paste the tracker sheet into your profit spreadsheet, or import the QuickBooks / Xero file (QuickBooks: Settings → Import data → Invoices. Xero: Business → Invoices → Import).

QuickBooks, first time only: before your first import, add three products/services named Marketplace Sales, Shipping Income and Sales Tax Collected, and point Sales Tax Collected at your Sales Tax Payable liability account — it’s tax the marketplace collected for the state, not income. Invoices import as unpaid; match them to your marketplace payout in the Banking feed. The payout is net of marketplace fees and excludes the tax the marketplace already remitted, so it won’t equal the invoice total — that’s expected.

What you get

Profit tracker sheet (.xlsx)

One row per order, pre-formatted as editable input cells for our Etsy / Shopify / eBay Profit Tracker spreadsheets — paste it in and the tracker’s own fees, profit and tax summaries calculate themselves. Works on its own in Excel or Google Sheets too.

QuickBooks Online import (.csv)

One invoice per order in QuickBooks’ own invoice-import layout: merchandise, shipping and marketplace-collected sales tax as separate lines, so your totals match the marketplace report to the cent. All orders book under one customer per platform (e.g. ‘Etsy Marketplace Sales’) — the way bookkeepers keep QuickBooks tidy. Buyer names stay in the tracker sheet.

Xero import (.csv)

The same invoices in Xero’s invoice-import layout, with your account codes and tax rate name applied. Multi-item orders stay one invoice with one merchandise line — no 400-row monsters. Dates are written DD/MM/YYYY, the format Xero’s importer expects — they will look swapped next to the QuickBooks file, which uses MM/DD/YYYY. That’s intentional.

Why not just use a sync app?

Sync apps are great if you need your books updated daily. Most small sellers don’t — they need last month (or last quarter, or the whole year at tax time) in their books, once. Those apps charge every month for that. This converter charges per conversion, runs only when you ask it to, and never sees your data: there is no server copy of your sales, because there is no server.

Pricing

$0
first conversion

Your first conversion is free — all three files, no row limit, no card required. See exactly what you get before you pay anything.

$9
per conversion

One conversion = one CSV file, any number of orders, all three downloads included. Right for quarterly bookkeeping or a one-off catch-up.

One conversion means one CSV file converted. Splitting a big export by month counts once per file; re-downloading a converted file, or re-issuing it after changing settings, is always free.

Prices in USD. Paid checkout opens at launch, handled by Paddle, our merchant of record — they take care of sales tax / VAT on the purchase itself, so the price you see is the price you pay.

FAQ

Is my sales data uploaded anywhere?

No. The conversion runs in JavaScript inside this page, on your computer. There is no upload, no server copy, and nothing to breach. You can check for yourself: load the page, disconnect from the internet, and convert — it still works.

Which files does it accept?

The standard orders export from Etsy (Shop Manager → Settings → Options → Download Data), Shopify (Orders → Export, the orders CSV) and eBay (Seller Hub → Orders → Download report). The platform is detected from the column headers automatically. If a file can’t be recognised, nothing is converted and no credit is used.

What exactly is in the QuickBooks and Xero files?

One invoice per order. Each invoice has a merchandise line (quantity × price, with the order’s discount already applied), a shipping line if the buyer paid shipping, and a separate line for the sales tax the marketplace collected — so the invoice total equals the order total on your marketplace report. Cancelled orders are excluded (they’re still in the tracker sheet, marked Cancelled). Amounts are in USD, matching the exports. Unit prices are always shown with at least two decimals. Discounts are already netted into the unit price, so the Discount column stays empty; the tax sits on its own line, so Xero’s TaxAmount column stays empty too; and InventoryItemCode is left blank — the converter doesn’t invent item codes.

What about refunds?

QuickBooks’ invoice import can’t take negative lines, so refunds are not baked into the import files: each invoice is booked at the full order amount. Your conversion summary lists every refunded order individually — e.g. “ETSY-3101007 — $31.72 refunded” — so you can record a matching refund receipt or credit memo in QuickBooks / Xero for each one. A fully refunded order then nets to zero, the way your bookkeeper would expect. Refunds are fully included in the tracker sheet.

Does it include Etsy / Shopify / eBay fees?

No — marketplace fees aren’t in the orders export, so they can’t be in the converted files. The files cover sales, shipping and marketplace-collected tax. Book marketplace fees from your payment-account statement as one monthly expense — or use the tracker sheet with one of our Profit Tracker spreadsheets, which calculates fees per order.

QuickBooks says my file is too big. What now?

QuickBooks Online imports at most 100 invoices (1,000 rows) per file. If your export covers more, split it by month at export time — the converter warns you when a converted file passes the limit. Xero has no equivalent per-file cap at these sizes.

Do the account codes and tax names have to match my books?

Yes — Xero imports need account codes and tax rate names that exist in your Xero organisation, and QuickBooks will ask you to map the item tax code on its import screen. Open “Bookkeeping settings” above the converter and set them to yours before converting; the defaults are the ones most small US sellers start with.

What should I set up in QuickBooks before my first import?

Add three products/services named Marketplace Sales, Shipping Income and Sales Tax Collected — the import file uses exactly those item names. Point Sales Tax Collected at your Sales Tax Payable liability account: it’s tax the marketplace collected from buyers and (in most states) already remitted, not income. Invoices import as unpaid; match them to your marketplace payout in the Banking feed. The payout is net of marketplace fees and excludes that remitted tax, so it won’t equal the invoice total — that’s expected.

Does it work with the Profit Tracker spreadsheets?

Yes — the .xlsx is the same ready-to-paste format the Etsy, Shopify and eBay Profit Tracker spreadsheets (sold in our Etsy shop, KurayaStudio) are built around, including the unlocked yellow input cells, so pasting can’t lock your sheet.

Which currencies are supported?

The marketplace exports are converted in USD, the currency Etsy, Shopify and eBay use for these reports. If your shop exports in another currency, the amounts still convert number-for-number — just don’t mix currencies in one QuickBooks / Xero import.

How is my annual pass remembered?

There’s no account — your pass (and any single-conversion credits) are stored in this browser, on this device. If you switch browsers or clear site data, message us through our Etsy shop, KurayaStudio, with your Paddle receipt and we’ll restore it.

Can I import the same period twice?

Invoice numbers keep your marketplace order numbers (e.g. ETSY-3101001), so duplicates are easy to spot in QuickBooks / Xero. Before importing, check the period isn’t already in your books — importing the same file twice would double-count those sales.

Checkout isn’t open yet

Payments open at launch. Your free conversion is unaffected — and if you’ve already converted, your files are yours to keep.