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

Bill Import Fields for Transaction Pro Online

TPro Field Name QBO Field Name Required Character Type Character Limit Notes
RefNumber Bill no Y Alpha-numeric 21 The Reference Number is the Bill 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. 
APAccount   N Alpha-numeric 100 QBO only allows posting to the default AP Account. If multiple currencies, it will post to the default AP Account for the currency of the Vendor.
Vendor Vendor Y Alpha-numeric 100 If importing a sub-Vendor, must include the full name. See this article for more info.
PrintOnCheckName   N Alpha-numeric 100 If the Vendor is being set up "on the fly" during the import, it allows this value to be set in the Vendor Setup in QBO. If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup.
TxnDate Bill 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 Due Date may be imported or may be calculated based upon the Terms. 
SalesTerm Terms N Alpha-numeric 31 If Vendor already exists in QBO, the Terms will be pulled from the Vendor 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.
AddressLine1 Mailing address N Alpha-numeric 500 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressLine2 Mailing address N Alpha-numeric 500 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressLine3 Mailing address N Alpha-numeric 500 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressLine4 Mailing address N Alpha-numeric 500 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressCity Mailing address N Alpha-numeric 255 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressState Mailing address N Alpha-numeric 255 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressPostalCode Mailing address N Alpha-numeric 30 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
AddressCountry Mailing address N Alpha-numeric 255 If the Vendor already exists in QBO, this info will be pulled from the Vendor Setup, if different data is not imported for this field.
PrivateNote Memo N Alpha-numeric 4000  
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 Vendor. If setting the Vendor 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.
ExpenseAccount Category N Alpha-numeric 100 Import either the full Account Name or the Account Number. See this article for more info.
ExpenseDesc Description N Alpha-numeric 4000  
ExpenseAmount Amount N Alpha-numeric 11 Maximum value 99,999,999,999.
ExpenseBillableStatus Billable N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
ExpenseBillableEntity Customer / Project N Alpha-numeric 100 Customer or Customer:Project name to be billed for expense. See this article for more info about importing Customer:Project.
ExpenseClass Class N Alpha-numeric 100 If importing a sub-Class, see this article for more info.
LineItem Product/Service N 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.
LineBillableStatus Billable N Y or N N/A Default is False (unchecked). To check field, valid values are 1, t, true, y, or yes.
LineBillableEntity Customer / Project N Alpha-numeric 100 Customer or Customer:Project name to be billed for expense. See this article for more info about importing Customer:Project.
LineClass Class N Alpha-numeric 100 If importing a sub-Class, see this article for more info.
  • 497
  • 24-Oct-2020
  • 1098 Views