Skip to content
logo Knowledgebase

Reconcile payroll values for submission

Created on  | Last modified on  Highlight Matches

Summary

Guidelines to reconcile your payroll for mid-year and tax year-end submissions on Sage Payroll Professional.

Description

Reconcile your monthly payroll values for tax, SDL UIF and ETI with the monthly declared values with the South African Revenue Service (SARS).

Resolution

1. Access the RSA Submission Utility:

  1. Go to the Utilities menu in your payroll company
  2. Select RSA Submissions, then SARS Submission Process
  3. Review the Period End Date and select Continue
  4. Click 'Step 5: Reconcile EMP501 Values'

Step 5: Reconcile EMP501 values button.

 NOTE: The EMP501 Reconciliation report is also available on the History reports menu. Click here for more details.


2. Print EMP501 Reconciliation History.

  1. Select 'Step 5.1 Print EMP501 Reconciliation History Report' 

Step 5.1 Print EMP501 Reconciliation History Report button.

  1. Select the Reconciliation period:
    • March to August for mid-year submissions
    • March to February for tax year-end submissions 
  2. Select to include Current Company or Multiple Companies
  3. Click Continue

 NOTE: For Multiple Companies reports the PAYE reference number and calendar month must be the same. 

  1. The report downloads to your computer
  2. Click Finish
  3. The Excel report prepopulates with the payroll values for the tax year

3. Capture declared and paid liabilities.

  1. Access and review your monthly EMP201 declarations on SARS eFiling (https://secure.sarsefiling.co.za/)
  2. Determine the total amounts declared and paid to SARS as payment receipts per month
  3. Capture the amounts on the spreadsheet

 NOTE: Add your total payroll liabilities which include tax, UIF, SDL and ETI (and the amounts of any manual certificates issued during the tax year) 

  1. The spreadsheet displays any differences between your payroll and EMP201 values
  2. Reconcile the values to identify any differences. Click 'Step 5.2 Reconcile EMP501 with SARS Payments' for guidelines

Step 5.2 Reconcile EMP501 with SARS payments button.


4. Print reconciliation reports.

  1. Print the reconciliation reports for details of each employee
  2. Select the available reports:
    • 12 Month Report
    • History Report
    • ETI History Report

Step 55.3 Print Selected Reports button.

  1. Tick the box to select the report to print
  2. Click 'Step 5.3 Print Selected Reports'
  3. Complete the selections per report

 TIP: Click 'Step 5 .3 Guide' for more details on these reports. 


5. Investigate differences and apply corrections.

  1. Select Step 5.4 to confirm the outcome of the reconciliation

Step .2: Confirm Outcome of Reconciliation button.

  1. Click 'Step 5.4 Confirm Outcome of Reconciliation'

EMP501 Reconciliation outcome selections.

  1. The options available:
    • EMP501 Values Balance: There aren’t differences, and Step 5 is complete
    • Please Help Me: There are differences on the reconciliation, and you need to review the issue

 TIP: For assistance with your payroll reconciliation, arrange a consultation with your Business Partner - click here to book a consultation. 

  1. Click Continue to return to Preparation menu 

4. Mark step as complete:

  1. Check the 'Mark as Complete' box next to Step 5 to confirm you finished the step.

Step" Reconcile EMP501 Values marked as complete.


Next steps

If the EMP501 balances, proceed with creating the IRP5 test file to import into SARS e@syFile™ Employer.

Continue to step 6 of SARS Submission Utility process: Generate Test Run IRP5 file on your payroll.