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 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…
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 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…
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…
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…
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 How can a sales transaction such as Estimate, Invoice, or Sales Receipt post to a General Ledger (GL) Account instead of an Item when importing into QuickBooks Online with Rightworks Transaction Pro Importer? RESOLUTION In QuickBooks Online , Intuit does not allow a GL Account to be used on sales…
MESSAGE "This key is already associated with an element of this collection" RESOLUTION Check the import file to see if there are extra spaces in the list name (Customer, Vendor, Employee, or Product and Service) that is being added. The issue is most likely caused by the scenario below: Customer name i…