Below is a description of the Spire Fields for this Import. 

Please refer to the User Manual for more information on how to do Imports.


Spire 3.11 Fields
Explanation
Example
Account No (Required)GL Account No11120
NameName of GL AccountBank
Division CodeDivision Code000
CurrencyCurency 3 digit codeCAD
RevalueT to check this box, F to leave blankT
Group (Required)Existing predetermined 3 digit Group110
SubgroupExisting created Subgroup180
TypeAsset = A, Expense = E,Liability = L, Revenue = R (If the Type does not match the Group it will not be updated)
A
Bank AccountT to check this box, F to leave blank
T
Next Cheque No.Next cheque number for bank GL accounts1001
Sales AccountT to check this box, F to leave blank
F
DesignationNormal balance for the account
C = Credit D = Debit
D
Prompt for job costNot in use, to be removedN/A
InactiveT to check this box, F to leave blank
F
Opening balanceOpening balance
12000
Opening foreign balanceOpening foreign balance8900
Last year budget - 1Last year, first period budget1000
This year budget - 1This year, first period budget1000
Next year budget - 1Next year, first period budget1000
This year forecast - 1This year, first period forecast12000
Last year foreign budget - 1Last year, first period foreign budget900
This year foreign budget - 1This year, first period foreign budget900
Next year foreign budget - 1Next year, first period foreign budget900
And so on to Period 13