Last updated: September 21, 2022

Exporting your budget from Sage Intacct Planning (SIP) 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 Profit & Loss (P&L) accounts, Balance sheet accounts, and Statistical data. 

  • Budgets are exported as the monthly change for balance sheet accounts and as monthly totals for P&L accounts. Statistical accounts are exported according to their reporting type:

    • For the period - similar to how P&L amounts are reported (Sum)

    • Cumulative - similar to how balance sheet amounts are reported (Last)

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

Using the integration between Sage Intacct and SIP allows you to drill down to your source budget details from your budget or financial report in Intacct so you can review your budget assumptions in SIP. For more information, see Drill down from a budget report in Sage Intacct.

💡 When you export your working budget to an existing budget in Intacct, if your company has dimension relationships with the Auto-fill related objects option set, you may receive an error message like Duplicate glbudgetitem. If this occurs, make sure that you enable the override of auto-filled objects in Intacct.

Export your comments

If you added comments to your budget lines in SIP, they are exported automatically and you can see them in your budget in Intacct.

The maximum comment length is up to 200 alphanumeric characters, including periods (.), commas (,), and dashes (-). Other characters are automatically changed to an underscore (_). Multiple comments are separated by periods.

Keep in mind that only the comment text is exported and not the author and timestamp.


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.

The export options in the following steps of the wizard are dependent on the selections you make in the 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 SIP, or you can add the budget data for a specific time period. Alternatively, you can export your budget data from SIP 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. This way you can always go back to the budget before the export from SIP.

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 dropdown and choose one of the options:

  • To delete the budget amounts in an existing budget in Intacct and replace them with budget data for the specified period, select Replace for the specified budget period.

  • If you want to add budget data from a specific period in SIP to an existing budget in Intacct, select 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, Model, or a combination of the 3) and click Next. If you select to export models, all of your model lines (from both the Models and Statistical accounts sections) that are mapped to statistical accounts are exported to Intacct.

📝 If you export your budget to a multi-entity company in Intacct, the P&L financial data is exported by default and you can choose to export your statistical data if it exists. The Balance sheet report is disabled.

6. Select the dimensions that you want to export.

💡 You must have a Location dimension to export your budget to the top level of a company in a multi-entity shared environment in Intacct.

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.

📝 If data does not transfer as you expect, check that each of your accounts is defined correctly in terms of revenue, expense, asset, and liability. Also, take a look at our guidelines for number signs when exporting to Sage Intacct.

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, Models, or a combination of the 3) and click Next. If you select to export models, all of your model lines (from both the Models and Statistical accounts sections) that are mapped to statistical accounts are exported to Intacct.

📝 If you export your budget to a multi-entity company in Intacct, the P&L financial data is exported by default and you can choose to export your statistical data if it exists. The Balance sheet report is disabled.

6. Select the dimensions that you want to export.

💡 You must have a Location dimension to export your budget to the top level of a company in a multi-entity shared environment in Intacct.

If there are budget lines in your export that 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 SIP, 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 export your P&L budget, choose whether you want to export your dimension data. Your budget in Intacct includes any dimensions you select. If you choose multiple dimensions, each budget line in SIP is split into 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 SIP 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!

📝 If data does not transfer as you expect, check that each of your accounts is defined correctly in terms of revenue, expense, asset, and liability. Also, take a look at our guidelines for number signs when exporting to Sage 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 versus actuals reporting.

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

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 SIP, 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 SIP accounts table.

Map lines missing locations

When you export your budget from SIP 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.

💡 You must have a Location dimension to export your budget to the top level of a company in a multi-entity shared environment in Intacct.

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 dropdown. Keep in mind that budget lines with missing locations are not exported.

Update mappings for dimensions and dimension values

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 SIP 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 SIP, the dimension is removed from the dropdown list.

Dimension values:  In the Map budget dimension values window, a list of dimension values from SIP requiring mapping is displayed. You will be prompted to map dimension values only if the dimension value in SIP 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.

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 SIP. (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?