How to Import Payroll

You can import your payroll data even if you use a point-of-sale system or a different time clock provider.

M
Written by Melissa Compagnon
Updated over a week ago

We understand companies may not have the option to utilize Fingercheck time clocks. If your company just so happens to use another system for employee time tracking, such as a point-of-sale (POS) system that also tracks tips, you can still utilize our import data feature to process your payroll.

Once you build your payroll data import, you will be all set to import your payroll at Step 4 of the payroll process.

For more details on preparing your payroll file and how to map payroll data, check out our article How to Import Data into Fingercheck.


Import your payroll

  1. Log in to your Fingercheck account as an Admininstrator.

  2. Click on the Payroll tab.

  3. Click Run Payroll.

  4. Click Start on the Review & Run option.

  5. Confirm payroll details for Steps 1 thru 3, and click Next at each step.

    1. Step 1: Select pay period

    2. Step2: Time review

    3. Step 3: Data verification

  6. At Step 4 select the import pay entry data icon located on the right side of the screen.

  7. Select the appropriate options:

    1. Job type: Manual

    2. Data exchange type: PayrollData

    3. Mapping: select the current payroll file matching the import you previously built

    4. Choose the .csv file to upload

  8. Click OK.

  9. Click OK to add the payroll import to your payroll process.

  10. Enter additional payroll details, or click Next to continue with the payroll process.

Please note: we recommend that you use the employee numbers used in Fingercheck match the employee numbers used in your time clock or POS system.


Payroll mapping

We have made the mapping process easy when building your payroll import. The file layout and headers do not have to match Fingercheck. The only thing you have to do is map the information from your time clock or POS system correctly to a field in Fingercheck.

Below is the layout for the payroll import file. Required columns are noted.

Field

Required

Notes

EmployeeNumber

Yes

Include leading zeros

PayNumber

Yes

The check number paid to an employee.

This field will usually report ‘1’.

NOTE: if the employee will be paid multiple checks, use the PayNumber to report additional checks.

Yes

Earning code to report the employee's pay

Hours

No

Number of hours the employee worked

Rate

No

Rate the employee should be paid, if different from the rate entered in their profile.

Amount

No

The amount the employee should be paid.

This column is great to issue bonuses.

RateCode

No

Rate code employee should be reported

No

Cost Center employee should be reported

No

Cost Center employee should be reported

No

Cost Center employee should be reported

No

Cost Center employee should be reported

No

Cost Center Employee should be reported

No

Job employee should be reported

No

Task employee should be reported

No

Pay period begin date

No

pay period end date

JobMapCode

No

job code assigned

RecordType

Yes

Earning or Deduction

Enter 'E' to report an earning

Enter 'D' to report a deduction

No

Enter special check type if special calculations for taxes, deductions, and direct deposit should be considered

DateWorked

No

Enter the date the employee worked

EntryType

No

Leave blank or enter ‘E’ for standard checks

StubMessage

No

Message that should appear on the employees pay stub

TaxLocation

tax location used for tax reporting

Please note: if you use the payroll import to issue a separate bonus or commission check, you will use the PayNumber to report additional checks. For each additional check you enter, please identify it by assigning a unique identifier in the PayNumber field. For instance, if an employee receives both their regular paycheck and a bonus check, label the regular check PayNumber as 1 and the bonus check PayNumber as 2.


FAQ

How does importing payroll data improve accuracy?

Automation reduces the risk of errors associated with manual data entry. By directly importing data from your POS system or other time clock provider, you ensure consistency and accuracy in payroll records, minimizing discrepancies that may arise from manual input.

Can I import tip data along with regular payroll information?

Yes, importing payroll can include tip data, providing a comprehensive overview of employee earnings. This is particularly beneficial for businesses in industries where tips are a significant component of compensation.

What steps are involved in setting up payroll imports from another time clock provider?

The process may vary based on your existing time clock system. Generally, it involves mapping data from your time clocks to Fingercheck. For more details on this process, check out How to Import Data into Fingercheck.

Is importing payroll data compatible with point-of-sale (POS) systems?

Yes, if your business utilizes a POS system, we can integrate payroll data from these systems as well. For more details on this process, check out How to Import Data into Fingercheck.

Can I import historical payroll data from previous quarters or years?

No, you can’t use this payroll import process to import your payroll data from prior quarters. If you need to report changes to your payroll from a previous quarter, contact Fingercheck Support to discuss.

How frequently can I import payroll data?

The frequency of importing payroll data depends on your business needs. You can set up regular schedules, such as weekly or monthly imports, to ensure that payroll information is always up-to-date.

Are there additional costs associated with importing payroll from other time clocks?

There are no additional costs associated with importing your payroll from another time clock provider.


See how to use the mapping builder in Fingercheck to begin importing your payroll.

Did this answer your question?