The Golf Course Scorecard Template I Wish I'd Built Five Years Ago (Plus the Maintenance Sheet That Actually Runs Our Course)

A practical golf course scorecard template for Google Sheets — plus the maintenance tracking system that keeps 18 holes, irrigation logs, and vendor docs from falling apart.

Last Tuesday I was standing in the pro shop at 6:45 AM, a member asking me why hole 7's yardage on our printed scorecard didn't match the tee markers, while my superintendent was texting me photos of a busted irrigation head on 14 and our beverage cart vendor was calling about a missing invoice from March. Three different problems, three different filing systems — a drawer of printed scorecards from a designer who ghosted us two years ago, a text thread full of course photos with no labels, and an email inbox that serves as our accounts payable department. I'd had enough. That was the week I finally rebuilt everything in Google Sheets, starting with our scorecard template and ending with a maintenance tracker that actually keeps this place running.

Why Your Golf Course Scorecard Template Needs to Live in a Spreadsheet

Most courses I know outsource their scorecard design to a print shop or a graphic designer. The result looks great — once. Then you re-rate a hole, move a tee box, add a new set of tees for a junior program, or the local rules committee updates the OB stakes. Now you're paying $300+ to update a PDF you can't edit yourself, and the old version sits in a box behind the register confusing everyone for three months until the new ones arrive.

