Skip to main content

How to Import your Timecard Report to Collsoft

If you use Collsoft as your payroll provider, you will need to make some edits to your Timecard Report so it can import into the software.

In order to import your hours into Collsoft from Bizimply for payroll, you need to first pull the Hours by Day csv Timescard Report.

  1. Click on Reports.

  2. In Employee Timecards (under Attendance Reports, the first report type that opens) select your Date Range, Locations, Payroll Departments, and Employees

  3. Select the CSV option from the available radio buttons, and then choose the Hours by Day in the dropdown menu that appears for the Breakdown.

  4. Choose to include or exclude TOIL if that option is available for you

  5. Click Export

Once the file is downloaded, you will need to open it on your device, and delete some rows and columns as per below:

  1. Delete Rows: 1 to 6

2. Delete Column A and E (Bizimply ID and Payroll Department)

3. Delete F to L (the individual Days of the Week from Mon-Sun)

4. Delete Totals rows at the bottom of your employees

5. Combine the First Name and Last Name column on Bizimply, as this will match the Collsoft import file specifications. You can take this action through Excel functions.

6. Rename the Employee No column to Works No.

7. There may be other columns on the sheet you also don't need, depending on your Collsoft set up and payment requirements.

Once you've finished editing the file, you can save a copy and import it into your Collsoft account.

There is more on importing files into Collsoft which you can find here on their own Help Article.

Did this answer your question?