Is there a report that shows total hours by role?

schemjo · ‎03-06-2023

Hi, I'm looking to run a report to see how many hours certain roles have in total. For example, I'd like to see how many hours we've worked in Production, Management, Training and Associate. We have several team members that overlap roles so I can't just look at the individual member. I couldn't see a way in Payroll reports or Square Reports so I wanted to see if I'm missing something.

TheRealChipA · ‎03-07-2023

Hi @schemjo. I think this will work for you, but it will involve downloading a CSV and then summarizing it yourself.

From your online dashboard, go to Shifts -> Labor & Tips. Then define the date range you want and click the Export button. Choose “Export Shifts” and download that CSV. Open it with Excel. you’ll notice a Job title column. You can use some quick spreadsheet formulas to summary the hours worked for each Job title in that column.

Let me know if you need anything else, including how exactly to do that in a spreadsheet. I’m skipping over that part. LOL

Regards,

Chip A.
Square Expert & Innovator and member of the Square Champions group. (But NOT a Square employee, just a seller like you)

Was my post helpful? Take a moment to mark it as a solution. Marked solutions help other sellers find possible resolutions to similar problems. Also, if you find your solution elsewhere (say, through Support), it is helpful to come back to your post and tell us about it, then mark that as a Solution. Solutions are what this Community is all about!