Forecast Upload

April 17, 2019 in General Ledger

Purpose

This procedure is used to upload and update the forecast details from a file created outside of the system. Since General Ledger financial forecasts are mostly made up of the estimated movements for each account for each month of the year, it is often easier to enter this detail in via a spreadsheet like input program and then upload it to the system for use as a Budget or Forecast to Actual GL movements and balances.

For additional details on creating upload files, see the note HERE.

Data Input

­

Step 1 – File Upload

Forecast Upload File

Select the spread sheet file you wish to upload, by clicking Browse. The file with the forecast data to upload must be accessible from the workstation/PC you are logged into the OA system from.

Forecast

Enter the forecast code, for which you wish to upload the details to. This must be an existing forecast that you have established on the system for use with these new forecast figures.
Return to the Top
­

Step 2 – Review Details

The forecast details of the spread sheet are displayed in the basic column format expected so you can review and confirm that you have selected the correct file for upload. Click Submit to submit all the details.
Return to the Top
­

Spread sheet format

The spread sheet must be in a csv format.

The first row of the spread sheet must be a heading row – it does not matter what the headings are, as long as they are meaningful to you e.g. you could have ‘Account’, ‘Chart of Account’ or ‘GL Code’. Columns for all 12 months forecast must be present – even if you are not filling up for all the months. An individual month can be left blank – you do not need to enter zero for anything without a forecast figure as it is assumed. The columns required are:

Column Name Additional Details
A Chart of Account Code Must be a valid account on the Chart of Account Master file. This column cannot be left blank.
B Branch Code Must be a valid branch on the Branch Master file. This column cannot be left blank.
C Division Code Must be a valid division on the Division Master file. This column cannot be left blank.
D Fiscal Forecast Month 1 Must be a numeric value, whole numbers only.
E Fiscal Forecast Month 2 Must be a numeric value, whole numbers only.
F Fiscal Forecast Month 3 Must be a numeric value, whole numbers only.
G Fiscal Forecast Month 4 Must be a numeric value, whole numbers only.
H Fiscal Forecast Month 5 Must be a numeric value, whole numbers only.
I Fiscal Forecast Month 6 Must be a numeric value, whole numbers only.
J Fiscal Forecast Month 7 Must be a numeric value, whole numbers only.
K Fiscal Forecast Month 8 Must be a numeric value, whole numbers only.
L Fiscal Forecast Month 9 Must be a numeric value, whole numbers only.
M Fiscal Forecast Month 10 Must be a numeric value, whole numbers only.
N Fiscal Forecast Month 11 Must be a numeric value, whole numbers only.
O Fiscal Forecast Month 12 Must be a numeric value, whole numbers only.

Return to the Top
­

Updating

Once you click submit, the rows on the entire upload file are validated. If no invalid data is detected, the details are updated to the forecast selected. If there are issues they will be reported and you need to adjust the source file before attempting to upload again.
Return to the Top

{ 0 comments… add one now }

Ask a Question or Leave a Comment

Previous post:

Next post: