Budgeting with Sage Intacct Planning

Keywords:   Intacct, Management, 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!

Budgets And Spending

Budgeting with Sage Intacct Planning

The Sage Intacct Planning application offers a simple, affordable, yet powerful cloud-based solution. You can streamline the entire budgeting cycle in one place, from budget creation to sharing and reviewing to forecasting.

About Sage Intacct Planning

Budgeting and planning for midsize companies comes with a number of challenges, including:

  • Keeping multiple versions of a spreadsheet
  • Emailing the spreadsheet around for approval and feedback
  • Forecasting for the future, all year long

In response, Sage Intacct Planning offers a simple, affordable, yet powerful cloud-based solution. Use Sage Intacct Planning to streamline the entire cycle in one place, from creation to sharing and reviewing to forecasting.

Key features

To support a continuous budgeting and planning cycle, Sage Intacct Planning boasts a number of features to extend your functionality, including:

  • Full and partial budget sharing: Build your basic budget structure. Then share parts of the budget with different team members, such as department or location managers, to collaborate and let them enter their own budget lines. When finished, send the entire budget for review and get feedback right in the budget.
  • Sage Intacct integration: Easily pull in your Intacct data while creating your budget, including fiscal year, accounts, dimensions, and headcount information. Import actuals to use for comparison, and export your final budget back into Intacct.
  • Financial models with formulas: Create formulas for budget assumptions with financial models and save them to your models library. Share these financial models with budget reviewers to show them how you’re calculating your numbers.
  • What-if scenarios: Build any number of scenarios to use as a basis for different budget proposals. Compare scenarios against each other or against your budget and use the insight to develop a budget that’s right for your company.
  • Forecasts and versions: Plan for the future after you’ve created your budget. Build and save forecasts as different versions. Compare forecast versions against each other or your budget to see how your estimates compare.

Basic budgeting vs. Sage Intacct Planning (with budgets)

Sage Intacct Planning is an intuitive cloud planning solution that eliminates your reliance on uncontrolled, inflexible, unsecure spreadsheets and replaces them with a real-time single source of financial truth for agile and confident decision-making.

The table below describes key feature differences between basic budgeting, which comes standard with Intacct, and Sage Intacct Planning.

What do I need?

Basic budgeting supports the most fundamental functionality needed when creating a budget. You create a budget in an external spreadsheet application, such as Microsoft® Excel, and then import the spreadsheet into Intacct for use. This solution is recommended for companies with simple budgeting needs.

In contrast, Sage Intacct Planning has features that extend budgeting and planning capabilities to support a year-long, continuous budgeting and planning cycle. This solution is especially useful for companies who need to collaborate on a budget and manage budget lines with multiple department heads or business unit owners. It’s also recommended for companies who need more functionality to support a complex budgeting and planning process.

Workflow comparison

Not only does Sage Intacct Planning offer additional features to support more complex business needs, but it also simplifies the process of creating a usable budget.

Though creating a budget is simplified and expanded with Planning, using a budget in Intacct remains the same. You can still report on the budget, compare your budget against your actuals, and enforce spending limits with Spend Management.

If you start out with basic budgeting, you can always grow into Sage Intacct Planning and subscribe later at any time.

Create a Sage Intacct Planning account

When you initially subscribe to Sage Intacct Planning, you’ll need a Sage Intacct Planning account and you’ll need to integrate it into Sage Intacct.

You cannot sign up for an account yourself. Your company administrator grants you access.

Admins: To grant users access

Only administrators designated as company owners can grant users access to Sage Intacct Planning.

  • If you have access to multiple budgets of 1 or more companies, select the relevant company from the company dropdown you want to manage and allow user access.
  • From the upper-right corner of the toolbar, select your user profile and select Administration.
  • From the User tab, select Add new user.
  • Enter the user details (email, name, and user status).
  • To grant the user Company owner status, select Owner.
    There can be 2 company owners. To change the company owner, select the user from the Users list and clear Owner.
  • Save your selections to add the user to the Users list.
  • From the user profile menu, select My budgets to return to your budget.

Users: Sign up

After your administrator grants you access to Sage Intacct Planning, you’ll receive an email with access information. This includes the login URL and a temporary password.

Log in and create your permanent password. You’ll need these when logging into Sage Intacct Planning.

Connect Sage Intacct Planning

Connect Sage Intacct Planning with Sage Intacct to navigate more easily between the two.

For example, when you’re viewing a report that includes budget figures, such as a financial statement, you can drill down into the budget figure. This opens the underlying Budget report view.

From there, you’re connected to Sage Intacct Planning. Using your Sage Intacct Planning credentials, you can access the application and immediately see the related budget sheet in context. This is great for users who need to reconcile the underlying budget assumptions versus actual performance.

Not sure if you subscribe to Sage Intacct Planning? Ask your admin or contact your account manager.

Configure the connection

To configure the connector from Sage Intacct to Sage Intacct Planning, simply turn it on. There’s no additional subscription charge, because you must already own Sage Intacct Planning to turn it on.

  • Go to Company > Admin > Subscriptions.
  • Find Sage Intacct Planning Reporting drill-through connector.
  • If the application is not already active, move the slider to turn it on.
    The slider appears green when the application is turned on.

