Results 1 to 6 of 6

Thread: VAT Control Account

  1. #1
    Junior Member
    Join Date
    Jul 2016
    Location
    South Africa
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VAT Control Account

    Hi There

    I am hoping someone will be able to assist me with the VAT Control Account

    I am using Pastel Xpress Version 11

    I have recently taken over the books for a (small) farming company, I was trying to reconcile the accounts and noticed that the VAT Control Account doesn't balance with the VAT returns (The VAT is was processed manually and reconciled on Pastel at a later stage). The Company is a CC so it has not been audited

    The last time the figures balanced was February 2013.

    I noted while manually going through Transaction Audit Trail the following:

    1. The company receives a Diesel Rebate which is usually paid separately but on the occasions that the company owed money to SARS the Diesel Rebate was deducted from the monies owed, it appears that this amount was then allocated to the VAT Control Account and so the full amount Due and Paid was not allocated correctly. How do I amend this?

    2. Some Invoices were processed incorrectly in the Cash Book (Bank Account) eg: Repairs was processed with no Vat when it should have been processed with VAT, I have noted a number of these transaction between 2013 and 2016, Can I amend this? What do I do if they were processed as GL Accounts and What do I do if they were processed under the Supplier Accounts?

    The year end for 2015/2016 has already been done, but the year end financials have not been done yet Is there a way to amend these discrepancies in the 2016/2017 or should the adjustments be done in the 2015/2016 financial year?

    I do not often work in Pastel and am finding it a little difficult to manoeuvre through all these mistakes

    Any help would be much appreciated.

    Debbie

  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

    Neville Bailey

    Quote Originally Posted by Debbie Mitchell View Post
    1. The company receives a Diesel Rebate which is usually paid separately but on the occasions that the company owed money to SARS the Diesel Rebate was deducted from the monies owed, it appears that this amount was then allocated to the VAT Control Account and so the full amount Due and Paid was not allocated correctly. How do I amend this?
    I would suggest you open a separate Diesel Rebate Control account in the Balance Sheet. When payments to SARS are made for VAT, split the payment into two lines, with the one line being allocated to the VAT Control account (before the deduction of the diesel rebate) and the second line being captured as a negative payment and allocated to the Diesel Rebate Control account. This will ensure that, all other things being equal, your VAT Control account will agree with your VAT reports.

    With regards to past payments to SARS, you will need to reverse each payment (by capturing them as negative payments) and then process them again as described above.

    Quote Originally Posted by Debbie Mitchell View Post
    2. Some Invoices were processed incorrectly in the Cash Book (Bank Account) eg: Repairs was processed with no Vat when it should have been processed with VAT, I have noted a number of these transaction between 2013 and 2016, Can I amend this? What do I do if they were processed as GL Accounts and What do I do if they were processed under the Supplier Accounts?
    If they were processed as GL accounts, process the payments again, exactly as they were originally processed (without VAT), but with a minus sign in front of the amount, and then process them yet again, but with the VAT code. You can only process these amendments in the current year and in the prior financial year, but not before the prior financial year.

    If they were processed to Supplier accounts, the amendments will be determined as to whether the original entries were processed in the form of supplier invoices or in the form of supplier journals. If they were processed as supplier invoices, then process Return & Debit notes to reverse the original supplier invoice and then process revised supplier invoices to account for the VAT. You will only be able to amend supplier invoices in the current financial year, as the system will not allow you to process supplier documents in the prior financial year. If they were processed as supplier journals, the same principle will apply as for the GL accounts.

    Quote Originally Posted by Debbie Mitchell View Post
    The year end for 2015/2016 has already been done, but the year end financials have not been done yet Is there a way to amend these discrepancies in the 2016/2017 or should the adjustments be done in the 2015/2016 financial year?
    I suggest that you process the amendments in 2015/2016, as current year adjustments, and then process them again in 2016/2017 as prior year adjustments.
    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
    Junior Member
    Join Date
    Jul 2016
    Location
    South Africa
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Neville I will give it a bash

  4. #4
    Junior Member
    Join Date
    Jul 2016
    Location
    South Africa
    Posts
    21
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Quote Originally Posted by Neville Bailey View Post
    I would suggest you open a separate Diesel Rebate Control account in the Balance Sheet. When payments to SARS are made for VAT, split the payment into two lines, with the one line being allocated to the VAT Control account (before the deduction of the diesel rebate) and the second line being captured as a negative payment and allocated to the Diesel Rebate Control account. This will ensure that, all other things being equal, your VAT Control account will agree with your VAT reports.

    With regards to past payments to SARS, you will need to reverse each payment (by capturing them as negative payments) and then process them again as described above.



    If they were processed as GL accounts, process the payments again, exactly as they were originally processed (without VAT), but with a minus sign in front of the amount, and then process them yet again, but with the VAT code. You can only process these amendments in the current year and in the prior financial year, but not before the prior financial year.

    If they were processed to Supplier accounts, the amendments will be determined as to whether the original entries were processed in the form of supplier invoices or in the form of supplier journals. If they were processed as supplier invoices, then process Return & Debit notes to reverse the original supplier invoice and then process revised supplier invoices to account for the VAT. You will only be able to amend supplier invoices in the current financial year, as the system will not allow you to process supplier documents in the prior financial year. If they were processed as supplier journals, the same principle will apply as for the GL accounts.



    I suggest that you process the amendments in 2015/2016, as current year adjustments, and then process them again in 2016/2017 as prior year adjustments.
    Hi Neville

    Thank You for your advice about the Diesel Rebate Control Account it was really helpful.

    I just have two further question:

    you said that I should process the amendments in 2015/2016 and then process them again in 2016/2017, could you please explain to me why it needs to be done in both financial years I was under the impression that if you processed Journal or Cash Book entries after the year end has been run that the adjustments would show up on the Trial Balance.

    Perhaps I misunderstood what you were telling me with regards to the current year adjustments and prior year adjustments.

    Just so I am 100% clear the amendments you were talking about in 2015/2016 are all the amendments (excluding the Return and Debit Transactions): VAT Control Account and The Diesel Rebate Control Account and the GL and Supplier Journal Transactions.

    I apologies for asking questions which seem very simple but I am really just a data capturer so my experience is very limited when it comes to corrections from mistakes made by the previous data capturer.

    Thanking you in advance for all your assistance

  5. #5
    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 Debbie Mitchell View Post
    you said that I should process the amendments in 2015/2016 and then process them again in 2016/2017, could you please explain to me why it needs to be done in both financial years I was under the impression that if you processed Journal or Cash Book entries after the year end has been run that the adjustments would show up on the Trial Balance.

    Perhaps I misunderstood what you were telling me with regards to the current year adjustments and prior year adjustments.
    Perhaps I need to clarify how Pastel handles financial year ends.

    Pastel maintains transaction history and balances for the current year and the prior year. So, for example, if you are currently processing in the 2016/2017 financial year, you are able to process journals in the prior year (2015/2016) without having to open the previous financial year's database. These prior year adjustments will automatically adjust the opening balances for the current financial year.

    What I was trying to say in my earlier post was that the prior year adjustments should be processed as prior year adjustment as in the 2016/2017 database, as well as in the 2015/2016 database in its current year. The two databases are independent from each other. In other words, you should have at least two databases in Pastel, i.e. the 2015/2016 database, which contains history for 2015/2016 as well as for 2014/2015, and the 2016/2017 database, which contains history for 2016/2017 as well as 2015/2016.

    Quote Originally Posted by Debbie Mitchell View Post
    Just so I am 100% clear the amendments you were talking about in 2015/2016 are all the amendments (excluding the Return and Debit Transactions): VAT Control Account and The Diesel Rebate Control Account and the GL and Supplier Journal Transactions.
    Yes.
    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)

  6. #6
    Silver Member Christel's Avatar
    Join Date
    Feb 2012
    Location
    Port Elizabeth
    Posts
    360
    Thanks
    57
    Thanked 96 Times in 68 Posts
    Hi there,
    Diesel claims can only happen if you have a valid log book for all expenditure.
    Diesel rebate refunds must be allocated to an Income Statement account - "other income".

    hope this helps.
    always fear when Christel is near....

Similar Threads

  1. [Question] Customs VAT and Tax Control Account
    By SnyLeigh in forum Accounting Forum
    Replies: 3
    Last Post: 21-May-16, 06:44 AM
  2. [Question] Pastel Xpress Tax Control Account
    By LindiD in forum Accounting Forum
    Replies: 0
    Last Post: 21-Apr-16, 03:54 PM
  3. Vat Control Account
    By seymoursmith in forum Accounting Forum
    Replies: 0
    Last Post: 19-Jun-15, 12:00 PM
  4. [Question] Vat control account balance, pastel
    By Jackievdw in forum Accounting Forum
    Replies: 6
    Last Post: 19-Feb-14, 10:55 AM
  5. Replies: 3
    Last Post: 28-Nov-12, 04:06 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
  •