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

Sage Cash Accounting Vat Report Includes...

Didn't find your answer?

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 (11)

Please login or register to join the discussion.

avatar
By johndon68
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
By daffodil
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
By alisonmcann
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
By johndon68
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
By alisonmcann
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
By johndon68
03rd Mar 2011 20:13

Invoices on reports

There is nothing I can think of, assuming the settings are correct, that should cause invoices to appear on the VAT Return if you are on Cash Accounting.

I'd be happy to take a look at it for you, free of charge, but I would need a backup copy of the Sage data - if you did want to do this, me email is [email protected]

John

Thanks (0)
avatar
By alisonmcann
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
By johndon68
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
By alisonmcann
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
By alisonmcann
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)