Settled
Features How it works Pricing FAQ For bookkeepers
Install on Shopify

Settled › Guides

Shopify Payments activity report for bookkeepers

Updated November 3, 2026

You keep the books for a Shopify store and the bank feed shows one deposit per payout while the sales report shows orders. This guide covers how to get access without the owner's login, which exports to ask for, how to book per payout and how to import a file into QuickBooks or Xero.

Get access the right way

Do not ask for the owner's login. Shopify offers two cleaner routes:

  • A staff account. The owner adds you under Settings → Users and permissions and limits the permissions to finances and reports. Shopify's permission names change, so choose the ones that cover payouts and reports.
  • A collaborator request. If you are a Shopify Partner, you can send a collaborator request, and the owner approves it with the same permission choices.

Either way you work under your own name, and the owner can remove you without changing a password.

The three exports and what each is for

ExportWhereUse it for
PayoutsFinances → PayoutsOne row per payout: date, status, amount. Matches the bank feed.
Payout transactionsInside a payout, or for a date rangeThe lines behind each payout: charges, fees, refunds, adjustments, reserves.
OrdersOrders → ExportThe sales side: order totals, dates and payment method.

Ask for the first two every month. Ask for orders only when you need to trace a line.

Book per payout, not per order

The bank shows one net deposit per payout. If you book every order, you have to rebuild that deposit from hundreds of lines. Book per payout instead: one net deposit, with the pieces as separate lines.

  • Sales, as the gross amount for the payout.
  • Processing fees, as an expense.
  • Refunds, as a reduction in sales.
  • Chargebacks and adjustments, on their own lines.
  • Reserves, as held funds that come back later.

The lines add up to the net deposit, so the bank feed can be matched in one click. Which accounts you use for each line is your call and your client's accountant's.

Review queue listing PayPal and Stripe rows that are not yet tied to a Shopify deposit
The Review queue lists rows that are not yet tied to a Shopify deposit.

QuickBooks Online: importing a file and matching the bank feed

  1. Make sure the accounts the file uses exist in QuickBooks. Settled's QuickBooks file uses Bank, Sales, Payment processing fees, Refunds, Payment adjustments and Funds held by processor. Rename them in the file or map them during import if yours differ.
  2. Go to Settings → Import data and choose the import type that accepts this kind of file. QuickBooks' own help lists the steps and template columns for your version.
  3. Upload the CSV and review the preview.
  4. Open the imported items and match the bank-feed deposit against the Bank line. The amount equals the net payout.

Import one month first and check the totals before you do a year.

Xero: importing a bank transactions CSV

  1. In Xero, open the bank account that represents Shopify Payments deposits. Ask the client's accountant which account to use.
  2. Choose Import a statement and upload the CSV.
  3. Xero maps by column position, so the file keeps Date and Amount first, then payee, description and reference.
  4. Check the preview, import, then reconcile against the bank feed.

Settled's Xero file has one row per settled payout, with the net amount, the payee Shopify Payments, and the payout reference. See the sample files on the Settled for bookkeepers page.

Multi-store clients

If a client has several stores, add a Store column to your working sheet and stack each store's payout export under one header row. Stores can pay out on different days, so check each store's calendar before you assume a missing deposit is an error. Filter by store to match the bank feed.

Month-end checklist for a Shopify client

  1. Export payouts and payout transactions for the month.
  2. Check that payout totals add up to the net deposits in the bank feed.
  3. List reserve and release lines and update the held total.
  4. Check refunds and chargebacks against the right payout.
  5. Import or book per payout, then match the bank feed.
  6. Note open items and carry them into next month.
  7. Send the client a one-line summary of anything unusual.

The Reconciliation checklist has the same steps in more detail.

Skip the manual sum

Settled Payouts builds the QuickBooks or Xero file for a year or a date range from the same payout data, and exports CSV, XLSX and PDF too. Files only: Settled never pushes anything into QuickBooks or Xero. Sample files are on the bookkeepers page.

Accounting exports are on Growth ($39/month) and Scale. 14-day free trial, no card required. Plans: Starter $19, Growth $39, Scale $79 per month.

Search Settled Payouts on the App Store

Keep reading

  • Settled for bookkeepers
  • How to reconcile PayPal and Shopify
  • Reconciliation checklist
Settled formats and explains data Shopify already provides — it is not tax or legal advice. Menu names in Shopify, PayPal, QuickBooks and Xero change over time; if a label differs, look for the closest match. Ask your accountant how to treat any amount in your books.
Settled

Payout dates, hold explanations, and reconciliation for Shopify Payments merchants.

Product

  • Features
  • Pricing
  • Sample payout
  • FAQ

Resources

  • Payout timing guide
  • Reserve & hold glossary
  • Reconciliation checklist
  • Help center
  • For bookkeepers
  • Guides

Company

  • About
  • Contact
  • Privacy
  • Terms
  • Buy me a coffee
© 2026 Settled. All rights reserved. Built for Shopify merchants · Not affiliated with Shopify Inc.