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.
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…
QUESTION If importing a General Ledger Account on a transaction with Rightworks Transaction Pro Importer, should the Account Name or the Account Number or both be used? RESOLUTION If using Account Numbers, the import data should include either the Account Name or Account Number but not both. If posting to…
QUESTION What types of files can be exported from QuickBooks Online with Rightworks Transaction Pro Exporter, and how is the export performed? RESOLUTION Exporter allows exporting both transactions and lists from QuickBooks Online with flexible mapping options. Transactions currently supported include: …
QUESTION Can exports be scheduled with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting transactions and lists from QuickBooks Online with Exporter, there is the option to configure and schedule the exports. The schedule can be one time or recurring. This option allows the…
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…
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…
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…
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…