Last updated: December 14, 2020

Exporting your budget to Sage Intacct is helpful for creating reports to compare your budget versus your actuals, or to use them with Spend Management in Intacct. 

With the integration to Sage Intacct:

  • Budgets can be exported to an existing budget in Intacct.

  • Budgets can be exported to the top level of a company in a multi-entity shared environment or to a specific entity of a multi-entity company, as well as to a consolidated budget.

  • Budgets can be exported for both Profit & Loss (P&L) accounts and balance sheet accounts. 

  • Budgets are exported as end of month balances for balance sheet accounts, and as monthly totals for P&L accounts.

  • Budgets for P&L accounts can be exported by dimensions. This, however, is not yet available for balance sheet accounts.

Select how you want to export your budget 

To export your budget to Sage Intacct:

1. Click the Connect to Sage Intacct icon on the menu bar:

2. Sign in using your Sage Intacct credentials and click Next:

3. Choose Export my budget to Sage Intacct and click Next:

In the following steps, the export options in the wizard are dependent on the selections you make in previous steps. For example, if you choose to add your budget data to an existing budget in Intacct, you can either replace the existing budget data in Intacct with the data from Budgeting and Planning or you can add the budget data for a specific time period. Alternatively, you can export your budget data from Budgeting and Planning to create a new budget in Intacct. Follow the steps to Export your budget data to an existing budget in Intacct or Export a budget to create a new budget In Intacct.

Export your budget data to an existing budget in Intacct

When you select to export a budget to an existing budget in Intacct, a copy of the existing budget in Intacct is saved before any changes are made so that you can always go back to the budget before the export from Budgeting and Planning.

1. Select Add to an existing budget in Sage Intacct to replace or add your budget data to an existing budget in Intacct.

2. Choose the Sage Intacct budget name from the drop-down and choose one of the options:

If you want to delete the budget amounts in an existing budget in Intacct and replace them with budget data for the specified period, choose Replace for the specified budget period.

If you want to add budget data from a specific period in Budgeting and Planning to an existing budget in Intacct, choose the Add option.

3. Click Next.

4. Budgets can be exported by months, quarters, or years (per your selection), according to the budgetable time periods defined in Intacct. Depending on your company's needs, it is recommended that you choose Months for the selected time period. Click Next.

5. Select which financial data you'd like to export (P&L, balance sheet, or both) and click Next.

📝 If you are exporting your budget to a multi-entity company in Intacct, only the P&L financial data is exported.

6. Select the dimensions that you want to export.

If any budget lines in your export aren't mapped to accounts in Intacct, you'll be prompted to update them. Continue to Update mappings for dimensions and dimension values (P&L only) and Update mappings for missing accounts. Otherwise, you can skip this step and continue to export your budget.

Export a budget to create a new budget in Intacct

1. Select Create a new budget in Sage Intacct.

2. Create a new unique budget ID or name and type a description as you would like them to appear in Intacct. If you are working with a multi-entity shared company, you can choose to add your budget data to the top level (or parent) of the company, to a specific entity (given that you are not restricted to a specific entity or entities), or to a consolidated budget for multi-entity companies with multiple base currencies.

3. Select whether you'd like to set the budget as the default in Intacct and click Next.

📝 If you set this budget as the default and you already have budgets in Intacct, this budget becomes the new default budget. For example, when a budget column is added to a financial report in Intacct, the default budget is automatically selected. You can always change the default to another budget.

4. Budgets can be exported by months, quarters, or years (per your selection), according to the budgetable time periods defined in Intacct. Depending on your company's needs, it is recommended that you choose Monthly for the selected time period. Click Next.

5. Select which financial data you'd like to export (P&L, balance sheet, or both) and click Next.

6. Select the dimensions that you want to export.

If any budget lines in your export aren't mapped to accounts in Intacct, you'll be prompted to update them. Continue to Update mappings for dimensions and dimension values (P&L only) and Update mappings for missing accounts. Otherwise, you can skip this step and continue to export your budget.

📝 In a single budget in Intacct, you can only have one budget amount for the same account, dimension, and time period combination. In Budgeting and Planning, if you have more than one budget line for the same combination, the budget amount exported will be the sum of the budget lines.

