Download it
Excel .xlsx, no email and no sign-up. Every derived cell is a real formula rather than a number somebody typed.
- Three shift blocks a day; one you do not run stays blank
- Collections by type, with drawer payouts added back and the float taken out
- Difference computed per shift and for the day
The format is argued for in staff roles and shift roster.
A roster is about attribution, not coverage
Any two people can cover a day. What a shift structure decides is whether a difference found at the end of it belongs to somebody.
A shortfall found at handover belongs to a named person who is still on the premises and can account for it. The same figure found at month-end belongs to nobody, and the conversation it produces is about trust rather than about a number. That is the entire argument for closing out per shift, and it is why this sheet names the operators at the top of each block rather than at the bottom of the day.
The two adjustments everyone forgets
They are rows on this sheet rather than advice, because a handover that omits them shows every shift as short by exactly the amount that legitimately left the drawer.
Money paid out of the drawer — a delivery driver, a repair, a float for the next shift — has to be added back before the drawer is compared with what it should hold. The opening float has to be taken out, because it was never today's revenue.
Together they account for most of the differences that get investigated and turn out to be nothing, and an outlet that adjusts for them is left with a difference that is worth asking about.
Three blocks, and a blank one is fine
The sheet carries three shifts because that is the common case. An outlet running two simply leaves the third blank rather than needing the layout changed, and one running four copies a block. The reconciliation at the foot of each is computed either way.