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.
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
Related Harvester training video:
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 videoThis Harvester Payroll training video explains: Offline Bulk Input of Payroll in Excel. |
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