x Want to participate? Join the group to interact
  • State Verified Answer
  • Replies 4 replies
  • Subscribers 16 subscribers
  • Views 343 views
  • Users 0 members are here
Browse Forums
Announcements
298
topics
217
replies
General Discussion
1k
topics
4k
replies
Be@ncounter

Payroll opening balances

SOLVED
Posted By

I took over a payroll in November and added the YTD payroll amounts in the Default payslip processing tab. However, the opening balance amounts do not print in the Monthly Analysis report. It also does not get included in the tax totals of the IRP5 certificates, but the opening balance amount is included in the 3699 Gross Remuneration amount in the IRP5 checklist report. The IRP5's are out of balance for income, although the PAYE, UIF and SDL amounts are correct.

How do I get Pastel Payroll to recognize and include the opening balance amounts in the reports? I have already proceeded to subsequent pay periods. Is it possible to activate the inclusion of the opening balance amounts now, after pay period updates done in the meantime?

Or, will I have to manually edit all IRP5 certificate amounts before filing them to SARS?

  • 0

    Hi  ,

    Thank you for the post.

    We apologise for the delayed response.

    When entering YTD values on payroll it doesn't allocate the processed values on a specific period, the system functionality is limited to adding the YTD values in the March period.

    The values that were added that were suppose to be allocated to 3601, was this processed under a Transaction and reports to Tax Total 3601?

    Kind regards

    Christelle

  • +1
    verified answer

    Hi Christelle,

    The opening balance amounts were entered against the particular transactions under the Default tab in November and then the month-end update was run.

    An employee earned basic salary of R219 150 for the 8 months from March to October. This amount was added under the Default tab for transaction 5000 Basic Salary.

    Basic salary for November = R28 400. Total for 9 months to November = R247 550. Therefore, 3601 should be R255 600 (R247 550 + R28 400). The IRP5 report up to November only reflects R28 400 and does not include the opening balance of R219 150.

    Fringe benefits for the 8 months from March to October = R26 789.28. Plus fringe benefits of R3 348.66 for November = R30 137.94. Therefore, 3828 should be R30 137.94. The IRP5 report up to November only reflects R28 400 and does not include the opening balance of R219 150.

    The total for 3699 is R277 687.94 (R247 550.00 + R30 137.94), and this is reflected correctly in the IRP5 report.

    My question is, when the IRP5 certificates are generated for the year to Feb 2024, will 3601 and 3828 reflect the correct amounts or will they remain exclusive of the opening balance amounts and will I have to amend each one manually in E@syfile / eFiling when filing the EMP501?

  • 0 in reply to Be@ncounter

    Hi  ,

    I just wanted to find out if you have rolled into December as yet?  The YTD values that you enter on the payslip will only update once it is written into the history and that is done when you do a pay period update.  So if you are still in November your checklist will be incorrectly and you will have a Tax Total 3696 <> Tax Total 3699 exception on your exception report.

    After doing the Pay Period update the checklist should show correctly.  If it doesn't I would advise that you do a Rebuild Totals in December.

    Daurayne
    Beyond Payroll 365
    Tel: 010 822 7799
    Email: [email protected] 
    www.beyondpayroll365.co.za




  • 0 in reply to Daurayne_Bp365

    Hi Daurayne,

    Thank you for clarifying that. I haven't looked at the checklist again since I posted the query. I have done a pay period update and the IRP5 income codes now reflect the correct amounts.

    Thank you for the peace of mind!

*Community Hub is the new name for Sage City