A private club budget is not a hotel budget with members bolted on. Much of the club's revenue arrives as dues before a single meal is served, the golf course is a cost center with no revenue line of its own, and the board wants to know one thing above all: does the operating budget balance at the proposed dues rate? A good private club budget template in Excel is built around that question.
This guide walks through the structure, the formulas and a fully worked example using fictional sample data, so you can build your own or check the one you have.
The structure of a club operating budget
A departmental layout modeled on the Uniform System of Financial Reporting for Clubs (USFRC) groups the budget into four blocks:
- Membership dues, budgeted by member class: annual dues = members in class × monthly dues × 12.
- Operated departments with their own revenue, such as food and beverage, golf operations, racquets or the pro shop. Each one carries revenue, cost of sales, payroll and other expenses, and ends in a departmental net = revenue − cost of sales − payroll − other expenses.
- Cost centers with no revenue, mainly golf course maintenance. These are pure expense lines.
- Undistributed operating expenses and fixed charges: administration, clubhouse operations, energy, property taxes and insurance.
The operating result is then:
operating result = dues + Σ departmental net − cost centers − undistributed − fixed charges
Capital dues, capital assessments and the capital portion of initiation fees stay out of operating revenue. Mixing them in is the quickest way to show a balanced operating budget that isn't.
Build it in this order
1. Member counts by class
Start with the membership roster: members in each class at the start of the year, expected resignations and new members, and the monthly dues per class. Average members for the year is better than year-end members if the roster moves.
2. Operated departments
Budget F&B from covers and average check where you can, then cost of sales as a percentage of revenue from your own history, and payroll from a staffing plan rather than a flat percentage. If the club has food and beverage minimums, budget the minimum shortfall as its own revenue line so you can see how much of F&B revenue is real spending.
3. Cost centers and undistributed expenses
Golf course maintenance, administration and clubhouse operations are mostly fixed and staffing-driven. Budget them line by line from last year's actuals plus known changes, not from last year plus a percentage.
4. Spread by month
Spread each annual amount across the months with a seasonality profile. A northern golf club and a city club need different profiles, and the monthly view is what the finance committee will compare against actuals all year.
5. Solve for dues
If the operating result comes out negative, the board has three levers: raise dues, cut expenses or accept a deficit funded from reserves. The budget template should make the dues lever visible, which is why dues sit at the top.
Worked example: Sample Oaks Country Club (fictional)
All figures below are fictional sample data for an imaginary club. They are there to illustrate the math.
Step 1, dues by class.
| Class | Members | Monthly dues | Annual dues |
|---|---|---|---|
| Full Golf | 300 | $650 | $2,340,000 |
| Social | 200 | $250 | $600,000 |
| Junior | 60 | $325 | $234,000 |
| Total dues | $3,174,000 |
Full Golf: 300 × $650 × 12 = $2,340,000. Social: 200 × $250 × 12 = $600,000. Junior: 60 × $325 × 12 = $234,000.
Step 2, departments and the operating result. Food and beverage revenue of $1,800,000, less cost of sales $630,000, payroll $846,000 and other expenses $180,000, leaves an F&B departmental net of $144,000. Golf operations brings in $420,000 against $310,000 of expense, a net of $110,000.
| Sample Oaks Country Club (fictional) | Budget |
|---|---|
| Membership dues | $3,174,000 |
| F&B departmental net | $144,000 |
| Golf operations departmental net | $110,000 |
| Golf course maintenance | -$1,450,000 |
| Undistributed operating expenses | -$1,520,000 |
| Fixed charges | -$210,000 |
| Operating result | $248,000 |
$3,174,000 + $144,000 + $110,000 − $1,450,000 − $1,520,000 − $210,000 = $248,000. The budget balances at current dues, with a surplus. If the board adds $300,000 of new clubhouse staffing, the result turns to -$52,000, and the next question becomes how much dues would need to move. That question is covered in the club dues increase calculator guide.
Common mistakes
- Counting capital dues or the capital share of initiation fees as operating revenue.
- Budgeting dues on year-end members when the roster is growing or shrinking during the year.
- Treating F&B minimum shortfall as food revenue, which hides how much members actually spend.
- Hard-typed totals that stop adding up after someone inserts a row. Every subtotal should be a formula, with a check cell that proves it ties.