Tasks ticked, time on site, and what this property's cleaning month comes to
A cleaning checklist is a free document, and it tells you what to clean. What it cannot tell you at the end of the month is how many of this property's tasks were actually ticked, what you flagged for the owner, how your time on site ran against the time that property allows, and what the month owes you. This page keeps the other half: the turnover record, with a face of its own to print and sign at the foot of this page. It keeps four things apart on purpose: a task ticked against the tasks that property's list carries; an item flagged for the owner, which is a note and never a cost; minutes on site against the minutes that property allows; and a finished turnover, which the month's amount counts, against a row still open, which it does not. Nothing you type leaves your browser.
This page is bookkeeping on one property's turnovers. It is a record of tasks ticked and time on site and nothing else - it makes no judgment about how clean anything is or about the state of the property, it names no cleaning agent, dilution or dwell time, and it is not a compliance record for a regulated premises. It gives no advice on what to charge or on what to do about anything you flag.
The walkthrough is on. Each part says what its figures mean and where they come from. Turn it off at the top once you know your way around. The figures in the blanks are a worked example so the page shows a real result before you touch it; replace them with yours.
Turnovers finished this month2 turns (one row still open)
Tasks ticked, of the tasks this property asks for96.4% — 54 of 56 tasks (one row still open)
Items flagged for the owner2 items (one row still open)
Minutes on site against the allowance+45 minutes (one row still open)
Amount due at your rate130.00(one row still open)
A
The property, once
One standing row for the property: the length of its own task list, the minutes a turnover there is allowed, and the rate you work to. Every turnover in part B is scored against this row, which is why it is typed once and not twelve times.
Tasks on its list
How many tasks the room-by-room list for this property carries. Yours or the owner's; this page supplies no list and has no view on what should be on one. If you leave it at nothing, no share of the list is printed.
Minutes allowed
The time a turnover at this property is allowed, as you settled it or set it. Not a target this page sets and not a limit it enforces: it is the figure your time on site is printed against.
Rate and basis
Whether you invoice this owner for the turnover or for the hour, and the rate on that basis. The basis changes what the month's amount means, so it is a field and not an assumption. Keep door, lockbox and alarm codes out of the label and off anything you print.
Short label for the property yours, not an address
Tasks on its list
Minutes allowed for one turnover
Rate written
Rate on that basis your currency, no conversion here
B
The turnovers, from your own log
One card per turnover, in whatever order you logged them. A card counts once it has anything on it; the rest appear as you fill them in. A card gives its minutes on site either from the two clock times or from a minutes figure you type, and a card that has neither stays open and adds nothing to the month.
Kept only the month's totals? Use one turn row for the whole month: leave the in and out times blank, type the month's total minutes in minutes on site, put the number of turns in turns covered, and enter the month's totals for tasks ticked and items flagged.
Time in, time out
Clock times as you wrote them, 24-hour, HH:MM. The page subtracts one from the other and never assumes a turnover ran past midnight, so a time out that is not after the time in gives no minutes and the row waits for a minutes figure instead.
Minutes on site
The alternative to the two clock times, not a third field to fill. A row takes its minutes from the times when the times give minutes, and from this figure otherwise. A row with both takes the times, and the row says so.
Turns covered
Normally one. It is more when one row stands for several turnovers, which is what the boxed line in this part is for: the tasks and the allowance are multiplied by it before the row is scored.
Items flagged
Something broken, missing or needing a restock that the owner should know about. A count of notes, nothing more: no cost goes here and none is asked for.
C
Each turnover, as logged
What each card came to. Minutes on site is from the two clock times where they give minutes and from the typed figure otherwise, and the row says which. A dash is not a figure of nothing: it means the row has no minutes yet, the tasks it ticked cannot be a count of this property's list, or this property's own task count is missing, and a note on the page names which.
Turnover
Minutes
From
Ticked
Share
Flagged
Row
Turnover 1, 3 Oct
155
the times
28 of 28
100.0%
0
finished
Turnover 2, 9 Oct
190
the times
26 of 28
92.9%
2
finished
Turnover 3, 16 Oct
—
no time out, no minutes figure
—
—
—
still open
D
Each turnover against the property's standard
The second level, and the one a per-visit tally has no room for: every row says how many turnovers it stands for, so the minutes it is scored against are this property's allowance multiplied by that, not one visit's own figure. The footing is the finished rows only, and it is what part E works from. A row still open prints no figure in any column here and says so in its own label, so each column of figures adds up to the footing under it.
Turnover
Turns
Minutes on site
Minutes allowed
Against allowed
Turnover 1, 3 Oct
1
155
150
+5
Turnover 2, 9 Oct
1
190
150
+40
Turnover 3, 16 Oct (still open)
—
—
—
—
The finished rows
2
345
300
+45
E
The month, with the working shown
Five figures, each beside the line that works it out, so nothing here has to be taken on trust. Counts are whole, because a part of a task is not a task; the amount is worked to the cent, rounded half away from zero. A row still open is counted nowhere on this list, and while one is open the statement at the top of the page carries a marker saying so.
This arithmetic again, written out for anything reading this page rather than looking at it: api.json beside this page carries every input, every output, the formula line by line, this worked example, and a list of what the record deliberately leaves out.
The printed face of this record. A signature here says which of the listed tasks were ticked on the turnovers listed, and nothing else: it is not a statement about the state of the property, and it values nothing you flagged.
CleanerDate
F
Words that come up
Listed
A task on the room-by-room list for this property. The page counts them; it does not hold them and does not supply a list.
Ticked
A listed task you did on that turnover. On a row standing for several turnovers it is the total for all of them.
Flagged
A note to the owner that something is broken, missing or needs a restock. A count of notes: no price, no fault found, no judgment about the property.
Minutes on site
From the time in and the time out where both read as a time and the second is after the first; from the minutes figure you typed where they do not. A row with both takes the times.
Turns covered
How many turnovers one row stands for. The tasks listed and the minutes allowed are multiplied by it before the row is scored, which is what lets a whole month sit in one row.
Open
A row with nothing to give its minutes. It prints no figures and the month counts it nowhere, so a month with an open row is a month not finished, and not a month short.
Against allowed
Minutes on site set beside the allowance for the turnovers in that row, printed with its sign. A turnover that finished inside its allowance carries a minus, and the minus is printed, never dropped.
Amount due
On the per-turn basis, the finished turnovers at your rate. On the per-hour basis, the minutes on site turned into hours at your rate, which is a timesheet total: it moves with the clock, and not with the count of turnovers.
The figures print with it, and so does the signature line. Nothing is sent anywhere and nothing is saved except whether the walkthrough is on.
The record this page cannot keep for you
This page holds one property for one month and forgets it when you close the tab. What it cannot tell you in March is which of your properties always runs over its allowance, or which one keeps flagging the restock you forget, because that answer is a season of your own turnovers and a single page holds none of them.
The kit is two files, for one price, yours to keep:
One workbook - five sheets in one file, with the formulas left in. Properties: one row per property, with its task count, the minutes a turnover there is allowed, the rate and its basis, and the restock par for consumables. Turnovers: one line per turnover, or one line for a whole month where a month's total is all you kept, scored against that property's own standing row exactly as this page scores it, with the standing figures copied onto the line and a Check column that names what a line is still waiting for. Statement: one row a property, each row named by that property's own label, carrying the turnovers counted, the time on site beside the time allowed, the tasks ticked of the tasks the lists carried, the items flagged, and the amount due at the rate that applied. It foots every counted line in the workbook, whatever date the line carries, so a month that has to stand on its own wants a workbook of its own. Check: every figure on the statement but the amount due and the count of flagged lines, worked a second way over this record with both figures printed, and the identities that have to hold. Read me: what the book is, what it is not, the order to use it in, and the line that tells you to keep door, lockbox and alarm codes out of the file. Nothing is a pasted value, so you can follow any figure back to the lines it came from.
One PDF, the rules - how to write a per-property list once, what a flagged item is and what it is not, what a signature on a sheet you print does and does not say, the four calls no formula makes for you, and a plain list of what this record deliberately leaves out.
One payment of $19 in US dollars, no subscription, no account on this site. One workbook and a PDF; files, not software. Nothing on this page needs it, and the page stays free and whole without it.