You are using an unsupported browser. Please update your browser to the latest version on or before July 31, 2020.
close
You are viewing the article in preview mode. It is not live at the moment.
Emails from our Customer Support team will be sent from [email protected].

To ensure you receive important updates without interruption, please add [email protected] to your safe sender list and mark it as “not spam.”

Showing articles from Import tag

Import Bank Statements or Bank Transactions

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…

Bill Import Fields for Rightworks Transaction Pro Online

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…

Import a Trial Balance into QuickBooks Online

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…

Account Does Not Exist error during Import in Rightworks Transaction Pro Importer

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…

Preparing to Import Time Tracking into QuickBooks Desktop

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…

Use the Static Value / Formula Column in Rightworks Transaction Pro Importer

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…

Cross-Reference Option for Accounts

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…

Clean Up QuickBooks Company File for New Year using Rightworks Transaction Pro Products

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 Assembly Import – Tips and Tricks

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…

Use Aliases with Rightworks Transaction Pro Imports for QB Desktop

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…

scroll to top icon