Harvester Payroll Help Centre
Search answers for employee setup, Excel payroll imports, timebooks, PAYE, NAPSA, NHIMA, payslips, reports and AI reporting.
Browse Help topics
228 topics found.
Browse Help Topics / Results Open help answers here after searching above
| Key Word |
Topic Title Click to open |
Description / Full Help Page |
|---|---|---|
| Annual Paye or Tax Summary Report and Gross |
How to extract an Annual Paye summary report for an employee?
Click this Topic Title above to open the full help page
and view any related training video if available.
|
The best practice is to export to excel the Paye-Detail Report or make use of the Gross Annual - Details Report (see below).
The actual Excel Export of the Full Summary report will include a Full Detailed-Report with more info than the visible browser report.
For detailed access to tax cards and history, there are detailed Paye reports that can be printed out.
Select the normal "Print Reports" option.
1) Choose the year you would like to see the Annual Report (normally the current year is the default).
2) Choose the month "December" to reflect the entire year. history as December is the last month.
3) Select the "Paye-Detail" Report.
4) In the "Current or Summary" options drop down box on the top left of the report page, select the option "Summary" and then click Search.
Note: You may also export this report to Excel.
Gross Annual - Details Report
This Report is very useful as its an accumulated, ongoing, annual-summary of important totals you may need.
On the normal Reports page look under "General-Reports" Section and then select the link for the Gross Annual - Details Report.
This report is found just below the link for the Workers Compensation Report.
It will export to excel the same information needed for Workers Compensation, but will also include accumulated totals for other helpful values like Basic Wage, Housing, Pay-rates, Gratuity, Terminal Benefits.
If you select the Status drop-down search box and select only Terminated or Employed employees, then the export to Excel report will show accumulated totals according to your selection. Eg If you want to see only the totals for Terminated employees during the year.
|
| Annual Report Summary and Workers Compensation |
How do I print Annual reports?
Click this Topic Title above to open the full help page
and view any related training video if available.
|
For annual reports there is the "General Accumulated Totals" report on the top of the "More Reports" page.
When you are in December before going to January, its good to export the workers compensation report for export. This does Jan through to Dec.
If you have already moved to January of the next year, you can still print the year report by selecting December and the year before your current year on the Choose pay period form that comes before the Print-Reports page is loaded.
You may also make use of the Gross Annual - Details Report. This Report (info found below) is very useful as its an accumulated, ongoing annual summary of important totals you may need.
Note:
For a good yearly summary, month by month in excel, type the word PAYE in help and look for "Paye Detailed History Report"
Note:
The actual Excel Export of the Full Summary report will include a Full Detailed-Report with more info than the visible browser report.
The Gross Annual - Details Report (info found below) is very useful as its an accumulated, ongoing annual summary of important totals you may need.
This will summarize the totals of the important summary pay figures, like Gross and Paye and Napsa for the calendar year selected.
Remember to specify which YEAR in the search box and then press search. This report can easily be exported to Excel.
Note: In Zambia everything to do with pay is run on a calendar year starting from January to December. Hence if your accounts year end is not in December, you may need to use a combination of 2 yearly summaries.
There is also a detailed Tax yearly report that can be exported to excel. Use the "Paye Detailed Report" on the "Main Reports" page. This report can be exported to excel and it will give a yearly summary showing the accumulated figures that the tax is worked out on. To export for the full year, be sure to select the option "Year Total(Excel Only)" in the search box and then press the search button. You may also select the "All months" option. This will be a large export file.
However, for a total excel based report of all important pay-detail data, the best is to use the "General Accumulated Totals" Report and export it to Excel.
It is a good idea to keep a monthly, excel export of the "Full Summary for Excel Export" found on the top right of the standard "print Reports" page. This is very useful if your year end is not December. If you have not exported the monthly reports to excel, you can do so by simply selecting each month in the drop down selection box before you reach the print page.
Note: on the "More Reports" page there is the "Values that Accumulate" report and the there is the "Tax" report which will also do yearly summaries.
Gross Annual - Details Report
NB Check for both terminated and employed reports as some employees may have worked for only part of the year.
On the normal Reports page look under "General-Reports" Section and then select the link for the Gross Annual - Details Report.
This report is found just below the link for the Workers Compensation Report.
It will export to excel the same information needed for Workers Compensation, but will also include accumulated totals for other helpful values like Basic Wage, Housing, Pay-rates, Gratuity, Terminal Benefits.
If you select the Status drop-down search box and select only Terminated or Employed employees, then the export to Excel report will show accumulated totals according to your selection. Eg If you want to see only the totals for Terminated employees during the year.
Related guide: Complete Harvester Payroll reporting options, including monthly and annual reports, management summaries, Excel exports and statutory reports:
https://www.harvesteronline.net/help/topic/payroll-reports-and-excel-exports/what-reports-are-available-in-harvester-payroll-online/
|
| Audit Trail User Changes |
How do I access the Audit trail of User Changes?
Click this Topic Title above to open the full help page
and watch the related training video.
|
The audit trail of User-Activities comes with the standard package.
To access this click on the Audit-Trail icon on the Settings page.
There are over 60 different audit-trail codes of various changes that is user is audited on.
Important audits of user-changes are recorded.
Examples:
When the user "moves to the next payroll period" or when the user triggers "annual renewal activation".
Related guide: Complete Harvester Payroll reporting options, including monthly and annual reports, management summaries, Excel exports and statutory reports:
https://www.harvesteronline.net/help/topic/payroll-reports-and-excel-exports/what-reports-are-available-in-harvester-payroll-online/
|
| Backup Annual History Reports |
How do I make sure Harvester keeps my historic Data for previous years online?
Click this Topic Title above to open the full help page
and watch the related training video.
|
If you use Upgrades on the Settings page, you may purchase the module to Keep-Historic-Data for 13 or more months back. This will ensure you have those months 'Live and Online'. Hence with this module, no offline backups will be needed for old monthly pay records from 13 or more months back.
If you don't purchase the module then its wise that you have all the monthly Pay-details offline backups for 13 or more months back. It is very import to ensure you have all the monthly Pay-details offline backups when Harvester reminds you to do the Compulsory Backup after January payroll is completed each year.
This means that if you don't purchase the module, as long as you have the monthly offline Pay-details backups you will be fine. For actual monthly pay records you will need each monthly backup of the specific months you would like to restore from. Ideally you should have 12 backups of the payroll data for the 12 months of the calendar year starting 2 years back.
Example: End of Jan 2020 harvester will clear historic data from Jan 2018 through to Dec 2018. These are the months you should have backups for as they will be removed after you finish Jan 2020 payroll. (Unless you have bought the module to Keep Old historic Data online in which case no backups will be needed)
Only in end of Jan 2021(in this example) Harvester will clear historic data from Jan 2019 through to Dec 2019. NB this means(in this example) that for the whole of 2020 you will still have direct access to any month in year 2019 EVEN IF you do not purchase the Keep-History module.
These are the months you should have backups for as they will be removed after you finish Jan 2020 payroll.
Harvester will always give you the reminder and the option to purchase the "Keep History Module" every time you move the payroll from January to February. If you do not want Harvester to delete the online history for more than 13 months back then you MUST purchase the module. Note that all the relevant accumulative values that need to be carried forward like leave etc are not deleted.
Note: If you have been saving your offline payslips and summary sheets in excel then you also have a soft copy offline. The monthly "compulsory" backups make all the raw data available offline as well. You can then be more assured that you still have the data in an offline format. Then you can avoid the charges needed for Harvester to keep that data for you online.
|
| Backup Compulsory History and Move Payroll |
Compulsory Back needs to be made after every 12 months
Click this Topic Title above to open the full help page
and view any related training video if available.
|
A compulsory Backup needs to be made after every 12 months.
Harvester online will remind you and so you don't need to remember to do it.
Click on the "Backup off the Cloud" icon.
Click on Backup-Employees(Blue highlighted text).
You will see your data in a table format. Above this is the actual "Backup-to-Excel icon". Click this to ensure your data is downloaded and hence backed up. It will be in an excel format that you can store locally on your machine or in another Internet drive location of your choice.
Note: There is NO NEED to change the MONTH or the YEAR from the default current month and year for the employee backup data.
If you do NOT choose to purchase the "Keep History module", then make sure you have a downloaded excel copy for any months more than 13 months back from the present month of February.
For these historic months (more than 13 months back), please check you have a NORMAL offline copy each month of your monthly Summary Report or Payslips in excel. (Only needed for pay-months more than 13 months back). If you do not have excel copies of these months then use the NORMAL reports menu to choose the historic month you have missing and then you will be able to do the export to excel.
Note: These "backups" are your normal payslip and or summary excel monthly reports and are not generated using the "Backup off the Cloud" icon.
Harvester online only keeps all your payroll history for 13 months back.
When you want to move from January to February just remember to click "yes to confirm backup is done" and then press submit. Then you can easily move your payroll forward. Until you select "yes" in the drop down box on the compulsory backup page you will not be able to move to the next month.
EXAMPLE:
End of Jan 2022 Harvester will clear historic data from Jan 2020 through to Dec 2020. These are the months you should have backups for as they will be removed after you finish Jan 2022 payroll. (Unless you have bought the module to Keep Old historic Data online in which case no backups will be needed). Only in the end of Jan 2022(in this example) will Harvester clear historic data from Jan 2020 through to Dec 2020.
This means(in this example) that for the whole of 2021 you will still have direct access to any month in the year 2021 EVEN IF you do not purchase the Keep-History module.
Note: You ONLY have to pay for the purchase module for Harvester to keep data older than 13 months.
For the "Free version" you can't purchase the "Keep-History Module". Harvester will keep data up to 13 months back on the "Free version". If you really want this module and you are on the "Free version", then you need to upgrade to the "10 employee package" first and then purchase the "Keep-History Module".
However, whether you purchase the module or not, you need to go through the compulsory backup check at the end of January each year in order to move to the next month.
Do this as follows:
To move from January, move pay period as normal on the Home page by clicking on the "Move to next period" icon.
You will be taken to the page "This month Harvester requires you to do a Compulsory Offline Backup from the Cloud"
Select "I agree to backup" and click "Submit".
On the next "Payroll Backup" page, simply click on the Icon where it says in bold "Click here". (Do not press the Cancel option)
On the next "Backup Page" at the bottom select 'Yes' to Confirm you have Backed up and then press the "Submit" button.
Lastly on the "Compulsory Backup Completed" page click on the "Move to next period" icon. Select "I agree to Move" and click "Submit".
|
| Backup off cloud |
How do I backup of the cloud?
Click this Topic Title above to open the full help page
and watch the related training video.
|
For peace of mind it is good to make a backup of your data off the cloud.
Go to Settings.
Click on the Backup off the Cloud icon.
There are 2 backups you can do.
1) Backup Company Settings and employees.
2) Backup Payroll Data.
With both options you will see your data in a table format. Above this is the actual Backup-to-Excel icon. Click this to ensure your data is downloaded and hence backed up. It will be in an excel format that you can store locally on your machine or in another Internet drive location of your choice.
How do I know that the backup is successful or not?
1) Click on the Backup off the Cloud icon to take you to the backup page.
2) Click on Backup-employees link.
3) It will take you to the page that is similar to most of the report pages. Here you can then use the icon to export to Excel. After clicking on the export to excel icon, your backup will download and then you will see your download in your downloads folder.
|
| Bank Account FNB or Zanaco or Stanbic or Flexipay |
Bank Account Report for FNB or Zanaco Flexipay or Stanbic ?
Click this Topic Title above to open the full help page
and watch the related training video.
|
Go to the main Print page.
Look for the bank account report.
On the bank account report, select your options in the top 'Search' area.
Bank: This pulls the various 'bank' options from your employee listing.
NB. For those who have bank payments, on "Edit Employees", make sure that they are marked as "Bank" and NOT "cash" and for FNB, for example, make sure all the bank "name" fields are "FNB" for
each employee.
Type: The specific type you of excel export report the bank uses.
example of Type: FNB Excel (similar for FNB CSV or FNB Ewallet)
First make sure you have selected FNB bank in the top left drop down to find all employees with FNB accounts.
Before you export you must select the bank-type as FNB CSV and then press Search.
Click on the 'export to Excel' button to generate the excel FNB CSV bank account return.
Make sure all bank-name fields you have entered on each 'FNB' employee is 'FNB' using Edit-Employee.
Note: For FNB EWALLET enter the Bank-Name as 'FNB EWALLET' and for the Bank-Sort-Code, enter '260006' which is the sort code for 'FNB EWALLET'.
For FNB EWALLET (not normal FNB), enter the 12 digit cell number of the employee in the Bank-Account field beginning with 260. eg For an MTN number it will be 260969078881
When you export the file, choose the FNB-Excel option. It will automatically save as an Excel type file. You can then use Save-As in Excel to save your file as CSV before you upload.
If you choose the export option as CSV then it will obviously be exported directly to a CSV file.
After exporting, simply upload or send it directly to FNB.
Do NOT open your exported csv file and re-save before uploading as your upload file might not work.
example of Type: Zanaco CSV or FlexiPay
1) for only Zanaco CSV:
If you would like to only use Zanaco Accounts or Mobile Money accounts, then first make sure you have selected Zanaco bank in the top left drop down to find all employees with Zanaco accounts.
Before you export you must select the bank-type as Zanaco CSV and then press Search.
Make sure all bank names you have entered on each 'Zanaco' employee is Zanaco. (Using Edit Employee)
2) for FlexiPay:
If you would like to use Zanaco Accounts as well as other bank accounts or Mobile Money accounts, then first make sure you have NOT selected Zanaco bank in the top left drop down. Leave this as blank to find all employees with bank accounts. (Not just for Zanaco)
Before you export you must select the bank-type as FlexiPay and then press Search.
Make sure all the bank Sort Codes are correct for Non Zanaco banks you have entered on each employee. (Using Edit Employee)
When you export the file, it will automatically save as a csv type file. After exporting, simply upload or send it directly to Zanaco.
Do NOT open your exported csv file and re-save before uploading as your upload file might not work.
Note: The Zanaco csv file as well as the FlexiPay file can also be used by Zanaco bank to pay people on MTN or Airtel from your employer Zanaco account. This can be done using the same export file that is used to pay employees with normal Zanaco accounts.
For those employees WITHOUT bank accounts, but do have cellular phones, go to "Edit-Employees":
1) Check that the "Bank Account Number" is "0" or empty if the employee does NOT have a bank account.
2) In the bank Account Name field enter "Zanaco" or another Zambian Bank-Name if you want the employee NOT to receive their pay on the cellphone. For Non-Zanaco accounts, make sure the Bank Sort code is correct for the respective banks.
3) Enter the 12 digit cell number of the employee in the Mobile-phone field beginning with 260. eg For an Airtel number it will be 260979079911
example of Type: Stanbic Excel
Before you export you must select the bank type as Stanbic and then press Search.
Make sure all bank names you have entered on each 'Stanbic' employee is Stanbic. (Using Edit Employee)
When you export the file, it will automatically save as an Excel type file. After exporting, please remember to just delete the first Title Row with the column headings. Then save it and then you can upload or send it directly to Stanbic.
Note: in the reference column Stanbic has the word "supplier" but Harvester gives the actual employee number and NRC in this field. This normally does not present any issues with the upload file.
Most bank reports sort in alphabetical order on surname, but some banks like the name and surname in the same column.
NB For bank account numbers longer than 11 digits e.g. 9130000412043 in the bank column, AFTER you have exported to excel you might see something like "9.1E+12".
This is Scientific Notation for large numbers and is quite normal. Leave it as is. The banks will read the numbers correctly when you send them the excel or csv file.
If you select the exact cell where you see a Scientific Notation number and look at the top of your spreadsheet in the actual cell reference you will see the proper number of 9130000412043(for our example).
Do not change this. This is correct.
The bank will read the numbers properly.
|
| Bank Account Numbers in strange format |
Why do I see a strange format of some of my bank account numbers in Excel export file?
Click this Topic Title above to open the full help page
and view any related training video if available.
|
For bank account numbers longer than 11 digits e.g. 9130000412043 in the bank column, AFTER you have exported to excel you might see something like "9.1E+12".
This is Scientific Notation for large numbers and is quite normal. Leave it as is. The banks will read the numbers correctly when you send them the excel or csv file.
If you select the exact cell where you see a Scientific Notation number and look at the top of your spreadsheet in the actual cell reference you will see the proper number of 9130000412043(for our example).
Do not change this. This is correct.
The bank will read the numbers properly.
|
| Batch Payment Capture |
How do I use the Batch Payment Capture Option?
Click this Topic Title above to open the full help page
and view any related training video if available.
|
If you are using the Batch entry option, Harvester will first let you input the normal standard entries on the Batch payment input table.
Then after you press Submit, you will be taken to a second Batch payment input table which handles the Custom Extras. When you press Submit on this second screen then all the employees and their extras will be paid.
NB Use the arrow keys on the keyboard to navigate easily around the table to make it easy to quickly capture inputs like you would do on a spreadsheet.
The Tab key also works to move quickly to the next input field.
Remember the payments are only actually paid once you click Submit on the Second Batch payment screen for the Custom Extras. If you do not have any custom extras, still press Submit to process the employee batch payments.
To make corrections for any payments already processed:
Go to Payroll-Entry-by-Individual on the home screen and then find the employee and edit the payment.
|
| Batch upload or Import of employees |
Is there a way to upload NEW employees from excel?
Click this Topic Title above to open the full help page
and watch the related training video.
|
You may import NEW employees using the Import from excel option found on the settings page.
This is normally used to import a batch of employees where you already have an excel copy of the names, surnames, SOC and NRC Numbers. There is also the option to upload other data like
Bank Account Numbers or
MTN Cellular Numbers or
NHIS Health Numbers along with the Names and NRC Numbers.
If you are not an existing offline Harvester user, then the NAPSA csv file of all your employee data can easily be used to populate the Harvesteronline upload template file as follows:
From the Home page, go to the Settings page.
Go to the Import from Excel link on the left hand side of the settings page.
You will be taken to the Choose-your-Template page.
Click the MIDDLE image (of the THREE options) to Proceed with Make-Import-Template.
Save the excel template file that is created and then copy your names, surnames, SOC and NRC Numbers into this generated template file. Make sure that you use the same format for employee data in each column of the template file by observing the first 3 "Test" employees. You should over write these "Test" employee names. (Note the source of these names does not have to be from the NAPSA csv file but this can be useful here).
Check your date format is correct on your computer. It should be set to English(UK) or English(Zambia). To know how to change this, type "Date" in help and look for help on "Date format needs to be dd/mm/yyy".
Make sure that you use the same format for employee data in each column of the Import-Template file by observing the way your existing data is saved. eg Column O and P : For the phone numbers(MTNMobile) or Bank-Account-Numbers or NHIMA employee numbers to update your online employees properly, keep the existing format.
Then click on "Go-to-Step 1" at the bottom of the Choose-your-Template page.
Then Click on "Step 1" at the top to add the upload file.
Once you have added the file you can then proceed to "Step 2".
NB Note1: If you want new employees to be added to an existing department, then you have to make sure the Department Name(NOT DEPARTMENT CODE) in column F on the excel import template file is exactly the same as the department on the online. Please also ensure the department name is 7 or less characters and has NO spaces. If you have two department names(NOT DEPARTMENT CODE) that are the same on your existing departments then its possible that none of your new employees may be imported.
Note2: Any existing Company-Wide extras will be added automatically, but not the department specific extras if you are importing to a pre existing department. After upload you can then use the Assign Extras to Department option to assign non-company wide extras to that department.
Note3: VERY IMPORTANT
Please use the example in the original downloaded excel TEMPLATE file to see THE EXACT data examples that are accepted. Eg if there is no value in a data Columns you need to enter a 0 and not a blank or empty space. (Like excel data)
For data Columns like pay-rate and fixed wage where for example the daily rate is 0 and the fixed wage is a positive value: make sure a 0 is entered if there is no positive value.
Follow the True or False values for the respective Column Data and leave no blanks or 0's in these columns.
For the Employee-numbers please use the example. Eg start with 1001 or at least have the same amount of digits as the sample ie not just the number 1.
For the Date Columns you may leave these values blank if there is for example, no birth date.
For Columns G : For the phone numbers(MTNMobile) or Bank-Account-Numbers to import your online employees properly.
For Columns F : For the NHIMA employee numbers to import your online employees properly, keep the existing format for the NHIMA number.
If you get a message that there is a wrong amount of columns then Harvester thinks you are trying to import from an old Harvester offline package and not your own list of employees in the excel template file. In which case check your "Import Template Choice" is correct.
The Import-Template file is for Importing NEW employees. (It has 20 columns of data up to Column S) The last column is the "email" column.
The Update-Template file is NOT FOR IMPORTING. It is for Updating EXISTING employees and NOT adding new employees. (It has 20 columns of data up to Column S) The last column is the "StartDate" column.
Click on Step 3 and the employees will be imported and updated and you will be ready for entry.
If you need to import more than 7 different batches of employees after you have already used this feature seven times, then you need to contact support@harvesteronline.net
You are allowed 7 different batch uploads on the standard version. This can easily be updated to allow further batch uploads of new employees after paying a small upgrade cost. See help on Multiple Batch uploads by typing "Multiple" in help.
|
Learn at your own pace
Harvester Payroll Training Course
Watch step-by-step training videos, from New Company Setup to payroll processing, imports and reports. Each video connects to relevant Help topics.
New to Harvester? Start with the New Company Setup training.
Get in touch
Email: support@harvesteronline.net
WhatsApp Text Only: +260969078711
Location: Plot E, Mazabuka, Zambia
by Sean Kelly : For the Glory of God
