How To Make NHIF and NSSF Excel Return Files

Both NHIF and NSSF require returns to be made in an Excel file. Here is how to create the Excel files from inside Nifty Payroll:

1 On the Payroll form click the Reports list and scroll down to the Monthly Returns Section

2 Click NHIF Return (Excel_Email) for the NHIF return (and similar for the NSSF return)

3 The NHIF Excel format is created by Nifty. Click Export to Excel

4 Excel automatically opens with the exported NHIF data

5 NSSF works the same

6 NSSF Excel schedule after exporting

7 You will need to convert the values to numbers using the Excel shortcut so you can total the relevant columns

8 Use the Formula shortcut in Excel to add the totals at the bottom

9 Add all the Totals and expand column B so that the whole company name appears

10 Save the file ready for sending to NSSF (do the same for NHIF)

Previous post:

Next post: