Mapping the Chart of Accounts to Profit and Loss Categories

Corporate users can configure different categories for income, expense, and overhead sections.

Navigate to Admin > Finance > Configure Profit & Loss Categories.Click the Associate Mapping tab.Click Save.  

You can associate your Standard QuickBooks CoA with the Profit and Loss Categories by dragging the Account Value from left to right. After moving the account value, you will notice that values are added in the Profit and Loss Categories and are grayed out in the Standard QuickBooks CoA section on the left.

If you are mapping a child account value with the Profit and Loss Categories, then the parent value of that child value will get grayed out.

Setting Up the Chart of Accounts (COA) by Brand for P&L

Previously, on the Associate Mapping page under Configure Profit & Loss Categories, there was no way to filter the Chart of Accounts (COA) by brand. All accounts and categories displayed together, which made brand-specific financial mapping difficult for organizations that manage multiple brands.

You can now use the Brand filter on the Associate Mapping page to view and manage brand-specific COA and Profit & Loss category mappings. When you select a brand, the Chart of Accounts and Profit & Loss Categories lists update to show only the data relevant to that brand, so you can map accounts to categories one brand at a time.

Understanding the Brand Filter

The Select Brand dropdown at the top of the Associate Mapping page controls what appears in both columns. You can select one brand at a time; it is a single-select dropdown. When you choose a specific brand, the Chart of Accounts and Profit & Loss Categories lists show only the items associated with that brand.

Brand-Wise COA Mapping Setup

This section explains how to open the Associate Mapping page, filter it by brand, and map your Chart of Accounts to the Profit & Loss categories.

1. Go to Admin > Finance and click Configure Profit & Loss Categories.
2. Open the Associate Mapping tab.
3. From the Select Brand dropdown at the top right of the page, choose the brand you want to work with. You can select one brand at a time.
4. The Chart of Accounts list (left column) and the Profit & Loss Categories list (right column) refresh to show only the items associated with the selected brand.
5. Drag a Chart of Accounts entry from the left column and drop it onto the Drop Here area of the matching Profit & Loss category on the right to create the mapping.
6. Click SAVE to save your mappings.

Admin > Finance > Configure Profit & Loss Categories

Select the brand from the Select Brand dropdown on the Associate Mapping tab

The Chart of Accounts and Profit & Loss Categories lists show only the selected brand’s data

Note: To use brand-wise mapping, your Chart of Accounts and Profit & Loss categories must be associated with the relevant brand; any account or category not associated with a brand continues to display without filtering. If you remove one brand and select another before saving, the system displays the message “You have unsaved changes for the selected brand. If you proceed without saving, your changes will be lost,” giving you the option to either proceed without saving or stay and save your changes.