There are two sections to this article. The first covers how to create the nominal budget template, the second how to use it to upload revisions to a budget.
To create the Nominal Budget template:
In Excel, select the Access tab.
Click Templates, Setup Update Template. The 'Choose your data connection' page appears.
Note: With AOI v5.14.9 or earlier just click Setup Update Template.Use the Data Connection drop-down and select the database to upload budgets to. Click Next.
Click the arrow next to Nominal Ledger to expand the list.
Select Nominal Budgets. Click Next.
Drag Nominal Code from the Available Fields list into the Column Fields list.
Select Nominal Code, click Set Range. The 'Choose column range for Nominal Code' window appears.
On the Excel sheet, drag to select a cell range i.e.from B7 to B12. In the 'Choose column range for Nominal Code' window, click confirm icon.
If you expand Nominal Code, you can also add the Account Name field by clicking on it and using the Set Range to put it beside the Code.
If you do this then it will be necessary to ensure that the Period Range does not overlap with the Account Name.
Repeat the steps 6 to 8, dragging Period to the Row Fields list and selecting a range (i.e. C6 to G6, which needs to be on same row as the Nominal Code column header), dragging Year to the Single Cell Fields list and selecting a cell i.e. E2, and finally dragging Revision and selecting a cell i.e. G2).
In the Row Fields list, select Period. Click Default Value. The 'Default values - Period' window appears.
Select the numbers of the periods required. Click OK.
Repeat steps 10 and 11 to set the default values for Year and Revision. The highest revision number used will be the budget and any lower numbers will be forecasts.
Click Next.
If filtering is required, use the drop-down and select the element required. Use the next drop-down to select the operator. Enter the value required. Click Add. Repeat to add other filters, using the And, Or, And (, and Or ( options as required.
Click Next.
If required, select Add column totals, Add row totals or Save Template and enter a name.
Click Insert.
A dialog will appear about extending the cell range.
Click Yes. Another dialog will appear about extending the cell range.
Click Yes. A processing dialog will appear.
Using the Nominal Budget Upload Template:
The existing budget figures will be pulled through, these will show in blue.
Check the Year and Revision number are correct.
To change a budget, replace the existing value in the cell with the new value required.
Before Updating, check the settings. On the Access tab, Excel Templates section, use the drop-down below Refresh and select Selected Cells or the Entire Template.
If you want to review the update before committing it, click Review.
Select the cells to update (if applicable).
Click Update. A review screen may appear where it is possible to check the proposed changes.
For any records which are incorrect untick the box on the left of the row.
Once correct, click Update.
A dialog appears showing progress and the cells updated will change colour from blue to green.