Access data in Stripe with Sigma
Sigma makes all your transactional data available within an interactive SQL environment in the Stripe Dashboard. Sigma lets you create fully customized reports using information about your payments, subscriptions, customers, payouts, and more.
With Sigma, you can:
Get the information you need that best reflects your business and Stripe integration.
Export in CSV format to import into your tools.
Fetch the data you need on a schedule of your choosing.
Begin building custom reports using templates. Learn more about writing queries and the broad range of reporting functions.
Financial reports in Sigma
Financial Reports give you the data you need to complete your accounting and reconciliation workflows. You can use Sigma to create customized versions of these reports tailored to your needs and find queries to generate Stripe’s financial reports in the templates section of the Sigma sidebar. Additionally, you can find the schema for the underlying tables that drive financial reports in the schema section of the sidebar.
You can recreate the following reports and their connected variants in Sigma:
|Report group||Sigma template name||API report type|
|Balance Report||Itemized balance change from activity|
|Payout reconciliation report||Itemized payout reconciliation|
|Itemized ending balance reconciliation|
Reports follow the same availability rules as the Stripe Dashboard. Payout Reconciliation reports are only available for users with the Automatic payouts setting enabled, and connect variants of reports are only available for users on Stripe Connect.
Opening a Financial Report in Sigma
To generate a Financial Report in Sigma, navigate to the templates section of your Sigma Dashboard and search for the report you want to generate. Click on the template, then click the Run button in the top right corner.
By default, these reports run on the last completed month that all data is available for. You can change the dates by making a copy of the template and editing the report date intervals.
Descriptions of the columns produced by financial report queries are available in the Financial Reporting documentation.
The Financial Reports you generate from your Sigma Dashboard might slightly differ from those you generate on the Stripe Dashboard.
- Data availability: For Financial Reports, you can find the most recent day of available data by selecting month to date or opening the date picker calendar. In Sigma, the
data_load_timeparameter provides the timestamp that data is available through.
- Time zone: Financial Reports in the Stripe Dashboard filter reports by the local time zone by default, but you can switch them to use the UTC time zone. Sigma filters templates by the UTC time zone.
- Date range: A selected date range for Stripe Dashboard financial reports, such as Jan. 13 to Jan. 14, filters reports from January 13 00:00:00 up to January 14 23:59:59. A chosen date range filter for Sigma templates for January 13 to January 14 filters reports from Jan 13 00:00:00 up to January 13 23:59:59.
- Currency: Financial Reports in the Stripe Dashboard always filter data to a single currency. By default, the Sigma report templates return all currencies. You can add a
WHEREclause to your Sigma query to restrict your results to a single currency.
- Metadata: Financial reports allow you to include metadata. Sigma templates don’t include it. You can add metadata to your reports by following the
Metadata to columnSigma template.
Unsubscribing from Sigma
If you currently have an active Sigma subscription and want to cancel it for any reason, unsubscribe from Sigma in the settings page of the Stripe Dashboard by clicking Cancel Stripe Sigma subscription. You can continue using Sigma until the end of the billing cycle, at which point the subscription ends.