INSERT INTO payroll_batch ( agency_id, employee_id, date_from, date_to ) VALUES ( '#session.AgencyId#' ,'#session.EmployeeId#' ,#CreateODBCDate(url.df)# ,#CreateODBCDate(url.dt)# ) Select LAST_INSERT_ID() AS id SELECT id FROM payroll WHERE ScheduleItems_Id = '#iArr[1]#' INSERT INTO payroll ( batch_id, ScheduleItems_Id, pay_date, pay_type, pay_rate, hours, wages, travel, travel_minutes, paperwork, paperwork_minutes, mileage_rate, mileage, miles, total_paid ) VALUES ( '#lastId#' ,'#iArr[1]#' ,'#iArr[2]#' ,'#iArr[3]#' ,'#iArr[4]#' ,'#iArr[5]#' ,'#iArr[6]#' ,'#travelamt#' ,'#iArr[8]#' ,'#travelamt#' ,'#iArr[10]#' ,'#iArr[11]#' ,'#iArr[12]#' ,'#iArr[13]#' ,'#paid#' )
Payroll Report for a Time Period
display:none;'>
  QuickBooks
From Date...
Click Here to Pick the date To Date...
Click Here to Pick the date		 Employees...
background:#fafafa;'> checked='checked' tabIndex='3' onclick="javascript: tExported(0);" /> ALL Payroll
background:#fafafa;'> checked='checked' tabIndex='4' onclick="javascript: tExported(1);" /> Not Yet Paid
background:#fafafa;'> checked='checked' onclick="javascript: tExported(2);" tabIndex='5' /> Marked as Paid
display:none;'> checked='checked' /> No checked='checked' /> Yes - Include Previously Exported Payroll items?
  Hide
Please select a Starting AND Ending date above to run a Payroll Report
SELECT a.Mileage_Rate ,si.ScheduleItems_Id ,si.Employee_Id ,si.Visit_Date ,DATE_FORMAT(si.Visit_Date, '%W, %M %d, %Y') vd ,DATE_FORMAT(si.Visit_Date, '%Y-%m-%d') dd ,si.Visit_Type ,si.ScheduleItems_Id ,si.Total_Hours hours ,si.StartTime ,si.EndTime, si.Progress_Note ,si.Progress_Note ,si.Travel travel ,si.Total_EPay paid ,si.Paperwork paper ,si.Mileage miles ,si.PayMileage ,e.Employee_Id ,e.Last_Name ,e.First_Name ,ep.Pay_Rate ,UPPER(ep.Measure) measure ,p.Last_Name_M0040 pl ,p.First_Name_M0040 pf ,py.id AS PayrollId ,'-1' AS PayrollId FROM Agency a, ScheduleItems si ,payroll py LEFT OUTER JOIN payroll py ON py.ScheduleItems_Id = si.ScheduleItems_Id , Employee e, Employee_Payroll ep, patient p WHERE a.Agency_Id = '#session.AgencyId#' AND si.Agency_Id = '#session.AgencyId#' AND si.Visit_Date BETWEEN #CreateODBCDate(url.df)# AND #CreateODBCDate(url.dt)# AND si.Deleted <> 1 AND si.Employee_Id IS NOT NULL AND si.ScheduleItems_Id IN (#scheduleItemIds#) AND py.ScheduleItems_Id = si.ScheduleItems_Id AND py.exported = 'N' AND si.ScheduleItems_Id NOT IN (SELECT ScheduleItems_Id FROM payroll WHERE ScheduleItems_Id = si.ScheduleItems_Id) AND e.Employee_Id = si.Employee_Id AND e.Employee_Id IN (#form.emps#) AND ep.Employee_Id = e.Employee_Id AND ep.EmpPay_Id = si.EmpPay_Id AND p.Patient_Id = si.Patient_Id ORDER BY si.Visit_Date, e.Last_Name, e.First_Name, ep.Measure >
Uncheck the 'Pay' checkbox for any Payroll items you do not wish to process at this time.
When you are ready to process the Selected items, please click the "Mark as Paid" button at the bottom of the page.
The Payroll items below have been Marked as Paid.

Click the Export Records button to create a file to send to your Payroll company or software.

If you do not wish to Export these records now, you can Find and Export these Paid Payroll items
later by entering the same Payroll Dates and selecting the "Marked as Paid" option when searching.
From: #url.df#   To: #url.dt#    Mileage Rate #DollarFormat(GetVisits.Mileage_Rate)# » View by Employee » Change Search Criteria
Unpaid Items:   Check ALL  /  Uncheck ALL
No Payroll data was found from #url.df# to #url.dt#

action = 'index.cfm?page=reports&cat=schedules&rpt=Payroll_Report' onsubmit = 'return cPayroll();' action = 'index.cfm?page=reports&cat=schedules&rpt=Payroll_Export' action = 'index.cfm?page=reports&cat=schedules&rpt=Payroll_Report_legacy' onsubmit = 'return cPayroll();' action = 'index.cfm?page=reports&cat=schedules&rpt=Payroll_Export_legacy' > #DollarFormat(dDue)#   #day#
bgcolor="FFFFFF" bgcolor="e7e7e9">
Employee Note? Pay Type Patient Hours Pay Rate Wages Travel Paperwork Pay Mi Due Pay
#Last_Name#, #First_Name# NO Undefined #mt# #patient# #DecimalFormat(hours)# style='background:##ffeeee;'>#DollarFormat(Pay_Rate)# Daily Pay #DollarFormat(amt)# #DecimalFormat(travel)# min #DecimalFormat(paper)# min > #DecimalFormat(miles)# N/A #DollarFormat(vTotal)#   Paid #DecimalFormat(((travel/60) * Pay_Rate))#0.00@#travel#0@#DecimalFormat(((paper/60) * Pay_Rate))#0.00@#paper#0@ >#mileage_rate# 0.00 @ > #DecimalFormat((miles * mileage_rate))# 0.00 @ #miles# 0 @#DecimalFormat(vTotal)#' checked='checked' />
#DollarFormat(dDue)#