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…
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 …
QUESTION How can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION In QuickBooks Online , Intuit does not allow a GL Account to be used on sales…
QUESTION: How are Deposit imports posted from Undeposited Funds when importing with Rightworks Transaction Pro Importer into QuickBooks Online? RESOLUTION: When importing Deposits into QuickBooks Online with TPro Importer, Deposits can be posted from Undeposited Funds. However, the Receive Payment or Sales …
QUESTION Can the Trial Balance Report be exported with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting transactions and lists from QuickBooks Online with Exporter, there is now the option to export the Trial Balance report. Below are the steps to export the Trial Balan…
QUESTION If exporting from QuickBooks Online using Rightworks Transaction Pro Exporter and then importing the data back into a QuickBooks Online company file, all of the column names do not match exactly. Are there pre-defined maps that can be used for the process? RESOLUTION When the data is exported from Q…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Dr Company Company N Alpha-numeric 100 FirstName First name N Alpha-numeric 25 MiddleName Middle name N Alpha-numeric 25 …
QUESTION How can the billing invoices from a Rightworks Transaction Pro subscription for QuickBooks Online be viewed and downloaded? RESOLUTION To access the billing invoices for a Transaction Pro subscription, the user will need to have Billing Admin Access. Click MANAGE for the subscription that you wis…
QUESTION How can a Trial Balance be imported into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION The best way to import a Trial Balance into QuickBooks Online is with the import type Journal Entry. NOTE: Any line in the import file that posts to an AR or an AP Account must referen…
QUESTION What order do lists and transactions need to be imported into QuickBooks Online? RESOLUTION When importing lists and transactions into QuickBooks Online with Rightworks Transaction Pro Importer, the lists and transactions should be imported in the same order as they would be manually entered into Qu…