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
Export to Excel for Accounting packages How do I make use of payroll data for linking with my accounting package?
Click this Topic Title above to open the full help page and view any related training video if available.
Harvester provides payroll Excel and CSV files to help prepare accounting journals. The current Paycode Journal offers an Excel workbook, QuickBooks CSV, Xero CSV and Sage 200 Evolution CSV. These are file exports; Harvester does not directly post journals into these accounting systems. SELECT ONE OF THREE JOURNAL LAYOUTS The Journal (Paycode) Entries report offers Consolidated - Company-Wide, Departmental Wages - Split Work Hours, and Detailed - Department and Payroll Class. Choose one layout, then click Excel workbook, QuickBooks CSV, Xero CSV or Sage 200 Evolution CSV. All four downloads use the chosen journal grouping; they are not four different journal calculations. Consolidated is a compact company-wide general ledger journal. Departmental Wages allocates only gross wages to the saved payroll department and optional second department for standard Work Hours; statutory categories and payables remain company-wide. Detailed produces all non-zero journal categories by CURRENT employee department and payroll class. Detailed is the larger Sage-style grouping, but it can also be exported in the other file formats. The Detailed view does not use second-department Work Hours allocation. Confirm that all layouts reconcile to the same payroll selection totals. Choosing an export format does not approve general ledger accounts, department/project codes, tax treatment or the import template. Keep the original reviewed workbook and resolve discrepancies before attempting import. START WITH THE PAYCODE JOURNAL Select the correct company, year, month and payroll period(s). Review the full selection totals, rounding and individual unresolved differences. Enter the posting date and journal reference, then replace suggested account labels with your accountant's actual ledger accounts. Names such as GROSS, NET, NAPSA_EE and NAPSA_ER are useful starting labels, not standard codes guaranteed to exist in your accounting package. Custom deduction names help identify the correct account but do not establish the accounting treatment. XERO CSV The export includes narration, date, description, account code, tax rate and signed amount columns. Debit amounts are positive and credit amounts negative. The tracking columns are currently blank; department tracking is not automatically mapped by this export. The Xero tax-rate field refers to the journal's accounting tax treatment, not payroll PAYE. Harvester allows you to leave it blank while preparing the file, but this does not guarantee Xero will accept a blank value. Use the exact appropriate tax-rate name from your Xero organisation/template and resolve required tax settings before import or posting. Ask the accountant which treatment applies. Download the current manual-journal template from your Xero organisation and compare it with the exported file. Xero's official manual journal guide: https://central.xero.com/0/article/Add-import-and-post-manual-journals-AU QUICKBOOKS CSV The export provides Journal No., Journal Date, Account Name, Description, Debits and Credits. Map these fields using the sample file and import options available in your QuickBooks product. The current export does not automatically supply department/class or location allocations. Import availability varies by product and edition; do not assume QuickBooks Desktop and QuickBooks Online accept the same file. Intuit's QuickBooks Online journal-import guide: https://quickbooks.intuit.com/learn-support/en-us/help-article/import-export-data-files/import-journal-entries-quickbooks-online/L4tQBwbs7_US_en_US SAGE 200 EVOLUTION CSV The Evolution export follows the layout selected in Paycode Journal. Detailed mode has journal lines by current employee department and payroll class; Consolidated mode groups amounts company-wide; Departmental Wages mode splits gross wages by saved primary/second Work Hours departments while leaving other entries company-wide. The CSV carries account, debit, credit, reference and period information. Harvester department names are supplied as provisional project references. They must be matched to the actual department/project codes and field mapping used by your Evolution installation. Obtain a blank journal import template or an anonymised sample from the responsible accountant for the installed Evolution version. Check the required column order, date format, debit/credit conventions, accounts and project fields. Remove review-only columns from the final import layout if the target template does not accept them. The supplied Harvester file is not a universal, prevalidated Evolution import template. Official Sage guidance on Evolution journal import-file setup: https://za-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=240728112025640 OTHER SAGE PRODUCTS AND ACCOUNTING PACKAGES Sage 200 Evolution, Sage Accounting and Sage Pastel are different products. Do not assume the Evolution file fits another Sage product. Use the reviewed Excel journal totals and obtain the exact target template before preparing a different layout. For Sage Accounting specifically, Sage provides this separate guide: https://gb-kb.sage.com/portal/app/portlets/results/viewsolution.jsp?solutionid=222001000100916 CHECK THE FIRST IMPORT Have the accountant review a small test journal before posting. Confirm accounts, date, currency, tax treatment, allocations and equal debit/credit totals. Compare the imported batch with the original Harvester journal and avoid importing the same payroll twice. Keep the approved workbook and final CSV as the audit record. A file that balances still needs correct account mapping. AI DEPARTMENTAL COSTING AND ACCOUNTING IMPORTS The AI Reporting journal can split gross wages expense between a payment's primary department and an optional second department selected for standard Work Hours. This is a read-only draft allocation with suggested department wages codes. The corresponding Departmental Wages layout is now available in Paycode Journal Excel and CSV exports. However, the exported accounting account and project fields are not automatically approved or verified against the target accounting package. If your accountant uses one wages expense GL account with separate tracking codes, the department allocation must be mapped into those tracking fields when preparing the final import. Always confirm the target software template and reconcile before posting. 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/ 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/
Extra Private Pension How do I enter a private pension that accumulates?
Click this Topic Title above to open the full help page and view any related training video if available.
If your pension is based on fixed salary earners who, for example, do not get the number of days-worked entered each month then you will need to use the Terminal-Benefit option and use this as a Pension field that accumulates. This will work in much the same way as Gratuity where you can specify a percentage of basic pay, eg 10 percent for Pension. Note however that the field will be called Terminal Benefit on all reports etc but it will work as a record of a private pension that accumulates. In this case then do not use the below example for a Pension as a custom-extra based on days worked and simply use the Terminal Benefit field for your pension. All accumulated values for Terminal Benefit will be the accurate accumulation of the Private Pension. The help below is for setting up pension based on days worked and is not to be used when employees are not paid on daily rate by the number of days worked each month. You can add a customised addition called, for example, "Pension" as an "Extra Based on Days" Type of extra. Go to the settings page. Choose Edit-Company-Extras. Click on "add an Extra"(at the bottom). Give it a name eg "Pension". Specify it as an "Addition" in the "Method" field. Specify "Based on Days" in the "Type" field. Click on the "Val times by Days" to edit the default Value. eg this is the Value that is multiplied by the number of Standard (normal) days. If the daily rate is for example K50, and your pension is 10 percent then the Pension-Daily Rate needs to be K5. Note for this to work, the pension needs to have normal days entered each month on the payment capture. It will be good to make this extra apply only on a Department level and NOT Company-Wide. So do NOT tick the checkbox "Apply-to-all" in the Company unless everyone gets the private pension. Note: This particular Customized extra will NOT appear on the the second input page for each employee payment capture as "no input" is required. Note: This value will be accumulated from month to month in the current calendar year and will NOT be included in the NET pay. At the end of the accumulated period you need to actually make an extra payment to the employee for the accumulated amount. Note the Accumulated Amount will still reflect on the payslip but will be automatically cleared each January so as to make room for the next year to start accumulating again. It is helpful to go to the "More-Reports" page and click on the "Extras-Accumulative" report to print out the summary of each employee's pension accumulation into excel. On this report, remember to click on the "Select Customised Extra" drop down search box on the top right and choose the "Pension" extra before you export to Excel so that you produce the Pension Report.
Extras Assigned by Employee How do assign a company extra to specific employees only?
Click this Topic Title above to open the full help page and view any related training video if available.
First add your customised Extra addition or deduction to the company. Use Settings and then click on Edit Company Extras. You have the option to apply the extra to all within the company. If you do NOT make the extra a Company-Wide extra then you can use Assign Extras to Department or Assign Extras to individual Employees. Click on edit Employees on the home screen and then on the right hand side of the table of employees click on "Extra Additions or Subtractions" to assign extras to the specific employee selected. NB NOTE: You may also use Individual Rates for Company-Wide Extras. If you want to specify INDIVIDUAL Itemised or the Fixed-Extra Custom-Extras per employee and would like Harvester to "remember" these values from month to month so that no re-input is required each month then type "Individual" in help.
Extras by Department or Company How do assign a company extra to all employees within a department?
Click this Topic Title above to open the full help page and watch the related training video.
First add your customised Extra addition or deduction to the company. Use Settings and then click on Edit Company Extras. You have the option to apply the extra to all within the company. If you do NOT make the extra a Company-Wide extra then you can use Assign Extras to Department or Assign Extras to individual Employees. To change an existing Extra from Department to Company-Wide level : On edit extras if you tick the check box for "Apply to all within Company" then it will become a Company-Wide extra. To change an existing Extra from Company-Wide to Department level you need to DELETE the extra. NB Please WAIT until you start a new payroll month BEFORE you delete a Company-Wide Extra to prevent changes to already processed payroll data. Any NON company wide extra can be applied to a department using the Department-Settings icon form the Settings page. Note that new employees added will only get assigned Company-Wide extras and if you are adding employees to a specific department then they will also be assigned department level extras for that specific Department. (If there are any Department-Level extras at the time of adding employees) You may also use the Department Settings icon to apply any department-level extras after employees are added. Extras are not assigned across all "permanents" or "casuals". They are only applied by "Company" or "Department". NB NOTE: You may also use Individual Rates for Company-Wide Extras. If you want to specify INDIVIDUAL Itemised or the Fixed-Extra Custom-Extras per employee and would like Harvester to "remember" these values from month to month so that no re-input is required each month then type "Individual" in help.
Extras Cane Bonus Based on Days example How do I enter a custom Accumulated amount based on Days worked?
Click this Topic Title above to open the full help page and view any related training video if available.
A customised Cane Bonus can be configured so that it is calculated using only the days on which an employee actually cuts cane. First, go to Settings, choose Edit Company Extras and add an extra called, for example, “Cane Bonus”. Set the extra up as follows: * Method: Addition * Type: Based on Days * Val times by Days: Enter the Cane Bonus value that must be multiplied by the employee’s cane-cutting days. The Cane Bonus should normally be applied only to the Cane Cutters department. Do not select “Apply to All” unless the bonus must apply to every employee. How to separate cane-cutting days from general labour days If a cane cutter works some days cutting cane and other days doing general labour or other non-cutting work: 1. Go to the Department Settings for the Cane Cutters department. 2. Enter the appropriate general-work daily rate in the Other Day Rate field. 3. During payment capture, enter only the days actually spent cutting cane in the Normal Days field. 4. Enter the non-cutting or general-labour days in the Other Days field. Because the Cane Bonus is configured as Based on Days, it will be calculated using the Normal Days entered for actual cane cutting. The Other Days will be calculated separately using the department’s Other Day Rate and will not increase the Cane Bonus. Example If an employee spends 18 days cutting cane and 4 days performing general labour: * Normal Days: 18 * Other Days: 4 Harvester will calculate the Cane Bonus using the 18 cane-cutting days only. The four general-labour days will be calculated using the department’s Other Day Rate. The different days and amounts will also be shown separately on the employee’s payslip. Accumulating and paying the Cane Bonus This customised extra accumulates during the current calendar year and is not automatically included in Net Pay. When the accumulated Cane Bonus must be paid, the total can be entered manually in the Bonus field on the employee payment-capture screen. You can view the accumulated amounts from More Reports by opening the Extras-Accumulative report. Select the Cane Bonus extra from the customised-extra list before exporting the report to Excel. Accumulated amounts are not cleared automatically in January. They continue to accumulate across months and years until the bonus or other accumulated amount has been paid. After payment, use the manual reset option under Settings to clear all previous accumulated amounts and begin a new accumulation period.
Extras Fixed Deduction Personal Levy Example How do I setup a Fixed Deduction that applies to all or many employees?
Click this Topic Title above to open the full help page and view any related training video if available.
You can add a customized deduction (or addition) as a "Fixed" Type extra. Go to the settings page. Choose Edit-Company-Extras. Click on add an extra(at the bottom). Give it a name eg Personal Levy. Specify it as a Deduction in the "Method" field. Specify "Fixed" in the "Type" field. Click on Edit Value (on the right hand side) to edit the default value of the Fixed Deduction. eg 15 for a fixed deduction of 15K applied to all that you apply this deduction to. ONLY Click Apply-to-all in the Company if you want the option to give everyone in the Company this deduction example. Customized extras will only appear on the "second page" of the direct payments entry screen which is the second input page for each employee payment capture. However this type of extra does not require user-input as it will automatically be deducted from those employees to whom you have applied this extra.
Extras Fixed Lunch Allowance Recurring Example How do I set up a fixed extra addition?
Click this Topic Title above to open the full help page and view any related training video if available.
You can add a customized addition(or deduction) as a "Fixed" Type extra. Go to the settings page. Choose Edit-Company-Extras. Click on add an extra(at the bottom). Give it a name eg Lunch. Specify it as an Addition in the "Method" field. Specify "Fixed" in the "Type" field. Click on Edit Value (on the right hand side) to edit the default value of the Fixed Deduction. eg 10 for a fixed addition of 10K applied to all that you apply this extra to. Click Apply-to-all in the Company if you want the option to give everyone in the Company this extra addition example. To edit individual amounts (for those not having the usual fixed amount), go to "Payroll Individual " screen on the main home page and then choose your employee who needs a different fixed addition. Then look to the last column and click on "extras". Look for the specific custom extra addition and then click "edit value". You will be able to give this employee a unique value that will be used for all future payroll payments processed. A Zero amount entered in this example will make sure that no extra addition is taken for that employee in future. Customized extras will only appear on the "second page" of the direct payments entry screen which is the second input page for each employee payment capture. However this type of extra does not require user-input as it will automatically be deducted from those employees to whom you have applied this extra. Note you can then set individual amounts for your Lunch Allowance so that Harvester will remember the individual amounts. For example your Lunch allowance varies per employee and you would still like it to be a "recurring input" that you do not need to input each month. Here is how you can easily do this: If you want to specify INDIVIDUAL Itemised or the Fixed-Extra Custom-Extras per employee and would like Harvester to "remember" these values from month to month so that no re-input is required each month then do the following to set this up BEFORE you begin processing the current month's payroll processing. Individual Itemised rates can be set to extras that are of the Type: Itemised or Fixed or Percentage-of-Basic. (The type can be set under Company Extras) To edit individual amounts, go to "Payroll Individual" screen on the main home page and then choose your employee who needs a different rate. Then look to the last column and click on "extras". Then choose any extra of the type that is "Itemised" or "Fixed" or "Percentage". Look for the specific custom extra and then click "edit value". You will be able to give this employee a unique value that will be used for all future payroll payments processed. Using this same page explained above, where you look for the last column and click on "extras", you can also click on the Add-Extras link to assign any NON company-wide extra to the specific employee. Some more notes: Another way to edit Individual Rates is use the Settings page and then click on Assign-Extras-to-Employees. Then choose any extra of the type that is "Itemised" or "Fixed" or "Percentage" and on the right hand side click on Edit-Value to edit the default itemized rate (default rate can be set under Company Extras). NB It is important to choose the Edit Value link for the individual employee on the RIGHT-HAND-SIDE of the edit Extras page. The Edit link on the Left Hand Side is for applying specific non-company-wide extras to individuals. It is helpful to use the Extra name-search box on the top to edit a specific Extras for employees. If the extra is a company-wide extra, then the input amounts can be captured via excel in the offline, excel, payroll input sheet. If the input amount each month needs to be the same value as the normal days worked (eg A Daily bonus or allowance depending on the days worked) do the following: If you are using the Offline-input Template In excel and you have specified your Custom Extra to be of the "Itemised-Type", then just copy the column of the standard days into the appropriate Item-Input Column.
Extras Itemised Rate Mealie Meal Example How do I enter an Itemised Deduction like Mealie Meal Bags times Price per Bag?
Click this Topic Title above to open the full help page and view any related training video if available.
You can add a customised deduction called Mealie Meal as an Itemised Type (no of Bags) entry. Go to the settings page. Choose Edit-Company-Extras. Click on add an extra(at the bottom). Give it a name eg Mealie Meal. Specify it as a "Deduction" in the "Method" field. Specify "Itemised" in the "Type" field. Click on Edit Value (on the right hand side) to edit the default itemized rate. eg Kwacha Price per Bag. Click Apply-to-all in the Company if you want the option to give anyone in the Company this deduction example. Customized extras will appear on the direct payments entry screen which is the second input page for each employee payment capture. When using the offline payroll input option, it will be much quicker to capture these entries in excel. On the offline payroll input sheet you will see your column headings for the "Mealie Meal" deduction and you will only need to enter the Number of Bags. (Harvester will multiply by the rate specified above when you upload) Note: If you want to specify INDIVIDUAL Itemised rates per employee and would like Harvester to "remember" these values from month to month, then type "Individual" in help.
Extras Itemised Rate Sick Allowance or Maternity Leave Example How do I process Sick Pay or Maternity Leave?
Click this Topic Title above to open the full help page and view any related training video if available.
You can use the 'standard' Kwacha entry and use this for sick Pay (or Maternity Leave) and enter the Kwacha value for this addition using the "Other Addition" field or you may use the 'standard' other option using the "Other Days" field. The "Other Days" field is found on the payment capture screen and you will notice in red text that you can set the rate for the "Sick Pay" or the "Maternity Pay" in the department before you capture the payment. The above is easiest and commonly used but you just need to make a note that you are using the other fields for sick pay as the label on the report will NOT actually show "Sick Pay" or the "Maternity Pay". However if you want the allowance to be a separate itemised (per day or per hour) report value called Sick Leave or Maternity Leave, then proceed as follows: You can add a customised addition called "SickPay" or "Maternity" as an Itemised Type (no of Days or Hours) entry. Proceed as follows: Go to the settings page. Choose Edit-Company-Extras. Click on add an extra(at the bottom). Give it a name eg "SickPay" or "Maternity". Specify it as an "Addition" in the "Method" field. Specify "Itemised" in the "Type" field. Click on Edit Value (on the right hand side) to edit the default itemized rate. eg Sick pay per Day or Maternity pay per Day. Click Apply-to-all in the Company if you want the option to give anyone in the Company this allowance example. Customized extras will appear on the direct payments entry screen which is the second input page for each employee payment capture. When using the offline payroll input option, it will be much quicker to capture these entries in excel. On the offline payroll input sheet you will see your column headings for the "SickPay" or the "Maternity" addition and you will only need to enter the Number of Days or hours. (Harvester will multiply by the rate specified above when you upload) Note: If the Sick Pay or "Maternity" rate varies per person, then you would need to specify that rate in the individual setup of each of these extras. To edit individual sick rates, go to "Payroll Individual " screen on the main home page and then choose your employee who needs a different rate. Then look to the last column and click on "extras". Look for the specific custom extra and then click "edit value". You will be able to give this employee a unique value that will be used for all future payroll payments processed.
Extras Itemised Rate Transport Allowance Example How do I enter a travel or food allowance per day worked?
Click this Topic Title above to open the full help page and view any related training video if available.
NEW BUILT-IN PER DIEM / TRAVEL ALLOWANCE OPTION Harvester now has a separate Per Diem / Travel Allow. (PAYE Exempt) field on the payroll payment screen. Use this built-in field when you simply want to enter the actual Per Diem or travel allowance amount for that employee for the current payroll period. The amount is shown separately on the employee payslip and on the PDF E-payslip. Search Help for Per Diem Travel Allowance for full details. The Itemised Custom Extra method below is still useful when you specifically want Harvester to calculate an allowance as Number of Days x Rate. You can use the standard Kwacha entry for travel allowance and enter the Kwacha value for this standard addition. However if you want the allowance to be itemised(per day) then proceed as follows: You can add a customised addition called "Travel" as an Itemised Type (no of Days) entry. Go to the settings page. Choose Edit-Company-Extras. Click on add an extra(at the bottom). Give it a name eg "TravelAllow". Specify it as an "Addition" in the "Method" field. Specify "Itemised" in the "Type" field. Click on Edit Value (on the right hand side) to edit the default itemized rate. eg Kwacha Allowance per Day. Click Apply-to-all in the Company if you want the option to give anyone in the Company this allowance example. Customized extras will appear on the direct payments entry screen which is the second input page for each employee payment capture. When using the offline payroll input option, it will be much quicker to capture these entries in excel. On the offline payroll input sheet you will see your column headings for the "Travel" addition and you will only need to enter the Number of Days. (Harvester will multiply by the rate specified above when you upload) Note: If you want to specify INDIVIDUAL Itemised or Fixed-Extra Custom-Extras per employee and would like Harvester to "remember" these values from month to month so that no re-input is required each month , then for more info type "Individual" in help. NB: You may edit the Itemised Rate so specific employees have a different amount. To edit individual amounts, go to "Payroll Individual " screen on the main home page and then choose your employee who needs a different fixed deduction. Then look to the last column and click on "extras". Look for the specific custom extra deduction and then click "edit value". You will be able to give this employee a unique value that will be used for all future payroll payments processed. A Zero amount entered in this example will make sure that no travel allowance is taken for that employee in future. If you are using Offline-Input in excel: If the days are the same as the normal days worked then in excel just copy the column of the standard days you have captured in excel into the "Travel" column.

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.

Next steps

Next steps
Start 10-week Free Trial Choose a Plan Prices Customers & Partners PAYE & Net Pay Calculator

Get in touch

Email: support@harvesteronline.net

WhatsApp Text Only: +260969078711

Location: Plot E, Mazabuka, Zambia

by Sean Kelly : For the Glory of God