User requirements

After the integration is turned on, users need a company ID, user ID, and password to use Sage Intacct Planning. Sage Intacct Planning is not supported in Preview or sandbox companies.

Use Sage Intacct Planning with Sage Intacct

Sage Intacct Planning has a built-in, bidirectional integration with Sage Intacct, which you can use to quickly and easily share data between the two applications.

  • Build a new budget in Planning based on your Sage Intacct data (chart of accounts, dimensions, and more).
  • Import actuals from Intacct to Planning to create your budget versus actual comparison and forecasts.
  • Export a budget from Planning to Intacct to create reports and use in Spend Management.

Check out the video below for a quick overview. It demonstrates using the wizard to select dimensions and use them to build a budget structure, merge multiple accounts into one budget line, populate your budget from actuals, and more.

Workflow

Sage Intacct Planning not only streamlines the budget creation workflow by ditching manual spreadsheets, it also expands functionality to include a share, review, and update process to support collaboration. However, using a budget in Intacct remains unchanged. Create budget in Planning

  • Reporting
  • Budget vs. Actuals
  • Spend Management

Integration details

Different information is shared between Planning and Intacct depending on the task that you’re working on.

  • Use Intacct data to create a new budget in Planning
  • Import actuals to Planning
  • Export a usable budget to Intacct

All Intacct dimensions are supported in Budgeting and Planning besides the employee dimension. Furthermore, dimensions in Sage Intacct Planning use the same terminology your company uses.

Use Intacct data to create a new budget in Sage Intacct Planning

When you create a new budget in Planning, you can import your Intacct data into your new budget, which provides the quickest way to create a budget. It is also the most effective method in terms of importing actuals or exporting a budget because a data map is automatically created between Intacct and Planning for you. The data that’s imported into Planning includes the following:

Import actuals to Sage Intacct Planning

When you import actuals, you’re taking a snapshot of your financials from Intacct and sharing it with Sage Intacct Planning to compare the budget you created against your actuals. During this process, Intacct shares the following information with Sage Intacct Planning:

  • Accounts
  • Monthly amounts
  • Dimensions

Export a usable budget to Intacct

When you export a budget made in Sage Intacct Planning to Intacct, you’re creating a whole, new budget record to hold all your new budget data. During this process, Planning creates and includes the following information in your new budget:

Created:

  • New budget record
  • If necessary, reporting periods to be used for budgeting

Included in the budget record:

  • Accounts
  • Dimensions
  • Budget amounts
  • Reporting periods

If your budget includes accounts and dimensions that do not exist in Intacct, you’re asked to map these new accounts and dimensions to existing ones during the export process.

Where do I make edits?

When you think of making edits to your budget, remember that data shared between Intacct and Planning is synced only when you initiate the sync. Anytime you decide to use the integration to build a budget structure or pull in actuals, the shared data is synced and up-to-date. For editing, this means you edit:

  • Budgets in Sage Intacct Planning
  • Actuals (accounts, dimensions, and so on) in Intacct

In addition, Planning includes mapping tables that let you define how accounts and dimensions in Planning map to accounts and dimensions in Intacct. When you use the integration to pull from or export data to Intacct, Planning automatically detects accounts and dimensions that do not exist in Intacct. Planning prompts you to map these items before you can finish the process.

Who needs access to which applications?

Users are separate for Sage Intacct and Sage Intacct Planning. Whether you need access to both applications depends on your use of them. Generally, only the main budget owner needs access to both Intacct and Sage Intacct Planning. Other stakeholders, such as budget reviewers and budget collaborators, only need access to Sage Intacct Planning when the budget is shared with them.

Budget owners also need a specific set of permissions in Intacct to use the integration:

  • Business user type
  • List, View, Add, Edit permissions to items on the integration list:
  • Company information
  • GL Accounts
  • Relevant dimensions
  • Employees
  • Budgets
  • Reporting periods

Multi-entity and multi-currency companies

Multi-entity companies: At this time, Sage Intacct Planning pulls in data from the top-level consolidation book. An option for book selection will be added in the future.

Multi-currency companies: You can create a budget in as many currencies as you want in Sage Intacct Planning. Simply set your own exchange rates in Sage Intacct Planning so that your budget amounts can be converted to your base currency.

Training: Sage Intacct Planning

Sage University provides training that you can take at your own pace. Our courses help you develop the skills and knowledge that you need to work effectively and efficiently in Sage Intacct.

The following learning objectives are designed to help new users get started quickly:

Before you start the training

To access Sage University, you need to log in to your Sage account. Your Sage account, which differs from your Intacct user name and password, uniquely identifies you across many Sage products and services including Sage University.

  • To connect to Sage University from within Sage Intacct, go to Help & Support, then select Sage University.
  • Log in with your Sage account email address and password, or select Create account at the bottom of the Login page if you do not have a Sage account.

Pause or resume a course

You do not need to complete a course in one session. You can pause and return to the course at any time.

  • Go to Help & Support > Sage University.
  • Select View my transcript.
  • Find your in-progress courses in your learning transcript list and select Open Curriculum.
  • Select Launch to resume a course.

Check out our Free Additional Articles