Unusual data is getting added to QuickBooks Desktop

Unusual data is getting added to QuickBooks Desktop

Overview

When reviewing your QuickBooks Desktop (QBD) 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.

Details

When importing data into QBD, QBD will at times automatically create entries so that the import can proceed.

Vendors

Vendors will be created automatically when importing sales tax codes and the vendor name you entered into SalesPRO does not match an existing vendor in QBD. To resolve:

  1. Review the tax agency/vendor for each sales tax code in SalesPRO. Compare the names to the vendors in QBD and correct as needed. You can correct in either SalesPRO or QuickBooks but both names must match exactly.
  2. In QBD, edit the sales tax items that you have already imported. Change the vendor to the correct vendor.
  3. Delete the incorrect vendor in QBD.

Income Accounts

Income will be created automatically when importing products and the sales account name you entered into SalesPRO does not match an existing account in QBD. To resolve:

  1. Review the linked accounts in SalesPRO. Compare the names to the accounts in QBD and correct as needed. You can correct in either SalesPRO or QBD but both names must match exactly.

Bank Accounts

Bank accounts will be created when importing data into that references accounts that don't exist in QBD. For example if your cost of good sold account in QBD is called "Cost of Good Sold" but in SalesPRO you entered "Cost of Good Sold". When a product is imported QBD will create a bank account called "Cost of Good Sold". To resolve:

  1. Find the account in the Chart of Accounts list in QBD.
  2. Right-click on the account and Use Register.
  3. Review the transactions to find out where the account was used.
  4. Edit or delete the transactions to so they reference the correct account.
  5. Once the account is no longer used you can delete it.
  6. Make sure to adjust SalesPRO to reference the correct account in QBD.

Service Items

Service items will be created when you import invoices, products, tax groups that reference items that don't exist. To allow the import to proceed QBD will create the item however it creates the items as service items which usually not what you want. To resolve:

  1. Review the service items that were created to determine what they should be (product item, sales tax code, etc.)
  2. Delete the service item from QBD. You will need to delete any data that associated with the service items first.
  3. Export the item from SalesPRO and import into QBD. For example if a product was added to QuickBooks as a service item, delete the item from QBD, export the product from SWCS and then import it into QBD.
  4. Export the original data you imported.

APPLIES TO

  • SalesPRO Software

    • Related Articles

    • What data is exported to QuickBooks Desktop

      Overview This article explains what data is exported from SalesPRO when QuickBooks Desktop (QBD) is selected as the accounting application. QuickBooks Desktop Employees Employee Name - This the full name which is made up of the First M. Last. Home ...
    • Requirements for exporting certain data to QuickBooks Desktop

      Overview This article will explain what data is required when exporting to QuickBooks. QuickBooks Desktop Sales Tax Codes Tax Agency/Vendor. This must reference the name of a vendor in QuickBooks that is setup to collect sales tax. This is not ...
    • Update Company Database for QuickBooks Desktop Invoice Exporting

      Summary This package will update the company database so that invoices for QuickBooks Desktop (QBD) can be correctly exported from SWCS (SalesPRO). Without this package the sales tax is not included in the invoice export which will prevent it from ...
    • Error when importing into QuickBooks Desktop

      When trying to import my QuickBooks Desktop .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 ...
    • Customers with parent customers don't export to QuickBooks Desktop correctly

      Symptoms When a customer that has a parent customer is exported to QuickBooks Desktop (QBD) the parent customer information is not included in the export file. Cause This is caused by a bug in the SWCS QBD module. Workaround There is no known ...