Importing Forecasting Detail Values

You can import forecasting detail values from a .csv file on the Forecasting Detail page.

Note When Month End or Income/Expense values are imported, the minimum remaining balances for balance sheet accounts that have cash flows turned on are used if a month-end balance is imported that is below that amount. Changes made to accounts through the import process are captured in the Audit Trail view.

Select Forecasting > Detail from the menu.
The Forecasting Detail page opens.
Select Import.
The Import page opens.
Select Upload CSV.
Find and select the .csv file to upload.
Select Open.
Select Month End or Income/Expense for the Data Type to import.
Select Time Frames to import.
1. Select the Calendar to open the Select Time Frames dialog box.
2. Select individual consecutive months to include or select All to select all months.
3. Select Apply.
Enter a column position for Organization ID, if applicable.
This field is only available if the chart of accounts is non-global.
Select GL # or Account Name for the Account Link.
Enter a column position for GL#/Account Name.
Enter a column position for each month for Month End or Income/Expense based on your previous selection.
Select Save to import the file and return to the Forecasting Detail page.