Which Shopify export should I use?

For a Shopify Payments balance account in your books, the transactions export from Finances, Payouts. For one journal entry per payout, the payouts export, which has a page of its own here.

What about rows that are still pending?

Rows whose payout status is not paid have not reached your bank yet. They are included in the account, and the notes say how many are still pending.

Why is my Shopify payout smaller than my sales?

Shopify Payments takes its fees and any refunds, adjustments and reserved funds before it pays out. The payouts export lists each, and the journal entry gives each its own line, so the payout total matches the deposit.

What happens to failed payouts?

The sales, refunds and fees inside a failed payout are still recorded, but no money reached your bank, so the journal keeps that amount in the clearing account. When a later payout shows it as a Retried Amount, it comes out of the clearing account again instead of being counted as income twice. Scheduled and in-transit payouts are left out until they are paid.

Shopify Payments CSV converter

Shopify Payments' transactions export lists every charge, refund and adjustment with Amount, Fee and Net in the payout currency, the payout status, and the payout date that settled it. Shopify Payments' payouts export has one row per payout: charges, refunds, adjustments, reserved funds, fees and the total sent to your bank.

Convert a Shopify Payments export

Any supported export

Choose file

A CSV export from Venmo, Cash App, PayPal, Stripe, Square, Shopify, Wise, Etsy, Airbnb, Gumroad or your bank, or an MT940 or camt.053 bank statement. The source is detected automatically.

Your file stays on this device

It is read and converted by this page, inside your browser. Nothing from the file is uploaded, and the converter keeps working offline once the page has loaded.

Choose where it is going

Shopify Payments transactions CSV

Shopify Payments' transactions export lists every charge, refund and adjustment with Amount, Fee and Net in the payout currency, the payout status, and the payout date that settled it.

How to export it

In Shopify admin open Finances, then Payouts.
Open View transactions (or a single payout) and choose the dates.
Click Export and download the CSV.
Upload the file here.

What to know about this file

Columns: Transaction Date, Type, Order, Card Brand, Card Source, Payout Status, Payout Date, Available On, Amount, Fee, Net; newer files add Currency, Presentment Amount and more.
Amount is in the payout currency, Fee is positive and Net is Amount minus Fee.
Transaction Date carries the store time zone offset; the store's own date is used.
Rows marked pending have not been paid out yet.
Each payout is identified by its payout date (or Payout ID when the file has one).

Shopify Payments payouts CSV

Shopify Payments' payouts export has one row per payout: charges, refunds, adjustments, reserved funds, fees and the total sent to your bank.

How to export it

In Shopify admin open Finances, then Payouts.
Choose the dates and click Export.
Upload the downloaded CSV here.

What to know about this file

One row per payout with Charges, Refunds, Adjustments, Reserved Funds, Fees, Retried Amount and Total.
Each paid payout becomes its parts plus the payout itself, so the Shopify balance nets to zero for every payout.
A failed payout's sales, refunds and fees are kept and stay in the Shopify balance; a later Retried Amount is paid out of that balance, not booked as income. Scheduled and in-transit payouts are left out.
A row whose columns do not add up to its Total is left out with a note.

Questions

Which Shopify export should I use?: For a Shopify Payments balance account in your books, the transactions export from Finances, Payouts. For one journal entry per payout, the payouts export, which has a page of its own here.
What about rows that are still pending?: Rows whose payout status is not paid have not reached your bank yet. They are included in the account, and the notes say how many are still pending.
Why is my Shopify payout smaller than my sales?: Shopify Payments takes its fees and any refunds, adjustments and reserved funds before it pays out. The payouts export lists each, and the journal entry gives each its own line, so the payout total matches the deposit.
What happens to failed payouts?: The sales, refunds and fees inside a failed payout are still recorded, but no money reached your bank, so the journal keeps that amount in the clearing account. When a later payout shows it as a Retried Amount, it comes out of the clearing account again instead of being counted as income twice. Scheduled and in-transit payouts are left out until they are paid.