03333 445950
Home
Up

                                

 

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.

 


Home Main site Contact Terms

Accounting, Pay as you go Sage 50 Support, Sage 50 Links to applications, 3rd Party integration and more!

This Sage 50 import website is copyright © Making I.T. Happen 2017