Last updated: October 18, 2020
The following article explains how you maintain mapping between Sage Intacct and Sage Intacct Budgeting and Planning.
During the process of importing actuals or exporting your budget, data is shared between the two applications. This data includes accounts, dimensions, budget or actuals amounts, and more. For more information on integrating with Sage Intacct, see About the Sage Intacct integration.
Why do you need mapping?
Once you set up your budget in Budgeting and Planning, you can use the built-in integration to import actuals from Intacct, or to send your budget data to Intacct. Mapping helps you determine:
When you import actuals data, how the actuals are mapped to your budget lines.
When you export budget data, how your budget lines are mapped to your accounts and dimensions in Intacct.
This may seem straight forward, but often your budget and your actuals and financial structure (accounts and dimensions) are not exactly the same. For example, when importing actuals data to create budget versus actuals comparisons, certain budget lines are more detailed than the actuals, while others are less detailed. Two common examples are the salary and wages budgets which are often calculated per employee, but the actuals are only by salary components and dimensions like department; and travel budgets which are often calculated as the total travel cost, but the actuals are divided into food costs, hotels, car costs, flight tickets, and more. The mapping determines how we handle this common gap in the relationship between your budget and your actuals and financial structure.
Manage mapping in Budgeting and Planning
Budgeting and Planning includes two mapping tables found in the Actuals→Mapping tab.
Accounts displays the map between your chart of accounts in Intacct and your budget lines in Budgeting and Planning.
Dimensions displays the map between the dimensions in Intacct and the dimensions in Budgeting and Planning.
Populate your mapping tables
If you built your budget using the integration, the mapping tables are populated automatically, based on the selections you made during the budget setup process. For more information, see Create a budget structure using my Sage Intacct data. You can also add or edit data directly in the mapping tables.
📝 Keep in mind, if you make changes to your budget structure after your initial setup, you may need to update your mapping tables, as well.
What happens if your data in Intacct has changed?
Let's say your data has changed, but you've already created your budget. Whenever you use the integration with Intacct, Budgeting and Planning automatically detects new accounts and dimensions and prompts you to map them. This way you can remain confident that your data is always complete.
Use the accounts mapping table to map your accounts from Intacct to the budget lines that appear in Budgeting and Planning. To view your accounts mapping table, go to Actuals→Mapping.
For each mapped account, the following information columns are displayed:
Account — The account number that appears in Intacct.
Account description — A description of the account received from Intacct.
Account type — The account type can be either Profit & Loss or Balance sheet, according to the account type that appears in Intacct.
Mapping type — The following options are available:
- Single budget line (default) — Actual amounts are imported to a single budget line in Budgeting and Planning.
- Multiple budget lines (available only for Profit & Loss account types) — Actual amounts can be split across multiple budget lines according to the dimensions you choose.
- Same as account — Copy the dimension and budget line selections from another account (displayed in the dropdown list) in the accounts table.
- No mapping — Actuals in this account are imported, but won't be mapped to any budget line.
Budget lines — Map your accounts to a budget line from the dropdown list of budget lines that appear in Budgeting and Planning. If you've chosen No mapping, the budget line field will remain blank.
📝 The same budget line can be selected for more than one account.
Dimensions — If you've selected Multiple budget lines as the Mapping type for a Profit & Loss account type, you can select one or more dimensions from the dimensions you have in your budget.
Your selections are saved to the Budgeting and Planning accounts table.
Use the dimensions mapping table to map the dimensions appearing in Intacct to the dimensions appearing in Budgeting and Planning. To view your dimensions mapping table, go to Actuals→Mapping, then click Dimensions.
In the Dimensions section of the mapping table, map the list of dimensions appearing in Intacct to the corresponding dimensions that appear in Budgeting and Planning. In the Dimensions Values section of the mapping table, map the dimension values appearing in Intacct to the dimension values that appear in Budgeting and Planning.
For each mapped dimension from Intacct, the following information columns are displayed:
Sage Intacct Name (ID) — The dimension value that appears in Intacct.
Budget Dimension — The dimension in Budgeting and Planning to which the dimension from Intacct is mapped.
Budget Dimension Value — The budget dimension value in Budgeting and Planning to which the dimension value from Intacct is mapped.
In the Budget dimensions without mapping section, the dimensions in your budget that have no mapping to the dimensions you imported from Intacct are displayed. The dimensions listed in the Budget dimensions without mapping are adjusted accordingly as you add new dimensions to your budget, or map and unmap dimensions.
For example, if you change the mapping of the Department dimension you imported from Intacct to the budget dimension Category that appears as having no mapping, the Category dimension is removed from the list of unmapped dimensions and the Department dimension is added to the list of unmapped dimensions instead. In addition, the previous mappings of the budget dimension values are removed and you can select new budget dimension values from the dropdown that are associated with the Category budget values.
Working with the Dimensions Mapping table
Following is an example of how to work with the dimensions mapping table.
In the following screenshot, the Dimensions section displays the mapping between the dimensions in Intacct and Budgeting and Planning. For example, the dimension Location in Intacct is mapped to the Location dimension in Budgeting and Planning. Click on the dropdown to change the mapping to a different dimension in Budgeting and Planning.
In the Dimension values table, the Sage Intacct name (ID) column shows the dimension value associated to the dimension from Intacct. From the Budget dimension value dropdown, you can map the dimension values from Intacct to one or more dimension values appearing in Budgeting and Planning.
These values are associated to the dimension in Budgeting and Planning that appears in the Budget Dimension column.
All of your selections are saved to the Budgeting and Planning dimensions table. When you import actuals by dimensions, the dimension values from Intacct need to be matched to values in Budgeting and Planning:
If the dimension value from Intacct is mapped to a single dimension value in Budgeting and Planning, then the actuals are matched to a budget line using the Budgeting and Planning value.
If the dimension value from Intacct is mapped to multiple dimension values in Budgeting and Planning, then the actuals are split between the budget lines, according to the budgeted amount for the actuals time period.
For instance, let's say that the dimension Location in Intacct has a value of California (2000) (shown in the example budget above). In Budgeting and Planning, the same value is mapped to the Geography dimension, with a value of CA. If you select multiple dimension values from the corresponding dimension values in Budgeting and Planning, actuals from Intacct with the value California (2000) can be matched to multiple budget lines in Budgeting and Planning with any of the dimension values you select (CA, USA, or other).
For more information on Dimensions in Sage Intacct Budgeting and Planning, see: