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.

  1. 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.

  2. From the Format Cells dialog, select Custom from the Category panel.

  3. In the Type field, enter 00 (two zeros) then click the OK button.

  4. Re-import the Budget Upload Template when all errors have been corrected.

  5. You should also ensure that all required year/periods have been created.