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

Import Journal Entries from Payroll Providers with Rightworks Transaction Pro Importer for QuickBooks Online

QUESTION How can an IIF file from a Payroll Provider be imported into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION Most Payroll Providers provide an IIF file for importing Payroll data into QuickBooks. However, QuickBooks Online does not allow IIF files to be imported, as these file…

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…

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…

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…

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…

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…

You Must Specify a Transaction Amount that is 0 or Greater - QuickBooks Online

MESSAGE "You must specify a transaction amount that is 0 or greater." RESOLUTION When importing a transaction, the sum of all the lines of a transaction must equal an amount of zero or greater. Line items in the transaction can have negative amounts, but the total must be zero or greater. If less zero, the t…

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…

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…

Item Assembly Import – Tips and Tricks

Item Assemblies can save a lot of time in QuickBooks Desktop (QBDT). Rightworks Transaction Pro Importer can be used to import Item Assemblies into QBDT. The data in the import file, though, must meet the requirements of QBDT. Below are some tips for ensuring the import file contains the necessary information to allo…

scroll to top icon