I help manage several businesses that utilize Square, Square for Retail and Square for Restaurants. At a couple locations, we have several employees with multiple jobs (each with a different pay rate). When our Accountants use the "Export Labor Cost" spreadsheet for their payroll reporting, it seems that in some cases it will separate out the employee's jobs on different rows (what we prefer) and others it will be consolidated into one row.
Are others seeing the same thing? Can someone from Square Support state how it should function and why we are seeing differences? I've already verified that each employee denoted in the screenshot below does in fact have clock-ins of more than one job.
@azcomps Have you exported the shifts and compared the 2 for just these employees to see what the .csv is showing? The labor cost summary is a great report, but the export shifts should have that breakdown by line and cost by line for each employee. It would be easy enough to sort by employee name/id and all of the same data and cost is there (the report pulls the regular and overtime out to the right). It looks like you have some overtime exempt employees the way your report reads. The export shifts also breaks down by location. Let me know what you see.
Donnie-M
@Donnie-M, Yes we are aware of the "Export Shifts" csv and know we can filter and get a detailed breakdown but it's cumbersome for our Accountants to dig and tally through every clock-in/out across 30+ employees versus the "Export Labor Costs" csv.
Just looking for a clear answer from @Square or other business owners on whether or not the "Export Labor Costs" csv should be breaking out Jobs to their own rows per Employee or if it should all be consolidated on a single line. Since we are seeing both occur, it's confusing.
Square Community
Square Products