Shop · Small Business

Daily Till Cash-Up: photo 1 of 5 from its Etsy listing
Small Business

Daily Till Cash-Up

Till Cash Up Sheet, Daily Cash Up Spreadsheet UK, Till Float and Takings Tracker, Over Short Log, Cafe Shop Bar, Excel & Google Sheets

£10 Buy on Etsy

Instant download: Etsy takes the payment and sends you the files straight away.

Cash up the till every night without a calculator. Type how many of each note and coin is in the drawer and it gives you the cash takings and exactly what to leave in for tomorrow's float. Then log the day: the till's end-of-day readings, the cash you counted and the card machine total. It works out the cash and card over or short and flags the day Short, Over or OK against the allowance you set.

Start Here shows the month at a glance: takings, the card and cash split, over/short, big shorts, your average day, best day, paid outs and the cash waiting to be banked. Monthly and By Weekday show 12 months of takings and which days are quiet.

Daily Till Cash-Up: photo 2 of 5Daily Till Cash-Up: photo 3 of 5Daily Till Cash-Up: photo 4 of 5Daily Till Cash-Up: photo 5 of 5

What's inside (6 tabs)

  • Start Here: Your settings, eight live totals, this month and the last seven cash-ups
  • Cash Count: Count the notes and coins: cash takings and tomorrow's float
  • Daily Log: One row a day: till readings, cash counted, card machine, over/short and a flag
  • Monthly: 12 months of takings, cash, card, paid outs, banking and over/short, with a chart
  • By Weekday: Average takings Monday to Sunday, for a month or the whole 12 months
  • Guide: How to use it, in plain English

What it does

  • Tomorrow's float made up from what's in the drawer, or how much change you're short
  • Daily Log: till readings v cash counted and card machine, with cash and card over/short worked out
  • Short / Over / OK against your own allowance, and a count of days short by more than your 'big short' level
  • Spots a card payment rung through as cash (cash short, card over by the same amount)
  • Paid outs (milk, the window cleaner) still count as takings; cash banked and cash waiting to be banked
  • 12 months of takings, cash, card, paid outs, banking and over/short, with a chart and the best day each month
  • Average takings for each day of the week, for a month or the whole 12 months; 500 days of rows

What you get

  • till_cash_up.xlsx with example data, so you can see how it works
  • till_cash_up_blank.xlsx: the same file, empty and ready for your own
  • A step-by-step PDF setup guide
  • A PDF with a one-click link to make your own Google Sheets copy

What you need

  • Microsoft Excel 2010 or newer (including Microsoft 365), on Mac or PC
  • OR a free Google account to use it in Google Sheets (the guide shows you how)
  • Best on a computer or tablet. Not made for Apple Numbers

Please note

  • This is a digital download. No physical item will be sent
  • For one till. It doesn't connect to your till or card machine: you type the readings. The example café, staff and figures are made up
  • For your own business use. Please don't resell or share the file

How it's made

Designed by me, built with the help of AI tools, then checked formula by formula in two different spreadsheet programs.

Daily Till Cash-Up £10
Buy on Etsy