GUIDES

Employee scheduling spreadsheet for multiple locations (free template)

Updated 2026-11-12 · By the Assistlify team · AI-assisted, every fact linked to its source below

A free employee scheduling spreadsheet for multiple locations works best as one shift list for every store (date, location, employee, start, end, break) plus a summary tab that totals each person's hours across all stores. The cross-store total matters because FLSA overtime is owed for hours over 40 in a workweek, and a person's shifts at all your stores are hours worked for you.

Tab 1: the shift list (one row per shift)

A: DayB: LocationC: EmployeeD: StartE: EndF: Unpaid break (min)G: Paid hoursH: Overlap?
MonStore 1Maria9:0017:00307.5FALSE
TueStore 2Maria10:0018:00307.5FALSE
WedStore 1Maria9:0017:00307.5FALSE
ThuStore 3Maria12:0020:00307.5FALSE
FriStore 2Maria9:0017:00307.5FALSE
SatStore 1Maria10:0016:0006FALSE
TueStore 2James12:0016:0004TRUE
TueStore 3James15:0019:0004TRUE

Formulas for row 2, filled down (Google Sheets and Excel):

For a dated schedule, put the date in column A instead of the day name, so the overlap check does not match the same weekday in different weeks.

Tab 2: weekly hours per person, all stores

A: EmployeeB: Store 1C: Store 2D: Store 3E: TotalF: Over 40
Maria21157.543.53.5
James04480

Example: Maria's Store 1 hours are 7.5 + 7.5 + 6 = 21, Store 2 is 7.5 + 7.5 = 15 and Store 3 is 7.5, for 43.5. No single store shows more than 21 hours, but she has 3.5 overtime hours. At $17 an hour: 40 × $17 = $680 plus 3.5 × $25.50 = $89.25, for $769.25. Check other rates with the overtime calculator.

Where the spreadsheet breaks

Breaking pointWhat goes wrongWorkaround in the sheet
Two managers edit separate copiesShifts in one copy are missing from the cross-store totalOne shared file; each manager edits only their store's rows
Time off arrives by textA shift lands on an approved day offA Time off tab (employee, date) and a COUNTIFS check in column I
Planned vs. worked hoursThe sheet holds the plan; Fact Sheet #21 requires hours actually worked each day and each workweekRecord actual in and out times for each shift; Fact Sheet #21 allows exception-only records only for employees on a fixed schedule from which they seldom vary.
Minors on the scheduleNo check against under-16 limitsA birth-date column (required for anyone under 19) and a weekly cap check; see rules for scheduling minors
Old weeks overwrittenWork and time schedules must be kept 2 years, payroll records 3 yearsSave a dated copy of every published week

The FLSA requires no particular form for records and accepts any timekeeping method that is complete and accurate (Fact Sheet #21), so a spreadsheet is allowed. For a single-store grid layout, see the retail store weekly schedule template.

When the shift list outgrows the file, Assistlify builds the weekly schedule with staff assigned to one or more locations and checks time off against shifts; you add your stores and staff yourself, with a setup consultation call if you have questions; see multi-location scheduling.

This is general information, not legal advice. Check your state labor department for current rules.

This is general information, not legal advice. Check your state labor department for current rules.

Questions

Is there a free spreadsheet template for scheduling multiple locations?

Yes: use one shift list with date, location, employee, start, end and break columns, and a SUMIFS summary that totals each person's hours across all stores.

Can I keep employee hours in a spreadsheet?

Yes; US DOL Fact Sheet #21 says the FLSA requires no particular form, as long as hours worked each day and each workweek are complete and accurate.

How long do I have to keep old work schedules?

Fact Sheet #21 says work and time schedules and time cards are kept 2 years and payroll records 3 years.

How do I count overtime for someone who works at two stores?

Add their paid hours at every store in the same workweek; 21 + 15 + 7.5 = 43.5 hours means 3.5 overtime hours.

Sources