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
| Export | Where | Use it for |
|---|---|---|
| Payouts | Finances → Payouts | One row per payout: date, status, amount. Matches the bank feed. |
| Payout transactions | Inside a payout, or for a date range | The lines behind each payout: charges, fees, refunds, adjustments, reserves. |
| Orders | Orders → Export | The 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.
QuickBooks Online: importing a file and matching the bank feed
- 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.
- 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.
- Upload the CSV and review the preview.
- 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
- In Xero, open the bank account that represents Shopify Payments deposits. Ask the client's accountant which account to use.
- Choose Import a statement and upload the CSV.
- Xero maps by column position, so the file keeps Date and Amount first, then payee, description and reference.
- 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
- Export payouts and payout transactions for the month.
- Check that payout totals add up to the net deposits in the bank feed.
- List reserve and release lines and update the held total.
- Check refunds and chargebacks against the right payout.
- Import or book per payout, then match the bank feed.
- Note open items and carry them into next month.
- 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