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…
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 a Product & Service item into a Category, import Category: Name for the Name field. Type Type N …
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…
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…
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…
QUESTION Will Rightworks Transaction Pro Importer import account names with special characters? RESOLUTION QuickBooks does not allow non-ASCII characters in list names. For more information about acceptable characters that can be used in QuickBooks Online, please refer to this Intuit ARTICLE .
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…
QUESTION What are some helpful tips to know when importing Credit Card Charges into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION Below are some helpful tips to keep in mind for the most common issues encountered when importing Credit Card Charges into QuickBooks Online using Importe…