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 actuals 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.

Create a budget from Sage Intacct data (6:49)

For more videos, visit the Video Hub in the Sage Intacct Planning Help Center.

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.

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

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:

Object	Fields taken
Company information Company > Setup > Configuration > Company	Name (General information tab) First fiscal month (Accounting tab) Base currency (Accounting tab)
Accounts General Ledger > All > Accounts	Account number Title Account type Category (if applicable)
Dimensions Reports > Setup > Dimensions > Any dimension you choose to include in your budget	ID Name Hierarchy
Employees Expenses > All > Employees	Name ID Title Start date and End date (if available) Assigned dimensions Salary (Cost rates tab) We recommend using employee headcount information from Intacct only if it is up-to-date and reliable. If you do not use Intacct to track your employees, it's better to import the information from Excel into Budgeting and Planning, or enter it manually.

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

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.

Learn more

To learn more about using Sage Intacct Planning features, such as financial modeling, forecasting, and building scenarios, go to the Help Center.