Modify budget data

You have several options when it comes to modifying your budget data. The best way to modify your budget data depends on 2 aspects:

  • How much modification is needed for your budget
  • What year of the budget you want to modify

For more information about budgets in Sage Intacct, check out our on-demand training course titled Working with Budgets.

Subscription

General Ledger

Regional availability

All regions

User type Business user with admin privileges
Permissions Budgets: List, View, Edit, Add

Modify budget data for the current fiscal year

There are 2 different options for you to modify budget data for the current fiscal year.

Edit a few numbers

Maybe you forgot to add a budget for an account, or maybe you entered the data wrong for 2 accounts. Whatever the case, you can easily update your budget for these accounts from within Sage Intacct.

For more information about budgets in Sage Intacct, check out our on-demand training course titled Working with Budgets.

When you modify budget data in Sage Intacct, you can only modify 1 account at a time. For this reason, we only recommend this method if you only have a couple of accounts to edit at most.
  1. Go to Budgets > All > Budgets repository.
  2. Find the budget that you want to modify, and then select Budget details.

  3. Find the account for which you want to adjust the budget, and then select Budgets.

    At least 1 account must be set up to be used for budgeting. If no accounts are set up to be used for budgeting, you will not see any accounts listed. For more information, see Accounting periods overview. Learn how to Set up reporting periods to be used for budgeting.

    You can filter on Account to find the account that you want to modify.
  4. Select Edit in the top-right corner to edit the budget over multiple reporting periods for this account.
  5. Make any necessary changes, and then select Save when you're done.
  6. Repeat these steps for any other numbers that you want to modify.

Revise several numbers

To make more significant changes to your budget data, it's best to export the budget, then manipulate the budget data in Microsoft Excel. In Excel, you can change numbers across all accounts and reporting periods, then simply upload the revised budget 1 time.

Before you do this, we recommend that you make a copy of the original budget in Sage Intacct to retain a historical reference. After you have a copy, make your changes to the original budget. The original budget is used in any actual-to-budget financial reports that you have already created, because the budget ID remains the same.

For more information about budgets in Sage Intacct, check out our on-demand training course titled Working with Budgets.

To copy a budget:

  1. Go to Budgets > All, and then select Add (circle) next to Budgets.
  2. Enter a Budget ID and Description.
    When copying a budget, the best practice is to use a naming convention that represents the original budget for the specified fiscal year.
  3. Select the Create a budget from existing budget and reporting period range option.
  4. In the dropdown, select the budget that you want to copy.
  5. In the 2 new fields, ensure that the reporting period range is the one you want to copy.
  6. Save your budget.

To export and revise a budget:

  1. Go to Budgets > All > Budgets repository.
  2. Find the budget in the list.

  3. Select More actions > Export at the end of the row.

  4. Specify your Start period and End period.
    Select only the reporting periods that you want to revise to ensure that other budget data remains unchanged.
  5. In the Filters section, verify the following:
    • The specified Budget is the one you want to revise.
    • The Display notes checkbox is selected to include a column about the budget notes.
  6. In the Format section, verify that the CSV importable format checkbox is selected so that your dimension values are exported without totals.
  7. Select Export > CSV, and then Download the file.
  8. Open the file to revise your budget data in Excel.
  9. When you're done, save the file as a CSV file.
  10. Import your budget data into Sage Intacct.
  1. Go to Budgets > All > Budgets repository.
  2. Find the budget in the list.
  3. Select Export in the budget's row.
  4. Specify your Start period and End period.
    Select only the reporting periods that you want to revise to ensure that other budget data remains unchanged.
  5. In the Filters section, verify the following:
    • The specified Budget is the one you want to revise.
    • The Display notes checkbox is selected to include a column about the budget notes.
  6. In the Format section, verify that the CSV importable format checkbox is selected so that your dimension values are exported without totals.
  7. Select Export > CSV, and then Download the file.
  8. Open the file to revise your budget data in Excel.
  9. When you're done, save the file as a CSV file.
  10. Import your budget data into Sage Intacct.
Be careful when you import budget data back into Sage Intacct. Intacct overwrites the budget amounts for all accounts, dimensions, and reporting periods included in the budget import file.

Append budget data for the next fiscal year

You can append budget data for the next fiscal year onto your current budget so that there are no disruptions in your reporting.

The best way to accomplish this is to create a new budget import file that uses the existing Budget ID, but includes the next fiscal year of reporting periods. Adjust the numbers per account per reporting period, save the file, and import it into Sage Intacct to append the data.

For more information about budgets in Sage Intacct, check out our on-demand training course titled Working with Budgets.