You can export Shopify Payouts with Transactions to Excel or CSV format.
Export all of the payouts, or filter them by date intervals.
Export all payouts or apply the date filters:
- Relative Date – for x last full minutes, hours, days, months
- Date Interval – from date to date
Filter by relative date:
To filter for x last full days or months.
The full day means that it will not export for today because it’s not yet ended.
Filter by date interval:
For the date interval, you can set the dates in the past and in the future.
That’s because Shopify actually generates the transactions for the future which are in pending status. But you can already see what the amounts are.
For example, to set up the repeated Payouts export for the whole year, you can set the date range from Jan 1 till Dec 31.
Automated Shopify Payouts Report
You can become creative and make the repeated export which is used in the Excel or Google Sheets reports by automatically loading it from the exported URL.
You can also send that exported file to FTP/SFTP server each time it exports.
This example shows you how to create automatic Payouts report on Google Sheets.
1. Select export Payouts without filters
Select whether you want to include Transactions for your payouts.
Don’t apply any filters if you want the full payouts history to be visible on your Google Sheets report. Or you can apply the date filter if you want to limit it in certain timeframe.
2. Set the Export Options to schedule the repeated export to the same CSV file every day
- Select the “Schedule export on” and set the time when do you want the export to start every day. The time is in your shop time zone.
- Select “Repeat every” and choose it to run every day.
- Set the “Custom file name” so that each time the export runs, it generates the data in the same URL.
- Uncheck the “Zip CSV files” checkbox so that the export is not zipped.
- Choose the format to be “Excelify: CSV” to generate export as a CSV file to be imported into Google Sheets automatically.
3. Press “Schedule Export”
After pressing “Schedule Export“, wait a couple of minutes because your first scheduled export for today will run automatically.
Then go to “History & Schedule” and find the finished export to “payouts”. If it’s not yet finished, refresh the page – it should be done within 1-2 minutes depending on how large are your payouts.
You should see the history like this:
The top row is the next scheduled export at midnight.
And after that is the OK export which got just finished now.
In the Files column, right-click on the “payouts.csv” file and press “Copy link address”.
4. Use this link in the Google Sheets =IMPORTDATA formula
The link will be something like this:
So the formula in your Google Sheets will look like this:
Your Google Sheet will be like:
Notice that the ID is repeating for each Transaction row, and the Amount is filled only for the first row of that payout.
That’s important so that you can sum the Amount column in Pivot tables, and at the same time be able to see what transactions make up that Payout.
5. Make the Pivot Table
Here you can knock yourself out by using this data in Pivot Table to make whatever report you need.
For example, here is how you can make the aggregated payouts by month:
Good to know
- If you already had Excelify installed, next time when you launch the Excelify app, it will ask you to confirm the changes in permissions because to export Payouts, the app needs access to this data.
- If your Date and Month columns don’t show as a proper date but as some number, you should change the format of that column to display as Date.
Google Sheets menu: Format -> Number -> Date
- See the detailed documentation of each Payouts columns.