I am looking for an excel spreadsheet to use to recon my VAT for the year... anyone have anything like this?
I am looking for an excel spreadsheet to use to recon my VAT for the year... anyone have anything like this?
Hi, very simple to make. Excell is extremely user friendly. Draw one up with the help of the "help" files. Just a few basic functions which you will quickly get to know inserted on your template and away you go. If you mail me a rough draft of what you want with fictitious accounts I could throw it together for you. Just me details of how you want to read/print it as well. Weekly/monthly/quarterly ....
Why not use your current accounting program?
I doubt it will not have something for it.
Are you looking for a spreadsheet for a VAT201 reconciliation or for a VAT control account reconciliation?
I am using Pastel, I unfortunately do not know all the ins and outs and sadly cant afford to pay for the maintenance contract with pastel hence them not being able to help me. The bank that finances us does 3 monthly audits and they have requested an excel reconciliation of each account, including VAT. They want monthly and yearly I am pretty new to this so dont even know where to start. I am sitting with study manuals trying to make heads or tails but am getting quite frustrated.... guess a couple of months and all will fall in place.
I am looking for both, our auditors want me to do an excel spreadsheet showing that all my VAT balances. I printed everything from Pastel but just dont know how to put into excel or how to show the layout....
Perhaps I can assist you with getting to grips with Pastel? Obviously you will need to weigh up the difference between paying for Pastel Cover and my fees.
I'm not sure how much you know and don't know, so I can't even give you a quote at this stage. Drop me an email, if you want, explaining exactly what you need training on, and I will see what I can offer...
Neville Bailey - Sage Pastel Accounting Consultant
www.accountingsoftwaresupport.co.za
neville@accountingsoftwaresupport.co.za
IronTree Online Solutions
"Give every person more in use value than you take from them in cash value."
WALLACE WATTLES (1860-1911)
If your Auditors are asking for it they should have a template for you, or at least it should be part of their audit process, otherwise what exactly are you paying them for? However I have a reconciliation that I have been using for the last ten years in Excel, this is a very useful tool as most accounting software packages only report on the 2 months or 1 month that you pull for the report. They do not allow for prior period adjustments and processing that does have an effect on the VAT liability. Unfortunately I am new to the forum so I have no idea of how to email this to you or attach it somewhere.
Participation is voluntary.
Alcocks Electrical Services | Alcocks Pest Control & Entomological Services | Alcocks Hygiene Services
thanks, I agree that if they want it they should give me the format but guess life is not so simple... you can email me on jan@batres.co.za thanks a ton and the forum is great you going to enjoy it
Did you like this article? Share it with your favourite social network.