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
Customer No (Required)Customer NoABC123
Transaction Type (Required)Invoice = I, Payment = P,
Credit Memo = C, Debit Memo = D, Service Charge = S, Write Off = W
I
Transaction Date (Required)

Date in one of the formats from the Date Format drop down

(yyyy-mm-dd, yyyy/mm/dd, mm/dd/yyyy, dd/mm/yyyy, mm/dd/yy, dd/mm/yy)

01/01/2024
Total (Required)Total of the Invoice, Payment, Credit Memo, Debit Memo, Service Charge or Write Off100.00
SubtotalSubtotal (before taxes) of the Invoice, Payment, Credit Memo, Debit Memo, Service Charge or Write Off
95.24
Payment AccountPayment GL Account11120
MemoMemo
For Postage
Reference NoReference No such as Invoice No
1001
Exchange RateExhange Rate for foreign currency0.75
Sales Tax 1Sales Tax 1 Amount4.76
Sales Tax 2Sales Tax 2 Amount4.76
Sales Tax 3Sales Tax 3 Amount4.76
Sales Tax 4Sales Tax 4 Amount5.76
Terms CodePayment Terms CodeCOD