The free workbook separates fines, payments received and actual cash. It includes four sheets, 500 prepared ledger rows and totals for up to 50 named players, without macros or an account.
A team fines spreadsheet should answer three different questions: what has been charged, what has actually been paid, and how much money the team currently holds. Treating those as one number is an easy way to spend money that has not arrived. This workbook separates the records and includes small worked examples so you can check the arithmetic before adding your squad.
Download the free workbook
Download the ClubFines team fines spreadsheet (.xlsx)
There are no macros and no ClubFines account is required. Save a working copy with your team’s name and season in the filename. The supplied names, dates and amounts are examples. Replace them before using the workbook for real records. Keep an untouched copy of the original download so that you can compare formulas if a cell is accidentally overwritten later.
This is a standalone website resource. It does not imply that ClubFines supports importing Excel workbooks. You can use the sheet independently and decide later whether an app would suit your administrators. Pick one currency for the entire workbook: it does not convert currencies. A five-pound entry and a five-euro entry must not be added as though they represent the same amount of money.
Understand the four sheets
| Sheet | Purpose | What you enter |
|---|---|---|
| Read me | Setup, limits and example checks | No regular transactions |
| Fines | Individual fines and remaining balances | Date, player, reason, fine, paid and note |
| Players | Totals for each listed player | Up to 50 consistent player names |
| Cashbook | Money actually received and spent | Date, description, money in and money out |
Fines and Cashbook each contain 500 prepared transaction rows. The player summary contains space for 50 names. Extend formulas, filter ranges and summary ranges before exceeding those limits. They are deliberately stated rather than hidden: a sheet that silently excludes the newest transactions can look tidy while giving the treasurer the wrong balance. Check the limits again before copying data from a much larger season file.
Enter a fine and a partial payment
Use one row for each fine. Enter a recognisable player name, the date and a short reason. Fine holds the full amount of that entry. Paid holds the total received against that specific fine so far. Outstanding calculates the difference, with a minimum of zero. Leave the prepared formula in place instead of typing a balance over it. The same rule applies to the formulas in Players and Cashbook.
Suppose Alex has a £5 fine and has paid nothing. Outstanding is £5. Alex then sends £2: enter 2 in Paid, leaving £3 outstanding. When another £3 arrives, update Paid to 5, not 3. That column is a cumulative total for the entry, rather than a history of individual transfers. Use the note column if you need to preserve the dates or references of several payments.
The workbook does not automatically carry over an overpayment as credit. If Paid is 7 against a £5 fine, Outstanding is zero, but the extra £2 still needs checking. Agree whether it should be returned or allocated elsewhere. Preventing negative outstanding amounts is a presentation rule, not a substitute for reviewing a transaction. This is particularly important when one transfer covers several different fines.
Keep player names consistent
On Players, enter names exactly as they appear on Fines. The summary matches the name: “Alex M” and “Alexander Miller” will be treated as different entries. Give two teammates with the same name a consistent distinguishing label. If you change a player’s spelling later, update their existing fine records as well as the summary. Avoid casual nicknames that a replacement treasurer would not recognise.
The totals use conditional sums. Microsoft’s SUMIF documentation explains how the function adds values associated with a matching criterion. Here that criterion is the player’s name. The workbook already contains the formulas, so routine use does not require writing them. Understanding the matching principle still helps you diagnose a total that unexpectedly appears as zero.
Separate cash from outstanding fines
Cashbook records real money movements. Enter an existing opening balance as the first Money in entry and label it clearly. Add fines when their payments have actually arrived. Record a team meal or equipment purchase in Money out. Balance adds all previous money in and subtracts all previous money out. A fine that remains unpaid does not belong in the income column.
Payments are not automatically copied from Fines into Cashbook. The separate ledger lets you record combined transfers and other kinds of team income explicitly. During the weekly check, confirm that fines marked as paid are also reflected in the cashbook. Record each cash movement only once. This distinction helps you compare records with actual cash or the team’s chosen payment account instead of comparing two incomplete lists.
Check the supplied example
The example contains two fines for Alex, worth 5 and 3, with 1 paid against the second. Sam has a fine of 10, paid in full. Total fines are therefore 18, total paid is 11 and total outstanding is 7. Alex owes 7; Sam owes zero. These are useful figures to check immediately after opening the file, before you replace the demonstration data.
The cashbook begins with 100, receives those 11 in fine payments and records 20 spent on a team evening. The balance is 91. It is not 98: the additional 7 is still outstanding and cannot yet be spent. Once you have checked the example, clear or replace the example input cells. Keep the formula columns intact so they continue to calculate your own records.
Build a routine people can maintain
Choose one authoritative working copy, one owner and one deputy. Once a week, review new fines, match received payments and compare the cashbook with actual funds. Restrict editing to the people doing those jobs. A workbook containing player names and outstanding amounts should not be shared through an unrestricted public link. Send each person the information they need instead of circulating unnecessary personal details.
Save a dated backup before major changes. At the end of the season, complete the reconciliation and start the next period from a fresh copy. Our end-of-season handover checklist explains the sequence. If several administrators need regular shared access, use the app, Excel and WhatsApp comparison to decide whether to change tools. A modest system maintained consistently is more useful than an elaborate workbook nobody updates.
From a download to shared admin
The team fund app helps you record team fines and outstanding amounts. Start with the football fines PDF to agree rules, or make your own list in the fines list generator.
