Budgeting and Spending in Sage Intacct

Keywords:   Prerequisites, Budgeting, Sage

Credit:–  Sage Photo By: FP

Struggling to Keep Your Books in Order? 📊📅

Let us handle the numbers while you focus on growing your business! Get expert bookkeeping support tailored to your needs.

👉 Click Here for a Free Consultation!

Budgeting with Excel spreadsheets

Budgets are powerful tools that you can use in financial planning and reporting. Many reports and dashboards in Sage Intacct include budget information that helps you monitor your business’s progress and compare actual results against your forecasted results.

You can do even more with Sage Intacct Planning. Integrate Intacct with Planning to sync your chart of accounts, actuals and budget data, dimensions, and more. Then use the Planning wizard, which guides you through creating a new budget. You can specify what accounts and dimensions to use and create a budget structure using dimensions. Other tools include data modeling, what-if scenarios, and rolling forecasts to help you see the impact of key decisions.

Before you create a budget

Budgets are powerful tools that you can use in financial planning and reporting. Many reports and dashboards in Sage Intacct include budget information that helps you monitor your business’s progress over the course of a year and compare actual results against your forecasted results.

Do some planning before you create your budget. How you set up your budget impacts the detail that you can view in reports. You can minimize the need to edit financial reports that use budget data. Carefully consider how to set up your budgets and how to prepare them. Most importantly, consider the following when planning your budgets:

  • Reporting periods
  • How often you expect to update the budget
  • Number of budgets you’re using

Additionally, many organizations use Spend Management to enforce spending validation against budgets, which requires additional configuration and thought as to how you want to validate your expenses.

You can simplify the budgeting process with Sage Intacct Planning. The bidirectional integration between Planning and Intacct means that you can share data for budgets, including your chart of accounts, dimension data, actuals, and more.

Prerequisites

Before you can create or import a budget, several items in Sage Intacct must be set up:

  • Reporting periods to be used for budgeting: Reporting periods must exist and must have the Use for budgeting checkbox selected. Reporting periods used for budgeting are typically monthly. Also, the reporting periods used for budgeting cannot overlap.
    For example, you cannot use all the following reporting periods for budgeting in a given year because they overlap:
  • January
  • February
  • March
  • First Quarter
  • Accounts: Each account that needs a budget must exist in the chart of accounts. Learn more about creating accounts.
  • Dimensions: You can use dimensions such as Location, Department, and Employee in a budget, but dimensions are not required. Learn more about planning a budget with dimensions.

Reporting periods with budgets

Budgets are typically created for reporting periods of 1 month. The monthly reporting period lets you roll up individual months to create quarterly, semiannual, and annual reports.

It’s possible to create a budget for reporting periods that are shorter or longer than a month, if the reporting period is set up to be used for budgeting.

Depending on how you set up your budgets, you can avoid the need to create a new budget for each year. There’s no limit to the number of reporting periods included in a budget. Just add reporting periods to your budgets and retain data from the previous year. Adding reporting periods to an existing budget can minimize the need to edit financial reports later.

A single budget

Many companies develop an annual budget that remains untouched for the entire year. In this case, you can create a single budget that can be used for multiple years. Just add the reporting periods for each subsequent year to the existing budget.

Multiple budgets

In contrast, some companies use multiple budgets in a fiscal year. This could be because the company wants to revise the budget throughout the year or consider multiple forecasts. If your company needs multiple budgets, consider that it will make the reporting process a bit more complicated. Because each financial report (such as an Actuals-to-budget report) refers to a specific budget, maintaining multiple budgets can mean that you have multiple copies of financial reports.

Even when you’re using multiple budgets in Sage Intacct, you need to have a top-level budget designated as the default. Budget entries can be made at the top level or at the entity level for all budgets.

When using multiple budgets, you have options to support efficient reporting.

Multiple budgets and multiple copies of financial reports

