Sales Tax Discrepancy

[John Thompson]

I am operating QB Pro 2003 (gonna update shortly). I am running a sales tax liability report. The balance due as per this report does not match the amount due when I click on Vendors, Sales Tax, Pay Sales Tax. The as of dates are the same. What am I missing? Thanks.

[Joe Williams]

On the Sales Tax liability report there are rows for the tax item. Is the column for "Tax Collected" on each of the tax items correct or is it the "Amount Due" that is wrong?
Is the "amount due", on the report, higher or lower than Pay Sales Tax amount?

[John Thompson]

It's the "amount due" on the report that is wrong. It is higher than the "Pay Sales Tax" amount (not by a lot; only $19.35). Thanks.

[Joe Williams]

That means that an invoice/sales receipt was entered/changed with a date before this tax period.
You can run the Transaction Detail report and modify it to show Entered/Last Modified and then filter it for: Date=1/1/1990 through 12/31/2007 ( all of the previous transactions, Transaction type=Invoice and Entered/Last modified= 1/1/2008 1/31/2008 ( any old transaction entered/modified this year). The colums entered/last modified and Date are normaly the same. If here is any differance, check that transaction.

[John Thompson]

I figured out the problem. It was a general journal entry which reduced the sales tax due. However, this entry was dated AFTER the period in question. So it should NOT have been included when I clicked on Vendors, Sales Tax, Pay Sales Tax. Any idea why it was included in this amount in spite of having a date in the month following the end of the period? The Sales Tax Liability report calculated the correct amount.

Thank you for your help!!

[Joe Williams]

QB includes JE on the tax liability report without reguard of the date on the entry. I don't know why but they do, it may be cause they think it was an adjustmet that should be included.....