How to handle cost tax with QuickBooks Integration

QuickBooks does not support cost tax; ESC does. This article will show you how to use the two together to handle cost tax effectively.

Setup:

QuickBooks does not handle cost tax. ESC gets around this by sending a general journal entry over to QuickBooks for the cost tax. This can cause a problem if it goes directly to the Sales Tax Payable account because there will be no due date associated with it. Follow these steps to setup a Cost Tax Payable account to use as a temporary holding area for those taxes until they need to be paid.

  1. Create a new Cost Tax Payable account in QB. This will be an Other Current Liability type account.
  2. Go through the QB Connection Wizard in ESC (File → QuickBooks Connection Wizard) and add the new account to ESC. Exit the wizard once this has been done.
  3. Create all of your tax codes that are based on cost in ESC. Use the Cost Tax Payable account for the line items that make up the tax. The Cost Account should be some sort of cost of sales or expense account.
  4. Use ESC normally. As invoices are posted to QB that use the cost tax codes the cost tax will accumulate in the Cost Tax Payable account. This allows you to see the total cost tax liability accrued at any point in time.

Remitting Taxes:

  1. When it is time to remit your taxes you will have to make a single journal entry to move the tax from the Cost Tax Payable account to the Sales Tax Payable account. To determine the amount of this journal entry run the Sales Tax Report in ESC (Sales → Reports → Sales Reports → Sales Tax Report) for the desired time period. Add the Tax amounts together from each Cost Tax Group on the report. You may also want to add the material cost amounts separately for reporting purposes.
  2. Once you know the amount of the journal entry, create it directly in QuickBooks by going to Company → Make General Journal Entries. Debit the Cost Tax Payable account for the amount using a memo similar to this so that you will know what the transaction was for: Move 05/2009 cost tax so it can be paid. Credit the Sales Tax Payable account for the same amount using the same description but also associate your tax vendor to this line by selecting them in the Name field. Save & Close.
  3. Now simply pay your sales tax normally in QuickBooks by going to Vendors → Sales Tax → Pay Sales Tax. Select all the line items and choose OK. Print the checks when you are ready to do so using the normal method in QuickBooks.
Was this article helpful?
0 out of 0 found this helpful

Still have a question? Try searching here or join an online chat below!

2 Comments

  • Avatar
    Brinda Smith

    So is this telling me ESC doesn't track sales tax due to the state?

  • Avatar
    Scott Haugsjaa

    Hello Brinda, ESC absolutely tracks Sales Tax due to the State.

    This article covers a specific scenario that is involved with Cost Tax when using QuickBooks as your Accounting Package with ESC. And is only relevant to those that are concerned about how the Tax is displayed in QuickBooks after coming from ESC, if that Tax is directly goes into a Sales Tax Payable account.

    If you are ever looking for more detail or information on a specific topic, or looking for greater clarification, we have some incredibly helpful outlets available. Simply click the link below and feel-free to submit a ticket or open a chat.

    https://descohelp.zendesk.com/hc/en-us/articles/219482847

    We'd be happy to go over any topics with you! So just let us know!

Please sign in to leave a comment.