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…
The following are instructions for importing the Certify Bill Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading a Bill Report from Certify , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Select BILLS as your import type by clicking on the b…
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…
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…
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 …
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 …
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 …
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: …