Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesRetail & E-commerceStore OperationsDaily Cash Register Reconciliation

SpreadsheetStore OperationsFree

Daily Cash Register Reconciliation

Close the till every day: cash, card and voucher takings against the POS, over and short against your tolerance, the bank deposit, a denomination count and variances by cashier.

Shown with sample data

Colour

Daily Cash Register Reconciliation

Close the till every day: cash, card and voucher takings against the POS, over and short against your tolerance, the bank deposit, a denomination count and variances by cashier.

Takings
$18,304
Net variance
-$28.50
Days to investigate
2
Cash to bank
$4,927
Total variance by day
  • Nov 3, 2026-$3.75
  • Nov 4, 2026-$1.50
  • Nov 5, 2026-$10.25
  • Nov 6, 2026-$2
  • Nov 7, 2026-$0.50
  • Nov 8, 2026-$10.50
Net variance by cashier
  • Omar-$1.50
  • Tom-$2
  • Priya-$4.25
  • Hannah-$10.25
  • Zoe-$10.50

How to use it

  1. 1Count the drawer with the Cash count sheet, then copy the total into Cash counted.
  2. 2Type the card and voucher totals from your terminal and the POS figures from the end-of-day report.
  3. 3Check the result: anything outside tolerance should be investigated the same day.
  4. 4Bank the Cash to bank amount and keep the float for tomorrow.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Close the till accurately every day. Record the opening float, the cash, card and voucher totals you count, and what the POS says for each. The sheet works out expected cash, over or short for each payment type, the total variance and the cash to bank, and checks each day against the tolerance on the Settings sheet. A denomination counter adds up the drawer for you, and a cashier summary shows whose shifts have recurring differences.

Who it’s for

  • Shops, cafés and bars with cash takings
  • Multi-person till closing
  • Spotting shrinkage and training needs

What’s included

  • Cash-up sheet: One row per till per day.
  • Cash count sheet: Count the drawer by note and coin.
  • By cashier sheet: Variances by the person who closed the till.
  • Settings sheet: Your variance tolerance.

How to use it

  1. 1Count the drawer with the Cash count sheet, then copy the total into Cash counted.
  2. 2Type the card and voucher totals from your terminal and the POS figures from the end-of-day report.
  3. 3Check the result: anything outside tolerance should be investigated the same day.
  4. 4Bank the Cash to bank amount and keep the float for tomorrow.

Tips

  • Have two people count the drawer when the variance is outside tolerance.
  • A pattern of small shortages on the same shifts matters more than one large error.

Questions

How is expected cash worked out?

Opening float plus the POS cash sales.

What is the tolerance?

The largest total difference you accept without investigating, set on the Settings sheet.

Related searchescash uptill reconciliationcash drawerend of daycash countover short

Details

Format
Spreadsheet
Category
Store Operations
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetStore OperationsFree

Daily Cash Register Reconciliation

Close the till every day: cash, card and voucher takings against the POS, over and short against your tolerance, the bank deposit, a denomination count and variances by cashier.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Store Operations
Sheets
4
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More store operations templates

View all
Retail Sales Tracker2 sheets

Net sales

$20,210

Avg transaction

$48

Conversion

24%

Net sales by day
SpreadsheetStore Operations

Retail Sales Tracker

Daily sales by channel with transactions, average basket and target progress.

10 min setupPreview
Retail Store KPI Scorecard2 sheets

Sales

$308,840

Conversion rate

14%

Average transaction value

$33

Sales by store
$148k
$130k
$31k
Riverside MallHigh StreetStation Kiosk
SpreadsheetStore Operations

Retail Store KPI Scorecard

Weekly footfall, transactions, units and sales by store, turned into conversion, basket value and units per sale.

10 min setupPreview
Store Staff Rota2 sheets

Total hours

150

Labour cost

$2,622

Labour % of sales

18%

ABCD
1StaffRoleContracted hrsMon
2HannahManager408
3OmarSupervisor320
4PriyaSales associate246
5TomSales associate160
Rota
SpreadsheetStore Operations

Store Staff Rota

Next week's hours by person and day, with contract and overtime checks, staff on and labour cost each day, minimum cover alerts and labour as a share of forecast sales.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