A Google Sheets scorecard template solves this in a boring, beautiful way. You build one master sheet with all 18 holes (or 9 — I'll cover that too), par, handicap index, yardages per tee, slope, rating, and local rules. When something changes, you change one cell. Print it, PDF it, email it to the Tuesday morning league coordinator who asks for it every single week.

Here's what I put in mine:

  • Hole number (1–18, split into Front 9 and Back 9 sections)
  • Par for each hole
  • Handicap stroke index for each hole
  • Yardage columns for each tee (we have 5: Black, Blue, White, Gold, Red)
  • Course rating and slope per tee set (in a header row above the yardage columns)
  • A local rules section at the bottom — drop zones, OB definitions, pace-of-play policy
  • Out/In/Total subtotals with SUM formulas so I never fat-finger the math again

The trick that makes it print-ready: set your column widths tight, freeze the header row, and use Print Settings → Fit to Page → Fit to Width. I export to PDF and send it straight to our in-house printer. Total cost per update: $0 and about twelve minutes.

Building a 9 Hole Golf Scorecard Template (and Scaling to 18)

If you run a 9-hole course or an executive layout, start simple. One tab, nine rows, done. But even for an 18-hole course, I recommend building the scorecard as two 9-hole blocks side by side rather than one long vertical list. It mirrors what players actually see on a physical card, and it makes printing on a half-sheet of cardstock straightforward.

Here's the layout I landed on after embarrassing amounts of trial and error:

  • Row 1: Course name, date field, player name fields (I leave four columns for a foursome).
  • Row 2: Tee name labels across the top — one row per tee color, merged cells for the header.
  • Rows 3–11: Holes 1–9, with columns for Hole #, each tee's yardage, Par, Handicap, and four player score columns.
  • Row 12: OUT totals — SUM formulas for yardage, par, and each player.
  • Rows 13–21: Holes 10–18, same structure.
  • Row 22: IN totals.
  • Row 23: TOTAL (OUT + IN).
  • Row 24–26: Local rules, signature line, date.

For pub golf scorecards or charity scrambles, I duplicate the tab and strip out the yardage columns entirely. Those events don't need slope ratings — they need big font, drink assignments, and maybe a penalty column. Different audience, same underlying structure.

The Scorecard Is the Easy Part — Maintenance Tracking Is Where It Falls Apart

I'll be honest: the scorecard template took me an afternoon. The maintenance and operations side of our course took me three weeks of rebuilding, and I'm still tuning it. This is where the real pain lives for anyone managing a golf course. You've got mowers with service intervals, irrigation zones with repair histories, chemical application logs that need to meet state environmental reporting requirements, and a grounds crew that communicates via group text and prayers.

Before I switched to a spreadsheet system, our maintenance "database" was a combination of a whiteboard in the maintenance barn, a spiral notebook in my superintendent's truck, and photos in his phone's camera roll labeled things like "IMG_4872.jpg." I once spent forty-five minutes looking for a photo of a drainage issue on hole 3 that we'd reported to our irrigation contractor. It was in a text thread from November. Of the previous year.

Here's the system I built — one workbook, four tabs:

  • Equipment Log: every mower, aerator, utility vehicle, and sprayer. Columns for asset ID, make/model, purchase date, last service date, next service due, hours, and a notes column.
  • Irrigation Zones: zone ID, hole(s) covered, head count, last inspection, repair history, contractor name.
  • Chemical Application Log: date, product, EPA registration number, rate, area treated, applicator name, wind speed, temperature. This one has to be printable for state audits.
  • Vendor & Invoice Tracker: every vendor we use, contact info, what they supply, last invoice date, amount, payment status.

The Equipment Log and Vendor Tracker tabs are where file attachments became non-negotiable. When a mower goes down, I need the last service receipt. When the state inspector shows up, I need the SDS sheets for every chemical we've applied. When our irrigation contractor disputes a bill, I need the signed estimate.

Attaching Photos, Invoices, and SDS Sheets Directly to Your Rows

The single biggest upgrade to our maintenance tracker was getting files INTO the spreadsheet instead of linked from somewhere else. I used to paste Google Drive links into a column, which works right up until someone reorganizes the shared drive and every link breaks. Or until your superintendent takes a photo on his personal phone and never uploads it.

FileFox solved this for us. My super takes a photo of a sprinkler head issue, drags it into the row for that irrigation zone, and it's there — attached to the data, not floating in a text thread. Same with vendor invoices: our bookkeeper drops the PDF into the vendor row and marks it paid. No more "Can you forward me that invoice from the fertilizer company?" emails.

The chemical application log was the real win. We attach the SDS sheet for each product directly to the row where it's logged. When our state environmental inspector visited in April, I pulled up the spreadsheet, showed him every application with the corresponding safety data sheet attached inline, and he was done in twenty minutes. He told me most courses hand him a binder with half the pages missing. I didn't tell him our binder was in worse shape — I just showed him the spreadsheet.

Golf Scorecard Examples: What Good Ones Have in Common

I've collected scorecards from about thirty courses over the past few years — some high-end private clubs, some munis, some par-3 executive tracks. The best golf scorecard examples all share a few traits that are easy to replicate in a spreadsheet:

  • Clean hierarchy: hole numbers are the largest text, par and yardage are secondary, handicap index is smallest.
  • Color coding for tees: not decorative, functional. Players find their tee instantly.
  • Subtotals for both nines AND a running total column — surprisingly few cards include all three.
  • Local rules are ON the card, not on a separate sheet that gets thrown away.
  • A small course layout or hole-by-hole diagram on the back (harder to do in Sheets, but I've seen people embed simplified diagrams as images).

The worst scorecards I've seen cram advertising for the on-course restaurant into spaces where players need to write. Or they use a font so small that anyone over 45 — which is most of our weekday players — can't read it without reading glasses. In your spreadsheet, you control the font size. Use at least 10pt for scores and 8pt for nothing.

The Formulas That Make It All Work

Nothing here requires advanced spreadsheet skills. The scorecard is mostly SUM formulas and conditional formatting. But a few formulas in the maintenance tracker save me real time:

For the equipment service reminder, I use a simple formula that flags anything due within 14 days:

Where F2 is the "Next Service Due" date. I pair this with conditional formatting — red background if the cell says "SERVICE DUE" — so it's impossible to miss when I open the sheet Monday morning.

For the vendor invoice tracker, I use a SUMIFS to see how much we've spent with each vendor this season:

This gives me a quick answer when the GM asks "how much have we spent on fertilizer this year?" without digging through QuickBooks. I'm not replacing our accounting software — I'm giving myself a fast operational view that lives where I already work.

What to Do First (Not Last)

If you're managing a golf course and your files are scattered across text threads, email, a shared drive nobody maintains, and a whiteboard that gets erased every Monday — start with one tab. Not the whole system. Just one.

My recommendation: start with the equipment log. It's the smallest dataset (you probably have 15–30 pieces of major equipment), it has the most obvious pain point (missed service intervals = expensive breakdowns in the middle of aerification week), and it gives you a quick win that proves the system works before you tackle the bigger tabs.

Then build the scorecard template, because your Tuesday league coordinator is going to ask you for an updated card this week anyway. And when you hand it to her as a clean PDF that you updated in twelve minutes instead of waiting six weeks for the print shop, she's going to tell every other league at your course. That's the kind of small operational win that compounds — one less thing on fire, one more system that just works.

Frequently Asked Questions

How do I make a golf course scorecard template in Google Sheets?

Create a sheet with rows for each hole (1–18 or 1–9) and columns for hole number, yardage per tee color, par, and handicap stroke index. Add SUM formulas for Out, In, and Total rows. Include course rating and slope in a header section, and local rules at the bottom. Use Print Settings → Fit to Width to export as a clean PDF.

What should a 9 hole golf scorecard template include?

At minimum: hole numbers 1–9, par for each hole, yardage for each tee set, handicap stroke index, a subtotal row, and player score columns. Include course rating, slope rating, and local rules. The 9-hole format is simpler to print on a half-sheet of cardstock and works well for executive courses and par-3 layouts.

Can I track golf course maintenance in Google Sheets?

Yes, and it works better than most golf-specific software for small to mid-size operations. Build tabs for equipment service logs, irrigation zone tracking, chemical application records, and vendor invoices. Use date-based formulas to flag upcoming service deadlines, and attach photos and documents directly to rows using a tool like FileFox.

How do I track chemical applications on a golf course for state reporting?

Create a dedicated tab with columns for date, product name, EPA registration number, application rate, area treated (in sq ft or acres), applicator name, weather conditions (wind speed, temperature), and re-entry interval. Use dropdown data validation for product and applicator names to keep entries consistent. Attach SDS sheets to each row so they're accessible during inspections.

What's the difference between handicap stroke index and hole difficulty on a scorecard?

Handicap stroke index determines the order in which handicap strokes are allocated — it's set by your course rating authority, not by which hole is hardest in absolute terms. The #1 stroke index hole is the hole where a stroke most helps a higher-handicap player compete at net par. Many DIY scorecards get this wrong by ranking holes purely by difficulty or length.