Blogger
Share this content
0
11
8842

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

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.

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)

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)

Thanks

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

Thanks (0)

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)

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)
Thanks (0)

vat invoices

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

Many thanks again

Alison

Thanks (0)

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)

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)

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)

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)