Orders5 min read

Split Adjustments Out of Your Shopify Payout Export

Filter Shopify payout transactions to Adjustment rows, total them per payout and match each one to your own records, so the Adjustments line stops being a mystery.

In this guide
  1. Why does my Shopify payout show a line called Adjustments?
  2. Which export shows each adjustment on its own row?
  3. How do I split Adjustments out step by step?
  4. How do I book the split for my accountant?
  5. Things to check before you rely on the split
  6. FAQ
  7. Try Columna: Order Export & Sheets

To split Adjustments out of a Shopify payout, export the payout transactions for the period (one row per charge, refund, dispute and adjustment, with the order, fee and net on each row), filter the Type column to Adjustment, and total Net per Payout ID. That gives you every adjustment on its own line instead of one lump on the payout. The export does not say what each adjustment is for, so the last step is matching those rows to your own records, such as the repayment history of a Shopify Capital offer.

This guide is for shop owners and bookkeepers who reconcile Shopify Payments payouts every month and find a line called Adjustments that they cannot explain from the orders. It describes how to filter the columns; it does not turn the export into a Capital statement.

Why does my Shopify payout show a line called Adjustments?

A Shopify Payments payout is a net amount. Shopify starts from the payments customers made, then subtracts refunds, fees, disputes, reserves and any adjustments before it sends the rest to your bank. On the payout summary, everything that is not a sale, a refund or a fee is grouped into a few totals, and Adjustments is one of them.

Merchants with a Shopify Capital offer often notice it first, because repayments can be taken from their payouts and shown under that grouped line. Other money can land in the same place, so the total alone does not tell you what happened.

Which export shows each adjustment on its own row?

There are two levels of payout data, and only one of them has the detail you need:

Export One row per What you see for adjustments
Payouts Payout, which is one bank deposit or withdrawal One Adjustments total, added up with disputes
Payout transactions Charge, refund, dispute or adjustment Each adjustment as its own row, with Amount, Fee and Net

You can export payout transactions from Finance > Payouts in Shopify admin, as described in Shopify’s payout details guide; the CSV is emailed to you. In Columna: Order Export & Sheets, the same data is the Payout transactions preset on the Accounting tab of Templates, downloaded straight as CSV or Excel.

How do I split Adjustments out step by step?

  1. Export Payout transactions for the month you are closing. In Columna the date range selects transactions by the date of the payout they were paid in, so the file describes the same money as that month’s payouts. Transactions not paid out yet, transfers and test transactions are left out.
  2. Open the file in a spreadsheet and turn on filters for the header row.
  3. Filter Type to Adjustment only. Disputes have their own type, so they drop out here even though the payout summary counts them with adjustments.
  4. Add a pivot table on Payout ID with the sum of Net for the filtered rows. Each payout now has its own adjustment total.
  5. Check each total against the Adjustments figure for the same payout. If you also export the Shopify Payments payouts preset, remember its Adjustments column includes disputes: add the Dispute rows of that payout before you compare.
  6. Sort the Adjustment rows by Order. Rows with an order number belong to that order, so look them up on the order first. Rows without one are not linked to any order.
  7. Match the remaining rows to your own records. For a Capital offer, compare them with the repayment history Shopify shows for that offer, by date and amount, and label the ones that agree.

How do I book the split for my accountant?

Once the rows are labelled, give your accountant one small table per month instead of the raw file:

Payout ID Payout date Adjustment net Your label
Capital repayment
Other adjustment, order linked
Other adjustment, no order

The label column is yours: it comes from your matching in step 7, not from the export. Keep the filtered transactions file with it, so every number can be traced back to a row. Agree with your accountant how repayments are booked; that is a bookkeeping decision, not something the export decides.

For the rest of the payout, our guide to matching Shopify Payments payouts to bank deposits covers every column of both files, and the Shopify month-end close walkthrough ties the payouts back to your orders.

Things to check before you rely on the split

  • Use the same date range and time zone for the transactions file and any payouts file you compare it with.
  • In Columna, the Payout date is blank when that payout was issued outside the date range. Widen the range if a payout looks incomplete.
  • The Order column is the Shopify order name, such as #1042, not an invoice number from an invoicing app.
  • The payout reports need Shopify Payments. In Columna they are greyed out with the reason on stores that do not use it, and the first export asks you to allow read-only payout access once.
  • These files are worksheets, not bookkeeping entries. Compare the totals with Shopify’s own finance reports before you close the month.

FAQ

Why does my Shopify payout say Adjustments and not Capital?

The payout summary groups money that is not a sale, refund or fee into a few totals. Adjustments is one of them, so several kinds of money can sit under the same label.

Can I see each adjustment separately?

Yes. Export the payout transactions for the period and filter the Type column to Adjustment. Every adjustment is then its own row with its amount, fee, net and payout.

Does the payout transactions export tell me which rows are Capital repayments?

No. It shows the type, amount, payout and order, but not the reason. Match the rows to your Capital repayment history by date and amount to label them.

Why doesn’t my Adjustment total match the payout’s Adjustments figure?

The payouts summary counts disputes together with adjustments. Add the Dispute rows of that payout to your Adjustment rows, and check that both files cover the same dates.

Try Columna: Order Export & Sheets

Columna: Order Export & Sheets exports Shopify orders to CSV or XLSX with line-item properties such as engraving text, gift messages and upload links, processed in your browser, for shops that hand orders to production, fulfilment or accounting. Its Accounting templates give you the payouts and payout transactions files for the month, ready to filter. Try Columna: Order Export & Sheets on the Shopify App Store.