Map to your chart of accountsBeta
You can customize accounting reports to use your chart of accounts instead of using the default accounts that Stripe provides. Map transactions, to the entire account or by product, to a financial account that you use in your general ledger. To do this:
- Create a mapping with the financial account name and its general ledger code (GL code).
- Apply to the entire account or specify the product that you want the mapping to apply to and the Stripe default account to override.
Stripe applies your custom mappings to the CSV reports you download and also when you audit your revenue numbers. A mapping consists of:
| Account Name | The name you want to associate transactions with. This is typically the name used in your ledger for the financial account. |
| GL code | The general ledger code to apply to the transactions. |
| Account | The Stripe default account that you want to override. |
| Product ID | (If applicable) The product to apply the mapping to. |
Effective period | The time period the mapping applies to. An invoice line item fulfills the effective period requirement if the finalization time of the invoice is within the specified effective period. A charge fulfills the effective period requirement if the balance transaction it corresponds to has a creation time that’s within the specified effective period. |
Create a mapping
From the Chart of accounts page, click Add mapping and provide the mapping details for your financial account.
Stripe generates report corrections when you apply a new mapping to transactions from closed (past) accounting periods. To avoid this, open the accounting period (that is, reopen your books) before you create the mapping.
For a given effective period, we allow there to be specific product mappings as well as a global mapping to be present. The product specific mapping will take priority when available during application.
Product Mapping
The mapping in this case will only be applied to the specific product and account combination. For example, say you reference the Revenue - Hosting account in your ledger and you want to associate the transactions from your monthly subscription prod_1234 with it:
| Account Name | Revenue - Hosting |
| GL code | 1000-01:1004 |
| Apply to | Product |
| Product ID | prod_1234 |
| Stripe GL Account | Revenue |
Effective period | Start
End
|
A customer starts 3 monthly subscriptions with you on January 15 for 31 USD. One for the product prod_1234, prod_2345, and prod_3456. The journal entries for this would look like:
| Account | GL code | Jan |
|---|---|---|
| Revenue - Hosting | 1000-01:1004 | +17.00 (from prod_1234) |
| DeferredRevenue | +42.00 | |
| Revenue | +34.00 (from prod_2345 and prod_3456) |
Global Mapping
The mapping in this case will be applied to the entire account for all products. For example, in addition to the previous product mapping, say you reference the Revenue - Server account in your ledger and you want to associate every transaction with it:
| Account Name | Revenue - Server |
| GL code | 1000-01:1005 |
| Apply to | Entire account |
| Stripe GL Account | Revenue |
Effective period | Start
End
|
Taking into the account the Product mapping and the 3 subscriptions in the Product mapping example, the journal entries would look like:
| Account | GL code | Jan |
|---|---|---|
| Revenue - Hosting | 1000-01:1004 | +17.00 (from prod_1234) |
| DeferredRevenue | +42.00 | |
| Revenue - Server | 1000-01:1005 | +34.00 (from prod_2345 and prod_3456) |