Skip to content
logo Knowledgebase

Step 5: Reconcile payroll values for submission

Created on  | Last modified on 

Summary

Guidelines to reconcile your mid-year and tax year-end submissions on Sage VIP Classic and Premier.

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'

Image

 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' 

Image

  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 will open in Excel prepopulated 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, based on actual SARS 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

Image


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

Image

  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 the reports. 


5. Investigate differences and apply corrections

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

Image

  1. Click 'Step 5.4 Confirm Outcome of Reconciliation'

Image

  1. The options available:
    • EMP501 Values Balance: There are not 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 you Business Partner - click here to book a consultation 

  1. Click Continue to return to Preparation menu 

Next steps

If the EMP501 balances, proceed with creating the IRP5 test file, for importing into SARS e@syFile.

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