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