MESSAGE "Duplicate Document Number Error : You must specify a different number. This number has already been used." RESOLUTION The message appears because a transaction already exists in QuickBooks Online with this number. In order to allow QuickBooks Online to use duplicate numbers, the following changes…
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…
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…
QUESTION What are the user types/roles for the online version of Rightworks Transaction Pro? RESOLUTION In the online version of Transaction Pro, there are three user types/roles: * Owner: The original user that setup the Transaction Pro subscription. There is only one Owner user per subscrip…
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…
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 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…
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 …