Report this item to Etsy

Caregiver Timesheet Excel Google Sheets, Home Care Payroll Hours Tracker, Weekly Overtime Hours, Caregiver Schedule and Shift Log Template

Item highlights

  • Digital download
  • Digital file type(s): 1 PDF, 1 other file

Seller's description

Log every caregiver shift once. The spreadsheet works out the hours (overnight shifts included), the pay, the mileage and what to bill the client, then adds everything up by work week, pay period, client and month, with overtime counted under the setting you choose.

WHAT IT DOES
- Shift log for up to 2,000 shifts: date, caregiver, client, start and end time, unpaid break and miles
- Hours for every shift, including overnight shifts that end after midnight
- Pay, mileage reimbursement and billable amount per shift from each caregiver's pay rate and each client's bill rate, with per-shift overrides for a holiday or a different service
- Weekly Hours: pick any week to see each caregiver's total, regular and overtime hours, hours left before overtime and gross pay, plus 8 weeks of hours side by side
- Pay Period: pick a weekly or every-two-weeks pay period to see hours, overtime, mileage and gross pay per caregiver, ready to pass to your payroll provider
- Client Hours: hours and billable amount per client for every month of the year
- Dashboard: hours, billable amount, gross wages, overtime and billed less pay by month and by caregiver

TABS
- Shift Log: One line per shift. Hours, pay, mileage and billable amount fill in.
- Weekly Hours: Total, regular and overtime hours and gross pay per caregiver.
- Pay Period: Hours, overtime, mileage and gross pay for each pay period.
- Client Hours: Hours and billable amount per client, month by month.
- Dashboard: Hours, billing, wages and overtime by month and caregiver.
- Settings: Pay periods, work week, overtime, caregivers and clients.

WHAT YOU GET (instant download, 2 files)
- UnitAndLedger-Home-Care-Schedule-Timesheet-Payroll-Tracker.xlsx: one spreadsheet file for Google Sheets and Excel. Formulas only, no macros, no add-ons, no subscription.
- UnitAndLedger-Home-Care-Timesheet-Tracker-Quick-Start-Guide.pdf: PDF quick-start guide (2 pages): how to open it in Google Sheets or Excel, the three steps to set up, and what each tab does.

GOOD TO KNOW
- Room for 40 caregivers, 60 clients and 2,000 shifts.
- Overtime is a setting, not a rule built into the file: you choose on or off, the weekly hours before overtime and the multiplier, after checking federal and state wage and overtime rules for your agency.
- Overtime is counted per caregiver per work week, on the caregiver's average rate for that week. Daily overtime and other premiums are not calculated; use a pay rate override for those shifts.
- Pay periods of 7 or 14 days from any start date, and a work week that starts on any day you pick.
- Gross pay is before taxes and deductions. This is a record-keeping tool, not payroll, tax or legal advice; it does not run payroll or file anything.
- Not affiliated with any payroll, scheduling or electronic visit verification software, or any state agency. Sample names are invented.

HOW IT WORKS
1. Buy and download instantly (Etsy emails a link; the files are also under Purchases and Reviews on etsy.com, not in the app).
2. Google Sheets: upload the .xlsx file to Google Drive, open it, then choose File > Save as Google Sheets. Excel: open it in Excel 2016 or newer on Windows or Mac.
3. Follow the Start Here tab or the PDF quick-start guide. The file opens with sample data so you can see how it works; clear it and type your own.

LICENSE AND NOTES
For use in your own business. Not for resale or redistribution. This is a planning and record-keeping tool, not payroll, tax, legal or financial advice. Built for Google Sheets and Excel on a computer; not tested in Apple Numbers. Because this is a digital product, returns are not accepted; if something does not work, message me and I will make it right.

Copyright UnitAndLedger.

View more
Etsy's Purchase Protection

If something goes wrong with an order, we've got your back for all eligible purchases. View program terms

NowPrice:$21.75

Original Price: $29.00

Loading

25% off

•

Sale ends in 6 days

You can only make an offer when buying a single item

