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…

Common Issues Importing Chart of Accounts into QuickBooks Online

COMMON ISSUE RESOLUTION Invalid Account Type See this  article  for valid Account Types Invalid Account SubType See this  article  for valid Account SubTypes (Detail Type). Valid Account SubTypes depend on the Account Type. Wrong Currency Imports Multi-currency not turned on in QuickBooks O…

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…

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 …

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…

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.…

scroll to top icon