Employee Expense Reimbursements may be imported into QuickBooks Desktop (QBDT) using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Check import type, if the reimbursement has already occurred. This article discusses importing as a Bill import type. For infor…
QUESTION What order do lists and transactions need to be imported into QuickBooks Desktop? RESOLUTION When importing lists and transactions into QBDT with Rightworks Transaction Pro Importer, the lists and transactions should be imported in the same order as they would be manually entered into QBDT. This is …
Employee Expenses charged to the company credit card may be imported into QuickBooks Desktop (QBDT) using Transaction Pro (TPro) Importer as a Credit Card Charge import type. TPro Importer does not require a specific file layout to import into QBDT. However, if you wish to view or use the TPro sample file for impo…
QUESTION Can a Positive Pay file be exported from QuickBooks Desktop (QBDT) with Rightworks Transaction Pro that can be sent to my financial institution? RESOLUTION In an effort to reduce fraudulent paper checks, most financial institutions offer a Positive Pay system that allows banks to match checks presen…
QUESTION How is a copy of a QuickBooks Desktop (QBDT) company file created? RESOLUTION Creating a copy of a QBDT company file can be useful for testing with Rightworks Transaction Pro Importer, Exporter, or Deleter. To create a copy of a QBDT company file: * Choose FILE > OPEN OR RESTORE COMPANY > OPE…
When contacting Rightworks Transaction Pro Support, Support may ask you to send certain files to help in resolving the error messages that you are receiving. The purpose of this article is to show you where to find these files and also explain how they are used. IMPORT FILE This is the excel, csv, or txt file t…
ISSUE When importing Invoices or Sales Receipts, the Customer Address is being cleared. RESOLUTION Verify that the Option to CLEAR TRANSACTION BILL TO/SHIP TO ADDRESS WHEN IMPORTING is not selected in the OPTIONS on the BASIC tab (see image below).
QUESTION "The item history could not be locked" RESOLUTION This message appears because one of the Items in the import file is being edited in the QuickBooks company file while the import is being processed. Once this Item is saved or closed in QB, the message will not appear.
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…
Rightworks Transaction Pro Importer map files can be created to import transactions such as Invoices or Journal Entries and to import lists such as Price Levels, Customers, or Items into QuickBooks Desktop (QBDT). Below is a screenshot of the Importer mapping screen with more detailed information below it. …