![][1] 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-numeric 25 LastName …
![][1] TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Class as a Sub-Class of another Class, use format Class:Sub-Class [1]: https://hf-files-oregon.s3.amazonaws.com/hdptransactionpro_kb_attachments/2020/10-12/3f38d995-…
![][1] 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 be sorted …
![][1] 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. Import must be s…
![][1] ![][2] 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-numeric 4000 Curr…
![][1] 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 dated the day of the im…
![][1] 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. Import …
**TYPE: INVENTORY** ![][1] **TYPE: NONINVENTORY** ![][2] **TYPE: SERVICE** ![][3] 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 T…
![][1] 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. TxnDate Date N D…
![][1] 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 must be sort…