QUESTION What import types that should be used when importing sales into QuickBooks? RESOLUTION Below are brief descriptions how Sales Receipts, Invoices and Deposits work in QuickBooks. Sales Receipts Sales Receipt should be selected as an import type when the Customers pay at the same time that they …
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes TxnDate Date (Deposit) Payment date (Check) N Date N/A If no date is imported, transaction will be dated the day of the import. PrivateNote Memo (Deposit) Memo (Check) N Alpha…
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…
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 "Required parameter line is missing in the request" when importing Checks or Bills into QuickBooks Online. RESOLUTION If importing Checks or Bills into QuickBooks Online, the data needs to be mapped to one of this two scenarios: * Products and Services: LineItem and LineAmount: Data must be map…
MESSAGE "You must fill out at least two detail lines." RESOLUTION The message appears because a Journal Entry in the import file does not have at least two lines. Rightworks Transaction Pro Importer for QuickBooks Online groups multiple lines onto the same Journal Entry that have the same value mapped to the…
QUESTION How do General Ledger Accounts need to be formatted in the import file when using Rightworks Transaction Pro Importer with QuickBooks Online? RESOLUTION If Accounts are used in the import file, only the Account Name or the Account Number should be used, never both. If using Account Numbers, only …
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…
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 …
MESSAGE "Unfortunately an internal error occurred while processing your request." RESOLUTION If the above message is received when using Rightworks Transaction Pro Importer for QuickBooks Online, the Admin of the TPro subscription will need to disconnect and reconnect TPro by following the steps below: *…