Dealing with Invalid Year/Period when Importing a Budget
This is caused by periods being entered in the Budget Upload template as single figures rather than having preceding zeros.
-
To correct this, highlight the entire column by clicking on the letter at the top of the column then right-click and select Format Cells from the drop-down menu.
-
From the Format Cells dialog, select Custom from the Category panel.
-
In the Type field, enter 00 (two zeros) then click the OK button.
-
Re-import the Budget Upload Template when all errors have been corrected.
-
You should also ensure that all required year/periods have been created.