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, 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).
- 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 | 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 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 |
| Account | Revenue |
| Product ID | prod_1234 |
Effective period | Start
End
|
A customer starts a monthly subscription with you on January 15 for 31 USD. The journal entry for this would look like:
| Account | GL code | Jan |
|---|---|---|
| Revenue - Hosting | 1000-01:1004 | +17.00 |
| DeferredRevenue | +14.00 |