How do I export payouts or a sales journal for my accountant?
On this page
Four presets on the Accounting tab of Templates build accounting files without setting up columns:
- Shopify Payments payouts: one row per payout, to match each deposit on your bank statement.
- Payout transactions: one row per charge, refund and adjustment inside your payouts, with the order it belongs to.
- Belgian sales journal: sales and credit notes by date, with the net amount per Belgian VAT rate.
- French sales journal (journal des ventes): the same, with French column names and French VAT rates.
These files are worksheets for you or your accountant. They are not filed returns. Before you file, compare the totals with Shopify’s own reports.
Export a report
- Open Templates in the app, then the Accounting tab.
- On the report you want, click Export report. The Orders page opens with the report selected.
- Set the date range: the month or quarter your accountant asks for.
- Click Export, choose CSV or Excel, and click Export again.
Everything is read and laid out in your browser. Nothing is stored by the app.
Payout reports need Shopify Payments
The two payout reports read your Shopify Payments payouts. The first time you use one, the button says Allow payout access. Click it and Shopify asks you to allow read-only access to your Shopify Payments account and payouts. You only do this once.
If your store does not use Shopify Payments, the payout reports are greyed out with the reason. The sales journals work with every payment provider.
Shopify Payments payouts
The date range selects payouts by the date they were issued. Order filters (status, tags, search) do not apply.
| Column | Meaning |
|---|---|
| Payout date | The day the payout was issued, in your store’s time zone. |
| Payout ID | The payout number shown in Shopify admin. |
| Status | Scheduled, In transit, Paid, Failed or Canceled. |
| Type | Deposit (to your bank) or Withdrawal (from your bank). |
| Bank reference | The trace reference from your bank, when Shopify has it. |
| Gross charges | Payments received from customers. |
| Refunds | Refunds paid back to customers, as a negative amount. |
| Adjustments | Adjustments and disputes. |
| Reserves and other | Reserved funds, retried payouts, advances and rebate credits. |
| Fees | Every fee Shopify took from the payout, added up. |
| Net | The amount Shopify sent to your bank. |
| Currency | The payout currency. |
Payout transactions
The date range selects transactions by the date of the payout they were paid in. Transactions not paid out yet, transfers and test transactions are left out.
| Column | Meaning |
|---|---|
| Transaction date | When the transaction happened. |
| Type | Charge, Refund, Adjustment, Dispute and so on. |
| Order | The order number, when the transaction belongs to an order. |
| Payout date | The issue date of its payout. It is blank when that payout was issued outside the date range. |
| Payout ID / Payout status | The payout the transaction was paid in. |
| Amount / Fee / Net | The transaction amount, Shopify’s fee, and what is left. |
| Currency | The transaction currency. |
Sales journals
The date range selects orders placed in the period and refunds made in the period. A refund of an older order appears on the day it was made. Amounts are in your store currency.
| Belgian journal | French journal | Meaning |
|---|---|---|
| Date | Date | The day the order was placed or the refund made, in your store’s time zone. |
| Order number | N° de pièce | The order number, such as #1001. |
| Type | Type | Sale or Credit note (Vente or Avoir). |
| Net 21%, Net 12%, Net 6%, Net 0% | HT 20 %, HT 10 %, HT 5,5 %, HT 2,1 %, HT 0 % | Amount without VAT at each rate, after discounts. Shipping is counted at the rate charged on it. |
| VAT | TVA | VAT charged, or refunded as a negative amount. |
| Gross | TTC | Net amounts plus VAT. |
| Currency | Devise | Your store currency. |
When an order was taxed at another rate (for example an EU OSS sale at 19%), the journal adds a column for that rate.
Left out of the journals: test orders, orders whose payment was voided or expired, and gift card sales. Tax-exempt orders (such as B2B reverse charge) appear at 0%.
Limits to check by hand
- The order number is the Shopify order name, not an invoice number from an invoicing app.
- Refunds that are not linked to an item or to shipping (for example a goodwill amount) are not in the journals.
- Each order reads up to 5 refunds with up to 10 refunded items each.
- The Paid at column you can add to any template is when the first successful sale or capture was processed, in your store’s time zone, read from the order’s first 10 transactions. It is blank for unpaid orders and orders that are only authorized; a later refund does not change it.
- Payout amounts are shown as Shopify reports them. Shopify Payments does not include VAT per payout.
Troubleshooting
- “Allow access to your Shopify Payments payouts first”: open Templates > Accounting and click Allow payout access on a payout report.
- “Your store does not use Shopify Payments”: there are no payouts to export. Use a sales journal, or your payment provider’s own statements.
- “Payout reports cover a date range, not selected orders”: you opened the Orders page with orders selected. Clear the selection, set the dates and export again.
- The report is empty: check that the date range covers the period. For a sales journal, also check that the order filters (payment status, tags, search) do not hide the orders.