Unusual data is getting added to QuickBooks

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.

Details

When importing data into QuickBooks, QuickBooks 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 QuickBooks. To resolve:

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

Income Accounts

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

  1. Review the linked accounts in SalesPRO. Compare the names to the accounts in QuickBooks and correct as needed. You can correct in either SalesPRO or QuickBooks 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 QuickBooks. For example if your cost of good sold account in QuickBooks is called "Cost of Good Sold" but in SalesPRO you entered "Cost of Good Sold". When a product is imported QuickBooks will create a bank account called "Cost of Good Sold". To resolve:

  1. Find the account in the Chart of Accounts list in QuickBooks.
  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 QuickBooks.

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 QuickBooks 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 QuickBooks. You will need to delete any data that associated with the service items first.
  3. Export the item from SalesPRO and import into QuickBooks. For example if a product was added to QuickBooks as a service item, delete the item from QuickBooks, export the product from SWCS and then import it into QuickBooks.
  4. Export the original data you imported.

APPLIES TO

  • SalesPRO Software

    • Related Articles

    • Requirements for exporting certain data to QuickBooks

      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 ...
    • What data is exported to QuickBooks

      Overview This article explains what data is exported from SalesPRO when QuickBooks 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 address The ...
    • Product does not get added to the system when doing a Product Refresh

      Symptoms After performing a Product Refresh in Product Manager to add a new product the product is not added. When looking in the Event Log the following error is listed: The product 'xxx' from the product file 'yyy' could not be added. More ...
    • 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, ...
    • Update Company Database for QuickBooks Invoice Exporting

      Summary This package will update the company database so that invoices for QuickBooks Desktop can be correctly exported from SWCS. Without this package the sales tax is not included in the invoice export which will prevent it from being imported into ...