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…
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…
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 do I add or delete users from my online subscription account for Rightworks Transaction Pro? RESOLUTION The OWNER or ADMIN user of the online subscription are the only ones that can add or remove PARTICIPANT users for the subscription. Below are the steps for adding or deleting a PARTICIPANT …
Below is a picture of a Purchase Order screen from QuickBooks Online to help get started. Please review the screenshot to make sure all the fields that are available are noted. The Data Dictionary may also be referenced for Purchase Orders HERE . INSTRUCTIONS 1. Sign in via the Rightworks Transaction Pro on…
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…
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 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 …