MESSAGE "String length specified does not match the supported length." RESOLUTION This message appears because some data in the import file exceeds the maximum length allowed in QuickBooks Online. Edit the data in the import file so that it is shorter. For more information about maximum character lengths …
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Estimate no Y Alpha-numeric 21 The Reference Number is the Estimate Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must b…
MESSAGE "Invalid Account specified in the APAccount column" when importing Bills. RESOLUTION If using Account Names for the Expense Accounts in the import file: - Enter the General Ledger Account Name of the Accounts Payable account on the Rightworks Transaction Pro Importer mapping screen in the Defaul…
COMMON ISSUE RESOLUTION Sub-Class Name Not Importing Sub-Class Name must include full name with a colon between each level with no space on either side of the colon. Example: CLASS:SUB-CLASS See this article for more info.
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date N Date N/A If no date is imported, transaction date will default to the date of the import. Name Name Y Alpha-numeric 100 Name can be an Employee Name or a Vendor Name (Contrac…
QUESTION What are some common uses for a Cash Purchases import into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION Some of the most common uses for a Cash Purchase import are listed below: * Importing transactions from a debit card * Importing monthly or daily activity from anoth…
QUESTION Can Memorized Transactions be imported into QuickBooks Online using Rightworks Transaction Pro Importer? RESOLUTION At this time, it is not possible to import Memorized Transactions into QuickBooks Online using Importer. A workaround is to use Importer to create these recurring transactions instead …
QUESTION Can a Trial Balance Report export be scheduled with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting the Trial Balance Report from QuickBooks Online with Exporter, there is the option to schedule future exports. The schedule can be one time or recurring. This opti…
QUESTION Is there a report in QuickBooks Online that shows what was imported with Rightworks Transaction Pro Importer? RESOLUTION The most helpful report in QuickBooks Online for reviewing or auditing what has been imported with Importer is the Audit Log report. It is available in QuickBooks Online unde…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Title Title N Alpha-numeric 4 Example: Mr, Mrs, Ms, Miss, Dr CompanyName Company N Alpha-numeric 100 FirstName First name N Alpha-numeric 25 MiddleName Middle name N Alpha-num…