Export Shopify Payouts and Balance Transactions to CSV or Excel

Mixtable can load your Shopify Payments payouts, and the balance transactions behind them, into a spreadsheet. You can see what each payout to your bank was made of, tie fees back to orders, and export everything to CSV or Excel for your bookkeeper or accounting software.

There are two worksheets to choose from:

A Payouts worksheet has one row for each Shopify Payments payout to your bank
A Balance Transactions worksheet has one row for each charge, refund, fee, or adjustment that adds up to your payouts

Both worksheets show data from Shopify Payments and are read-only. You can sort, filter, and export them, but Mixtable doesn’t change payouts or transactions in Shopify. If your store takes payments only through other payment providers, Shopify has no payouts for Mixtable to load.

Create a Payouts worksheet

If you don’t have a Mixtable spreadsheet yet, open your Mixtable dashboard, click Create spreadsheet (or Browse all templates on your first visit), and choose Blank Excel-like Spreadsheet under Start From Scratch. Then add the worksheet:

Click the + button at the end of the worksheet tabs, at the bottom of the screen
Select Shopify data worksheet, then click Continue. If you have more than one Shopify store connected, choose the store here too
Under Orders & Finance, click Payouts
On Choose your columns, pick the fields you want and click Continue. Mixtable starts you with Payout ID, Payout Status, and Net Amount, so add Issued At to see when each payout was sent, plus any of the fee fields described below
Choose Load everything, or choose Only rows that match rules to load only some payouts, such as payouts with a status of paid
Click Create Worksheet

Mixtable adds one row for each payout.

Get the latest payouts

Shopify doesn't send changes to payouts on its own, so download them when you need the latest. Click Download latest in the sync control at the top right of the spreadsheet (or choose Shopify Sync > Sync with Shopify…) to open the sync card. Under Download latest from Shopify, click Download next to Payouts.

Do this before you export, so your file includes payouts Shopify has issued recently.

What’s in a Payouts worksheet

Each payout row can show:

Payout ID, Issued At, and Payout Status, which tells you whether the payout is scheduled, paid, failed, or canceled
Net Amount and Net Currency Code: the amount sent to your bank, after fees
Transaction Type: whether the payout is a deposit to your bank or a withdrawal from it
Company Name, Display Name, Business Entity ID, and Primary: the business that received the payout, which helps if your store sells through more than one business

A payout also has a breakdown of what it’s made of. For each part, there’s a gross amount and a fee amount, each with its own currency code column:

Charges Gross Amount and Charges Fee Amount: customer payments
Refunds Fee Gross Amount and Refunds Fee Amount: refunds to customers
Adjustments Gross Amount and Adjustment Fee Amount: adjustments Shopify made to your balance
Reserved Funds Gross Amount and Reserved Funds Fee Amount: money Shopify held back or released
Retried Payouts Gross Amount and Retried Payouts Fee Amount: earlier payouts that failed and were sent again
Advance Gross Amount and Advance Fees Amount: advances included in the payout

Add a Balance Transactions worksheet

Balance transactions are the individual entries in your Shopify Payments balance. Use them when a payout total isn’t enough and you need to see which charges, refunds, and fees went into it.

Create the worksheet the same way as a Payouts worksheet, but click Balance Transactions under Orders & Finance. Mixtable starts you with Transaction ID and Amount. For most reconciliation work, also add:

Transaction Date and Transaction Type (such as a charge, refund, dispute, or adjustment)
Fee Amount and Net Amount: what Shopify Payments charged on the transaction, and what was left after the fee
Associated Order Name: the Shopify order the transaction came from, such as #1001
Associated Payout ID and Associated Payout Status: the payout the transaction is part of

Other available fields include the currency code for each amount, Associated Order ID, Source Type, Source ID, Source Order Transaction ID, Adjustment Reason, and Test Transaction, which shows whether the transaction was made in test mode.

Payouts and balance transactions download separately. On a Balance Transactions worksheet, click Download latest in the sync control and then Download next to Balance transactions to bring in recent transactions.

Match transactions to a payout

With a Payouts worksheet and a Balance Transactions worksheet in the same spreadsheet, you can trace a deposit in your bank account back to the orders behind it:

On the Payouts worksheet, find the payout and copy its Payout ID
On the Balance Transactions worksheet, filter the Associated Payout ID column for that ID
Review the remaining rows: every charge, refund, fee, and adjustment in that payout, each with its Associated Order Name

To see what Shopify Payments charged you on a payout, add up the Fee Amount column for those rows. You can also look up each order in an Orders worksheet when you need its customer or line items.

To see a single payout’s breakdown without adding all the summary columns, select a cell in its row and click Details at the right end of the toolbar. The Details panel lists what the payout is made of, with the amount and fees for charges, refunds, adjustments, and its other parts. For a balance transaction, Details shows its order and payout, and for an adjustment, the orders it adjusted.

Export payouts to CSV

Open the Payouts or Balance Transactions worksheet you want to export
Click Import & Export in the menu bar
Select Export to CSV
Save the downloaded .csv file

CSV export includes the current worksheet only, which suits most accounting imports.

Export the full spreadsheet to Excel

Click Import & Export in the menu bar
Select Export to Excel
Save the downloaded .xlsx file

Excel export includes the entire spreadsheet, with every worksheet. This is handy for keeping payouts and their balance transactions together in one file, each on its own sheet. Remove any worksheets you don’t want to share first.

Payouts and sales numbers are different

A payout is cash Shopify Payments sent to your bank, after fees, refunds, and adjustments. It covers only payments processed by Shopify Payments, and it can include money from orders placed on different days. Sales figures, such as Total Sales or Net Sales, describe what customers bought.

That’s why your payouts and your sales reports rarely match exactly. Use payouts and balance transactions for bank reconciliation, and use refund exports or sales analytics when you’re looking at what was sold and returned.

Troubleshooting

Why is my Payouts worksheet empty?

Your store may not use Shopify Payments, or it may not have received a payout yet. If your store does have payouts, click Download latest in the sync control, then Download next to Payouts, to bring them in.

Why are some amount columns blank?

Click Download latest in the sync control, then Download next to Payouts. This refreshes every payout Mixtable has saved and fills in fields that came through empty in an earlier download.

Can I edit a payout in Mixtable?

No. Payouts and balance transactions are records of money Shopify Payments has already moved, so they’re read-only in Mixtable and in Shopify.