QB2003 VAT detail report

[dominiquer]

QB2003 VAT detail report (cash net) & vat detail report (cash VAT)
QuickBooks 2003 regular VAT detail report (cash net) & vat detail report (cash VAT) are not accurate as yet (26/4/03). They still do not list VAT zero rate in sales if I run "last VAT quarter" (which is the period before I bought and installed that new Quickbooks). The VAT 100 is accurate though!! I have cash accounting.

First of all Intuit support says you should not use the SORT BY "default" but select "type".

Then under MODIFY REPORT, FILTERS, VAT CODES, select SELECT VAT CODES and tick them all.

This works when I select as DATES "current VAT quarter". The zero VAT rate does show!!! But when I select for DATES "last VAT return" the zero rated items do not show!!!

I just tried to create another VAT rate with a zero value and used it in a sale transaction but that still does not work for my last VAT period. I did the RECEIVE PAYMENT and DEPOSIT at a date of my last VAT return (Nov-Jan) of course.

When I was lucky enough to talk to customer support I had a visitor to whom I had to talk to and had to cut my conversation short unfortunately. The second time I rang they were no longer willing to talk to me unless I paid the CUSTOMER SUPPORT subscription.

Since I received v2 which has not solved that problem.

I make the assumption and I hope that this is due to trying to looking at data before receiving this new QuickBooks.

I am not using it on my live data but on a copy during my spare time.

If I do not return the product. I plan to start really using it at the beginning of my next financial year.

Any positive answers welcome.

[gibbo]

In Australia we have two tax codes (actually lots - but for this excercise we need to consider two), GST with a rate of 10% and FRE with a 0% rate. We sell stock and attach one of these codes to each item sold - some sold at 10% tax others at zero tax. This correctly reports both in the tax reports. The Tax Reports pick up those transaction lines that have a tax code attached. Lines with a zero VAT must have the Tax Code. Adding it now does not put it on previous transactions. You would have to go to each transaction and manually add them to every line. Payments and Deposits do not have tax codes attached - so they cannot be used for VAT reporting. It is in the Sales and Purchases transactions that VAT is calculated - not the receipt of the payments.