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…
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…
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 mu…
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…
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…
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…
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…
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 "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 …
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…