TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Miss, Dr CompanyName Company N Alpha-numeric 100 FirstName First name N Alpha-numeric 25 MiddleName Middle name N Alpha-num…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Estimate no Y Alpha-numeric 21 The Reference Number is the Estimate Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must b…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date (Deposit) Payment date (Check) N Date N/A If no date is imported, transaction will be dated the day of the import. PrivateNote Memo (Deposit) Memo (Check) N Alpha…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref No Y Alpha-numeric 21 The Reference Number is the Credit Card Charge Reference Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Check no Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import m…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Sales Receipt no Y Alpha-numeric 21 The Reference Number is the Invoice Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import mu…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Credit Memo no Y Alpha-numeric 21 The Reference Number is the Credit Memo Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Impor…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 100 Reference Number is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this column prior to import. TxnDa…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 31 The Reference Number for this type of import should be unique for each row. TxnDate Payment date N Date N/A If no date is imported, transaction will be date…
TYPE: INVENTORY TYPE: NONINVENTORY TYPE: SERVICE TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Product & Service item into a Category, import Category:Name for the Name field. Type Type N …