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…
QUESTION How can in the box THIS CUSTOMER IS TAX EXEMPT on the Tax tab of Customer setup being checked when importing Customers? RESOLUTION When processing a Customer import, if a value is imported for the TAX EXEMPTION REASON field in the Rightworks Transaction Pro mapping, the box for THIS CUSTOMER I…
The following are instructions for importing the CenterCard Credit Card Report into QuickBooks Online using Rightworks Transaction Pro Importer. After downloading a Credit Card Report from CenterCard , log into Transaction Pro and select to IMPORT. CHOOSE IMPORT TYPE: Select CREDIT CARD CHARGES as you…
QUESTION How can fees on PayPal transactions be imported? RESOLUTION The download file from PayPal has the gross amount and the PayPal fees listed on one line. However, in Rightworks Transaction Pro Importer, only one item can be mapped per line. The workaround for this is to import the Gross Amount as a Pro…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes RefNumber Ref no. Y Alpha-numeric 21 The Reference Number is the assigned Vendor Credit Number, but it also is how TPro and QuickBooks Online know which detail rows belong on the same transaction. Imp…
QUESTION Can a Trial Balance Report export be scheduled with Rightworks Transaction Pro Exporter for QuickBooks Online? RESOLUTION When exporting the Trial Balance Report from QuickBooks Online with Exporter, there is the option to schedule future exports. The schedule can be one time or recurring. This opti…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 31 To import Term be a Sub-Term of another Term, use format Term:Sub-Term DueDays Due in fixed number of days N Numeric 3 Due Date calculated by adding the specifi…
TPro Field Name QuickBooks Online Field Name Required Character Type Character Limit Notes Name Name Y Alpha-numeric 100 To import Location be a Sub-Location of another Location, use format Location:Sub-Location.
MESSAGE "You must select a product/service or an account for each split line with either an amount or a billable customer" RESOLUTION This is a known bug in the QuickBooks Online Application Program Interface (API) as it is a false error message. The actual issue is that an expense transaction (Bills, Che…
MESSAGE "Root Element is Missing" RESOLUTION The message appears because Rightworks Transaction Pro Importer is experiencing intermittent issues with QuickBooks Online Application Programming Interface (API). Please go into QuickBooks Online and review recent transactions and re-import any remaining trans…