I've been asked to look at a very old version of Sage (Sage Accounts) for some work I'm doing. I've noticed on there, there are transactions which seem to have been included in a VAT return, as they have been flagged as reconciled, but there are no VAT returns showing in the VAT module, so we cannot run the actual VAT return reports.
I have a feeling I've see this before, where we have up-graded the software and for some reason the VAT information hasn't come across properly, has anyone else come across this? I just can't work out at all how they could have flagged the transactions as VAT reconciled without actually running the return?
I'm on the wrong computer so can't check, but I _think_ it's possible to delete the old VAT returns (and if Sage doesn't offer the option, it may be possible from outside of the program). If my memory is correct, that's quite probably what's happened.
If you need to check the returns as part of what you need to do, in theory you should be able to produce reports that match the returns as were - IIRC, along with the VAT reconciled flag there's a date; the period end date of the return the transaction was included on - and I'm pretty sure that's a named field, so accessible from the report generator. I don't think there are any standard reports for this, so you'd have to either tailor and re-purpose an existing report, or create a new one.
(I may have done this in the past, but I've come up with so many solutions to resolve people's problems I can't remember for certain - which is also why I can't be 100% sure it's possible!)
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)
Well they've certainly run the VAT return process in Sage - otherwise there wouldn't be transactions flagged as VAT reconciled. (It may be possible to flag them as VAT reconciled via the corrections screen, but I can't remember - however, I'm assuming that when you said there are transactions flagged as such, you mean lots. It would be very time consuming to do lots manually like that).
Running the VAT process in Sage doesn't necessarily mean Sage has been used to produce the VAT returns *as submitted* though - that's true. It's entirely possible, for example, that various Sage reports have been run and VAT returns worked out manually from them and then, possibly, someone has decided to 'tidy up' Sage by running a single VAT return covering the entire history of them. (Been there, had to do that - and make it all balance!)
But you'll form a better idea of what's happened by looking at those VAT reconciled flags, running reports based on them and seeing if they seem to correspond with submitted returns.
__________________
Vince M Hudd - Soft Rock Software
(I only came here looking for fellow apiarists...)