Cash closeout worksheet

Cash Box Count and Closeout

Count each till, compare actual cash with expected sales, and print the deposit amount with two signature lines.

Works from your entries Print, CSV, backup file Saves in your browser No account

Free worksheet, no account needed

One signed record for every till

Enter the starting bank and ending denomination count for each till. Print the over/short, deposit amount, and signature lines for both counters.

Not saved yet

Step 1

Event and deposit details

Step 2

Cash boxes and tills

Till 1
Count all cash before separating the retained bank.

Ending bills and loose coin

Rolled coin and partial rolls

Step 3

Checks, card/POS, and online report totals

Closeout results

Cash count and deposit totals

How this is calculated
Expected cash not entered
Actual cash sales$0.00
Cash over/shortNot comparedEnter expected cash to compare.
Cash to deposit$0.00
Cash + checks deposit$0.00
Card/POS net$0.00Gross less entered fees/refunds.
Net receipts after fees$0.00
Check before the treasurer signs
  • Till 1 needs initials or role labels for both counters.

Example packet

Friday concession closeout example

Two concession tills close after a home game. The main window has one cash drop, the ticket table keeps its starting bank, and the chair enters card/POS totals from the report.

  • $967.00 actual cash sales.
  • Expected and counted cash match across both tills.
  • $1,087.00 cash-plus-check deposit total.

Assumptions

What the numbers assume

  • Count all bills, loose coin, rolled coin, and partial rolls before separating the retained bank.
  • Use expected cash from tickets, item counts, or a POS/report only when your group has a source you trust.
  • Checks and card/online payments are tracked beside cash, but they are not counted as cash over/short.
  • Use initials or role labels for counters if your group does not need full names on a shared packet.
  • Follow your school, PTO/PTA, booster, district, bank, and local procedures for deposits and records.

Formula notes

How the totals are calculated

Check local rules

Sources for this worksheet

Use your group's current forms and procedures for deposits, approvals, and recordkeeping.

FAQ

Questions that come up

What does the cash box closeout calculate?

It calculates actual cash sales, cash over/short, cash and check deposits, and net receipts after card and online fees. You can then print the closeout packet or export CSV and backup files. Follow your local treasurer and bank procedures.

Can this replace our treasurer forms or bank process?

No. Use it as a count sheet and handoff packet. Your school, PTO/PTA, booster, district, bank, and local procedures are still the source of truth.

What should I avoid entering?

Do not enter bank account numbers, tax IDs, student private information, donor private contact details, or official login credentials. Initials or role labels are usually enough for count-team fields.

Related workflow

Other sheets for this event