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

Incorrect Date Issue for Mac Users

ISSUE When importing with Transaction Pro Importer on a Mac computer, the dates import incorrectly. RESOLUTION Check to make sure that the 1904 date format is not turned on in Excel. If it is, it will cause dates to shift by 1462 days. The Excel setting is in different places depending on the Office versi…

Order to Import Transactions into QuickBooks Online

QUESTION What order do lists and transactions need to be imported into QuickBooks Online? RESOLUTION When importing lists and transactions into QuickBooks Online with Rightworks Transaction Pro Importer, the lists and transactions should be imported in the same order as they would be manually entered into Qu…

Entering Discount When Receiving Payments

QUESTION How is a discount entered when importing Receive Payments? RESOLUTION The amount mapped to the Discount Amount field must be expressed as a positive value. The Discount Account field needs to be the lowest sub-account number or sub-account name of the General Ledger account.

Import Refund Receipts into QuickBooks Online

QUESTION How can a Refund Receipt be imported into QuickBooks Online using Transaction Pro Importer? RESOLUTION Refund Receipts can be imported into QuickBooks Online using Importer. A Refund Receipt is a posting transaction that is used when reimbursing a customer's money. Some important formatting consi…

JOOR Sales Transaction Estimate Import into QuickBooks Online

Below are the instructions to import JOOR sales transactions into QuickBooks Online as an Estimate using Transaction Pro Importer. After downloading your sales file from JOOR , log into Transaction Pro Importer and select to START IMPORT. CHOOSE IMPORT TYPE: Select ESTIMATES as your import type by clicking …

Desktop Data Dictionary: How Should My Data Be Mapped?

QUESTION How I should my data be mapped when importing into QuickBooks Desktop (QBDT)? RESOLUTION The attached Data Dictionary shows the types of lists and transactions that can be imported using Rightworks Transaction Pro Importer into QBDT, as well as the available and required fields for each import type.…

Customer:Job: XYZ is Duplicated in the QuickBooks File

MESSAGE "Customer:Job: XYZ is duplicated in the QuickBooks file," where XYZ indicates the Customer name that is causing the error. RESOLUTION This message appears because a Customer name exists under the same name either as a Customer, Vendor, Other Name, Employee, or Item in the QuickBooks Desktop (QBDT) co…

QuickBooks found an error when parsing the provided XML text stream

ISSUE QuickBooks found an error when parsing the provided XML text stream RESOLUTION If you are receiving this error AFTER mapping your data and clicking import, it is usually caused by one of the three items below. Please review the import file for these items. * Import data includes special characters …

Options Available in Rightworks Transaction Pro Importer for QuickBooks Online

QUESTION What Options are available to be used when importing using Rightworks Transaction Pro Importer for QuickBooks Online? RESOLUTION There are currently 19 Options available to be used with Importer, but the list of available Options continues to grow. To access all the Options, on the Preview and Im…

Automate Rightworks Transaction Pro Import for QuickBooks Desktop

QUESTION Can imports using Transaction Pro Importer with QuickBooks Desktop (QBDT) be scheduled/automated? RESOLUTION For more advanced users who would like to schedule imports into QBDT, a full command line interface exists that you can use to start the process even if the QBDT company file is not open. The…

scroll to top icon