QUESTION Can Bank Transactions (Deposits and Checks) be imported together into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer? RESOLUTION Both Deposits and Checks can be imported together in a single import as a Bank Statement import into QBDT with Importer. Below are some formatting i…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Bill no Y Alpha-numeric 21 The Reference Number is the Bill Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted…
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…
MESSAGE When importing transactions into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer and using the Account Name, it says the Account does not exist even though it does. RESOLUTION There are two options to resolve this issue: 1. Check your preferences in QuickBooks Desktop to make su…
QUESTION Can external time information be imported into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer? RESOLUTION If external time-tracking systems or time clocks are used, Transaction Pro Importer can be used to import the time activity into QBDT for payroll processing. Reference thi…
QUESTION How is the Static Value / Formula column used on the mapping screen of Rightworks Transaction Pro Importer? RESOLUTION The Static Value / Formula column within Importer can save time from manually manipulating the import file prior to importing into QuickBooks Desktop (QBDT). Below are some examp…
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 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…
Item Assemblies can save a lot of time in QuickBooks Desktop (QBDT). Rightworks Transaction Pro Importer can be used to import Item Assemblies into QBDT. The data in the import file, though, must meet the requirements of QBDT. Below are some tips for ensuring the import file contains the necessary information to allo…
QUESTION When importing Credit Card Charges, how can the Vendor names on the Credit Card Statement be matched to the Vendor names that already exist in QuickBooks Desktop (QBDT)? ANSWER Rightworks Transaction Pro (TPro) Importer for QBDT has an ALIASES option that allows names to be matched between the impor…