QUESTION Can the Journal Entry that the third-party payroll processor provides each payroll be imported into QuickBooks Desktop (QBDT) using Rightworks Transaction Pro (TPro) Importer? RESOLUTION Yes, if the third-party payroll processor can provide a flat file type such as Excel, csv, or txt, then TPro Impo…
ISSUE When importing with Transaction Pro Importer on a Mac computer, the dates import incorrectly. RESOLUTION Check to make sure that the 1904 date format is not turned on in Excel. If it is, it will cause dates to shift by 1462 days. The Excel setting is in different places depending on the Office versi…
QUESTION How do you connect Rightworks Transaction Pro to a QuickBooks Desktop company file? COMMON SCENARIO Upon initial installation of Transaction Pro, the software must be connected to the QuickBooks company file that you wish to use it for. If Transaction Pro will be used with multiple QBDT compa…
Rightworks Transaction Pro Importer Command Line Codes Some additional features exist for Transaction Pro Importer that are not included with the standard installation. These additional features can be accessed by adding Command Line Codes to the Transaction Pro properties. For more information about how to add a …
Employee Expense Reimbursements may be imported into QuickBooks Online using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Expense or Check import type, if the reimbursement has already occurred. This article discusses importing as a Bill import type. For in…
Below are the instructions to import JOOR sales transactions into QuickBooks Online as an Estimate using Transaction Pro Importer. After downloading your sales file from JOOR , log into Transaction Pro Importer and select to START IMPORT. CHOOSE IMPORT TYPE: Select ESTIMATES as your import type by clicking …
COMMON ISSUE RESOLUTION Required parameter ExpenseAccountRef or IncomeAccountRef is missing in the request Income Account is required on all Types. Expense Account is required for type Inventory. Expense Account is required for type NonInventory and Service if values are imported for Purchase Description…
QUESTION How is a discount entered when importing Receive Payments? RESOLUTION The amount mapped to the Discount Amount field needs to be expressed as a positive amount. The Discount Account field needs to be the lowest sub-account number or sub-account name of the General Ledger account.
QUESTION How can a Refund Receipt be imported into QuickBooks Online using Transaction Pro Importer? RESOLUTION Refund Receipts can be imported into QuickBooks Online using Importer. A Refund Receipt is a posting transaction that is used when reimbursing a customer's money. Some important formatting consi…
QUESTION Why do new Products and Services that set up during an import into QuickBooks Online set up with the Accounts of Uncategorized Income or Uncategorized Expense? RESOLUTION If a Products and Services in an import does not already exist in QuickBooks Online, Transaction Pro Importer will create the mis…