Work with statistical accounts

Statistical accounts, like P&L and Balance sheet data types, are visible in Planning across Actuals, Inputs, Reports, and more. You manage statistical accounts just like you manage all of your accounts from the Actuals > Mapping tab. As with P&L and Balance sheet data, you can also import statistical actuals data and use the actuals data for budget comparison in your Sheets view.

From the Actuals > Mapping > Accounts tab, you can add and view your statistical accounts in the Statistical tab. The accounts mapping table lets you map your statistical accounts to the model lines that appear in your budget.

For each mapped account, the following parameters appear:

Parameter	Description
Account	The account that appears in Intacct.
Account description	A description of the account received from Intacct.
Mapping type	The following options are available: Single model line (default) — Actual amounts are imported to a single budget line in Planning. Multiple model lines — Actual amounts can be split across multiple budget lines in Planning according to the dimensions you choose. No mapping — Actuals in this account are imported, but won't be mapped to any budget line in Planning.
Model lines (for Statistical)	Map your accounts to Model lines from the dropdown that appears in Planning. If you've chosen No mapping, the Model line field remains blank. You can't select the same model line for more than one account.
Reporting type	The following options are available: For the period — Reports the net change for the period, similar to how income and expense amounts are reported (Sum). Cumulative — Reports the balance of the account for the period, similar to how balance sheet amounts are reported (Last).
Dimensions	If you select Multiple model lines as the Mapping type, you can select one or more dimensions from the dimensions you have in your budget.

Keep in mind that mapping is unique for model lines and the same model line can’t be mapped more than once. So, after an account is mapped to a model line (or a few model lines), other accounts can’t be mapped to the same model line.

Additionally, if you choose to duplicate a statistical account line, the line in the mapping table is duplicated without a mapped model line. In this case, you need to manually map the line to a model line that appears in the dropdown.

Actuals > Details tab

The Actuals > Details > Model tab displays the transactions that are relevant to your general models and statistical accounts. After a transaction is added to the Model tab, the transaction can’t be moved to the P&L & Cash, and Balance sheet tabs.

The Unit type in a model transaction represents the unit of measure of your data. For example:

• Area in square feet

• Currency

• A number

• A decimal number

• A percentage

The Unit type value is determined by the model line to which you map your transaction.

If the transaction isn’t mapped, the Unit type remains empty. If you change the Unit type of the model line, the Unit type automatically updates in the Actuals > Details tab along with its calculations.

When the unit types have the same value for all Model transactions, such as the same currency, or a number or decimal number value, a total of the transactions appears at the bottom of the window. If the unit types are different or if they are percentages, then the total of the transactions doesn’t appear.

You can manually add transactions to your models or import model transactions from Excel from the Details tab.

Manually add model transactions

To manually add a single transaction:

1. From the upper-right corner of the Actuals > Details > Model tab, click + Add transactions and then + Add manually.
   When you manually add transactions, the transaction appears in the table of the tab you selected. For example, P&L & Cash, Balance sheet, or Model.

2. In the Model table, enter the Description of the transaction, the Account number that represents the model transaction or balance, the Month of the transaction, Amount, Unit Type, and Model Line mapping.

   Select or multi-select allows you to perform different actions on one or multiple transaction lines, such as duplicate, reverse, or delete.

Import model transactions from Excel

To import transactions from Excel:

1. Click Add transactions > Import from Excel. When you import transactions, the transaction appears in the table of the tab you selected. For example, P&L, Cash, Balance sheet, or Model).

2. Drag your Excel file to the upload window or click on the link to browse for the file.

3. Select either the Model transactions or Model balances template, depending on which type of transaction you want to import.

4. In the Setup, select your header row and title column and click Next.

5. In the Data-Columns, click on the dropdown of each data column you want to import, map to the correct column type, and click Next.

6. From the Data-Rows, select the lines of actuals you want to import. The Unit type of each transaction is determined based on the line to which the transaction is automatically or manually mapped.

7. Preview your data for import and make any relevant changes.

8. Click Import.

In the Inputs > Model tab, you can view your lines with Budget, Actuals, or Rolling data. If your budget has actuals, the Rolling view displays a combination of your actuals data and your budget in an updated view of the budget period. A sub-header for each month indicates if the column contains actuals or budget data.

Actuals > Summary tab

Use the Model tab from the Actuals > Summary tab to see a summary of your models and statistical accounts. Like in the Cash, P&L, and Balance sheet options, you have the option to click on the Actuals column of the months that have actuals, and select Close month, Remove column, or Exclude from forecast from the Model tab.

The statistical account tab that appears in the Inputs > Model view is displayed as a statistical accounts Model group at the end of the model list in the Actuals > Summary > Model tab. The models and models lines appear in an identical format to that of the statistical account tab in the Inputs > Model view.