Delivery

Instant download

Your files will be available to download once payment is confirmed. Here's how.

Instant download items don't accept returns, exchanges or cancellations. Please contact the seller about any problems with your order.

Seller's description

Specifications

Log every caregiver shift once. The spreadsheet works out the hours (overnight shifts included), the pay, the mileage and what to bill the client, then adds everything up by work week, pay period, client and month, with overtime counted under the setting you choose.

WHAT IT DOES
- Shift log for up to 2,000 shifts: date, caregiver, client, start and end time, unpaid break and miles
- Hours for every shift, including overnight shifts that end after midnight
- Pay, mileage reimbursement and billable amount per shift from each caregiver's pay rate and each client's bill rate, with per-shift overrides for a holiday or a different service
- Weekly Hours: pick any week to see each caregiver's total, regular and overtime hours, hours left before overtime and gross pay, plus 8 weeks of hours side by side
- Pay Period: pick a weekly or every-two-weeks pay period to see hours, overtime, mileage and gross pay per caregiver, ready to pass to your payroll provider
- Client Hours: hours and billable amount per client for every month of the year
- Dashboard: hours, billable amount, gross wages, overtime and billed less pay by month and by caregiver

TABS
- Shift Log: One line per shift. Hours, pay, mileage and billable amount fill in.
- Weekly Hours: Total, regular and overtime hours and gross pay per caregiver.
- Pay Period: Hours, overtime, mileage and gross pay for each pay period.
- Client Hours: Hours and billable amount per client, month by month.
- Dashboard: Hours, billing, wages and overtime by month and caregiver.
- Settings: Pay periods, work week, overtime, caregivers and clients.

WHAT YOU GET (instant download, 2 files)
- UnitAndLedger-Home-Care-Schedule-Timesheet-Payroll-Tracker.xlsx: one spreadsheet file for Google Sheets and Excel. Formulas only, no macros, no add-ons, no subscription.
- UnitAndLedger-Home-Care-Timesheet-Tracker-Quick-Start-Guide.pdf: PDF quick-start guide (2 pages): how to open it in Google Sheets or Excel, the three steps to set up, and what each tab does.

GOOD TO KNOW
- Room for 40 caregivers, 60 clients and 2,000 shifts.
- Overtime is a setting, not a rule built into the file: you choose on or off, the weekly hours before overtime and the multiplier, after checking federal and state wage and overtime rules for your agency.
- Overtime is counted per caregiver per work week, on the caregiver's average rate for that week. Daily overtime and other premiums are not calculated; use a pay rate override for those shifts.
- Pay periods of 7 or 14 days from any start date, and a work week that starts on any day you pick.
- Gross pay is before taxes and deductions. This is a record-keeping tool, not payroll, tax or legal advice; it does not run payroll or file anything.
- Not affiliated with any payroll, scheduling or electronic visit verification software, or any state agency. Sample names are invented.

HOW IT WORKS
1. Buy and download instantly (Etsy emails a link; the files are also under Purchases and Reviews on etsy.com, not in the app).
2. Google Sheets: upload the .xlsx file to Google Drive, open it, then choose File > Save as Google Sheets. Excel: open it in Excel 2016 or newer on Windows or Mac.
3. Follow the Start Here tab or the PDF quick-start guide. The file opens with sample data so you can see how it works; clear it and type your own.

LICENSE AND NOTES
For use in your own business. Not for resale or redistribution. This is a planning and record-keeping tool, not payroll, tax, legal or financial advice. Built for Google Sheets and Excel on a computer; not tested in Apple Numbers. Because this is a digital product, returns are not accepted; if something does not work, message me and I will make it right.

Copyright UnitAndLedger.

  • Item type
    Digital download
  • Digital file type(s)
    1 PDF, 1 other file
Shop with confidence
Etsy Purchase Protection

If something goes wrong with an order, we've got your back on all eligible purchases. View program terms

Meet your seller

UnitAndLedger ·

Woodbridge, Virginia

No reviews yet
·
1 sale
·
New on Etsy