The following are instructions for importing the Concur Employee Expense Reimbursement Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading an Employee Expense Reimbursement Report from Concur , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Sele…
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…
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 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 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 …
QUESTION How does the cross-reference option work for Accounts when importing into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro (TPro) Importer? RESOLUTION In QBDT, Accounts are organized by Name. However, other databases or services that may be imported may use a the Account Description instead…
QUESTION What import types should be used when importing sales into QuickBooks? RESOLUTION Below are brief descriptions of how Sales Receipts, Invoices, and Deposits work in QuickBooks. Sales Receipts Sales Receipt should be selected as an import type when the Customers pay at the same time that they p…
The following are instructions for importing Expensify Expense Reports into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro Importer. After downloading an expense file from Expensify , log into QBDT. Open Transaction Pro Importer and select the file to import into QBDT by clicking BROWSE and selec…
MESSAGE " Hours/minutes must be supplied for a time tracking item" RESOLUTION Check to see if any transaction in the import file has a zero for the duration. These rows should be deleted from the import file prior to importing.