Harvester Payroll Reports - Complete Guide to Excel, Management and Statutory Reports
Harvester Payroll help topic
Read the help answer below and, where available, watch the matching Harvester YouTube training video.
Help answer
Browse Help Topics / Results Open help answers here after searching above
| Key Word |
Topic Title Click to open |
Help Answer & Related Training |
|---|---|---|
| Payroll Reports and Excel Exports |
What reports are available in Harvester Payroll Online?
Click this Topic Title above to open the full help page
and view any related training video if available.
|
Harvester Payroll Reports - Complete Guide to Excel, Management and Statutory Reports
INTRODUCTION
Harvester Payroll Online includes monthly payroll summaries, management and annual reports, Excel exports, payslips, ZRA PAYE, NAPSA, NHIMA, employee records, bank and mobile-money payment files, audit information, leave and gratuity balances for Zambian employers.
This guide covers the reporting choices currently shown on the Reports and More Reports pages. The exact fields, filters and export formats depend on the report selected. Some detailed Excel exports contain more columns than the on-screen report.
HOW TO OPEN THE REPORTS
1. Log in to the correct company and open the Home page.
2. Choose Print Reports and select the year, month and pay period on the period-selection screen. The default is normally the current payroll period.
3. Open Reports for the main reporting menu. Select More Reports for additional and accumulated reports.
4. Select a report. Where available, use its search filters (such as employee, department, year, status or report options) and then Print or Export to Excel/CSV as appropriate.
5. Check that the selected company, month, pay period and filters are correct before submitting or using a statutory or payment upload file.
IMPORTANT: The main Reports and More Reports menus require login. Access to individual reports depends on your Harvester user permissions.
MONTHLY PAYROLL, MANAGEMENT SUMMARIES AND EXCEL
On Reports under Summary:
- Full Summary - for Excel Export: the best starting point for a detailed monthly payroll export and further analysis in Excel. Its Excel output contains additional detail compared with the browser display.
- Summary - Print Option: printable payroll summary.
- Summary - Basic: simpler summary view.
- Specific Custom Extras (Additions): report on selected extra additions.
- Specific Custom Extras (Deductions): report on selected extra deductions.
For management reporting, begin with the Full Summary - for Excel Export. Save each selected month as an Excel file if you need a month-by-month comparison of employee or departmental wage costs. Annual reports and accumulated totals are covered below.
PAYSLIPS AND EMPLOYEE REPORTS
On Reports under Payslips & E-payslips:
- Payslips (and E-Payslips)
- Payslips - No Logo
- Payslips - small
- Payslips - Security
- Payslips - large
- Payslips (For paper-print): the menu specifically describes this option as only for payslips with no email address.
On Reports under General Reports:
- Employees Paid
- Employee Payment Lists
- Time and Attendance
- Daily Register
- Personal Details
- Employee ID Cards: employee identification and statutory detail fields.
Individual report search controls can help select an employee or department where supported.
ZRA, NAPSA, NHIMA AND LEVIES
On Reports:
- NAPSA Electronic Return
- Leaver's Certificate (NAPSA)
- Paye Data Report with Totals
- Paye Upload Return
- Paye Detail: includes historical/yearly tax reporting options described in the separate PAYE Help topic.
- Union
- Skills Development Levy
- Personal Levy
- NHIMA Upload CSV (in the Bank Acc / Mobile Transfers / NHIMA area).
Always review values and the current official upload requirements before submitting files to ZRA, NAPSA or NHIMA.
ANNUAL, ACCUMULATED AND HISTORICAL REPORTS
On Reports under General Reports:
- Gross Annual - Detail
- Gross Annual - Workers Comp
On More Reports:
- Gratuity / TermBen Totals
- Accumulated Totals
- Historic Accumulated Totals
- NAPSA Accumulated
- Tax Reports
- Leave Accumulated
- Loan Balances
Some accumulated/yearly reports include their own year, employment-status or other selection options. For a calendar-year view, check that you have chosen the correct year. The Gross Annual - Detail, accumulated totals and PAYE reports can be especially useful for year-end accounting and reconciliation. Previous months may be available through the period chooser, subject to the company's retained-history settings.
CUSTOM ADDITIONS, DEDUCTIONS AND EMPLOYEE DOCUMENTS
On More Reports:
- Extras - Deductions
- Extras - Additions
- Loan Balances
- Leave Accumulated
- Gratuity / TermBen Totals
- Leaver's Certificate (Parts 1 and 2)
- Contracts (Parts 1 and 2)
Use these reports where you need more detailed information on accumulated employee obligations, individual custom extras and employee documents. The report-specific search controls determine which records are shown.
BANKING, BULK SALARY PAYMENTS AND CASH
On Reports under Bank Acc / Mobile Transfers / NHIMA:
- Bank Accounts & Zanaco PayFlexi
- Tilt Africa Bulk Payments
- SPENN Bulk Salary Upload
- MTN Mobile Money Bulk Upload
- Kazang Bulk Salary Payments
- Journal (Paycode) Entries
- NHIMA Upload CSV (also listed above under statutory reports).
Under Cash Breakdown:
- Breakdown - Details
Payment files are generated for supported payment systems. Check the destination, account/mobile-wallet information and final totals before uploading a payment file to a bank or payment provider.
AUDIT AND REPORT FILTERS
On More Reports:
- Audit User Activities
Harvester also provides user activity audit information through Settings. Relevant report pages may support filtering or sorting by department, employee number, date, status or year. The options depend on the specific report. Optional AI Payroll Reporting is now available to individually authorised and licensed users through a compatible AI connection. It is read-only and does not change or process payroll.
MORE DETAILED HELP AND TRAINING
Monthly and annual Excel payroll summaries:
https://www.harvesteronline.net/help/topic/annual-or-monthly-excel-report-summary/how-do-i-get-am-annual-or-monthly-summary-in-excel-off-my-payroll-to-keep-offline/
Annual payroll, gross annual and Workers Compensation reports:
https://www.harvesteronline.net/help/topic/annual-report-summary-and-workers-compensation/how-do-i-print-annual-reports/
Custom additions and deductions in payroll summaries:
https://www.harvesteronline.net/help/topic/summary-inclusive-of-custom-extras/how-do-i-print-a-summary-report-including-my-custom-extras/
Specific custom extra reports:
https://www.harvesteronline.net/help/topic/print-a-specific-custom-extra/how-do-i-print-a-specific-custom-extra/
PAYE historical/yearly reporting:
https://www.harvesteronline.net/help/topic/paye-detailed-history-report/how-do-i-see-the-paye-or-tax-history/
NAPSA annual and accumulated totals:
https://www.harvesteronline.net/help/topic/annual-napsa-or-total-accumulated-summary/how-do-i-print-annual-napsa-or-total-accumulated-napsa/
Previous-month and historic report access:
https://www.harvesteronline.net/help/topic/print-historic-or-backup-previous-history-months/print-previous-payslips-or-backup-historic-reports/
Employee and departmental report sorting:
https://www.harvesteronline.net/help/topic/sort-order-of-employees/how-is-the-order-of-employees-stored-online/
Audit trail of user activities:
https://www.harvesteronline.net/help/topic/audit-trail-user-changes/how-do-i-access-the-audit-trail-of-user-changes/
Training videos:
https://www.harvesteronline.net/help/video/
For help choosing reports for your business, contact Harvester support: support@harvesteronline.net
PAYCODE JOURNAL AND AI REPORTING
The expanded Paycode Journal includes individual deductions, employee and employer NAPSA/NHIMA, current custom labels, net pay and per-record rounding reconciliation. Excel, QuickBooks, Xero and Sage 200 Evolution file exports require the appropriate account mapping and target-template checks; they do not automatically post to an accounting package.
AI Reporting lets authorised users ask questions about available payroll records, departments, accumulated totals and draft journals. Missing months, current department assignments and historical archive limitations must be explained. Full summary and journal tools expose selection and reconciliation information; retrieve all pages for complete lists.
PAYCODE JOURNAL THREE LAYOUTS
On Journal (Paycode) Entries, choose Consolidated - Company-Wide, Departmental Wages - Split Work Hours, or Detailed - Department and Payroll Class. Then export the selected journal layout to Excel, QuickBooks, Xero or Sage 200 Evolution. Company-wide is the compact single-company journal. Departmental Wages costs gross wages to saved primary/second Work Hours departments with other liabilities company-wide. Detailed lists journal categories by current employee department and payroll class; the number of lines grows with the number of active departments/classes, but it does not apply the second-department Work Hours split.
Authorised AI users can request the same three views with report=journal and groupBy=company, department or detailed. All are read-only drafts; reconcile totals, inspect individual discrepancies and approve the GL, project codes and target import template before using the results in an accounting package.
RELATED HELP
Which report do I use for Journal entries into an accounting program?
https://www.harvesteronline.net/help/topic/journal-entries/which-report-do-i-use-for-journal-entries-into-an-accounting-program/
How do I make use of payroll data for linking with my accounting package?
https://www.harvesteronline.net/help/topic/export-to-excel-for-accounting-packages/how-do-i-make-use-of-payroll-data-for-linking-with-my-accounting-package/
What can Harvester AI Payroll Reporting do?
https://www.harvesteronline.net/help/topic/ai-payroll-reporting/what-can-harvester-ai-payroll-reporting-do/
How do I connect and disconnect Harvester AI Reporting?
https://www.harvesteronline.net/help/topic/ai-reporting-setup-and-permissions/how-do-i-connect-and-disconnect-harvester-ai-reporting/
What questions can I ask the Harvester AI assistant?
https://www.harvesteronline.net/help/topic/ai-payroll-example-questions/what-questions-can-i-ask-the-harvester-ai-assistant/
How do I get am annual or monthly summary in excel off my payroll to keep offline?
https://www.harvesteronline.net/help/topic/annual-or-monthly-excel-report-summary/how-do-i-get-am-annual-or-monthly-summary-in-excel-off-my-payroll-to-keep-offline/
|
Get in touch
Email: support@harvesteronline.net
WhatsApp Text Only: +260969078711
Location: Plot E, Mazabuka, Zambia
by Sean Kelly : For the Glory of God
