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…
Below are the instructions to import JOOR sales transactions into QuickBooks Desktop (QBDT) as a Sales Receipt using Rightworks Transaction Pro Importer . A sample map file is attached on the right-hand side of the screen to use with your JOOR Sales Receipt Import After downloading your order file from JOOR, lo…
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 Can a Transaction Pro import that uses a Microsoft Access database file be automated? RESOLUTION Yes, imports that use a Microsoft Access database file as the import file type can be automated. Below are some tips on how to automate the import process once several successful manual imports are have …
MESSAGE "Employees QuickBooks: The integrated application has no permission to access personal data." RESOLUTION The Integrated Application settings in QuickBooks Desktop (QBDT) need to be updated for Transaction Pro Importer. To update the Integrated Application Settings, follow the steps below: * Th…
Below are the three quick steps to eliminate manual data entry to QuickBooks by using Rightworks Transaction Pro Importer. Step 1: Identify where manual data entry is being done Meet with all QuickBooks users and have them identify what they manually enter into QuickBooks. Then, have them estimate how much time…
QUESTION How can Rightworks Transaction Pro be used to clean up a QuickBooks company file for the New Year? RESOLUTION Below are some examples on how to utilize Transaction Pro Importer, Transaction Pro Exporter, and Transaction Pro Deleter to start off the new year with a cleaner QuickBooks Desktop (QBDT) c…