Error when importing into QuickBooks

Error when importing into QuickBooks

When trying to import my QuickBooks .iif file, I get the following error

You cannot associate an item with Sales Tax Payable, Undeposited Funds, accounts receivable, accounts payable, or non-posting

Cause

There can be a number of different causes for this type of error but the most common occurs when the sales tax item on the order being imported is not setup in QuickBooks or it is setup in QuickBooks but as a Service item instead of a Sales Tax Item.

Resolution

First identify the sales tax code that is being used on the order(s) being imported. You can do this by looking at the order in SWCS Order Entry. Then open the Items List in QuickBooks and locate the matching sales tax item.

  • If you don't see one then add a sales tax item to QuickBooks using the same name as the sales tax code in SWCS.
  • If you have a sales tax item in QuickBooks, check its type. If it's setup as a service type then that is most likly the cause and needs to be fixed. You won't be able to change the type of this item in QuickBooks so first try to delete it. If it's not being used you'll be able to delete it. Once deleted you can add the sales tax item correctly and try the import again. If you can't delete it then you'll need to add a new sales tax item to QuickBooks with a different name, rename the matching sales tax code in SWCS and re-export the affected orders.

    • Related Articles

    • Common problems when importing into QuickBooks

      Overview This article will explain solutions to common problems that you may encounter when exporting from SalesPRO and import into QuickBooks. You can't change the type of a name or add duplicate name. This can occur if you attempt to import an ...

    • Unusual data is getting added to QuickBooks

      Overview When reviewing your QuickBooks company you may see data such as accounts, items, vendors, etc. that you don't recognize. This article will explain where some of these items may come from if you're importing SalesPRO data into QuickBooks. ...

    • Importing customers from external sources

      Summary Solatech Focus users have the ability to import customers from external sources, such a CRM systems. In order to do this, the data exported from the outside source must be formatted in a certain way before import.  This knowledge base article ...

    • How to use QuickBooks Online Integration

      Summary This knowledge base article will describe the process of sending information from a Solatech Focus account to a QuickBooks Online account.  This knowledge base article assumes that QuickBooks Online integration is enabled for your account, ...

    • Importing Customer Measurements from a CSV file

      Summary This article will step you through the process of importing customer measurement from a CSV file. What you will need SalesPRO HF5182018 Creating the import file 1. Run Microsoft Excel. 2. On line 1 Add the column headings: Location, Room, ...