Part 1:  Recommended Reports 


The recommended sales tax and sales reporting reports that tie to the QuickBooks posting are noted below. Each report in the DX1 reporting module is built on specific criteria designed for a dealer’s needs. For sales tax report, it is recommended that you use:


Sales Tax Liability by Category


Sales tax Liability by Tax Rate 


Note: Sales Liability by Tax Rate should only be used if required for your dealership for reporting purposes. 



Part 2:  Reconciling DX1 Sales Tax Activity in QuickBooks


The following is a step by step process to review the sales tax transactions in your sales tax payable account in QuickBooks. 


Go to List > Chart of Accounts


Find Sales Tax Payable Account


Right-Click on Sales Tax Payable


Click QuickReport Sales Tax Payable


Change Dates to Sales Tax Return Month (i.e. 8/1/2013-8/31/2013)


Sort by Date


Note the starting balance in bold at the very top underneath the word Balance


Look through your transactions and find the sales tax payment. It should equal the beginning balance of this month’s sales tax activity. If you don’t see it there, go find the check in your register and make sure it was coded to the sales tax payable account. If it is in the QuickReport but is the wrong amount, you will need to research that variance by reviewing your sales tax returns from the previous month(s).


Sort by Memo


Scroll all the way to the top


Look for transactions that the memo does not start with “Z:”


Double-click on each of them that have a tax amount. If it is a non-DX1 transaction then print it out. You will need to adjust your DX1 sales tax reports from #1.


Total all non-DX1 transactions


Total Balance at the end should be the total sales tax collected on the 117B plus any tax collected non-DX1 transactions. If your beginning balance was incorrect, your ending balance will also be incorrect until you get it fixed. Contact your CPA. You may need to make a correction in QB or amend previous month’s sales tax returns.