QUESTION Can the Trial Balance Report be exported with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting transactions and lists from QuickBooks Online with Exporter, there is now the option to export the Trial Balance report. Below are the steps to export the Trial Balan…
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 …
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 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…
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 …
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Dr Company Company N Alpha-numeric 100 FirstName First name N Alpha-numeric 25 MiddleName Middle name N Alpha-numeric 25 …
QUESTION If exporting from QuickBooks Online using Rightworks Transaction Pro Exporter and then importing the data back into a QuickBooks Online company file, all of the column names do not match exactly. Are there pre-defined maps that can be used for the process? RESOLUTION When the data is exported from Q…
QUESTION How can the billing invoices from a Rightworks Transaction Pro subscription for QuickBooks Online be viewed and downloaded? RESOLUTION To access the billing invoices for a Transaction Pro subscription, the user will need to have Billing Admin Access. Click MANAGE for the subscription that you wis…
QUESTION How can a Trial Balance be imported into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION The best way to import a Trial Balance into QuickBooks Online is with the import type Journal Entry. NOTE: Any line in the import file that posts to an AR or an AP Account must referen…
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…