Employee taxation (PAYE, UIF, etc) "manual" (Excel) calculations

[Robz]

Hi all, I have a very specific question that I would appreciate the community's insights with - before I do something incorrectly! :-)

The context here is that I run my own accounting/bookkeeping practice, from end-to-end (ie. receive info from a client, do the necessary and submit).

So, my question is about how to accurately calculate, in Excel - and Sage Online Payroll (ie. getting them to match also) the tax and other statutory deductions for a given set of employees. My client has been paying them their 'full rate' without any deductions whatsoever.

Ideally, I would like to be as transparent (and compliant!) as possible without creating the impression that we're 'cooking the books' (eg. if SARS were ever to want to verify our figures). The client has indicated that he is willing to remit the taxes etc. that wasn't deducted.

I'd sincerely appreciate any advice. Looking forward to working this out! :-)

[Dave A]

I suggest the first step would be to rebuild the payroll the way it should have been done. And then you'll have to make some decisions on what to do from there.

[Robz]

Thank you, Dave! I appreciate your input. :-)