03333 445950
 |
 |
 |
Making I.T. Happen
Accounting and Information Technology, Assistance and Support
Nominal Records
The field order is specified below, for users using a spreadsheet to prepare data we have also included column letters.
| Field | Description V11- | Description V12+ | Notes | |
| 1 | A | Account Reference | Account Reference | This must be just the Numbers 0 to 9
You can not have any spaces,
NB Excel may strip leading zeros, make sure you set the cell type to "text" to avoid this. |
| 2 | B | Account Name | Account Name | |
| 3 | C | Year Budget | Year Budget | |
| 4 | D | Budget Month 1 | Budget Month 1 | |
| 5 | E | Budget Month 2 | Budget Month 2 | |
| 6 | F | Budget Month 3 | Budget Month 3 | |
| 7 | G | Budget Month 4 | Budget Month 4 | |
| 8 | H | Budget Month 5 | Budget Month 5 | |
| 9 | I | Budget Month 6 | Budget Month 6 | |
| 10 | J | Budget Month 7 | Budget Month 7 | |
| 11 | K | Budget Month 8 | Budget Month 8 | |
| 12 | L | Budget Month 9 | Budget Month 9 | |
| 13 | M | Budget Month 10 | Budget Month 10 | |
| 14 | N | Budget Month 11 | Budget Month 11 | |
| 15 | O | Budget Month 12 | Budget Month 12 | |
| 16 | P | Prior Year Month 1 | Prior Year Month 1 | |
| 17 | Q | Prior Year Month 2 | Prior Year Month 2 | |
| 18 | R | Prior Year Month 3 | Prior Year Month 3 | |
| 19 | S | Prior Year Month 4 | Prior Year Month 4 | |
| 20 | T | Prior Year Month 5 | Prior Year Month 5 | |
| 21 | U | Prior Year Month 6 | Prior Year Month 6 | |
| 22 | V | Prior Year Month 7 | Prior Year Month 7 | |
| 23 | W | Prior Year Month 8 | Prior Year Month 8 | |
| 24 | X | Prior Year Month 9 | Prior Year Month 9 | |
| 25 | Y | Prior Year Month 10 | Prior Year Month 10 | |
| 26 | Z | Prior Year Month 11 | Prior Year Month 11 | |
| 27 | AA | Prior Year Month 12 | Prior Year Month 12 | |
| 28 | AB | Year 2 Month 1 | ||
| 29 | AC | Year 2 Month 2 | ||
| 30 | AD | Year 2 Month 3 | ||
| 31 | AE | Year 2 Month 4 | ||
| 32 | AF | Year 2 Month 5 | ||
| 33 | AG | Year 2 Month 6 | ||
| 34 | AH | Year 2 Month 7 | ||
| 35 | AI | Year 2 Month 8 | ||
| 36 | AJ | Year 2 Month 9 | ||
| 37 | AK | Year 2 Month 10 | ||
| 38 | AL | Year 2 Month 11 | ||
| 39 | AM | Year 2 Month 12 | ||
| 40 | AN | Year 3 Month 1 | ||
| 41 | AO | Year 3 Month 2 | ||
| 42 | AP | Year 3 Month 3 | ||
| 43 | AQ | Year 3 Month 4 | ||
| 44 | AR | Year 3 Month 5 | ||
| 45 | AS | Year 3 Month 6 | ||
| 46 | AT | Year 3 Month 7 | ||
| 47 | AU | Year 3 Month 8 | ||
| 48 | AV | Year 3 Month 9 | ||
| 49 | AW | Year 3 Month 10 | ||
| 50 | AX | Year 3 Month 11 | ||
| 51 | AY | Year 3 Month 12 | ||
| 52 | AZ | Year 4 Month 1 | ||
| 53 | BA | Year 4 Month 2 | ||
| 54 | BB | Year 4 Month 3 | ||
| 55 | BC | Year 4 Month 4 | ||
| 56 | BD | Year 4 Month 5 | ||
| 57 | BE | Year 4 Month 6 | ||
| 58 | BF | Year 4 Month 7 | ||
| 59 | BG | Year 4 Month 8 | ||
| 60 | BH | Year 4 Month 9 | ||
| 61 | BI | Year 4 Month 10 | ||
| 62 | BJ | Year 4 Month 11 | ||
| 63 | BK | Year 4 Month 12 | ||
| 64 | BL | Year 5 Month 1 | ||
| 65 | BM | Year 5 Month 2 | ||
| 66 | BN | Year 5 Month 3 | ||
| 67 | BO | Year 5 Month 4 | ||
| 68 | BP | Year 5 Month 5 | ||
| 69 | BQ | Year 5 Month 6 | ||
| 70 | BR | Year 5 Month 7 | ||
| 71 | BS | Year 5 Month 8 | ||
| 72 | BT | Year 5 Month 9 | ||
| 73 | BU | Year 5 Month 10 | ||
| 74 | BV | Year 5 Month 11 | ||
| 75 | BW | Year 5 Month 12 |
The Custom integration & import tool will allow you to have fields in any order and extract them from formats other than CSV.
