QUESTION What is the easiest way to tell if a QuickBooks Online company is set to automatic or manual tax? RESOLUTION The quickest way to tell if on the automatic sales tax or manual sales tax option is to open a Customer in QuickBooks Online and go to the TAX INFO tab. If the tab displays a checkbox followe…
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 What Options are available to be used when importing using Rightworks Transaction Pro Importer for QuickBooks Online? RESOLUTION There are currently 19 Options available to be used with Importer, but the list of available Options continues to grow. To access all the Options, on the Preview and Im…
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 …
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 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…
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.
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…