Cash closeout / Calculator worksheet

Cash Box Reconciliation Tool

Count starting cash, ending bills and coins, digital payments, expected sales, and over/short notes for the closeout packet.

Calculates totals Print, CSV, backup JSON Saves in your browser No account

Free worksheet — no account needed

A count sheet that does its own math

This BoosterTally worksheet autosaves in your browser. When you're done, print the closeout packet, export a CSV, or download a backup file. Initials or role labels are fine where full names aren't needed.

Not saved yet

Step 1

Event and deposit handoff

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

Treasurer handoff 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

Event closeout

Date not set

Deposit handoff$0.00
Cash box summary by till
TillEnding countActual cashDeposit cashOver/short
Till 1$0.00$0.00$0.00Expected cash not entered

Till 1 count lines

No denomination counts entered for this till.

Prepared by__________
Treasurer/receiver__________
Bag or envelope__________
Review notes
  • Till 1: add two counter initials or roles before handing this to the treasurer.
Review before handoff
  • Till 1: add two counter initials or roles before handing this to the treasurer.

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.
  • $2.00 cash overage to explain in the notes.
  • $1,087.00 cash-plus-check deposit handoff 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.

Sources and local checks

Where to check the rules behind this worksheet

These references help set the worksheet's boundaries. Your current school, district, PTO/PTA, booster, treasurer, bank, and local procedures still come first.

FAQ

Questions that come up

Does the Cash Box Reconciliation Tool calculate totals?

Yes. Enter your cash counts and payment totals, 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

Sheets that belong in the same event packet