QUESTION How I should my data be mapped when importing into QuickBooks Desktop (QBDT)? RESOLUTION The attached Data Dictionary shows the types of lists and transactions that can be imported using Rightworks Transaction Pro Importer into QBDT, as well as the available and required fields for each import type.…
QUESTION If importing Sub-Levels for Customers, Vendors, Classes, Products and Services, or Accounts into QuickBooks Online using Rightworks Transaction Pro Importer, how do they need to be formatted? RESOLUTION Format for Customers If the Customer import file contains Sub-Customers, both the main Custome…
MESSAGE " Hours/minutes must be supplied for a time tracking item" RESOLUTION Check to see if any transaction in the import file that have a zero for the duration. These rows should be deleted from the import file prior to importing.
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…
Employee Expense Reimbursements may be imported into QuickBooks Desktop (QBDT) using Transaction Pro (TPro) Importer as either a Bill import type to be reimbursed at a later date or as an Check import type, if the reimbursement has already occurred. This article discusses importing as a Check import type. For info…
MESSAGE "This account period is closed" RESOLUTION The date of the transaction being imported falls before the closing date restriction that has been set in QuickBooks Online. To import, either the date of the transaction to be imported will need to be changed to a later date or the closing date restriction will need…
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 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 is needed to be imported that is not available to download from the financial institution's website in one of Rightworks Transaction …
MESSAGE "Error validating Invalid double:" when importing Time Activities into QuickBooks Online RESOLUTION Verify the following: * If importing billable time into QuickBooks Online, be sure to have an import column with a Y mapped to BillableStatus or enter a Y for the Default Value column. * If import…
Sometimes, it may be necessary to sever the connection between QuickBooks Desktop (QBDT) and Rightworks Transaction Pro Importer. No saved information will be lost when this function is performed. It only severs the connection and forces Importer to reconnect to QBDT the next time that it is launched. To disconnec…