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
      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
    Bank reconciliation
Data
Startup incorporation
HomeFinance automationReportingRevenue recognitionMap to your chart of accounts

Bulk account mapping

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

Copy page

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