Labor report for 5.7.14 time clock

[Jesse]

These reports will work with Metrik

Hello here is a useful labor report that works with the new time clock in 5.7.14

[Labor Report:1,1,1,1,1,1]
>Net Sales|Checks|Check Avg|Labor Hrs|Labor $|Labor $/Net
{TIMECLOCK DETAILS:T.TotalHours.sum,T.TotalWage.sum::{REPORT TICKET DETAILS:T.PlainSum.sum:(TS.Status=Paid)}|{REPORT TICKET DETAILS:T.TicketNumber.count:(TS.Status=Paid)}|[=F(TN('{REPORT TICKET DETAILS:T.TotalAmount.sum:(TS.Status=Paid)}')/TN('{REPORT TICKET DETAILS:T.TicketNumber.count:(TS.Status=Paid)}'))]|{0}|{1}|[=F(TN('{1}')/TN('{REPORT TICKET DETAILS:T.PlainSum.sum:(TS.Status=Paid)}')*100)] %}

[Jesse]

Here is another one that you may find useful. Reminder that you must have 5.7.14 for this to work and you must be using the new built in time clock.

[Payroll Summary:2,1, 1, 1, 1,1] 
>Name|Role|Card Tip|Total Hours|Total Wages
{TIMECLOCK DETAILS:T.Name.asc,T.RoleName,T.CardTip.sum,T.TotalHours.sum,T.TotalWage.sum::{0}|{1}|${2}|{3}|${4}}

@{TIMECLOCK DETAILS:T.Name.asc,T.Date,T.TotalHours.sum::{0}:,}
[$1:1,1,1,1,1,1]
{TIMECLOCK DETAILS:T.Name,T.ClockIn,T.ClockOut,T.TotalHours,T.TotalWage,T.Date.asc:T.Name == "$1":[=FD('{5}','ddd, MMM d')]|{0}|[=FD('{1}','h\:mm tt')]|[=FD('{2}','h\:mm tt')]|{3}|${4}}

[Oscar_Castillo]

thank you very much. Always contributing and giving us your time and knowledge.

[Chipwagon]

I can’t figure out why I’m not getting any totals on this or any report for the new(est) Time Clock.

[Payroll Summary:2,1, 1, 1, 1,1]
>Name|Role|Card Tip|Total Hours|Total Wages
{TIMECLOCK DETAILS:T.Name.asc,T.RoleName,T.CardTip.sum,T.TotalHours.sum,T.TotalWage.sum::{0}|{1}|${2}|{3}|${4}}

@{TIMECLOCK DETAILS:T.Name.asc,T.Date,T.TotalHours.sum::{0}:,}
[$1:1,1,1,1,1,1]
{TIMECLOCK DETAILS:T.Name,T.ClockIn,T.ClockOut,T.TotalHours,T.TotalWage,T.Date.asc:T.Name == “$1”:[=FD(‘{5}’,‘ddd, MMM d’)]|{0}|[=FD(‘{1}’,‘h\:mm tt’)]|[=FD(‘{2}’,‘h\:mm tt’)]|{3}|${4}}

Everything else works great, just don’t get the total per shift or total hours…

[VehbiEmiroglu]

Ok i will check about totals.

[Chipwagon]

Totals are working now… I thought it would give totals for Clock Ins/Outs that were made before the report was created but it only started to work on Clock Ins/Outs made after report was created.