Skip to content
Create account
or
Sign in
The Stripe Docs logo
/
Ask AI
Create account
Sign in
Get started
Payments
Revenue
Platforms and marketplaces
Money management
Developer resources
Overview
Billing
OverviewAbout the Billing APIs
Subscriptions
Invoicing
Usage-based billing
Quotes
Customer management
Billing with other products
Revenue recovery
Automations
Revenue recognition
Test your integration
Tax
Overview
Use Stripe tax
Manage compliance
Reporting
Overview
Select a report
Configure reports
Reports API
Reports for multiple accounts
Revenue recognition
    Overview
    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
Data
OverviewSchema
Custom reports
Data Pipeline
Data management
HomeRevenueRevenue recognitionReports

Data reconciliation with Stripe reports

Learn how to reconcile Revenue Recognition data with other financial reports.

You can reconcile the cash account from Revenue Recognition and the Balance change from activity report within the same month. Because Revenue Recognition focuses on revenue-generating activities, you must exclude fees, network costs, contributions, and financing paydowns from the Balance change from activity report before reconciling. To get the cash amount in Revenue Recognition, download the balance sheet report in the summary format.

Note

The balance sheet report doesn’t take corrections into account. If there were corrections issued for the month for which you’re attempting to reconcile reports, you must also consider the Revenue Recognition corrections summary reports for all subsequent months. Any corrections that would have been booked to the original_accounting_period of the reconciliation month must be factored into the Revenue Recognition cash amount.

Example

As an example, the balance sheet report might look like the following, with a 100 USD amount:

accountcurrencynet change
Cashusd+100.00
Casheur+15.00

To get the cash amount in the Balance change from activity report, set the currency to USD, and the report timezone to UTC.

After downloading the report in the summary format, it might look like the following:

reporting categorycurrencygross
chargeusd+140.00
refundusd-40.00
refund_failureusd+20.00
partial_capture_reversalusd-20.00
feeusd-10.00
network_costusd-10.00
contributionusd-10.00
financing_paydownusd-10.00
totalusd+60.00

The total gross amount excludes some Stripe fees. After deducting rows for additional Stripe fees, network costs, contributions, and financing paydowns, the calculated cash amount is 100 USD.

Journal entries

The journal entries in the Debits and credits report don’t consider fees, network costs, contributions, and financing paydowns. However, you can use Stripe fees in your Revenue Recognition reporting to create journal entries for these items.

Note

As of March 1, 2025, journal entries in the Debits and credits report automatically incorporate fees, network costs, and contributions. Stripe fees for charges paid before March are not displayed to prevent showing only a portion of the total fee. As a result, discrepancies might arise when these fees are associated with charges in later periods, such as during disputes. To enable Stripe fees support in Revenue Recognition for all accounting periods and avoid the discrepancies, create a ticket on our support page.

With Stripe fees enabled, you can do the following to reconcile Revenue Recognition fees with the Balance change from activity report:

  1. Download the Balance change from activity report in the summary format. Make sure you select these columns: Reporting Category, Gross, and Fee.
  2. Calculate the total fee by summing the values in these columns:
    • Gross column: fee, network cost, and contribution
    • Fee column: total

In the following example, you calculate the total fees: -1000.00 + -0.50 + -0.40 + -1.00 to get the sum: -1001.90.

reporting categorygrossfee
charge100.00-4.00
refund-100.003.00
platform earning refund-0.100.00
fee-1000.000.00
network cost-0.500.00
contribution-0.400.00
total-1001.00-1.00

If you download the Debits and credits report in the summary format, you can see 1001.90 debited from the Fees expense account and credited to the Cash account.

debitcreditamount
FeesCash1001.90

Note

The debits and credits report doesn’t take corrections into account. If there were corrections issued for the month for which you’re attempting to reconcile reports, you must also consider the Revenue Recognition corrections summary reports for all subsequent months. Any corrections that would have been booked to the original_accounting_period of the reconciliation month must be factored into the Revenue Recognition cash amount.

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