Results 1 to 10 of 10

Thread: Pastel v11 Tax Report Difference

  1. #1
    New Member
    Join Date
    Mar 2013
    Location
    Cape Town
    Posts
    9
    Thanks
    6
    Thanked 0 Times in 0 Posts

    Pastel v11 Tax Report Difference

    Hi There

    I am using Pastel v11 for the first time and on printing the tax type report for Jan & Feb, I'm finding the following difference:

    Balance of Tax Control Account as at 28/02/2013 R43 912.18
    Tax Total as per this report R43 780.35
    Closing Balance of VAT/Tax Control Account is R43 912.18

    It gives me a difference of R131.82. As far as I know, the report printed out at the end of December balanced and that amount was paid to SARS. I notice in the VAT/Tax Control Account, however, that the opening balance for Jan/Feb differs by the same amount yet we have checked through our processing and cannot find anything that may have been backdated to the previous tax period.

    Would anyone be able to help us figure out what other things we could look at that may have caused this difference? Any help would REALLY be appreciated!!

    Thanks
    Sasha

  2. #2
    Diamond Member Neville Bailey's Avatar
    Join Date
    Nov 2010
    Location
    Westville, Durban
    Posts
    2,515
    Thanks
    36
    Thanked 408 Times in 355 Posts
    Hi Sasha, something else that you can check is whether any transactions have been allocated directly to the VAT control account, apart from your payments/claims to and from SARS.
    Neville Bailey - Pastel Accounting Consultant and Photographer
    neville@accountingsoftwaresupport.co.za
    www.accountingsoftwaresupport.co.za
    IronTree Online Solutions
    View Neville Bailey Photography

    "Give every person more in use value than you take from them in cash value."
    WALLACE WATTLES (1860-1911)

  3. Thanks given for this post:

    Sasha (02-Apr-13)

  4. #3
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,519
    Thanks
    221
    Thanked 334 Times in 291 Posts
    Hi Sasha - an invoice dated the previous month and entered after VAT was paid will show a difference. Also check your journal entries ... if you use 01 in Journals they do not always show correctly in the report.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  5. Thanks given for this post:

    Sasha (02-Apr-13)

  6. #4
    New Member
    Join Date
    Mar 2013
    Location
    Cape Town
    Posts
    9
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thanks so much...really appreciate your help! Will let you know if I manage to sort it out.

  7. #5
    New Member
    Join Date
    Mar 2013
    Location
    Cape Town
    Posts
    9
    Thanks
    6
    Thanked 0 Times in 0 Posts
    Thanks all - managed to resolve the issue. The previous bookkeeper had left out a VAT amount for an entry posted in June last year. Thank heavens we managed to find it!

  8. #6
    Diamond Member Mike C's Avatar
    Join Date
    Apr 2012
    Location
    Durban
    Posts
    2,519
    Thanks
    221
    Thanked 334 Times in 291 Posts
    Quote Originally Posted by Sasha View Post
    Thanks all - managed to resolve the issue. The previous bookkeeper had left out a VAT amount for an entry posted in June last year. Thank heavens we managed to find it!
    The latest Pastel (Xpress 12) now has an option where you close your VAT after doing your return. Any "late" entry after that is flagged and shows in your report. I think that this will be quite a helpful feature.
    An education isn't how much you have committed to memory, or even how much you know. It's being able to differentiate between what you do know and what you don't. - Anatole France

  9. #7
    New Member
    Join Date
    Jan 2019
    Location
    Rustenburg
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi I'm now learning about pastel, etc. When I was searching for how the balance of tax control account is worked out, I came across your question. So we have been using pastel for many years and for the last few years the balance of tax control account and the tax total as per this report is way different.

    In another thread I read that it should be the same? here is the link to that thread. https://www.theforumsa.co.za/forums/...ort+difference

    So what I want to know is:
    1. What is the balance of tax control account?
    2. How is it calculated?
    3. Must it be the same as the tax total as per this report?

    For example our Tax Type report for the tax period 201812 (01/11/2018 - 31/11/2018)
    The Balance of tax control account as at 31/12/2018 is R 1133128.01
    The tax total as per this report is R-227738.73

    Thanks for your help

  10. #8
    Full Member
    Join Date
    Aug 2018
    Location
    Johannesburg
    Posts
    29
    Thanks
    0
    Thanked 5 Times in 5 Posts
    Hi Michelle

    1 - The balance of the tax control account is the general ledger account you have setup for VAT. It can be found under Setup...Tax... General Settings. If you are using Pastels standard chart of accounts, it will be 9500/000.
    2 - All entries that are processed with a tax type that is not 0% will go to the VAT Control account. When you make your payment to SARS for VAT, it should also go to the 9500/000 account as a tax type 00 entry. If you have a difference between the Tax Total and the tax control account, you need to investigate why. This can be caused by journals that have been processed to the control account, or by processing entries into a period after the VAT report was run and submitted. Eg you run the vat report for December, pay the VAT in January, then process entries in December again. The tax control account is a balance sheet item, and the differences in any prior period would accumulate over time, leading to a large discrepancy between the report and the control account.
    3 - The control account should balance to the tax report

  11. Thanks given for this post:

    Michelle271 (30-Jan-19)

  12. #9
    New Member
    Join Date
    Jan 2019
    Location
    Rustenburg
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Thanks for all the info. We will look for the time they did balance and search from there>

    Thanks

  13. #10
    New Member
    Join Date
    Jan 2019
    Location
    Rustenburg
    Posts
    5
    Thanks
    1
    Thanked 0 Times in 0 Posts
    Hi how can we fix the problem? (question 3 from yesterday) We think it started in 2011.

Similar Threads

  1. File name for Tax Type report (Pastel Xpress)
    By J7J in forum Accounting Forum
    Replies: 4
    Last Post: 25-May-12, 10:06 AM
  2. [Question] Pastel Tax Box Report & Vat Detail report giving different figures!
    By Cin8 in forum Accounting Forum
    Replies: 3
    Last Post: 22-May-12, 03:57 PM
  3. Difference between CC and PTY
    By Slippy in forum General Business Forum
    Replies: 7
    Last Post: 21-Oct-11, 08:20 PM
  4. Report writer in Pastel
    By Martinco in forum Accounting Forum
    Replies: 1
    Last Post: 23-Jun-11, 02:29 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
  •