Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Excel spreadsheet for VAT reconciliation

  1. #1
    Email problem
    Join Date
    Aug 2011
    Location
    Gauteng
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excel spreadsheet for VAT reconciliation

    I am looking for an excel spreadsheet to use to recon my VAT for the year... anyone have anything like this?

  2. #2
    Gold Member Sparks's Avatar
    Join Date
    Dec 2009
    Location
    Port Elizabeth
    Posts
    890
    Thanks
    20
    Thanked 127 Times in 96 Posts
    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.

  3. #3
    Silver Member geraldenek's Avatar
    Join Date
    Jul 2008
    Location
    Somerset West
    Posts
    229
    Thanks
    19
    Thanked 112 Times in 80 Posts
    Are you looking for a spreadsheet for a VAT201 reconciliation or for a VAT control account reconciliation?

  4. #4
    Email problem
    Join Date
    Aug 2011
    Location
    Gauteng
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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.

  5. #5
    Email problem
    Join Date
    Aug 2011
    Location
    Gauteng
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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....

  6. #6
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Quote Originally Posted by JaunetteK View Post
    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.
    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)

  7. #7
    Email problem Mike Simmonds's Avatar
    Join Date
    Aug 2011
    Location
    Bronkhorstspruit
    Posts
    76
    Thanks
    15
    Thanked 29 Times in 20 Posts
    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.

  8. #8
    Site Caretaker Dave A's Avatar
    Join Date
    May 2006
    Location
    Durban, South Africa
    Posts
    22,648
    Thanks
    3,304
    Thanked 2,676 Times in 2,257 Posts
    Blog Entries
    12
    Quote Originally Posted by Mike Simmonds View Post
    Unfortunately I am new to the forum so I have no idea of how to email this to you or attach it somewhere.
    Hopefully this will help.

  9. #9
    Email problem
    Join Date
    Aug 2011
    Location
    Gauteng
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts

    mrs J K

    Quote Originally Posted by Mike Simmonds View Post
    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.
    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

  10. #10
    Email problem Mike Simmonds's Avatar
    Join Date
    Aug 2011
    Location
    Bronkhorstspruit
    Posts
    76
    Thanks
    15
    Thanked 29 Times in 20 Posts
    Quote Originally Posted by Dave A View Post
    Thanks Dave, I am giving it a try.

Page 1 of 2 12 LastLast

Similar Threads

  1. [Question] Excel Help please
    By greghsa in forum Technology Forum
    Replies: 16
    Last Post: 04-Aug-14, 02:24 PM
  2. NOTIFICATION FROM WORLD DEBT RECONCILIATION COMMITTEE,UK.
    By Vincent in forum Scam Alert Forum
    Replies: 30
    Last Post: 07-Oct-09, 03:42 PM
  3. SASOL & EXCEL in trouble
    By Sieg in forum General Business Forum
    Replies: 5
    Last Post: 21-Oct-08, 11:17 AM
  4. IRP 501, employees tax reconciliation
    By duncan drennan in forum Tax Forum
    Replies: 1
    Last Post: 18-Apr-07, 04:46 PM

Did you like this article? Share it with your favourite social network.

Did you like this article? Share it with your favourite social network.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •