Daily Cash (Galla) Closing Sheet
A one-page galla closing sheet: opening cash, cash sales and other cash in, less expenses, supplier payments, refunds and withdrawals, gives the cash that should be in the drawer. Count the notes, and the sheet shows whether the galla is over or short. A month log tracks the pattern.
- Published
- Reading time
- 2 min read
Daily cash (galla) closing sheet (Excel): expected cash, note count and over or short, with a month log
Excel (XLSX) · 10 KB · free, no sign-up
What is in the file
- Closing: the day's cash in (opening float, cash sales, udhaar recovered in cash, other) and cash out (expenses, supplier payments, refunds, owner withdrawal, cash sent to the bank), giving the expected cash. Below it, a note count for 5000, 1000, 500, 100, 50, 20 and 10 rupee notes and coins gives the counted cash, and the sheet shows the over or short amount. Card, JazzCash, Easypaisa, bank and udhaar sales are noted separately, as they are not in the drawer.
- Month log: one line a day with expected, counted and the difference, a monthly total, and shortages in red.
Direct link to the file: nafaa-daily-cash-closing-sheet.xlsx. Free to use, copy and share.
How to use it
Step 1: Start with the float
Write the cash left in the drawer the night before as opening cash.
Step 2: Enter cash in and cash out
Take cash sales from the day report and note every payment made from the galla.
Step 3: Count the notes
Write how many of each note you have; the counted total and the difference fill in.
Step 4: Log the day
Copy expected, counted and the difference into the Month log and write the reason for any gap.
Why the daily close matters
A small shortage every day adds up to a large sum by the end of the month, and it is only traceable while the day is fresh. Our guide to a daily cash closing routine explains how to run it in ten minutes. Nafaa closes each counter shift with the expected cash already worked out from the bills, takes the note count, and asks for a reason when the galla is short or over; see the POS.
Frequently asked questions
What is the opening float?
The opening float is the cash kept in the drawer at the start of the day so the cashier can give change, usually small notes and coins. It is not part of the day's sales. Write it as opening cash, and decide each night how much to leave for tomorrow; the rest goes to the safe or the bank.
What should I do when the galla is short?
First recount, then check the obvious causes: an expense paid from the drawer but not written, change given wrongly, a refund, a card or wallet payment entered as cash, or a bill not made. Write the reason in the log. Repeated shortages on the same counter or shift need a closer look at who handled the cash.
