Description
Sound familiar?
- The till is short and nobody knows which shift it was.
- Loyalty coffees and staff meals make the Z report never match the drawer.
- Cash sits in the safe for days because nobody tracks what's been banked.
What the Cash Up Sheet does
Enter the till (Z report) total, card takings and the cash in the drawer, and it works out whether you're over or short. It adds back anything given away free, tracks cash banked, and gives you a Dashboard and a month-by-month summary for the year.
What’s inside
- How to use – step-by-step instructions and what the colours mean
- Settings – your business name, lists for the drop-downs and a colour theme picker
- Dashboard – till totals, card and cash takings, free items, net over/short, cash banked and cash not yet banked
- Cash Up – one line per till, per shift, per day, with OK or SHORT straight away
- Cash Count – count the drawer note by note and coin by coin
- Free Items – loyalty cards, vouchers, staff meals and comps
- Monthly Summary – every month of the year with a year total
Format
- Your blank spreadsheet (.xlsx, UK edition), ready for your business
- A filled-in DEMO copy, so you can see every tab working before you start
- A full PDF user guide: set-up, every tab explained, a daily routine, the rules that apply and answers to common questions
- Works in Microsoft Excel (Windows and Mac) and Google Sheets
- No macros, nothing to install, no subscription
- Yellow boxes are for you to fill in; pale green boxes work themselves out
How it works
- Buy and download the file straight away.
- Open it in Excel, or upload it to Google Sheets.
- Open the DEMO and the PDF guide to see how it works, then fill in Settings on your blank copy and start typing your own.
Please note
This is a digital product — nothing will be posted. It is a record-keeping template, not legal, tax or food safety advice. For use in your own business only — please don’t resell or share the file.
Questions before you buy? Message me any time — happy to help!
Cash Up Sheet FAQ
Can I use it with more than one till?
Yes. List your tills and shifts in Settings and pick them on each line.
How much can a till be out before it's flagged?
You choose. The default is £2 either way, and you can change it in Settings.
Does it connect to my EPOS?
No. You type in the figures from your Z report, so it works with any till or EPOS.
Do I need Microsoft Excel?
No. It works in Microsoft Excel, or free in Google Sheets.
Is it a subscription?
No. It is a one-off payment and the file is yours to keep. There are no monthly fees.
I'm not good with spreadsheets. Is this for me?
Yes. You type into the yellow boxes and everything else works itself out. There are no formulas to write, and the How to use tab walks you through it.
Can I see it before I buy?
Yes. Look through the screenshots above. Your download includes a filled-in DEMO copy and a full PDF guide as well as the blank spreadsheet, so you can see exactly how it works before adding your own.
Does it work on a Mac, iPad or phone?
Yes on a Mac: use Excel for Mac, or open it free in Google Sheets in your web browser. On an iPad or phone you can open it in the free Excel or Google Sheets app, but a computer is easier for setting it up.
Can I get a refund?
Because it is an instant digital download, I can’t offer a refund once the file has been downloaded. If the file is faulty and I can’t fix it, you were charged twice, or you received the wrong product, I will put it right or refund you. See the Refund Policy. This doesn’t affect your statutory rights.
How do I get my file?
It is an instant digital download. You will get a download link straight after checkout, and by email.
What if I get stuck?
Message me any time and I will help you get set up.
Reviews
There are no reviews yet.