Sales Orders

Why Does My Sales Order Sales Tax Item Remain Open?

Use a QuickBooks tax code or change the item type

Problem

Your sales order remains open, even though Connex synced an invoice. 

Description

QuickBooks will not close a sales order if one of the lines includes a Sales Tax Item. This is a common occurrence when Add tax as a line item is selected in the automatic mapping section of sales tax settings.

Solutions

#1 Map QuickBooks tax codes

  1. In Connex, go to sales tax. Disable the Add tax as a line item setting in the automatic mapping section of sales tax settings.
  2. Use Manual Mapping to apply tax codes by either uploading a .CSV file or entering individual codes.

For additional information:

#2 Create sales tax as a service item

  1. In Connex, enable the Add tax as a line item setting in the automatic mapping section of sales tax settings.
  2. Find the Sales Tax Item in your QuickBooks file that matches this naming convention. Change the name of this Sales Tax Item to something else (eg, ShopifyTaxOLD).
  3. Recreate SalesTax a service item:
  4. Create a new Service Item called SalesTax:
  5. Now create a new liability account (you can call it whatever you want). Assign this liability account to the new Service Item. This option allows you to import sales tax as a line item without using a Sales Tax Item in the line.
  6. The sales tax amount will apply to the liability account. We recommend using journal entries to manage debit sales tax income and credit sales tax payable, on a scheduled interval. This can be done under Company > Journal Entries: