← All prebuilt solutions
Industry

Retail Daily Takings & Till Cash-up

Daily takings, card and cash, till variances, banking and VAT for a shop – with a printable end-of-day cash-up sheet

£20

Secure checkout. Your file is ready in your client portal as soon as payment clears.

Retail Daily Takings & Till Cash-up

Overview

A simple daily routine for any shop, café counter or market stall with a till. Each evening print the Z-reading, count the till using the Cash-up sheet and enter one line on Daily Takings. Differences are flagged straight away – while you can still remember what happened.

Price
£20
Who it’s for
Industry
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Daily Takings

Takings by day, payment type and till, with variances. What you do: one line per day.

Daily Takings
Cash-up

Step 2

Cash-up

A printable end-of-day cash-up sheet. What you do: count and enter.

Step 3

Settings

Tills, float and VAT rate. What you do: set up once.

Settings

Step 4

Who it is for

Made for people like you

  • Example – text
  • Shops and retail businesses – Reconcile tills every day and spot variances.
  • Cafés and takeaways – Keep cash and card takings straight.
  • Bookkeepers – Clean daily takings records for the books.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – Shop name, the month, your float, the variance you accept and your VAT details. Save a fresh copy for each month.
  2. At close – Print the Z-reading and the card terminal total. Count the till on the Cash-up sheet.
  3. Daily Takings – Enter total sales, card, other payments, refunds, paid-outs, the cash counted and any banking.
  4. Dashboard – Sales, average sale, till differences and cash still to bank.

Key features

  • One line a day from the till Z-reading: card, cash, other payments, refunds and paid-outs – with the cash you should have and any over or short highlighted.
  • Tracks what has been banked and what is still in the safe, the number of customers and average sale, and the VAT in your takings.
  • Includes a printable end-of-day cash-up sheet that counts the notes and coins, takes off the float and checks the result against the day's expected cash.

What’s included

  • Dashboard – The month at a glance
  • Settings – Shop, month, float and VAT
  • Daily Takings – One line a day
  • Cash-up – End-of-day till count
  • Guide – How to use this workbook

How buying works

Your file is only released to your client portal once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your file is ready in your client portal as soon as payment clears, and we email you your invoice with a link to the portal.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions