Blogger
Share this content
0
2
1116

Report on items without a VAT code in QuickBooks-2013

Hi,

I did my VAT return today and noticed that an invoice I had paid did not show up in the Detailed VAT Report in QB2013 on checking the invoice I had omitted to put N for not registered in the drop-down box, changing it fixed the problem but I thought I should check to see if I had made the mistake elsewhere. OK as no VAT is involved it doesn't change anything but just in case, I tried everything I could think of to produce a report to identify any offending invoice entries but cannot find a way.

Anybody got any ideas or even if I should bother, if I change all the historic entries will it produce a massive Exception report?

I upgraded from 2003 to 2013 in May 2013 at my year start and was unable to transfer my QB file but did manage to transfer the Customers and suppliers files but today I can see that it transferred none of the VAT codes. So another job trying to remember who is VAT registered and who is not!

Thanks for any suggestions.

Steve

Replies

Please login or register to join the discussion.

avatar
13th Aug 2014 16:49

Various Options

I think the easiest way to capture any transactions where you have forgotten a VAT code is to run either the balance sheet or profit & loss, change dates to all, at top where is says columns change to VAT code – this will show you total spend per VAT code including items with no code

Re remembering which suppliers are VAT registered and which are not – surely the safest option would be to look at the invoices they have sent you?  QB will normally provide some free software for in between years to enable the data to upgrade from 2003 to 2013

 

Thanks (0)
avatar
14th Aug 2014 12:34

Done it

Thanks @fiona-howells,

It didn't work as you described because the columns button wouldn't do anything but I then saw the expenses by Supplier report and as I started anew with QB2013 there were only about 50 suppliers rather than the 500 odd in my supplier file, some of which I have only used once in ten years.

So by putting a Vat Code filter of N in it actually showed the ones with nothing as well so it was easy to click on them to bring up an invoice to see how they charged last time and change the vat code in the vat file without having to dig out all the invoices. So job done very quickly and thanks for pointing me in the right direction. So difficult to see the wood from the trees sometimes and a good moral "don't be lazy and use the quick supplier setup" But it is strange that some reports treat nothing as an N code but the Vat report doesn't or at least show them in the exception report.

Out of interest the QB software to convert 2003 to 2013 failed and they required me to send the QB file into them for conversion and I didn't fancy sending my whole business off to some contractor in India or wherever so I decided to start again which of course got rid of all the crudd that had built up over the years especially as the VAT system is so much better in 2013.

Once again thanks for your help.

Steve

Thanks (0)