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 …
ISSUE When processing a Customer import into QuickBooks Online with Rightworks Transaction Pro Importer, a value is imported for the Default Sales Tax Code. However, the value does not display in QuickBooks Online after import. RESOLUTION If the QuickBooks Online company is setup with the automatic sales…
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 …
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Check no Y Alpha-numeric 21 The Reference Number is the assigned Check Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import m…
QuickBooks Terminology: * QBDT or QBD – This is a short name for QuickBooks Desktop and includes Pro, Premier, and Enterprise. * QBE – This is a short name for QuickBooks Enterprise. * QuickBooks in the Cloud – This refers to QuickBooks Desktop being hosted on a remote server or QuickBooks Online. * Company…
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 on the transaction can be a negative amount, but the total amount needs to be zero or greater. If less z…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Credit Memo no Y Alpha-numeric 21 The Reference Number is the Credit Memo Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Impor…
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 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. QuickBooks Sales Receipts Sales Receipt should be selected as an import type when the Customers pay at the same time…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Sales Receipt no Y Alpha-numeric 21 The Reference Number is the Invoice Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import mu…