Skip to content
  • There are no suggestions because the search field is empty.

Troubleshooting Sales Tax Template Import Issues for QuickBooks Desktop Enterprise Hosted on RightWorks

This article helps Webgility Desktop users in diagnosing and resolving sales tax mapping import errors when integrating Shopify with QuickBooks Desktop Enterprise hosted on RightWorks. It provides operational steps for troubleshooting issues encountered during the import of sales tax templates used to configure city-based tax mapping. Common causes include data formatting or entry errors within the template, and the guide assists users in identifying and correcting these to achieve successful imports.

Overview

This article provides operational steps to diagnose and resolve sales tax mapping import errors encountered when integrating Shopify with QuickBooks Desktop (QBD) Enterprise, hosted on Right Networks. This guide assumes the user is importing a sales tax template to configure city-based sales tax mapping.

Common Import Error Causes

Sales tax template import errors typically relate to data formatting or entry mistakes. A successful import after entering mapping for a single city suggests issues with template content or structure.

Frequent Sources of Error

  • Blank fields in required columns
  • Spelling mismatches between template city/state names and those in QBD
  • Extra/missing columns or altered column headers
  • Non-standard characters, formatting, or encoding issues

Step-by-Step Resolution

1. Verify the Template Structure

  • Ensure you are using the most recent, supported sales tax mapping template from the integration provider or documentation.
  • Template columns (e.g., City, State, Tax Rate, Tax Agency) must match expected headers exactly (case-sensitive, no extra spaces).
  • Open the template in a basic text editor or Excel and confirm there are no hidden columns or special formatting.

2. Check for Data Entry Issues

  • Scan for blank rows or cells in required columns. Remove any completely empty rows, especially at the bottom.
  • Double-check city and state names for typos or mismatches with exact QBD naming conventions.
  • Validate that all required fields are populated for each city.

3. Prepare a Test Import with Minimal Data

  • Create a new copy of the template containing only one city sales tax mapping as a test (as previous success indicates this isolates template issues).
  • Attempt the import. If successful, incrementally add more cities to identify any entry causing the error.

4. Resolve Formatting/Encoding Problems

  • Save the template as CSV UTF-8 format if using Excel; avoid any non-standard file encodings.
  • Avoid saving as macros-enabled or with formulas—static CSV data only.

5. Review Integration/Environment Factors

  • Ensure you are logged into QBD with appropriate permissions on Right Networks.
  • Confirm that the Shopify-QuickBooks integration app or connector tool version is up to date.

6. Monitor and Confirm Successful Import

  • After a successful test with minimal data, expand mappings gradually.
  • Check QBD's Sales Tax Item and Tax Agency lists to confirm proper import.
  • If errors persist at scale, consider splitting the template import into smaller batches.