Daily Takings and Cash Reconciliation
Cash up consistently and record the difference every day, which is how a problem gets noticed in a week rather than in an audit.
Restaurants and bars · RB-05
A free printable takeaway order reconciliation sheet — delivery app orders with value, commission, refunds and net due, matched to the platform's statement.
One page. Choose your paper size — both versions are laid out identically, so neither one gets shrunk to fit.
Print it and write on it
Fill it in type and save
The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.
Check that what the delivery platforms paid matches what they took, order by order, so a missing payout or an unexplained refund is caught in the period it happened.
Restaurant, takeaway and pub kitchen owners and managers selling through one or more delivery apps or aggregators.
One page, top to bottom:
Printed under the title: Orders taken through delivery apps, listed from the tablet as they come in, then matched line by line to the platform's own statement: gross, deductions, refunds and what reached the bank. Commission is your own contract rate and is written beside each order, not printed here.
Write-on lines: Venue · Period (from / to) · Platforms in use
Table, 8 rows: Date · Platform · Order ref · Order value · Commission & fees · Refund / adjustment · Net due · On statement · Issue
Table, 3 rows: Platform · Orders (count) · Gross ordered · Deductions · Net expected · Statement paid · Difference · Queried with platform
Signature strip: Reconciled by · Checked by · Date
Because every platform charges a different rate and every venue has its own contract, sometimes with promotions and fees on top. The column is there for the deduction as your contract sets it, so the net can be checked against the statement rather than assumed.
Cash up consistently and record the difference every day, which is how a problem gets noticed in a week rather than in an audit.
Keep one line per sale as it happens, with the payment recorded beside it, so the month adds up from something written on the day.
Cash up a bar with several tills so that a short drawer is found on the night and has a till and a shift attached to it, instead of vanishing into one bag.
Find the reason your records and the bank disagree, instead of assuming one of them is wrong.
Every sheet, binder, game and puzzle on Upkeep Papers is free to download, with no email and no account. Making them is not free: each one takes days of research, design and checking, and the site costs money to run. If something here saved you time, you can buy us a coffee. It is entirely optional: nothing is locked, and nothing changes if you don’t.
Opens PayPal in a new tab. Any amount, and nothing changes if you would rather not.