Export Payroll Data in Medlin Format

Previous Top Next


Export Payroll Data in Medlin Format (Payroll Template)

This function can be used for those who prefer to manage most payroll data by editing a spreadsheet.

The template will also work for giving to your payroll clients, having them edit in the hours and employee information, including adding new employees, then returning the file to you for import, check creation, and report creation.

The template file will contain the active employee information.

Edit the file as needed, save the file, then import.

The import will add new employees (if needed), then create paychecks for employees with time worked.

 

NOTES

Do not alter the header information (the first row).

No adding or deleting columns.

All employee rows can be edited.

If an employee has no pay for the pay period, leave their hours blank or zero.

For salaried employees, make sure to either enter their time worked, or some sort of hour figure, such as 40, 80, etc.

If you do not need to track a salaried person's actual time worked, you can even enter 1 for the hours worked, and they will receive their salary amount.