You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close

Invoice Import Fields for Transaction Pro Online

TPro Field Name QBO Field Name Required Character Type Character Limit Notes
RefNumber Invoice no Y Alpha-numeric 21 The Reference Number is the Invoice Number, but it also is how TPro and QBO know which detail rows belong on the same transaction. Import must be sorted  by this column prior to importing. 
Customer Customer Y Alpha-numeric 100 If importing a sub-Customer or Project, must include the full name. See this article for more info.
TxnDate Invoice date N Date N/A If no date is imported, transaction will be dated the day of the import.
DueDate Due date N Date N/A If no due date imported, the due date will be calculated based upon the Terms.
ShipDate Shipping date N Date N/A  
ShipMethodName Ship via N Alpha-numeric 31  
TrackingNum Tracking no N Alpha-numeric 99  
SalesTerm Terms N Alpha-numeric 100 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
Location Location N Alpha-numeric 100 May be set as Business, Department, Division, Location, Property, Store, or Territory in QBO Settings. However, the field will also be named Location in TPro mapping. If importing a sub-Location, see this article for more info.
Class Class N Alpha-numeric 100 Class if the setting in QBO is for one class per transaction. If importing a sub-Class, see this article for more  info.
BillAddrLine1 Billing address N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrLine2 Billing address N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrLine3 Billing address N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrLine4 Billing address N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrCity Billing address N Alpha-numeric 255 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrState Billing address N Alpha-numeric 255 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrPostalCode Billing address N Alpha-numeric 30 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
BillAddrCountry Billing address N Alpha-numeric 255 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrLine1 Shipping to N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrLine2 Shipping to N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrLine3 Shipping to N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrLine4 Shipping to N Alpha-numeric 500 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrCity Shipping to N Alpha-numeric 255 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrState Shipping to N Alpha-numeric 255 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrPostalCode Shipping to N Alpha-numeric 30 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
ShipAddrCountry Shipping to N Alpha-numeric 255 If the Customer already exists in QBO, this info will be pulled from the Customer Setup, if different data is not imported for this field.
PrivateNote Message on statement N Alpha-numeric 4000  
Msg Message on invoice N Alpha-numeric 4000  
BillEmail Customer email N Alpha-numeric 100 Must be valid Email. If multiple Email addresses, separate each Email by a comma.
BillEmailCc Cc N Alpha-numeric 100 Must be valid Email. If multiple Email addresses, separate each Email by a comma.
BillEmailBcc Bcc N Alpha-numeric 100 Must be valid Email. If multiple Email addresses, separate each Email by a comma.
Currency   N Alpha  3 Only available if multi-currency activated in QBO. Must match currencies pre-defined in QBO. It will default to Currency assigned the Customer. If setting the Customer up "on the fly," this field will be the assigned Currency.
ExchangeRate   N Numeric   For all currencies except for BITCOIN, the saved Exchange Rate for that currency in QBO must be used.
Deposit Deposit N Numeric 11 Maximum value 99,999,999,999. Reduces amount of Invoice due. Import as positive number.
ToBePrinted Print later N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
ToBeEmailed Send later N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
AllowIPNPayment   N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
AllowOnlineCreditCardPayment Cards N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
AllowOnlineACHPayment Bank transfer N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
ShipAmt Shipping N Numeric 11 Maximum value 99,999,999,999.
ShipItem          
DiscountAmt Discount value N Numeric 11 Maximum value 99,999,999,999. The value for this field imports is a set Discount Amount. Import as positive number.
DiscountRate Discount percent N Numeric 11 Maximum value 99,999,999,999. The value for this field imports as a Discount Percentage. Import as positive number.
TaxAmt Select tax rate N Numeric 11 Maximum value 99,999,999,999. Only a valid import field for US Version of QBO and if on Manual Tax Calculation. Otherwise, tax is calculated based upon the Customer's tax setting, the Customer's ship to address, and the tax setting of the Product/Service.
DiscountTaxable   N Y or N N/A To import Discount as Taxable, valid values are 1, t, true, y, or yes. To import Discount as Nontaxable, valid values are 0, f, false, n, or no. Default is Nontaxable.
LineServiceDate Service Date N Date N/A  
LineItem Product/Service Y Alpha-numeric 100  
LineDesc Description N Alpha-numeric 4000  
LineQty Qty N Numeric 11 Maximum value 99,999,999,999. If importing an Inventory type, quantity is required.
LineUnitPrice Rate N Numeric 11 Maximum value 99,999,999,999.
LineAmount Amount N Numeric 11 Maximum value 99,999,999,999.
LineClass Class N Alpha-numeric 100 If importing a sub-Class, see this article for more info.
LineTaxable Tax N Y or N N/A To import Item as Taxable, valid values are 1, t, true, y, or yes. To import Item as Nontaxable, valid values are 0, f, false, n, or no. Default is Nontaxable.
Custom Field 3   N Alpha-numeric 30 The name of this field will reflect the name assigned in QBO Settings.
Custom Field 2   N Alpha-numeric 30 The name of this field will reflect the name assigned in QBO Settings.
Custom Field 1   N Alpha-numeric 30 The name of this field will reflect the name assigned in QBO Settings.
  • 505
  • 24-Oct-2020
  • 1844 Views