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…
The following are instructions for importing the Concur Credit Card Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading a Credit Card Report from Concur , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Select CREDIT CARD CHARGES as your import t…
QUESTION If importing a General Ledger Account on a transaction with Rightworks Transaction Pro Importer, should the Account Name or the Account Number or both be used? RESOLUTION If using Account Numbers, the import data should include either the Account Name or Account Number but not both. If posting to…
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…
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…
MESSAGE "Required parameter line is missing in the request" when importing Checks or Bills into QuickBooks Online. RESOLUTION If importing Checks or Bills into QuickBooks Online, the data needs to be mapped to one of this two scenarios: * Products and Services: LineItem and LineAmount: Data must be map…
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 a sales transaction, such as an 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 …
QUESTION What types of files can be exported from QuickBooks Online with Rightworks Transaction Pro Exporter, and how is the export performed? RESOLUTION Exporter allows exporting both transactions and lists from QuickBooks Online with flexible mapping options. Transactions currently supported include: …
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 a Product & Service item into a Category, import Category: Name for the Name field. Type Type N …