Last updated: September 21, 2022
Importing actuals from Sage Intacct lets you compare your budget with your actuals and easily share your budget versus actual results with your colleagues. The easiest and most beneficial way to import your actuals from Intacct is to use the integration from SIP. With the integration:
Actuals can be imported into Profit & Loss (P&L), cash, balance sheet, and statistical data reports.
Actuals are imported as monthly totals into P&L accounts, total cash balances into cash reports, end-of-month balances into balance sheet accounts, and statistical accounts according to their reporting type.
📝 P&L and statistical accounts can be divided by dimension.
Actuals can be filtered by dimension values so that you import only the relevant actuals data.
To import your actual amounts from Intacct to SIP:
1. Click the Connect to Sage Intacct icon on the menu bar:
2. Sign in using your Sage Intacct credentials and click Next:
3. Choose Import actuals and click Next:
4. Select which reports (P&L, Cash, Balance sheet, Statistical data) you'd like to import and click Next.
5. By default, actuals are imported from Intacct for the entire company. However, you can import only what's relevant by filtering actuals based on dimension and dimension values. Only the actuals data containing the dimension value that you select is imported.
For instance, to import actuals by multiple dimensions, the actuals data must contain the combination of all the dimension values you selected in the filter. If one of these conditions is not met, the actuals with incomplete data are not imported. So, if you select the dimension Department X and Product Y, but the actuals data does not contain the product dimension value Y, then the actuals data is not imported. If you select Department X and Department Z with Product Y, then the actuals containing either Department X and Product Y, or Department Z and Product Y (or both) are imported.
Additionally, if you choose the No Project dimension value, then the actuals with either of the dimension values you selected, or those with no Project value at all, are imported.
6. Actuals are imported from reporting books defined in Intacct, such as ACCRUAL, CASH, consolidation books, and user-defined reporting books.
The Select reporting book window is displayed and the default reporting book used by your company is automatically displayed in the Reporting Book field. If you prefer to import your actuals from different reporting books, choose additional reporting books from the Additional books dropdown, or you can overwrite the Main reporting book value. If you choose No book as the main reporting book, select an additional reporting book (or books) from the Additional books dropdown.
7. Select a date range and click Next.
8. If there are no new accounts or new dimensions in Intacct since the last time you connected, your actuals amounts will be imported. Otherwise, the accounts are identified and you’re prompted to map them to budget lines in SIP.
Click Finish and you're done!
You can now review your budget versus your actuals in the Sheets view, or edit them in the Actuals tab. Otherwise, go on to the next section.
Import actuals for new accounts and dimensions
When actuals are imported from Intacct, all of your accounts and dimensions are automatically checked for mapping into SIP. These mappings are saved under the Actuals → Mapping tab. (For more explanation, see Map your Sage Intacct accounts and dimensions to your budget in SIP.)
If new accounts and dimensions in Intacct are found during the import, or there are accounts and dimensions that haven't been previously mapped into your budget, you are prompted to map them. Your selections are then saved to the mapping tables. This way, when you import actuals in the future, you won't be prompted to map them again.
Map new accounts
When actuals are imported, if an account isn't mapped in SIP, a list of new accounts requiring mapping is displayed.
For each new account requiring mapping, the following information is displayed:
Account — The account number appearing in Intacct.
Type — The account type can be either P&L or balance sheet according to the account type that appears in Intacct.
Mapping type — The following options are available:
Single budget line (default) — Actual amounts are imported to a single budget line in SIP.
Multiple budget lines (available only for P&L account types) — Actual amounts can be split across multiple budget lines according to the dimensions you choose.
Same as account — Copy the dimension and budget line selections from another account (displayed in the dropdown list) in the accounts table.
No mapping —Actuals in this account are imported, but won't be mapped to any budget line.
Budget lines — Map your accounts to a budget line from the dropdown list of budget lines that appear in SIP. If you've chosen No mapping, the budget line field remains blank.📝 The same budget line can be selected for more than one account.
First select a Mapping type, and then the associated Budget lines. If you select Multiple budget lines as the Mapping type for a P&L account, you can select one or more dimensions from the dimensions you have in your budget.
📝 All of the new accounts must be mapped to proceed.
Map new statistical accounts
When you import actuals of statistical accounts that aren’t mapped in SIP, a list of new accounts requiring mapping is displayed.
For each new statistical account requiring mapping, the following information is displayed:
Account — The account number that appears in Intacct with the number or symbol, dash, and account description.
Mapping type — The following options are available:
Single model line (default) — Actual amounts are imported to a single model line in SIP.
Multiple model lines — Actual amounts can be split across multiple model lines according to the dimensions you choose.
No mapping —Actuals in this account are imported, but won't be mapped to any model line.
Model lines — Map your accounts to a model line from the dropdown list of model lines that appear in SIP. If you've chosen No mapping, the model line field remains blank.
Map new dimensions
Mapping dimensions is only required if you need to map actuals using a budget dimension that isn't already mapped to a dimension in Intacct. You will be prompted to map dimensions if:
You've selected to import P&L or statistical actuals.
There are dimensions selected for mapping purposes in the accounts table in SIP (in accounts where the mapping type is Multiple budget lines).
The accounts in which the dimension is selected for mapping are active and have actuals for the selected time period for import.
There are missing dimension or dimension value mappings.
📝 The dimensions must be mapped to proceed.
A list of new dimensions requiring mapping is displayed:
For each new dimension requiring mapping, the following information is displayed:
Budget dimension — The budget dimension in SIP
Maps to — The dimension appearing in Intacct
Map new dimension values
You will be prompted to map new dimension values only if:
The dimension value belongs to a dimension that was selected for mapping actuals purposes.
The dimension value has actuals for the selected time period for import.
The dimension value isn't mapped to a budget dimension value (in the dimension mapping table).
A list of dimension values from Intacct which require mapping is displayed:
For each new dimension value requiring mapping, the following information is displayed:
Sage Intacct value — The dimension value appearing in Intacct. The name of the value is displayed and the ID in parenthesis.
Budget dimension — The budget dimension in SIP to which the dimension from Intacct is mapped.
Budget dimension value — The budget dimension value in SIP to which the dimension value from Intacct is mapped.
Review your accounts
When you add transactions using the Import actuals wizard, all related transactions are automatically added to the Actuals > Details tab in SIP.
Additionally, when you add transactions using the Import actuals wizard and select to include statistical accounts, all selected accounts are added to the Actuals > Mapping > Accounts > Statistical tab.
For related articles, see:
Map your Sage Intacct accounts and dimensions to your budget in SIP
Statistical accounts in Sage Intacct Planning (SIP)