Google Sheets + Excel spreadsheet

Home Care Schedule, Timesheet and Payroll Hours Tracker

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.

  • Start Here + 6 tabs
  • 2-page PDF guide
  • Formulas only, no macros
$29Buy on Etsy: Schedule, Timesheet and Payroll Hours Tracker

Price shown on Etsy at checkout may differ during a sale.

Instant download from Etsy.

Who it is for

Small agencies that keep caregiver shifts in a spreadsheet and pass hours and gross pay to a payroll provider, and want client hours and billable amounts from the same log.

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.

What it is not

  • It does not run payroll or file anything. Gross pay is before taxes and deductions.
  • Overtime is a setting you choose, not a rule built into the file. Check the current federal and state wage and overtime rules for your agency before you set it.
  • Not a substitute for payroll, scheduling or electronic visit verification software, and not affiliated with any of them or with any state agency.
  • Built for Google Sheets and Excel on a computer; not tested in Apple Numbers.

Good to know

  • Room for 40 caregivers, 60 clients and 2,000 shifts.
  • 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.

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

For use in your own business. Not for resale or redistribution. Because this is a digital item, returns are not accepted; if something does not work, message the shop on Etsy.

A look inside

Free tools and guides

Works with

Price shown on Etsy at checkout may differ during a sale.

Complete Start-Up Bundle

All ten products in one download

Seven document packs (263 pages of Word and PDF) and three spreadsheets, in one ZIP. The same files as the ten products sold separately. Bought one by one, the ten products are $350.

Price shown on Etsy at checkout may differ during a sale.