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).
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.
ISSUE QuickBooks found an error when parsing the provided XML text stream RESOLUTION If you are receiving this error AFTER mapping your data and clicking import, it is usually caused by one of the three items below. Please review the import file for these items. * Import data includes special characters …
MESSAGE " Error Validating Employee or Vendor" when importing Time Activities. RESOLUTION This message appears because an Employee or Vendor in the import file does not already exist in QuickBooks Online. All Employees and Vendors in a Time Activities import file must previously exist in QuickBooks Online pr…
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…
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 Check import type. For i…
QUESTION Can imports using Transaction Pro Importer with QuickBooks Desktop (QBDT) be scheduled/automated? RESOLUTION For more advanced users who would like to schedule imports into QBDT, a full command line interface exists that you can use to start the process even if the QBDT company file is not open. The…
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…
ISSUE Most financial institutions will keep a few months of activity on their website for account holders to download as either an Excel or .csv file. What happens, however, if data needs to be imported that is not available to download from the financial institution's website in one of Rightworks Transaction P…
When importing a Chart of Accounts into QuickBooks Online using Rightworks Transaction Pro Importer, the types listed below are the only valid Account and Sub-Account (Detail) types currently available to be used with Importer. NOTE : There are no spaces between the words for the Account Types or Sub-Account Types…