Almost there but missing something in condition. To determine the band your condition from Tax Payable 2 upwards must identify the tax bracket otherwise it will calculate payable tax wrongly. so for instance:
Tax Payable 2 Condition: (first N300,000)
CI > 0 and CI <= 300000
Tax Payable 3 Condition: (Next N300,000)
CI > 300000 and TI <= 600000
Tax Payable 4 Condition: (Next N500,000)
CI > 600000 and CI <= 1100000
and so on until you get to Tax Payable 7 which determines the tax payable if next salary band is is in excess of N3,200,000.
Up until this point I assume these tax components are created as statistical components so they will not show up in your totals. you need to create a pension component which will show on your payslip and use it to calculate your pension deduction. But you created a pension component and made it statistical in earning so it will not act as a deduction. Move to deduction section to give it effect.
i really must appreciate your effort and time in helping me out, trust me i sincerly do but as at this hour, i have compared both with mine yet i dont know why my results are different . Does it have anything to do with the unticked check box on each salary component or version or anything ?
Nigerian PAYE 2021 is a little different from the previous years.
If you use the formula in salary components, it’s a good idea but becomes difficult to understand in the long run. If in the nearest future, the formula is changed again you begin to scramble because tracking the spot to change is cryptic.
The PAYE TAX can be easily achieved with a plugin that validates instantly both on salary slip form, or in the background.
There is also an option of API based PAYE computation that interface with your erpnext.
@Huawei_Hackace Thanks for bringing this up. However from my little investigation so far not much has changed in the way tax computation for salary earners is achieved. The tax derivation formula is more or less the same, save for an additional element in determining your non-taxable income. Essentially the extra element is 1% or N200,000+20% of gross income (whichever is higher) is added to the tax-exempt income. Everything else is same. I have not attempted to add this tax-exempt to my existing structure but will do so at a later date.
As for tracking changes, someone will always need to adapt changes to any software so be it your suggested plugin or using the existing condition/formula in ERPNext; someone still has to do the dirty work. ERPNext, for all its quirks, still offer ways to achieve these things and just like I figured out a way to use the current salary structure to achieve the previous tax calculation, I will find a way to incorporate this new tax element.
The computation for the different salary components is correct according to their calculation. But when you look at the gross pay, net pay and rounded total, they don’t add up. Please I am a bit confused as to how to correct or resolve this miscalculation. I will be grateful if anyone can assist in resolving this error, I will be very grateful.
The circled components are the components that are computing the wrong figures. I would want a situation whereby the “Pay As You Earn” component computes the right figures, but can’t seem to achieve this.