If you're exporting your P&L budget, choose whether you want to export your dimension data. Your budget in Intacct will include any dimensions that you've selected. If you choose multiple dimensions, each budget line in Budgeting and Planning is split to multiple budget lines in Intacct (according to the dimension value, or values, of the budget line). For any dimension you select:

  • If the budget line has one dimension value, the total budget is exported with the dimension.

  • If the budget line doesn't have a dimension value, the total budget is exported without dimension information.

  • If a budget line has more than one dimension value:

  • The budget line amount is split between dimensions, according to the set allocation.

  • If the budget line has only partial allocation (for example, 20% US and 50% England), then a budget line is also created in Intacct with no dimension value for the amount which wasn't allocated to a dimension.

If you choose not to map the dimensions in Budgeting and Planning to dimension values in Intacct, the dimensions are not exported. Go on to Update mappings for dimensions and dimension values (P&L only).

When your budget export is complete, click Finish and you're done!

Update mappings for dimensions and dimension values (P&L only)

During budget export, you can choose to export dimensions with your P&L export.  As with accounts, when you export dimensions, all of your dimensions and dimension values are automatically checked for mapping from your current budget in Budgeting and Planning to the company in Intacct.

To ensure that the export matches up with your Intacct data, you may be prompted to map dimensions and dimension values. These items might have the same or different names from what you have in Intacct. For example, Geography is typically mapped to Location in Intacct. Department is commonly used in Intacct, but your budget might use slightly different department names than the values in Intacct.

Dimensions: From the Map budget dimensions window, map the dimensions from your current budget to the list of dimensions in Intacct.

Dimensions can't be selected twice. If you select a dimension from Intacct to map from a dimension in Budgeting and Planning, the dimension is removed from the dropdown list.

Dimension values:  In the Map budget dimension values window, a list of dimensions values from Budgeting and Planning which require mapping is displayed. You will be prompted to map dimension values only if the dimension value in Budgeting and Planning isn't mapped to a dimension value in Intacct. Select the corresponding value in Intacct from the dropdown.

When you select your mappings, they will be saved under the Actuals→Mapping tab for future use. You won’t be prompted for mappings again unless you add a new dimension or dimension value to your budget that hasn’t yet been mapped to Intacct.

Update mappings for missing accounts

During export, you may be prompted to map your budget lines to Intacct accounts. Mapping your budget lines to accounts ensures that the budget data will be applied to a valid account in Intacct, which allows it to be used in budget to actual reporting.

For more information on mapping, see Map your Sage Intacct accounts and dimensions to your budget in Budgeting and Planning.

Missing account mappings can occur if:

  • A budget line isn't mapped to an account

  • Mapping exists, but the account doesn't exist in Sage Intacct

  • Mapping exists, but the Sage Intacct account is inactive or the wrong account type

Once you've mapped accounts, you won't be prompted again unless something changes (for example, you added new budget lines in Budgeting and Planning, or Intacct accounts changed since the last time you exported the budget).

Budget lines that have not been linked to accounts are displayed in the Map Profit & Loss budget lines window. Assign the budget lines to the accounts from the dropdown list of corresponding accounts appearing in Intacct.

If you select to export the balance sheet budget, and there are balance sheet lines with a budgeted amount that don't have an account linked to them, the accounts are displayed in the Map balance sheet budget lines window:

📝 If you decide not to map the budget lines to an account, then these lines won't be exported. Your selected mapping, however, is saved to the Budgeting and Planning accounts table.

When you export your budget from Budgeting and Planning to a multi-currency company in Intacct, your budget lines are automatically mapped to locations. If there are budget lines that are missing locations, you can map them using the wizard. 

If you want to map multiple budget lines to the same location, select the budget lines you want to map and select the location from the drop-down. Keep in mind that budget lines with missing locations are not exported.

What’s next

When you complete exporting your budget to Intacct, a snapshot of the exported budget is automatically saved in your version history in Budgeting and Planning. (Export to Sage Intacct appears in the comment field.)

📝 If the snapshot doesn’t save correctly, or if creating a snapshot takes longer than expected, you’ll receive the error message Yikes! Something went wrong. If this happens, click the link to export your budget again. If the budget you created initially was a new budget in Intacct (and not an existing budget to which you added values), then the budget is automatically deleted when you rerun the export. If you choose to close the wizard without re-exporting your budget, the new budget in Intacct isn’t deleted.

Once you’ve successfully exported your budget, click on Go to Sage Intacct and get started working!

Did this answer your question?