--- title: payouts description: >- Reference for the ShopifyQL `payouts` table. Every metric and dimension, paired with worked example queries. api_version: 2026-07 source_url: html: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/payouts md: >- https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/payouts.md api_name: shopifyql --- # payouts The `payouts` [schema](https://shopify.dev/docs/api/shopifyql/latest/schemas) reports on the deposits Shopify sends you, not the individual transactions inside them. Use it to build payout timelines and summarize payouts by currency. ### Use cases * **Payout timeline**: Group [`payout_amount`](#payoutsmetric-propertydetail-payoutamount) by week or month to see how much Shopify deposited and when. * **Currency view**: Compare [`payout_amount`](#payoutsmetric-propertydetail-payoutamount) with [`payout_amount_in_payout_currency`](#payoutsmetric-propertydetail-payoutamountinpayoutcurrency) by [`payout_currency`](#payoutsdimension-propertydetail-payoutcurrency) to reconcile deposits across the currencies you settle in. Examples ### Examples * #### ##### Description Compare cumulative \`payout\_amount\` by month for the year to date against last year. This example uses \[\`CUMULATIVE\_VALUES\`]\(/docs/api/shopifyql/latest/syntax/with#cumulative-values) for a running total, with \[\`WITH PERCENT\_CHANGE\`]\(/docs/api/shopifyql/latest/syntax/with#percent-change-columns) and \[\`COMPARE TO previous\_year\`]\(/docs/api/shopifyql/latest/syntax/compare-to) adding the year-over-year change column. ##### ShopifyQL ```shopifyql FROM payouts SHOW payout_amount, payout_amount_in_payout_currency TIMESERIES month WITH CUMULATIVE_VALUES, TOTALS, PERCENT_CHANGE DURING this_year COMPARE TO previous_year ORDER BY month ASC VISUALIZE payout_amount TYPE line ``` * #### ##### Description Split last quarter's \`payout\_amount\` by currency. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add the combined all-currency total to every row. ##### ShopifyQL ```shopifyql FROM payouts SHOW payout_amount, payout_amount_in_payout_currency GROUP BY payout_currency WITH TOTALS DURING last_quarter ORDER BY payout_amount DESC VISUALIZE payout_amount TYPE donut ``` * #### ##### Description Track your weekly payout totals last quarter in both your store currency and the currency each payout settled in. This example uses \[\`WITH TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#total-columns) to add a last-quarter total beside the weekly rows. ##### ShopifyQL ```shopifyql FROM payouts SHOW payout_amount, payout_amount_in_payout_currency TIMESERIES week WITH TOTALS DURING last_quarter ORDER BY week ASC VISUALIZE payout_amount TYPE line ``` * #### ##### Description Track weekly \`payout\_amount\` split by \`payout\_currency\` across last quarter. This example uses \[\`GROUP\_TOTALS\`]\(/docs/api/shopifyql/latest/syntax/with#group-total-columns) to add a per-week total across currencies beside the per-currency bands. ##### ShopifyQL ```shopifyql FROM payouts SHOW payout_amount GROUP BY payout_currency WITH TOTALS, GROUP_TOTALS TIMESERIES week DURING last_quarter ORDER BY week ASC VISUALIZE payout_amount TYPE stacked_bar ``` *** ## Metrics Counts and calculations that let you track key business indicators. Metrics show up as the columns when queried. Metrics you can use when querying `FROM payouts`. * **payout\_​amount** **MONEY** The value of payouts issued to your store, reported in your store's currency. * **payout\_​amount\_​in\_​payout\_​currency** **MONEY** The value of payouts in the currency specified by [`payout_currency`](#payoutsdimension-propertydetail-payoutcurrency). ### MONEY A monetary amount representing currency values such as prices, revenue, costs, and discounts. ```ts ``` *** ## Dimensions Attributes of your data that let you look more granularly at aspects of the data. Group and filter by dimensions to shape the rows your query returns. Dimensions you can use when querying `FROM payouts`. * **day** **DAY\_TIMESTAMP** The day a payout was issued. * **day\_​of\_​week** **DAY\_OF\_WEEK** The day of the week a payout was issued, with values Monday through Sunday. * **hour** **HOUR\_TIMESTAMP** The hour a payout was issued. * **hour\_​of\_​day** **HOUR\_OF\_DAY** The hour of the day when the payout was issued, with values 0 through 23. * **minute** **MINUTE\_TIMESTAMP** The minute a payout was issued. * **month** **MONTH\_TIMESTAMP** The month a payout was issued. * **month\_​of\_​year** **MONTH\_OF\_YEAR** The month of the year when the payout was issued, with values 1 through 12. * **payout\_​currency** **STRING** Currency the payout was issued in * **quarter** **QUARTER\_TIMESTAMP** The quarter a payout was issued. * **second** **SECOND\_TIMESTAMP** The second a payout was issued. * **shop\_​id** **IDENTITY** The unique Shopify identifier for your store. Use [`shop_id`](#payoutsdimension-propertydetail-shopid) with [`shop_name`](#payoutsdimension-propertydetail-shopname) to show readable store labels. * **week** **WEEK\_TIMESTAMP** The week a payout was issued. * **week\_​of\_​year** **WEEK\_OF\_YEAR** The week of the year when the payout was issued, with values 1 through 53. * **year** **YEAR\_TIMESTAMP** The year a payout was issued. * **shop\_​name** **STRING** Name of your store ### DAY\_TIMESTAMP A date value truncated to day precision. ```ts ``` ### DAY\_OF\_WEEK A day within a week, used for weekday-based grouping and filtering. ```ts ``` ### HOUR\_TIMESTAMP A timestamp truncated to hour precision. ```ts ``` ### HOUR\_OF\_DAY An hour within a day, typically represented as an integer from 0 to 23. ```ts ``` ### MINUTE\_TIMESTAMP A timestamp truncated to minute precision. ```ts ``` ### MONTH\_TIMESTAMP A date value representing the start of a month. ```ts ``` ### MONTH\_OF\_YEAR A month number within a year. ```ts ``` ### STRING A sequence of characters representing text data. ```ts ``` ### QUARTER\_TIMESTAMP A date value representing the start of a fiscal quarter. ```ts ``` ### SECOND\_TIMESTAMP A timestamp truncated to second precision. ```ts ``` ### IDENTITY A unique identifier for a Shopify resource such as a customer, product, or order. ```ts ``` ### WEEK\_TIMESTAMP A date value representing the start of a week. ```ts ``` ### WEEK\_OF\_YEAR A week number within a year. ```ts ``` ### YEAR\_TIMESTAMP A date value representing the start of a year. ```ts ``` *** ## Related schemas * [`payments`](https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/payments): Transaction data upstream of these payouts. * [`fees`](https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/fees): Processing and FX costs deducted from payouts. * [`chargebacks`](https://shopify.dev/docs/api/shopifyql/latest/schemas/finance_and_payments/chargebacks): Disputed transactions that reduce payout amounts. ***