Why integrate with Sage Intacct?

With the integration between Sage Intacct Planning (SIP) and Sage Intacct, you can easily and quickly share data between the two applications to:

  • Build a new budget in SIP based on your Sage Intacct data.

  • Import actuals from Sage Intacct to SIP to create your budget versus actuals comparison and forecasts.

  • Export a budget from SIP to Sage Intacct to create reports and use in Spend Management.

Looking for details on how to use the integration? Go to Create a budget using my Sage Intacct data or watch the video Introduction to Sage Intacct Planning (SIP).

How does the integration work?

All integration processes are initiated from SIP. The integration is built based on the Intacct API and is bi-directional, which means you can send data from Intacct to SIP, and vice versa. Given that the two applications aren't automatically synced, you must run the integration to exchange data.

💡 You can use your SIP user to connect to different Intacct companies.

Does the integration require setup?

In SIP, no setup is required. In Sage Intacct, you will need to follow two simple steps to enable it. For more information, go to Configure the Sage Intacct integration.

Who needs access to which application?

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

Budget owners also need List, View, Add, and Edit permissions in Intacct for permissions on the integration list:

  • Company information

  • GL accounts

  • Relevant dimensions

  • Employees

  • Budgets

  • Reporting periods

Which data is shared between the applications?

Different data is shared between SIP and Intacct depending on the task at hand.

📝 All dimensions, other than the employee dimension, are supported in SIP.

Create a new budget in Sage Intacct Planning (SIP)

When you create a new budget in SIP, you can choose to 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 for you between Intacct and SIP. The data imported into SIP using the integration includes:

  • Company information (Name, First fiscal month, Base currency)

  • Accounts (Account number, Title, Account type, Category (if applicable))

  • Dimensions (ID, Name, Hierarchy)

  • Employees (Name, ID, Title, Start date & End date (if available), Assigned dimensions, Salary)

Import actuals to Sage Intacct Planning (SIP)

When you import actuals, you actually take a snapshot of your financials from Intacct and share it with SIP to compare the budget you created against your actuals. The data SIP takes during import includes:

  • Accounts

  • Monthly amounts

  • Dimensions

📝 If you have accounts and dimensions in Intacct that don't exist in SIP, you will automatically be prompted during the import process to map these new accounts and dimensions in SIP.

Export a budget to Intacct

When you export a budget from SIP to Intacct, you create an entirely new budget record to hold all your new budget data. During this process, SIP creates and includes the following information in your new budget:

Created:

  • New budget record

  • If necessary, budgetable reporting periods

Included in budget record:

  • Accounts

  • Dimensions

  • Budget amounts

  • Reporting periods

📝 If you have included accounts and dimensions in your budget that don't exist in Intacct, SIP will automatically prompt you to map these new accounts and dimensions to existing ones during the export process.

How do we map the data between the applications?

SIP includes mapping tables that let you define how accounts and dimensions from SIP should map back to accounts and dimensions in Intacct. Furthermore, whenever you use the integration, SIP automatically detects new accounts and dimensions, and prompts you to map them, so that your data is always complete.

Did this answer your question?