Skip to main content

How To: Map Your Chart of Accounts to Another for Cost Reporting

Welcome to our guide on how to use the Chart of Accounts Mapping feature in GreenSlate. I’ll walk you through each step, so you can complete the process with ease.

1. Navigate to Account Mapping

First, navigate to the Account Mapping option under the Budget Tracking section in the left hand navigation menu.

Navigate to Account Mapping

Note: If you do not see this option contact support and they will enable this feature for you.

2. Click Create New Map

Next, click the Create New Map button in the top right-hand section.

Click Create New Map

3. Open Destination Chart Selection

Now, from the Destination Chart of Accounts drop down menu, select the latest version of Studio Chart of Accounts you would like to map to.

Open Destination Chart Selection

4. Access Mapping Details

Then, click Go To Mapping to start linking your accounts to the destination chart of accounts.

Access Mapping Details

5. Select Auto Map Options

Now, at this point you have the option to Auto Map: The Auto Map buttons will map on a one-to-one basis where the project chart of accounts and the studio's chart of accounts match by account number or description. Auto Map by Account will look to the account numbers, Auto Map by Description will look at the descriptions.

Select Auto Map Options

6. If Auto Map is Selected

Next, if Auto Mapping is selected a warning will appear asking you to confirm your current changes can be overwritten.

If Auto Map is Selected

7. Manual Map Options

Now, If you would rather manually map your accounts, this allows you to map each account or group of accounts to the ones you prefer.

Manual Map Options

8. Manually Select Accounts

Then, if you decide to manually map, you may map multiple accounts of the same type to a single destination account.

Manually Select Accounts

You cannot map different account types; they must be the same in both the project's COA and the studio's COA

9. Manually Select Accounts

Next, select the accounts you want to map and then in the top Map Destination drop-down select the studio account to link to.

Manually Select Accounts

10. Filtering and Collapsing Account Ranges

Afterward, you may filter the accounts by the Mapped column set to No to see which accounts remain to be mapped. Then you may collapse the header account to hide entire ranges once mapped by clicking the triangle to the left of any given header.

Filtering and Collapsing Account Ranges

11. Finalize Chart of Accounts Mapping

Finally, when you are ready, click the Lock COA button. Once you lock the COA you will not be able to edit or change your mapping later.

Finalize Chart of Accounts Mapping

Tip: The following accounting reports can be generated for a mapped COA:

Cost Reports

- Cost Report Rounded Decimals (mapped CoA)

- Cost Report with Net Total (mapped CoA)

- Top Sheet Cost Report (mapped CoA)

General Ledger Reports

- GL Bible (mapped CoA)

Trial Balance Reports

- Detail Trial Balance (mapped CoA)

- Trial Balance (mapped CoA)

That's it. You have successfully configured the Chart of Accounts Mapping in GreenSlate. If you have any questions or need more help, please visit our Help Center or reach out via email or chat.

Did this answer your question?