You can create multiple budgets with different Budget IDs, and then make copies of all financial reports that include budgets. After, edit each financial report to retrieve the desired budget ID.

Pros: Offers the greatest flexibility of using multiple budgets. Different reports can be run during a period to display different budgets. You can even run a single report that refers to multiple budgets.

Cons: Increases the number of financial reports in your company that have similar specifications, resulting in a larger list and perhaps requiring extra report management.

A default budget and copies of previous budgets for historical purposes

You can save a copy of the original budget with a new Budget ID. With this option, you can still modify the default budget without affecting existing financial reports.

For example, you have a budget called Current Budget that’s used in your financial reports. When you want to revise the budget amounts, make a copy of the current Budget and name it Old Budget. Then make the desired changes to the current Budget so that your reports reference this updated information.

Pros: Requires only 1 copy of your financial reports, because each report continues to reference the same budget ID.

Cons: You can only consider and report on a single budget at any given time.

To save the original budget with a new name, follow the directions to Create a budget from an existing one. Be sure to select the option to create a new budget from an existing one.

Accounts with budgets

It’s possible to budget for both income statement and balance sheet accounts, although many companies include only income statement accounts in the budget.

Income statement accounts

Income statement accounts are reported as the activity for the reporting period, and can be described as “for the period.” Enter the budgeted activity for the period as the budget entry.

For example, the budget amount for an income statement account is 4,000 for January, 4,000 for February, and 4,000 for March. The reported amount for the monthly period of March is 4,000, and the amount for the first quarter is 12,000.

Balance sheet accounts

Intacct reports balance sheet amounts as of a point in time, which can be described as a cumulative balance as long as there’s a budget amount for each period. The budget entry for a period is the change in the balance sheet account.

For example:

  • The ending budget account balance for January is 2,000.
  • The ending budget account balance for February is expected to be 6,000.
  • The February budget amount is entered as 4,000.

For balance sheet accounts, you must enter a budget amount for every period to keep a cumulative balance. If there’s no budget amount for a period, Intacct sees this as no budget, so there will not be a cumulative amount. In this case, the budget amount is not carried forward from the last period.

Statistical accounts

Statistical accounts can also be included in a budget, and they can be defined as “for the period” or “cumulative” when they’re created.

  • If the statistical account is defined as for the period, enter the budget amount as the change for the period.
    For example, the opening balance for a headcount account is 243. If you expect headcount to go up by 10 in a particular month, enter 10 as the budget amount.
  • If the statistical account is defined as cumulative, enter the ending balance as the budget amount. For example, the opening balance for a headcount account is 243. If you expect the headcount to go up by 10, enter 253 as the budget amount.

Dimensions with budgets

Creating a budget using dimensions offers greater flexibility and detail in reporting. While using dimensions is optional, we strongly recommend including them in the budgets for reporting purposes. For example, your company wants to compare budgeted expenses to actual expenses by location or department. If your budget does not include those dimensions, you will not be able to run this report.

Similarly, your company can track revenue by salesperson using the Employee dimension. By budgeting for revenue including the Employee dimension, you can run reports comparing budget versus actuals for each salesperson.

Any dimension that’s available in the General Ledger can be used with budgets.

The following example shows budget data for a company that includes dimensions in its budget.

You add dimension-level detail to your budget when you add details to the budget.

Budget for some accounts using dimensions and others without

You can use different dimensions for different accounts. And you can use dimensions for some accounts and not others. Your reporting needs determine the level of detail. Each account can be budgeted at a different level of detail.

If your actual amounts will include dimensions, create the budget with dimensions to allow for comparison at the same level of detail.

Use a budget with Spend Management

Budgets associated with Spend Management must have a value, even if the value is zero. Spend Management will not validate anything left blank. Intacct assumes that you want to skip spending validation for this account. Therefore, when you want an account used for validation, and it has no budget amount, set the amount to 0. Refer to Spend Management validation for more information.

