Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Developer tools
Get started
Payments
Finance automation
Get started
Payments
Finance automation
Platforms and marketplaces
Money management
Overview
Billing
Tax
Reporting
    Overview
    Select a report
    Filters and settings
    Categories and types
    Connect an accounting tool
    Reports API
    Reports for multiple accounts
    Revenue recognition
      Get started
      How Revenue Recognition works
      Data freshness
      Pricing
      Multi-currency
      Connect platforms
      Revenue Recognition for Usage-Based Billing
      Revenue contracts
      Reports
        Monthly summary
        Revenue waterfall
        Balance sheet
        Income statement
        Trial balance
        Accounts receivable aging
        Debits and credits
        Corrections
        Sigma and SDP
        Data reconciliation
      Overrides
      Audit your numbers
      Examples
      Revenue recognition rules
      Revenue Recognition settings
      Map to your chart of accounts
      Performance obligations API
      Import data to Stripe
      Export data from Stripe
    Bank reconciliation
Data
Startup incorporation
HomeFinance automationReportingRevenue recognitionReports

Custom reports by Sigma and SDP

Learn how to build your own Revenue Recognition reports using Sigma and SDP.

Copy page

You can build your customized reports using revenue_recognition_debits_and_credits and other tables in Sigma.

Recognized revenue from unpaid invoices example

This sample query generates a report for revenue recognized from the unpaid open invoices and groups the invoices by invoice ID. You can add your desired time frames and adjust the grouping parameters.

Note

If you’re using our chart of accounts beta feature, be sure to update the debit and credit mappings in the query below to reflect the accounts in your general ledger.

with revrec as ( select * from revenue_recognition_debits_and_credits where debit = 'DeferredRevenue' and credit = 'Revenue' ), sigmainv as ( select * from invoices where status = 'open' ) select revrec.invoice_id, SUM(revrec.presentment_amount) AS recognized_revenue from sigmainv left join revrec on revrec.invoice_id = sigmainv.id group by revrec.invoice_id
Was this page helpful?
YesNo
Need help? Contact Support.
Join our early access program.
Check out our changelog.
Questions? Contact Sales.
LLM? Read llms.txt.
Powered by Markdoc