QUESTION How can lines be removed from the import file from within Rightworks Transaction Pro Importer for QuickBooks Desktop (QBDT)? RESOLUTION Sometimes, the import file may contain additional lines that are not to be imported or when testing, only a line or two is desired to test. The additional lines can…
An overview is provided in this article on how to import Statement Charges into QuickBooks Desktop (QBDT) using Transaction Pro Importer. On the first screen of Importer, click the BROWSE button to select the import file and select STATEMENT CHARGE as the IMPORT TYPE. Then select the OPTIONS button, if any options…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber 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 must be so…
QUESTION How can Rightworks Transaction Pro Importer create a new name (Customer, Vendor, or Employee) during a Journal Entry import into QuickBooks Desktop (QBDT)? RESOLUTION By default, Importer does not create new names when importing Journal Entries. However, by using the command line /JE_NAME, Importer …
The following are instructions for importing the Certify Bill Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading a Bill Report from Certify , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Select BILLS as your import type by clicking on the b…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Estimate no Y Alpha-numeric 21 The Reference Number is the Estimate Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Import must b…
MESSAGE "Invalid Account specified in the APAccount column" when importing Bills. RESOLUTION If using Account Names for the Expense Accounts in the import file, enter the General Ledger Account Name of the Accounts Payable account on the Rightworks Transaction Pro Importer mapping screen in the Default Value…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Refund Receipt no Y Alpha-numeric 21 The Reference Number is the Refund Receipt Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. I…
NOTE: THIS POST ONLY IMPACTS QUICKBOOKS USERS FROM CANADA, UNITED KINGDOM, AND AUSTRALIA. USA USERS CAN IGNORE THIS POSTING. ISSUE As of 2008, Intuit dropped support for setting Tax1Total and Tax2Total via the QBSDK. Users that have been using these fields to set GST/PST (Canada) or VAT (UK) will not longer hav…
ISSUE After selecting the Option for QuickBooks Online to AUTO ASSIGN the transaction number and importing the transaction with Rightworks Transaction Pro Importer, the transaction number field is blank in QuickBooks Online. RESOLUTION If a transaction number is not auto assigned even when the Option to have…