Results 1 to 7 of 7

Thread: Vat control account balance, pastel

  1. #1
    New Member
    Join Date
    Jun 2012
    Location
    cape town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Vat control account balance, pastel

    Hi. Please can someone advise me why my total nett vat is different to my vat control account balance in pastel and how do I correct this.
    Thank you

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    There are a number of reasons that can cause this.


    1. If you pay VAT or claim VAT for an amount that is different to the previous VAT report, as per Pastel, then there will be a difference when you run the VAT report for the next VAT period.
    2. If you process back-dated transactions, that have VAT implications, into prior VAT periods.
    3. If you process journals directly into the VAT Control Account, other than payments to SARS or claims from SARS. It is critical that you only use the relevant VAT code in the "Tax" column to process VAT entries, so that both the VAT Control Account and the VAT reports are updated in sync.
    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)

  3. #3
    New Member
    Join Date
    Jun 2012
    Location
    cape town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Good morning Neville
    Thank you for your reply. Please can you tell me how I can correct the vat balance for your reason number 1
    Thank you
    Kind regards
    jackie

  4. #4
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    Hi Jackie,

    If the difference is because of reason 1, then either:
    • The VAT was processed correctly, but you paid SARS the incorrect amount; or
    • The VAT was processed incorrectly, and you paid SARS the correct amount, based on manual calculations.


    If point 1 is the case, then you need to over/underpay SARS by the difference when you submit your next VAT return, and then the VAT Control Account balance will tie up with the VAT report for the following VAT period.

    If point 2 is the case, then you need to pass correcting entries in the prior months, so that the VAT is correctly calculated. For example, if you processed a cashbook payment for Bank Charges of R114.00 (VAT inclusive), but you omitted to claim the R14.00 VAT by using the VAT code 01, then you need to do the following two entries to fix the incorrect transaction:
    • Recapture the payment in the cashbook, exactly as you captured it originally, i.e. without the VAT code, but put a minus sign in front of the amount. This will effectively reverse the original entry.
    • Capture the payment in the cashbook once more, with no minus sign, but now include the VAT code in the entry.


    Hope this makes sense.
    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)

  5. #5
    New Member
    Join Date
    Jun 2012
    Location
    cape town
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Hi.
    I did an inventory journal on pastel but the amount reflected on the trial balance is completely different to the amount I actually processed. Why would they differ?
    Thank you

  6. #6
    Email problem
    Join Date
    Feb 2014
    Location
    Durban
    Posts
    2
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Jackievdw View Post
    Hi.
    I did an inventory journal on pastel but the amount reflected on the trial balance is completely different to the amount I actually processed. Why would they differ?
    Thank you
    If my Balance of Tax Control amount is R14030.50 and my Tax Total amount as per my report is R16060.96 - did I over or underpay SARS?

  7. #7
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,760
    Thanks
    44
    Thanked 451 Times in 396 Posts
    You have overpaid SARS.
    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)

  8. Thanks given for this post:

    Ola (19-Nov-20)

Similar Threads

  1. Credit card cashbook won't balance
    By Vinruby in forum Accounting Forum
    Replies: 2
    Last Post: 10-Jan-12, 12:53 PM
  2. Replies: 0
    Last Post: 21-Dec-11, 05:52 PM
  3. [Question] Zero balance appearing for a customer that owes money
    By blou in forum Accounting Forum
    Replies: 3
    Last Post: 24-Nov-11, 03:25 PM
  4. Replies: 7
    Last Post: 21-Feb-11, 09:45 AM

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
  •