QUESTION If the multi-line transactions are in columns instead of rows when importing Bills or Checks into QuickBooks Desktop (QBDT), how can the transaction be imported with Rightworks Transaction Pro Importer? RESOLUTION Importer has the option to import Bills and Checks as columns. These options are found…
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…
TYPE: INVENTORY TYPE: NONINVENTORY TYPE: SERVICE TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Product & Service item into a Category, import Category:Name for the Name field. Type Type N …
ISSUE Unable to activate Rightworks Transaction Pro Importer (TPI), Exporter (TPE), or Deleter (TPD) Desktop or Server Editions. RESOLUTION Please check the following items: * You have an Internet connection. * Your login and password are correct (the password should contain no spaces). * You have read/w…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Y Alpha-numeric 100 Reference Number is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must be sorted by this column prior to import. TxnDa…
MESSAGE "This key is already associated with an element of this collection" RESOLUTION Check the import file to see if there are extra spaces in the list name (Customer, Vendor, Employee, or Product and Service) that is being added. The issue is most likely caused by the scenario below: Customer name i…
QUESTION: How are Deposit imports posted from Undeposited Funds when importing with Rightworks Transaction Pro Importer into QuickBooks Online? RESOLUTION: When importing Deposits into QuickBooks Online with TPro Importer, Deposits can be posted from Undeposited Funds. However, the Receive Payment or Sales …
Retail type businesses, often times, use a Point of Sale (POS) system that does not integrate with QuickBooks Desktop (QBDT) and are looking for an easy way to record a daily summary of the sales and payment activity. An easy way to do this is to enter a daily summarized Sales Receipt into QBDT. A detailed article as…
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…
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…