Budget planning

Budgets are powerful tools that you can use in financial planning and reporting. Many reports and dashboards in Sage Intacct include budget information that helps you monitor your business’s progress over the course of a year, and compare actual results against your forecasted results.

Use the Budget planning page (Budgets > All > Budget planning) to access Sage Intacct Planning, import budgets from a spreadsheet or other tool, or create a budget manually.

Prerequisites

Before you can create or import a budget, several items in Sage Intacct must be set up:

  • Reporting periods to be used for budgeting: Reporting periods must exist and must have the Use for budgeting checkbox selected. Reporting periods used for budgeting are typically monthly. Also, the reporting periods used for budgeting cannot overlap.
    For example, you cannot use all the following reporting periods for budgeting in a given year because they overlap:
  • January
  • February
  • March
  • First Quarter
  • Accounts: Each account that needs a budget must exist in the chart of accounts. Dimensions: You can use dimensions such as Location, Department, and Employee in a budget, but dimensions are not required.

Create a named budget

No matter how you’re going to add your budget, you need to start with a named budget.

Go to Budgets > All and select

Add

beside the Budgets repository. Provide a Budget ID and Description.

Make any other selections and save your budget. You can now use that budget to provide details or as the container into which you can import a prepared budget.

Integrate with Sage Intacct Planning

When you open the Budget planning page, you’ll see a link to log in to Sage Intacct Planning with budgets.

With Sage Intacct Planning, you can skip the manual spreadsheet imports. The bidirectional integration between Planning and Intacct means that you can share data for budgets, including your chart of accounts, dimension data, actuals, existing budgets, and more.

When you’re ready to create a budget in Planning, a wizard guides you through the process. You can select which accounts and dimensions to use, combine accounts into one budget line, and use your dimensions to create a budget structure.

Import a prepared budget

It’s common to create a budget using Microsoft Excel or other spreadsheet program. Creating a budget in spreadsheet form allows you to upload large volumes of data. The spreadsheet can include all account and dimension combinations.

Create a budget

If you’re new to creating budgets, we recommend that you review the information in Before you create a budget and Overview of creating budgets. The Budget information page is where you create a unique ID—called a Budget ID—for your budget.

When you create a budget, the general process is to:

  • Create a budget u vsing the Budget Information page.
  • Add data to the7 budget by:
  • Importing a budget from a CSV file
  • Connecting to Sage Intacct Planning
  • Entering budget amounts manually.
  • For Global Consolidations companies, create a budget and flag it as containing consolidated amounts. Tagging a consolidated budget lets you easily report on forecasted, annual, and local versus consolidated budget amounts.

Create a new named budget

Instead of creating a new budget for each fiscal year, you can append data for the new fiscal year to the existing budget. As a result, you will not need to update your financial reports that reference the budget. Use the As of date to control which fiscal year appears in the report. Go to Budgets > All and select

  • Add (circle)
  • next to the Budgets repository.
  • In the Budget ID field, enter a unique name to identify the new budget.
    Best practice is to give the budget an ID that doesn’t reference a particular fiscal year or date. Then you can append new time periods to your existing budget.
  • Enter a Description to distinguish your budget from others with a similar name.
  • Select Create a new budget to create a budget from scratch.
    Consider uploading the data from a spreadsheet. Uploading a CSV file of budget data is a faster alternative to creating budgets manually. Go to uploading a budget from a spreadsheet for details.
  • For Global Consolidations companies: You can tag this budget as containing consolidated amounts by checking the Consolidated budget checkbox. Then, select which currency you’re entering your amounts in from the Consolidated currency dropdown.
    You can create as many budgets as you need and mark each as consolidated or unconsolidated. This is useful for tracking your annual plan, actuals, and forecasts and comparing them side-by-side in a financial report. You can then specify if this consolidated budget is the default consolidated budget for your company for easier reporting.
    To use your consolidated budgets in financial reports, you must tag them as consolidated here. After you tag a budget as consolidated, it appears in the consolidated budget dropdown list when you create a financial report.Be sure to convert your local budget from the entity-level currency into your consolidated currency, then upload the amounts to your consolidated budget.
  • To specify this budget as the default budget to use when you create financial reports, select the Default budget checkbox. There must be at least 1 top-level budget designated as the default.
    For Global Consolidations companies, check the Default budget checkbox if this is the first consolidated budget you’re creating with amounts in a specific currency. This enables you to select this budget as the default consolidated budget in financial reports. Update your default consolidated budget as you pass through the fiscal year and new budgets are created.
  • To allow a project estimate to post to this budget, select the Project estimate checkbox.

