SEASON OVERVIEW
Start here when someone wants the club story in one page: what has happened, what matters now, and where to click next for proof. Use the cards and jump links below as the shortest path into the right detail tab.
Total Square Money In
All Square money collected this season
Square Match-Subs Collected
Ahead / Behind Collection Plan
Current Cash Position
What Changed This Week
This is the quickest club-level read for someone opening the dashboard cold. It explains the latest week, the latest cash move, and where to click next for proof.
Revenue Split (Square)
Useful for context, but secondary to the club story above. It shows how recorded Square revenue is split across subs, annuals, and fines.
Scope: budget performance is based on Square weekly match-subs only (objective and traceable).
Committee Read: these are the three club-facing signals worth sharing out. Use them as the quick narrative for captains, the chairman, fixtures, and anyone who needs the short version before drilling into proof.
Positive Signals
Watch Items
Action Now
WEEKLY TREND
Square weekly match-subs only · money in vs plan · to date
This tab shows the collection pace rather than the full bank story. Use it when the committee wants to see whether collections are keeping pace with the plan and which weeks explain the gap.
Includes Square weekly subs
Excludes bank & cash receipts
Proof: week-by-week detail below
Season Avg / Week
Total Budget Shortfall
vs cumulative Square-only budget to date (bank excluded)
Best Single Week
Weeks At/Above Budget
out of 24 weeks played
Weekly Money In vs Weekly Plan
Bars show actual Square match-subs by week against the budget line. Use this to identify the exact weeks that created or recovered the season gap.
Hover a week to see the exact collections, budget, and variance behind the bar.
Weekly Income by Team (Stacked)
This explains how the weekly total is built team by team, so captains can see which side is driving the movement in a given week.
Money Collected vs Plan to Date
This is the season pacing chart. The green path shows what has actually been collected, while the percentage line shows how much of the cumulative budget has been achieved so far.
Week-by-Week Detail
| Week | 1st XI | 2nd XI | 3rd XI | Vets | Total | Budget | Variance |
|---|
TEAM OVERVIEW
Square weekly match-subs by team · budgets only when Game Played? = Yes
This is the drill-through tab for captains and committee leads. Start with team totals, then drop into the player payment table to see exactly who paid, how much, and what each payment related to.
Use team cards as shortcuts
Week and team filters stay in sync with the page URL
1st XI — Season (Actual)
2nd XI — Season (Actual)
3rd XI — Season (Actual)
VETS — Season (Actual)
Actual vs Budget to Date (Square Weekly Subs Only)
Player Payment Detail
Select a week to inspect who paid into a team total. Amounts are the raw Square player payment lines for the selected week, so this table is the quickest proof behind a team headline number.
| Date | Player | Team | Amount | Payment Type | Description |
|---|
CASH POSITION
Bank cash movement, outgoing costs, and operating trend
This tab is the bank-backed proof behind the club cash story. Use it to explain whether the balance is rising or falling, which weeks drove the swings, and whether the notes on large weeks are complete enough for committee use.
Bank-backed only
Excludes gross Square totals
Proof: weekly movement detail below
Opening Balance
Season start input
Current Closing Balance
Latest rolled-forward position
Month-to-Date Net
Current month cash movement
Season-to-Date Net
Receipts less outgoings
Closing Cash Balance by Month
Use this as the runway line. If the balance is flattening or dropping, move down to the weekly detail table to see which weeks explain it.
Monthly Net Movement
Positive months add to the runway and negative months consume it. This is the quickest month-to-month read before dropping into individual weeks.
Weekly Net Movement by Week
This is the sharpest explanation of the cash swings. Combine it with the notes table underneath to understand whether a drop was routine, one-off, or still unexplained.
Hover a week to see receipts in, outgoings, net movement, and the saved note for that week.
Outgoing Cost Mix
| Category | Total | Share |
|---|
Weekly Cash Movement Detail
| Week | Receipts In | Outgoings | Net | Review | Notes | Closing Balance |
|---|
FINAL PUSH
Run-in target model for remaining fixtures and runway protection
This is the end-of-season collection model. It answers a narrow question: how much Square subs do we need per team-game from here to cover the remaining scheduled cost base and keep the runway healthy.
Uses current cash + remaining fixtures
Excludes fines inflow
Proof: team targets and fixture list below
Current Cash
Live bank-backed starting point
Remaining Costs
Subs Needed per Team Game
Forecast Closing @ Current Rate
Remaining Cost Build
Current vs Required Subs per Team-Game
Team Targets
| Team | Games Left | Home | Current Avg | Target / Game | Target Total | Gap / Game |
|---|
Remaining Fixtures
| Team | Date | Venue | Opponent | In Model |
|---|
FINANCIAL CONTROLS
Consolidated controls for operator review
This remains the operator-style tab. Use it when the headline dashboard raises a question and you need the exception list, tie-out proof, or the control rows still holding back a clean read.
Open Reco Variances
Square-to-bank batch rows
Reco Variance (£ abs)
Must trend to £0
Audit Failures
Membership tie-outs/checks
Bank Review Queue
Target: £0
Open Issues
| Check | Source | Current State | Required Action |
|---|
Passed Controls
| Check | Source | Current State | Interpretation |
|---|
Open Reconciliation Detail
| Row | Payout Date | Square Net | Bank Sum | Variance |
|---|
Failed Audit / Weekly Checks
| Source | Reference | Issue | Status |
|---|
PLAYER MEMBERSHIP
This tab is the player-level proof behind the membership status headline. Use the filters to isolate chase lists or clean cohorts, then bring the table back into captains’ or committee follow-up.
Search updates the live result count
Status pills narrow the table instantly
Players Who Have Paid Annual
Players Needing Annual Follow-Up
Low-Impact Follow-Up
Total Players
Tracked via Square this season
Player Follow-Up Split
Priority Annual Follow-Up List
| Player | Team | Member Rate Used (Pre-Annual) | Total Paid | Sq Txns |
|---|
All Players — Payment Status & Follow-Up
This table is the proof behind the membership compliance headline numbers.
| # | Player | Team | Annual Paid | Member Rate Pre-Annual | Total Paid | Sq Txns | Status |
|---|