Page 2 of 2 FirstFirst 12
Results 11 to 18 of 18

Thread: Excel spreadsheet for VAT reconciliation

  1. #11
    Email problem Mike Simmonds's Avatar
    Join Date
    Aug 2011
    Location
    Bronkhorstspruit
    Posts
    76
    Thanks
    15
    Thanked 29 Times in 20 Posts
    VAT Recon.xls

    Here is the VAT recon, the overall idea is to track cumulative income and expenses and the VAT paid or claimed thereon. Expenses and credit notes applying to prior periods, that will generally not appear on the reports of Accounting Software programs, are one of the main reasons for continually updating this recon before every VAT submission.

    I hope it helps you, but please let me know if you have any queries.

  2. Thanks given for this post:

    Dave A (27-Aug-11)

  3. #12
    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
    Sweet!

  4. #13
    New Member
    Join Date
    Nov 2016
    Location
    Silverton
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by JaunetteK View Post
    I am looking for an excel spreadsheet to use to recon my VAT for the year... anyone have anything like this?
    Hi

    Did you come right with the VAT Spreadsheet, i m looking for one myself, please if you can

    Thank you

  5. #14
    New Member
    Join Date
    Nov 2016
    Location
    Silverton
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi

    mine, i am looking for a spreadsheet that i can use to manually capture the the tax invoices and it calculate the rest, for example: i put the exclusive amount then both tax portion and inclusive are calculated or inserted without me punching the actual numbers and vis vesa

    If possible please see attached and assist with make it more user friendly in terms of the above

    Thanks
    Attached Files Attached Files

  6. #15
    Gold Member Sparks's Avatar
    Join Date
    Dec 2009
    Location
    Port Elizabeth
    Posts
    890
    Thanks
    20
    Thanked 127 Times in 96 Posts
    Formulas are basic instructions. Just tell Excel what you want.
    Select your target cell where you want the answer, type: =
    Then put in whatever you want the answer to be: select the cell with the figure you want to reference
    Type in the function you want Excel to perform: +,-,* or /
    Then type in the reference or select a reference cell
    Now hit "Enter"

    To calculate VAT the formula is "=", "Amount cell", "*", "0.14", then hit "Enter"
    To add VAT the formula is "=", "Amount cell", "+", "the cell with the VAT amount created above", then hit "Enter"

    Remember to select the cell you want the answer to be in first.
    Columns or rows can be filled with the same formula by using the "Fill" function of Excel.

  7. #16
    New Member
    Join Date
    Jun 2017
    Location
    South Africa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good evening all

    Can anyone please assist with a VAT reconciliation template?

    Regards
    DFS

  8. #17
    New Member
    Join Date
    Nov 2016
    Location
    Silverton
    Posts
    5
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by JaunetteK View Post
    I am looking for an excel spreadsheet to use to recon my VAT for the year... anyone have anything like this?
    Hi

    I hope the attached will help you
    Attached Files Attached Files

  9. #18
    New Member
    Join Date
    Jun 2017
    Location
    South Africa
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thank you Risgila, much appreciated

Page 2 of 2 FirstFirst 12

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
  •