Settled for bookkeepers
You keep the books for a store on Shopify Payments. The bank shows one deposit per payout, the sales report shows orders, and the two never agree on their own. Settled turns each payout into a line-by-line breakdown and gives your client files you can import or open in a spreadsheet.
Who it is for
- Bookkeepers and accountants who handle the books of Shopify Payments merchants.
- Merchants who want to hand their bookkeeper something better than a screenshot of the Shopify dashboard.
Your client installs Settled. You get the files. Settled has no separate bookkeeper login, so you work from what the merchant sends you.
What you get
Every payout opens into sales, fees, refunds, adjustments and reserves, line by line, each matched to an order number. The gap between gross sales and the deposit is spelled out. Settled reads the data Shopify already holds and never changes the store.
The Export screen offers five formats, for a year or any date range:
| Format | What is in it | Good for |
|---|---|---|
| CSV | One row per balance transaction: payout date, order number, gross sale, fee, refund, adjustment, chargeback, net, currency, type, processed time. | Spreadsheets and pivot tables |
| XLSX | A Summary sheet (totals by currency and the payout list) and a Detail sheet with the same rows as the CSV. | A year-end pack |
| Totals for the period and a payout list with date, currency, status, gross, fees and net. | Files, lenders, a quick read | |
| QuickBooks file | One block per settled payout: the net deposit on the Bank line, with sales, fees, refunds and held funds as the other lines. The lines add up. | Importing into QuickBooks Online |
| Xero file | A bank transactions CSV with one row per settled payout: date, net amount, payee, description, reference. | Importing into Xero |
Orders show an order number only, never customer details. Every file carries a line saying Settled formats and explains data Shopify already provides and is not tax or legal advice. Settled does not push anything into QuickBooks or Xero. You import the file yourself, so nothing changes in your client's books until you do it.
How the merchant shares it
- The merchant opens Export in Settled.
- They pick a year under End-of-year export, or a From and To date under Custom date range.
- They click the format you asked for (CSV, XLSX, PDF, QuickBooks or Xero).
- They send you the downloaded file by email or shared folder.
Exports are on the Growth plan ($39/month) and Scale ($79/month). Every plan starts with a 14-day free trial, no card required. Scale covers up to 3 stores with a store switcher, for clients who run more than one.
Tell your client the file you want and the period. A monthly request for the QuickBooks or Xero file is enough for most clients.
Sample files
These three files were produced by Settled's own export code from made-up fixture data. They contain no real merchant data. Open them to see the columns before you ask a client for one.
- settled-sample-payouts.csv: the CSV export, one row per balance transaction.
- settled-sample-quickbooks.csv: the QuickBooks file for two payouts.
- settled-sample-xero-bank.csv: the Xero bank transactions file for the same two payouts.
The second payout in the samples has a held amount, so you can see how a reserve appears in each format.
Guides for bookkeepers
- Shopify Payments activity report for bookkeepers: access, the three exports, booking per payout and importing into QuickBooks or Xero.
- Why is my Shopify payout less than my sales?
- How to reconcile PayPal and Shopify
- Reconciliation checklist
Ask your client to try it
Send your client to the Shopify App Store and ask them to search for Settled Payouts. They can see their next payout date, open any deposit and export the file you need.
14-day free trial, no card required. Plans: Starter $19, Growth $39, Scale $79 per month.
Search Settled Payouts on the App Store