National Health Monthly Return
Harvester Payroll help topic
Read the help answer below and, where available, watch the matching Harvester YouTube training video.
Browse Help Topics / Results Open help answers here after searching above
| Key Word |
Topic Title Click to open |
Help Answer & Training Video |
|---|---|---|
| National Health Insurance NHIS or NHIMA |
National Health Monthly Return
Click this Topic Title above to open the full help page
and view any related training video if available.
|
National Health Monthly Return
Enter your NHIS "Employer" Account Number by going to settings and then company settings. Please do not enter the preceding letters 'NHIS' for your Company Health Number on Company-Settings page. Some employers have been issued a numeric-only NHIS employer number. In Harvester, go to Settings and then Company Settings and uncheck "Does NHIS precede Health No?" so the export matches the required format." Each member (employee) will also be given a membership number. This employee number can be entered on the Edit-Employee page. Some numbers are 14 digit numbers and others are a combination of "NHA" plus a 10 digit number.
For example: 12341911077853 or NHA1911077853
To obtain an updated listing of each of your unique employee membership numbers, please login to the NHIMA website and click on "returns" and then click on "Upload Return" and finally click on the "Download Sample From Employees" in order to get your existing, unique employee-membership numbers.
Monthly NHIMA Contribution CSV Upload
Important: Please use the report National Health Upload CSV and not the National Health Datareport.
Click the report link National-Health-Upload-Csv.
Click the Export Excel button and this will create a CSV (Comma delimited) file ready for direct upload to NHIMA.
Once you have downloaded the CSV file, do not re-save it before uploading to NHIMA.
Why?
If you open the CSV in Excel and then save it again, Excel may:
Remove leading zeros from NHIS numbers (e.g. 0123456789 becomes 123456789), and
Reformat some values.
This will cause the NHIMA upload to fail.
You may open the CSV in Excel to view it, but if you do, do not save it again - just close Excel and upload the original downloaded file to NHIMA.
This is due to the fact that re saving a CSV file in excel sometimes causes the format to change. For example the long NHI numbers in "Column D" might revert to Scientific notation and all look the same!
In other words, once you have exported your file, it is ready for upload and you do not even need to open it before you upload it to NHIMA.
Note: Sometimes you may find that you still get certain columns of data, like the Employee number on the NHIS upload report, reverting to a scientific notation format where it does not show the actual number. If you literally upload the exported CSV file(without first opening the CSV file) then the upload file should work as it is. If this does not seem to work, then open the exported CSV file in Excel and then use the Excel program to save as a CSV file type. This process will often fix such "format errors" with CSV files.
If you want to verify or do a manual edit of the CSV file, then right click the file and open with Notepad and then you can see the true CSV format that the NHI system wants.
If you do open your CSV file in excel and you see the numbers for NHI for each employee are showing in Scientific notation, do not be concerned. If you put your cursor on one of the numbers (by selecting any cell in "Column D" in excel) and then you look at the formula bar above, you will notice that it actually is storing the number correctly because the formula bar will show the actual 14 digit Number. (The display is just in Scientific notation)
When you pay for National Health, you do not need to download the NHIS template that they provide each month.
For the few employees who have kept the older 10 digit numbers, please enter the letters NHA preceding the number example: NHA5555555555
Note: The health number must not start with ' before the number.
If you have a ' before the number, please remove the '.
So in harvester put the letters NHA instead of the ' or simply remove it so that you just have a numerical number.
Make sure when you Submit to save, its just a number with no blanks saved after it and there is no '.
Then prepare the upload and you will see it will save it correctly.
After you have entered the employee Membership Numbers supplied by the NHIS to you for each employee on Harvester as well as your unique company Number (the 10 digit number following the letters 'NHIS') then you can simply generate the export report and use this to upload to their system.
The report does NOT show the grand totals. Hence you should use the other Health Report called National-Health-Data and export this for your own records. It will be saved in an Excel format and have the total contributions of all employees in the total row. Your payment amount will be double this value.
To make it easier to enter all the employee Membership Numbers, you may use the Quick Table Employee Edit to do batch saves of 15 employees at a time. Tick the tick box for Health and fill in the health number on the employee grid and save up to 15 employees' Health data info at a time.
To make it easier to enter all the employee Membership Numbers, you may use the Quick Table Employee Edit to do batch saves of 15 employees at a time. Tick the tick box for Health and fill in the health number on the employee grid and save up to 15 employees' Health data info at a time.
NB please make use of the Bulk employee update feature by using a Harvester-generated, excel import template.
Type Update or Import in Help and look for the help on "Batch Upload or Update Import of Existing Employees from Excel"
Your existing names, surnames etc are all generated in this Update_Template file. Make sure that you use the same format for employee data in each column of the template file by observing the way your existing data is saved in your downloaded template file. For the NHIMA employee numbers to update your online employees properly, keep the existing format (in CSV) so numbers look like this 14 digit number example: 55,555,555,555,555.00
(once updated online the NHIMA Numbers will look normal)
If you have already processed the wages for the current month before you started enabling employees for NHI then you need to re submit the payment. So after you have ticked the check box for each employee go to edit payments and re submit the current month payment to recalculate so that NHI will show for all those employees who have the tick box checked on NHI. It will remember your setting for the next month.
Note harvester does not do the initial registration of your employees. It does the monthly returns once you have received your registration employee NHA numbers.
Note that the NHI upload report does not and must not have the grand totals for it to work on uploading to the NHI web site when you upload your employee contributions. The other "health" report is good to save for your own records and this has the grand totals at the bottom.
Each employer needs to register all the employees with the NHIS (National Health Insurance Scheme). Harvester does not register your employees for you. This needs to be done once-off by you. However its very helpful to use the full summary report that Harvester produces in excel to copy and paste the relevant columns into the "Bulk Member Registration Sample" that NHIS provide on their website under "Employees".
|
New Harvester YouTube Training Course
Learn the latest Harvester Payroll step by step. Our newest YouTube playlist has over 30 short videos, most roughly 5 minutes each, so you can learn one topic at a time or complete the full course in under 3 hours.
Watch Harvester Training on YouTube