Edit and update a consolidated budget from an existing budget

This feature is only available in companies that use Global Consolidations.

To select a consolidated budget in a financial report, your budget must be tagged as consolidated. If your budget is not currently tagged as a consolidated budget, simply duplicate your existing budget and tag it as consolidated.

Want to compare your consolidated actuals to the budget in a financial report? To select a consolidated budget in a financial report, your budget must be tagged as consolidated, and the consolidation currency must match for both budget and actuals.

  • Go to Budgets > All > Budgets > Budgets repository.
  • On the Budgets list, next to the budget you want to tag as consolidated, select Edit.
  • On the Budget Information page, select Duplicate.
  • Enter a new Budget ID.
  • Select the Consolidated budget checkbox.
  • From the Consolidated currency dropdown, select the currency your amounts have been entered in.
  • Select Save.

Import a budget

You can create a budget using a spreadsheet program, such as Excel, and then import the budget into Sage Intacct.

Creating a budget in a spreadsheet allows you to import large amounts of data. The spreadsheet can include all account and dimension combinations.

Example

The following example of a budget spreadsheet shows budget data for an organization that includes some dimensions (department, location, project, and item) in its current budget.

Each row in the spreadsheet represents a budget detail. They include the budget ID, general ledger account number, selected dimensions, and budget amounts for each reporting period in the budget. There’s a separate row for each account and dimension combination being budgeted.

Except for the budgeted amounts, all the information in the spreadsheet must match exactly with what’s in Intacct:

  • BUDGET_ID: This must match a budget ID defined on the Budgets repository page (Budgets > All > Budgets repository).
  • ACCT_NO: These must match GL accounts defined on the Accounts page (General Ledger > All > General Ledger accounts).
  • Dimensions: Any dimension ID must match one defined on the applicable dimension page (listed under Reports > Setup > Dimensions). For example, any ID in the LOCATION_ID column must match a location ID defined on the Locations page.
  • Reporting periods: In the columns for reporting periods, each heading must match a reporting period name defined on the Reporting Periods page (Reports > Setup > Reporting periods).

Create a budget manually

The Budget Information page is where you create a unique ID—called a Budget ID—for a budget to which you plan to add data.

If you’re new to creating budgets, we recommend that you start by reviewing the information in Before you create a budget and Create budgets. You’ll learn the different ways to create and manage budgets and get recommendations and resources that can help you get started more quickly.

Manually creating a budget allows you to enter budget data for each account one-by-one, month-by-month. Manual budget creation is useful if you’re adding budget data for only some of your accounts.

Manually entering budget data is a multi-step process:

  • Create a new budget and give it a unique Budget ID.
  • Add account information to your budget.
  • Enter budget amounts for your accounts.

Step 1: Create a new budget and give it a unique Budget ID

Before you can upload a budget spreadsheet or manually enter budget data, you must first create the budget.

  • Go to Budgets > All > Budgets and select
  • Add (circle)
  • next to the Budgets repository.
  • Enter a Budget ID.
    Best pra ctice is to give the budget an ID that does not reference a particular fiscal year or date. Then you can append new time periods to your existing budget.
  • Enter a Description for the budget.
  • Select Create a new budget.
  • If this will be a single currency budget, select the checkbox and enter a consolidated currency.
  • If this will be the default budget, select the Default budget checkbox.
  • Select Save.

Step 2: Add account information for your budget

After you’ve created your budget ID, you’re ready to add budget data for your accounts. When you’re manually adding budget data, you can only enter data for only 1 account at a time.

If you’re tracking budget data at the dimension-level, such as tracking data for different departments and locations, you’ll need to add multiple entries for each account. For example, if you’re entering Travel Expense data for 3 locations, you’ll need 3 entries for this account.

  • Go to Budgets > All > Budgets > Budgets repository.
  • Find the budget and select Budget details.
  • Select Add.
  • On the Budget amount details page, select the Account.
  • Optionally, select dimensions for your budget data.
    For example, if you’re entering budget data for a particular location, select the Location.
  • Use the Periods from date and Periods to date fields to select reporting periods for the budget.
    You can select a single period or a range of periods.
  • Select Show periods to display the reporting periods.
    When you select Show periods, the page refreshes to display both the reporting periods you can include in the budget along with fields for entering individual amounts.
  • If no reporting periods display when you select Show periods

Step 3: Enter budget amounts

There are 2 ways to assign a budget amount to a reporting period. You can enter the amounts manually or you can have the amounts computed for you based on a prior period.

Enter amounts manually

  • Select the checkbox to the left of the Reporting period to use it in the budget.
  • Enter amounts into the Budget amount fields for each budget period.
  • Optionally, add a note about the budget or budget amount.
  • Select Save.

Automatically compute budget data based on amounts from a past period

  • Select the period that you want to use as the starting point for the calculation from the Past period dropdown list.
  • In the Grow by field, enter a percentage or dollar amount.
  • Select either Percent or Amount.
  • Select a method from the Based on dropdown list. You can base the calculation on actual data, budget data, or employee count. The choices are described in the following table. To add reporting periods to your budget, select the checkbox for the Reporting periods on the lower part of the page.
  • Select Compute to calculate the amounts for the selected periods.
  • Select Save.

If you’re trying to view budget data, such as the amounts entered for specific accounts, select Budget details next to the budget on the Budgets list. Or use Export to export the budget data in spreadsheet format.

Edit budget details for a specific account

The Budget Accounts Information page lets you manually edit or view account-level budget data, or add new budget data for an account.

After a budget for an account is saved, you can edit:

  • Period from and period to dates
  • Based on, grow by, and compute amount

If you assigned the amount to a particular dimension, such as department, and determine that the wrong dimension was assigned, you have two choices:

  • Reset the budget amount to zero (0).
  • Delete the old account budget and create a new account budget with the correct dimension assignments. Delete only the budget period for the account, not the entire budget, or budgets for other accounts.

To zero out account budget detail:

  • Go to Budgets > All > Budgets repository > Budget details and select Budgets.
  • Select Edit on the Budget amount details for the account that you want to change.
  • Select Zero out.
  • Save your changes.

To delete the account budget:

  • Go to Budgets > All > Budgets repository > Budget details.
  • Find the budget and select Delete.

View the budget for an account

Only a few of the specific details for a record can be shown in the list columns.

Select View. The record details appear. If the record is complex, the details are categorized into sections and tabs.

Delete a budget

Carefully consider the implications before you delete a budget. After you delete a budget, you’ll no longer be able to use its data to create future budgets, and it can no longer be used in financial reports.

You can delete any budget, as long as it’s not being used by a financial report and it’s not the default budget.

  • To delete a budget that’s used by a financial report, you must first modify the report and remove the Budget ID.
  • A default budget cannot be deleted. First make another budget the default budget. Default budgets are always set at the top level.

To delete a budget:

  • Go to Budgets > All > Budgets repository.
  • Find the budget.
  • Select Delete.

Check out our Free Additional Articles