Shiftee's Exported Excel

Written At: 2018-03-21


As you operate your business, it is important to collect data. Almost all area of the business could be quantified if you could set up a proper method of data collection. These data can be used to analyze the past and current situation of your operation and also forecast future outcomes.

Shiftee_attendance_payroll_excel_download

The same applies to attendance system in your business. Whether your business employs part-time shift workers or regular office employees, or even in a work environment that supports freedom of work hours, collecting attendance data for analysis is important. For example, you may get some insights on how many staff were present during the busiest hours of the restaurant and also compare that to the revenue or a number of customer complaint issues. If you find out the restaurant was short-staffed, you can reinforce more staff for the next holiday season.

The timeclock attendance system of Shiftee links with shifts that you've scheduled and can be exported to Excel for further processing. This exported attendances will show the following items:

A. Clock-in/out time & break-in/out time [Actual]
B. Clock-in/out time & break-in/out time [Payroll Time Unit adjusted i.e. rounding rules]
C. Automatically-added break minutes [Rules can be set]
D. Total hours (clock-out time - clock-in time - all break minutes) [Actual]
E. Total hours (clock-out time - clock-in time - all break minutes) [Payroll Time Unit adjusted]
F. Hourly wage rate
G. Base pay (E x F)

Shiftee_attendance_payroll_excel_download

If you look at the downloaded Excel from Shiftee, it shows all of the aforementioned items in each column. Now, what differentiates Shiftee's exported attendance spreadsheet? Let's look into it.

  1. Filters
    When you work with Excel, there is almost always a need to use filters. You need to filter by a specific employee to process payroll, filter by each location to analyze total worked hours and wages. Not to worry, Shiftee's exported Excel already has filters set up so you don't have to add filters everytime you export to Excel.

  2. Functions and Formula
    If you click on ‘total hours’ and ‘base pay’, you will see that we've inserted functions and formula. So if you change the clock-in time, clock-out time, or even break minutes, it will automatically update other related cells to calculate hours and base pay accordingly.

  3. Subtotal at the Top
    Above all attendance records, there is a row with bolded numbers. You guessed it right. Those are subtotals which calculates the total amount of all hours or wages below. It only subtotals visible items. So if you filter by employee(s), location(s), or position(s), it will subtotal whatever is filtered.

See this close-up screenshot of Shiftee's exported Excel and notice the filters, functions, and subtotals in bold at the top. Shiftee_attendance_payroll_excel_filter_functions_subtotal

From a management point of view, you need to allocate the right human resource to the right place with the right roles, don't get your capable employees held up with tedious Excel tasks. Empower them with Shiftee and help them ‘excel’ in their area of expertise.


Recommended Articles