Free Scratch-off inventory spreadsheet
Count your books, calculate expected sales, and reconcile a daily close. Download both editable CSV worksheets for Excel or Google Sheets. No account is required.
Enter your own numbers in the free calculator before creating an account. One reviewed close is free, with no card required. Continued daily tracking is Starter at $19/month.
Each file includes one example row with formulas. Replace its inputs, then copy the row down for another book or day. Format money columns to two decimals and keep book numbers as text.
Prepare one real close
- Gather your source reports. Use the terminal report, POS lottery totals, payouts and cancellations, and ticket counts for the same business date.
- Reconcile cash and ticket counts. Replace the worksheet example or enter your totals in the calculator. Investigate each cash or inventory difference separately.
- Save and review. Keep your calculator totals through account creation, add POS and commission figures in Daily Close, and document differences before saving a reviewed close.
Need help getting started? Ask for help with your first close. Describe where you are stuck.
1. Count tickets remaining for each book
Use one row per book and close period. Counts are tickets remaining, not the printed ticket number. Enter activations and returns as ticket quantities, not numbers of books.
| Date | Game Name | Book Number | Face Value | Starting Count | Activated Tickets | Returned Tickets | Ending Count | Tickets Sold | Expected Scratch Sales | Notes |
|---|---|---|---|---|---|---|---|---|---|---|
| 2026-09-11 | Example Game | BK-1042 | $5 | 300 | 0 | 0 | 256 | 44 | $220 | Illustrative data |
Tickets sold = starting count + activated tickets − returned tickets − ending count.
In this example: 300 + 0 − 0 − 256 = 44 tickets sold. At $5 each, expected scratch sales are $220.
The CSV puts these formulas in I2 and J2. Negative ticket sales indicate counts or book movement that need review.
2. Reconcile the cash for the same period
Add the expected scratch sales from all books to terminal gross sales. Subtract payouts and cancellations once. Compare the result with lottery cash collected, excluding the opening float and unrelated store sales.
- Terminal gross sales
- $500
- Scratch gross sales
- $220
- Payouts / cancellations
- $100 / $0
- Expected lottery cash
- $620
- Counted lottery cash
- $618
- Cash over / short
- −$2
Use gross sales in this worksheet. If your source already deducts cancellations, do not subtract them again. Record a reason for the $2 shortage before calling the close complete.
3. Save and review your first close
- Enter your own totals in the reconciliation calculator, then keep those totals through account creation into Daily Close.
- Enter the same date, terminal sales, scratch sales, payouts, cancellations, and POS terminal sales from your source reports.
- Enter your provider's commission rate and actual commission. The example rate of 6% produces $43.20 on $720 gross sales; it is not a rate recommendation.
- Save a draft, check the exceptions and your cash worksheet, then mark the close reviewed when you have resolved or documented differences.
One reviewed close is free, with no card required. Continued daily tracking is Starter at $19/month. These CSVs are manual worksheets, not LottoTally import files.
Prefer an on-page tool? Use the lottery reconciliation calculator. Compare inventory workflows in the LottoTally vs LottoVault guide.