Home → EstiMate Version 1 → Technical Support Bulletins → Bulletin: Importing Sales Tax Info into QuickBooks

5.4. Bulletin: Importing Sales Tax Info into QuickBooks

When importing the records from EstiMate, QuickBooks places the sales tax into a new bank account instead of an ?Other Current Liability? sales tax payable account.

EstiMate Technical Support Bulletin

NOTE: The information outlined in this support bulletin is directed to those users of EstiMate who are using QuickBooks accounting software and the export functions of EstiMate. If you are using another accounting software package or are not using the export functions in EstiMate you may disregard this notice.

We have discovered a limitation in QuickBooks that affects the importing of sales tax information from EstiMate. When importing the records QuickBooks places the sales tax into a new bank account instead of an ?Other Current Liability? sales tax payable account.

Support for QuickBooks is beyond the scope of our support desk, but the following instructions are provided in the interest of assisting our customers. These instructions are in no way guaranteed and are all the instruction / support we will provide on this issue. WYSIWYG.

The following procedure is recommended to resolve the problem:

1. Open QuickBooks
2. On your keyboard press Ctrl-A to reach the chart of accounts.
3. Scroll approximately ¼ of the way down on the page to the ?Other Current Liability? section.
4. Find and identify the sales tax payable account.
5. Write down the name of the account paying close attention to upper and lowercase as well as any spaces between words.
6. Open EstiMate. Click Management > Configure EstiMate > Program information Tab. Examine the ?Local Tax Rate? description field located towards the lower right of the screen. The description must match exactly the sales tax payable account name from QuickBooks. If it does not exactly match then change the description in EstiMate to match the name you notated from QuickBooks, again making a careful attention to case and spaces between words.
7. Click the OK checkmark in EstiMate to save your changes.

This will insure that all future jobs that are exported will end up in the correct account.

QUESTIONS AND ANSWERS

Q: What about jobs that I have already imported?

A:
1.Open each invoice or cash sale individually that you have imported so far and drop down the tax box. Select the proper tax and save the record. Continue this process until all invoices have been corrected.

2. Press Ctrl-A and find the sales tax ?bank? account that QuickBooks created after importing. Make sure the balance is zero. Highlight the bogus bank account and press Ctrl-D to delete it.

This procedure will effectively eliminate the incorrect account that QuickBooks created after importing.

Q: What if the balance on the unwanted account is still not zero after completing step number one?

A: You will want to go through the invoices again to make sure one of the records was not overlooked.