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
    Get started
    How Revenue Recognition works
    Data freshness
    Pricing
    Multi-currency
    Connect platforms
    Revenue Recognition for Usage-Based Billing
    Revenue contracts
    Reports
    Overrides
    Audit your numbers
    Examples
    Revenue recognition rules
    Revenue Recognition settings
    Map to your chart of accounts
      Bulk account mapping
    Performance obligations API
    Import data to Stripe
    Export data from Stripe
Data
OverviewSchema
Custom reports
Data Pipeline
Data management
HomeRevenueRevenue recognitionMap to your chart of accounts

Bulk account mapping

Simultaneously upload multiple chart of accounts mappings to simplify your Stripe to general ledger setup.

The Bulk Account Mapping feature lets you simultaneously upload multiple chart of accounts mappings, simplifying how you connect Stripe’s default accounts to your General Ledger (GL) structure. By using a CSV file, you can create hundreds of mapping rules in a single operation, which:

  • Eliminates the time-consuming manual creation of individual mappings.
  • Ensures consistency across large product catalogs.
  • Reduces repetitive work when adding new products or entities.

Upload your mappings

Step 1: Access the bulk upload feature

  1. Navigate to Revenue Recognition > Chart of Accounts.
  2. Click Map chart of accounts.
  3. Select Upload CSV from the dropdown menu.
Bulk Mapping Button

Step 2: Download and prepare the CSV template

  1. In the upload dialog, click Download template.
  2. Open the template in a spreadsheet application.
  3. Add your mappings.

Use the following columns when adding your mappings:

CSV columnDescriptionRequired or optional
Stripe AccountThe default Stripe account in camel case that you want to override (“Revenue”, “AccountsReceivable”)Required
General Ledger AccountThe name of your GL accountRequired
GL Account numberThe number corresponding to the GL accountOptional
Effective Start DateStart date (YYYY-MM-DD)Required
Effective End DateEnd date (YYYY-MM-DD)Required
Product IDProduct IDs for products that you have configured in the Stripe DashboardOptional
Invoice Metadata Key and Invoice Metadata ValueCreate a rule by selecting a key and adding a value. The keys are from metadata you created in past invoices.1Optional
Shipping Region Country and Shipping Region StateSpecify the shipping region to map transactions. Only ISO-compliant country and state codes are supported.Optional

If you don’t specify a condition (product, shipping region, or invoice metadata), the mapping applies to all transactions involving the configured Stripe account to the GL account.

Step 3: Upload your CSV file

After you complete these steps, the system starts processing your mappings:

  1. In the upload dialog, click Browse or drag and drop your completed CSV file.
  2. Review the file details.
  3. Click Upload.
Upload csv dialog

Step 4: Monitor processing status

After you upload your CSV, processing typically completes within minutes, depending on the file size. While the system processes your file, a progress notification banner appears in the Dashboard. When finished, the banner updates to show you the results. You can find the mapping on the Accounts mapping tab.

Error handling

If we can process a mapping, the system provides tools to identify and correct these issues.

Understand error notifications

Based on the processing results, you see one of these messages:

  • Complete success: “[X] of [Y] mappings added successfully. Mappings will appear in your reports within 24 hours.”
  • Partial success: “[X] of [Y] mappings added successfully. Mappings will appear in your reports within 24 hours.”
  • Complete failure: “Review errors and re-upload the file.”
Error banner

Review and fix errors

  1. For partial or failed uploads, click Review errors in the banner.
  2. In the File upload results dialog, click Download error report.
  3. The error report includes each failed mapping row with:
  • The original row data.
  • The specific error message explaining why the mapping failed.
Review error dialog

Reupload corrected mappings

  1. Fix the identified errors in your CSV file.
  2. Return to Map chart of accounts > Upload CSV.
  3. Upload your corrected file.
  4. Monitor the processing status.

1 Don’t import any personally identifiable information (PII) or protected health information.

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