Feature
The weekly payroll sheet, generated instead of retyped.
Somewhere in your business there is a spreadsheet that payroll actually runs on. Hours copied out of one system, salaries and mileage and loan balances remembered from last week, leave hand-written in the margin. This produces that exact workbook — a real .xlsx with live SUM formulas — from the punches your staff already made. Read this part first: it is not a payroll processor. It does not file taxes and it does not move money.
01 — What it is
And, just as importantly, what it isn't
The distinction matters enough to put above everything else, because getting it wrong is how businesses end up with tax penalties.
- It is a workbook generatorOne button on the timesheets screen, one week, one .xlsx download. Genuine Excel — not a CSV with a renamed extension — with live SUM formulas in the subtotal rows so whoever opens it can still edit a cell and watch the totals move.
- It is not a payroll processorNo withholding calculations, no tax filings, no direct deposit runs, no money movement of any kind. Whoever cuts your checks today keeps cutting them. This removes the four hours of transcription in front of that, not the payroll company behind it.
- It matches the sheet you already sendWe built this against a real franchise's existing weekly workbook — their column order, their section breaks, their subtotal rows. A bookkeeper who has opened that file every Monday for years should not have to learn a new one to accept ours.
- Owner-only, end to endPay rates, salaries, loan balances and the workbook endpoint itself are owner-scoped on the server. A GM or manager can run a week of timesheets and never touch a dollar figure.
02 — What's in it
Every column the sheet actually has
Hours and overtime come out of the time clock — paired punches per store, so a person who worked two locations gets a row under each rather than one blended number. Salaried rows work the other way round: their hours are that week's published hours from the schedule at that store, which is what a salary sheet expects.
Leave gets its own columns: vacation, sick, holiday, bereavement, paternity/maternity, and an “other” column with a written reason that lands in the comments. Every one of them can be left blank for hand-fill, exactly like the paper version, or entered in the portal per employee, store and week and printed straight into the workbook. Most operators do both — the predictable stuff typed in, the odd Tuesday written on the printout.
Alongside the hours sits everything that makes a payroll sheet a payroll sheet rather than a time report: per-store salary splits, mileage, loan balances, deductions, direct-deposit notes, and free-text comments — all stored per employee and per store, because a salaried person working under three entities gets paid differently by each of them. A trailing-30-day new-hires section runs at the bottom, so onboarding paperwork and first-week pay get looked at in the same place.
And when something changed that week, the whole row turns yellow: a pay change applied since the start of the week, a note on someone's profile, or any leave hours entered. That highlight is the single most-used feature in the file. A bookkeeper scanning forty rows does not need to compare against last week — the rows that moved are the yellow ones.
03 — Layout
By legal entity, or salary then hourly
Multi-entity businesses argue about this, so both layouts ship and it's one setting. By entity gives each LLC its own section with its own subtotals — the shape you want when each entity files separately and somebody reconciles section by section. Person-major puts every salaried person first and every hourly person after, one row per company beneath a bold name line with the entity label in the store column, and a subtotal row closing each section. Somebody who is salaried at three stores and hourly at a fourth appears in both sections, which is correct rather than a bug.
One rule keeps the file honest: a person gets a row at a store if they punched hours there or they have a payroll profile there. Salary specifically requires a profile row at that store — a salaried person with no profile is skipped rather than guessed at, so a salary can never duplicate itself into another entity's subtotal. That rule is shared with the timesheet and the schedule's salary split, so all three agree by construction instead of by coincidence.
Small thing worth mentioning because it decides whether people trust a generated file: the workbook declares its own sheet dimensions and row height, so it previews correctly in Quick Look and opens clean in Excel and Numbers. A payroll sheet that renders as three giant rows on a Mac gets deleted and retyped by hand, and then none of the above matters.
04 — Questions
Straight answers.
Is this a payroll processor?
No. It does not file taxes, does not calculate withholding, and does not move money. It produces the weekly workbook your bookkeeper or payroll company already works from, filled in from your own punches and pay records. Whoever runs payroll today keeps running it.
Can I lay it out by legal entity instead of by person?
Both layouts ship and it is one setting. By entity gives each LLC its own section with its own subtotals. Person-major puts every salaried person first and hourly people after, with one row per company under each name and the entity label in the store column — which is how a mixed salary-and-hourly person reads cleanly. Somebody who is both appears in both sections.
Where do the leave hours come from?
Either place. Vacation, sick, holiday, bereavement, paternity/maternity and an “other” column with a reason can be left blank for hand-fill the way a paper sheet always was, or entered in the portal for that employee, store and week and printed into the workbook.
How does the workbook handle someone salaried at one store and hourly at another?
Salary belongs to the stores where that person has a payroll profile with a salary on it. Their punches at any other store are paid as hours. A salaried row is generated from store membership rather than punches — so a salaried person with no punches still appears — and its hours come from that week's published schedule.
05 — Next step
Send us your current payroll sheet.
Bring the workbook you email every Monday to a 20-minute demo. We'll show you the generated version beside it, column for column, and tell you honestly what wouldn't fit.
Workforce & ops pricing is quoted per site and headcount — see pricing · no contracts