To ensure you receive important updates without interruption, please add [email protected] to your safe sender list and mark it as “not spam.”
.png)
.png)
The Item History Could Not Be Locked
QUESTION The item history could not be locked RESOLUTION This message appears because one of the Items in the import file is being edited in the QuickBooks company file while the import is being processed. Once this Item is saved or closed in QB, the message will not appear.
Customer Address Being Cleared on Import
ISSUE When importing Invoices or Sales Receipts, the Customer Address is being cleared. RESOLUTION Verify that the Option to CLEAR TRANSACTION BILL TO/SHIP TO ADDRESS WHEN IMPORTING is not selected in the OPTIONS on the BASIC tab (see image below).
Let QuickBooks Online Assign the Next Transaction Number during Import
QUESTION How can the next transaction number in QuickBooks Online be used when importing a transaction with Transaction Pro Importer? RESOLUTION If the transaction number is not in the import file or if it is preferred to let QuickBooks Online use the next transaction number in the current numbering sequence…
Useful Excel Formulas and Tips to Use with Imports and Exports
Rightworks Transaction Pro Importer and Transaction Pro Exporter both support the use of Excel files. Below are some tips and common features that can be used with Excel import or export files: * Drop Down Lists: This can be helpful when having users do data entry and want to be sure that a valid customer, it…
Incorrect Date Issue for Mac Users
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…
Advanced Features Available for Receive Payment Imports into QuickBooks Desktop
This article will point out many options that are available within Rightworks Transaction Pro Importer to use when importing Receive Payments into QuickBooks Desktop (QBDT). The options that will be explained are: * Customer Account Number Cross Reference * Command Line to Apply a Payment to Multiple Invoices…
Import Employee Expense Reimbursement to be Paid into QuickBooks Online
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…
JOOR Sales Transaction Estimate Import into QuickBooks Online
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 …
Entering Discount When Receiving Payments
QUESTION How is a discount entered when importing Receive Payments? RESOLUTION The amount mapped to the Discount Amount field must be expressed as a positive value. The Discount Account field needs to be the lowest sub-account number or sub-account name of the General Ledger account.
Import Refund Receipts into QuickBooks Online
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…
