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

Create Custom Color Schemes with Rightworks Transaction Pro Importer and Exporter for QuickBooks

In Version 7 of Rigthworks Transaction Pro Importer and Exporter for QuickBooks Desktop (QBDT), the color scheme can be changed. This is a similar feature to what the QB Pro, Premier and Enterprise software allows. When in Importer or Exporter, click the box in the upper right-hand corner that looks like an arrow.…

Link Invoices to Sales Order When Importing

QUESTION How can an open Sales Order be linked to an Invoice during import? RESOLUTION Rightworks Transaction Pro Importer can link an open Sales Order to an imported Invoice with the use of the command line /INVOICESO=1 The information below discusses this option as well as some additional steps to be ta…

Auto Assign Transaction Numbers - QuickBooks Desktop

QUESTION How can it be set so that QuickBooks Desktop (QBDT) auto assigns the next transaction number when importing with Rightworks Transaction Pro Importer? RESOLUTION On the first window of Importer, click OPTIONS. On the BASIC tab in the Transaction Reference Numbers section, select the option to LET QUI…

Concur Employee Expense Reimbursement Import into QuickBooks Online

The following are instructions for importing the  Concur  Employee Expense Reimbursement Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading an Employee Expense Reimbursement Report from  Concur , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE:  Sele…

Import Classes on QuickBooks Desktop Transactions

QUESTION Can Classes be imported into QuickBooks Desktop (QBDT) with Rightworks Transaction Pro Importer on a transaction? RESOLUTION If the option to use Classes is selected in QBDT Company Preferences under Accounting, the Class field will be available in Importer for use on imported transactions. In QB…

Receive Payment Import Fields for Rightworks Transaction Pro Online

TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber   Y Alpha-numeric 31 The Reference Number for this type of import should be unique for each row. TxnDate Payment date N Date N/A If no date is imported, transaction will be date…

Common Issues Importing Customers into QuickBooks Online

COMMON ISSUE RESOLUTION Sub-Customer Name Not Importing Sub-Customer Name must include full name with a colon between each level with no space on either side of the colon. Example: CUSTOMER:SUB-CUSTOMER See this  article  for more info. Wrong Currency Imports Multi-currency not turned on in QuickBoo…

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 in Importer can save time by avoiding manual manipulation of the import file before importing into QuickBooks Desktop (QBDT). Below are some exa…

Apply Vendor Credits to Bills or Bill Payments - QuickBooks Online

QUESTION How can Vendor Credits be applied to Bills or Bill Payments? RESOLUTION At this time, Rightworks Transaction Pro Importer cannot apply Vendor Credits during an import. These will need to be matched manually in QuickBooks Online.

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…

scroll to top icon