I have just receieved a client's year end Sage Line 50 file and it seemed great at first as the bank was reconciled and the postings looked accurate.
However, I noticed that there was a Purchase and Sales Tax Accounts with numbers in the TB and the client is not VAT Registered.
I have found a report to idenify some of the transactions - via the VAT Return, but some (random) transaction have been posted as T9 (i.e.they do not appear on the VAT Report).
I need to identify which nominal codes that the VAT amounts have been posted to, and am nearly there in regards to the data, but I still need to work out how to filter the amounts by nominal code. I guess the best bet is to transfer to csv file then play about in excel?
How large is the difference, you could always right it off using the get out of materiality! The sales tax account can be written back to Sales straight away.
I think CSV option is probably your best route.
I find it bonkers that sage allows you to do this if you are not vat registered!
__________________
Phil Hendy, The Accountancy Mentor
Are you thinking of setting up your own practice or have you set up and need some help?
If so a mentor may be the way forward - feel free to get in touch and see how I can assist you.
I have an application you can trial for free which will give you all the T9 transactions for any date range in under 30 seconds. Features live link to sage to pick up all new entries
Excel based and very simple to use simply click 3 buttons.
Thanks
Jeremy Optegra Financial
__________________
"Quite simply the best add on for Sage we have ever invested in.."
Want to see what all the fuss is about? Click here: OptegraMRP
