QB2003 VAT detail report (cash net) & vat detail report (cash VAT)

[dominiquer]

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]

The Australian GST system is similar to your VAT, so I hope this helps.
QuickBooks uses tax codes attached to transactions to decide what is reportable, not just to decide the Tax component. However, there are some transactions that occur in business that are not reportable for GST. These include "money movements", where no activity actually occurs to trigger a responsibility for GST reporting. These transactions are best left with no code attached. If you attach a code, even a zero-based code, QuickBooks will expect that you want these transactions included in your VAT reports. If this is what you need, create the zero tax code. (We have a FRE code for sales that do not have a GST component, and NCG for Purchases). All Sales transactions that are reportable, that have no GST, use the FRE code. But any transaction that is not reportable does not have a code. Your previous transactions cannot have this code automatically added. You will need to manually add the code to each line of the transactions. As there is no tax, it will not alter the amounts on the invoices or cash sales dockets, but will fix the reporting.
Use a Custom Transaction Detail report, totalled by Account and with Tax Codes as an added column, to check if you have coded transactions correctly.