Offline Bulk Payroll Input from Excel

Harvester Payroll help topic with training video

Read the help answer below and, where available, watch the matching Harvester YouTube training video.

Payroll Help, Training and Support Actions

Payroll Help, Training and Support
Start 10-week Free Trial See Plans & Pricing Payroll Zambia Features Trusted Customers ZRA PAYE & Net Pay Calculator
Clear
Browse Help Topics / Results Open help answers here after searching above
Key Word Topic Title
Click to open
Help Answer & Training Video
Excel Offline Monthly Input Upload Offline, excel, payroll input upload
Click this Topic Title above to open the full help page and watch the related training video.

Offline Bulk Payroll Input from Excel

On the home page look for: Offline Pay Input in Excel Click Step 1. Prepare for offline input. Click Step 2. Create Offline Template file. On this form at the top left, click the export image to create the template file. This is the actual excel file you simply download and use to enter all your variables. Once you download, open the file and click on the top button within excel that says "enable editing". This is the same procedure for all excel files that are downloaded off the internet. Once you have entered the days etc on the excel offline file, you need to upload it. Note: In the blank columns only, will you be able to edit the values. You will not be able to change the rates or any data in the locked, coloured cells. Leave zero values as 0. Click on step 3. Upload Offline Template file for processing. This will enable you to complete another few quick steps to actually import and calculate your entire payroll according to what you entered offline. Step 1: Add file for import. Step 2: Import. Step 3: Process. Notes: If you already have an existing file added(from a previous month or upload attempt), you must click the Delete button. This can easily be deleted without fear of losing work. If you are not happy with your import you can simply redo the upload or you may go to any employee online and and edit any individual, current-payroll entry. Re employing people and using offline Excel input: Best practice is to employ the "new" employees online BEFORE you make the download spreadsheet in Step 1. What you must NOT do is employ the NEW employees AFTER you have prepared for offline and BEFORE you do the upload. If you have already been working on the Offline spreadsheet and you want to re employ people, then work on the offline spreadsheet and wait until AFTER you have uploaded. Harvester will calculate and process pay for all those that you inputted on the excel sheet. After this then re employ the "new" employees and manually pay them directly online using the "pay-me" option. Note: To completely redo the offline input file if you want to start again from scratch, then you can go to "Settings" and then "Delete Payroll Options" and then choose option 1 for "Delete current payroll Period". then you can start Step 1 from the beginning.

Watch the Harvester training video

This Harvester Payroll training video explains: Offline Bulk Input of Payroll in Excel.

Open this Harvester training video on YouTube

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

Next steps

Next steps
Start 10-week Free Trial Create Account Prices Trusted Customers PAYE & NAPSA Calculator