What is Spreadsheet Import?

Spreadsheet Import is a simple way of importing pay information directly into the payroll run, without having to create a complicated CSV file.

For example, you may run a bureau and receive spreadsheets with hours or payments on them each week from your client. Spreadsheet Import makes transferring this information from the spreadsheet into Earnie quick and easy.

This feature can also be used to speed up manual payroll data entry. For example, if you need to pay everyone a bonus at Christmas - you can quickly type in the bonus amounts on one screen against the relevant employee, without having to scroll through each person’s payroll screen one at a time.

The Spreadsheet Import is used for variable payroll data only. If you need to import any standard employee or company data you should use the File/Import feature.

Spreadsheet Import has two main stages:

• Configuring your template containing the pay elements to be imported.

• Importing data into this template from a Microsoft Excel spreadsheet (or manually entering amounts into the template).

	Quickstart Overview and demonstration on how to configure your template.
	Quickstart Run a payroll with data imported using the spreadsheet import module.