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…
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…
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 is the only one who can add or remove PARTICIPANT users for the subscription. Below are the steps for adding or deleting a PARTICIPANT USE…
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 types of files can be exported from QuickBooks Online with Rightworks Transaction Pro Exporter, and how is the export performed? RESOLUTION Exporter allows exporting both transactions and lists from QuickBooks Online with flexible mapping options. Transactions currently supported include: …
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…
TYPE: INVENTORY TYPE: NONINVENTORY TYPE: SERVICE TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import a Product & Service item into a Category, import Category: Name for the Name field. Type Type N …
QUESTION How can a sales transaction, such as an 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 …
QUESTION If exporting from QuickBooks Online using Rightworks Transaction Pro Exporter and then importing the data back into a QuickBooks Online company file, all of the column names do not match exactly. Are there pre-defined maps that can be used for the process? RESOLUTION When the data is exported from Q…
QUESTION What import types should be used when importing sales into QuickBooks? RESOLUTION Below are brief descriptions of how Sales Receipts, Invoices, and Deposits work in QuickBooks. Sales Receipts Sales Receipt should be selected as an import type when the Customers pay at the same time that they p…