alisonmcann
Blogger
Share this content
0
11
9619

Sage Cash Accounting Vat Report Includes invoices which are still unpaid.

Sage Cash Accounting Vat Report Includes...

Hi, I hope some-one can help.  The company I work for are using the Vat cash accounting scheme, whereby we only account for vat on the invoices which are paid.  Recently I had a look at a detailed report of our return to date & I found that it had included invoiced which we have not received payment for.

I have checked the setting for vat in sage & it clearly states that we use the cash accounting scheme, why then is sage counting these unpaid invoices in our return.

Any ideas will be greatly appreciated.

Alison

Replies

Please login or register to join the discussion.

avatar
02nd Mar 2011 14:34

Cash Accounting

Invoices should not be appearing on the the Return at all on Cash Accounting - the report that you ran, was this the Detailed Report that you can run by clicking Print on the VAT Return screen after calculating the VAT Return or is it a different report?

John

Thanks (0)
avatar
02nd Mar 2011 21:13

Sage VAT Report

If you are using cash accounting for VAT, the Sage VAT Details report will list payments, not invoices. If your report is listing invoices, I think perhaps the Cash Accounting check box has been ticked after invoices have already been recorded and that these invoices have not been reconciled on a previous VAT return.

Thanks (0)
avatar
03rd Mar 2011 08:56

Thanks

Hi John thanks for your reply, you are correct I am clicking the print button after the vat report screen.

Thanks (0)
avatar
03rd Mar 2011 09:02

VAT Report

Not something I've ever seen - even if you had changed the VAT Scheme at some point, the report knows which scheme you are on now and should report the transactions accordingly...

If you run Check Data, do you get any errors?

John

Thanks (0)
avatar
03rd Mar 2011 20:06

Vat Report

Hi John, There are no errors, No one i have spoken to have ever seen this, would it have anything to do with the fact that all the invoices are posted even though they are unpaid?

Thanks (0)
avatar
03rd Mar 2011 20:13
Thanks (0)
avatar
03rd Mar 2011 20:33

vat invoices

Thanks John, I will back up to memory stick & contact you in next few days. 

Many thanks again

Alison

Thanks (0)
avatar
By janeym
18th Apr 2011 10:46

Cash Accounting - VAT return

Hi Alison

Did you get anywhere in solving this problem?  I've had the same thing happen on my VAT return.

 

 

Thanks (0)
avatar
18th Apr 2011 11:04

Cash Accounting

I've tried multiple scenarios to try and recreate this problem with no success, nor is it something I've seen before with any data.

As per my offer to the OP, I'd be happy to take a look at your data, free of charge to see if I can find the problem...

John

Thanks (0)
avatar
19th Apr 2011 08:59

sage

HI

I am sorry I have not yet got anywhere with this matter, my boss has taken out sage cover recently but as yet I have not had time to call them.  I have not been able to take up the offer from OP tocheck all the data as my boss will not allow me to, but thank you for your offer as it was much appreciated.

If sage can give me an answer I will let you know.

Thanks (0)
avatar
11th May 2011 14:44

sage Vat

Hi

I have finally got my problem sorted, go into settings & configuration then tax codes, double click on each code & check if reverse charge is ticked ( this should only be ticked for EC sales code ), otherwise untick it & this solve the problem. Simples :)

 

Alison

Thanks (0)