The season is long, the memory is short, and the pen always wins
Eighteen regular-season weeks. Then the wild card, divisional, conference championship, and Super Bowl rounds. Add it all up and a single NFL season presents you with somewhere around 285 fixtures you can bet, and roughly two-thirds of those fall on the same crowded Sunday slates where the brain has no chance of remembering which line you backed at which price three weeks ago.
I learned the hard way. My third NFL season as a serious bettor, I tried to track everything in my head, with the occasional WhatsApp note to myself. By week five I had lost the thread entirely — I could remember roughly how I had done, but not which bets had won, which had pushed, or where my edge had actually come from. I went into week six convinced I was up a couple of hundred pounds. The bank statement said otherwise. That was the season I started building proper sheets.
The structure that finally worked is not complicated. One row per bet, eleven columns, two formats — a printed paper sheet for the bets-in-progress mid-week, and a spreadsheet for the closing-line value and the season roll-up. The paper sheet exists because betting decisions are made in the moment and a printed page in front of you is faster to mark up than any app. The spreadsheet exists because end-of-season analysis needs maths, and maths needs a calculator.
This guide walks through the construction of that template. Header design first, then the three odds-format columns, then the stake and result columns, then the closing line value column that I treat as more important than any of the others. The aim is that by the end of the page, you can build the template once and use it for the rest of the season without redesigning it every Sunday. Not which sheet to download — building your own teaches you what each column does. Not how to read an existing sheet — that is a different skill that lives elsewhere. Just the construction.
What actually has to live on the page
The first time you sit down to design a weekly sheet, the temptation is to add every column you can think of. Resist that urge. A sheet with thirty columns is a sheet you will not fill in. The minimum viable template has eleven columns, and adding more usually subtracts utility rather than adds it.
Here is the eleven-column list. Fixture name, kickoff time in UK time, market type, line, odds in three formats, stake, result of the game, return amount, profit or loss, and closing line value. Each one earns its place by answering a question the others cannot.
Fixture is the row anchor. Without it nothing else makes sense, and it should be written in a consistent format every week — favourite-at-underdog or home-vs-away, but pick one and stick with it. Kickoff in UK time is what tells you when to be at the screen and prevents the worst beginner mistake of betting a game that has already started. Market type — spread, total, moneyline, prop — categorises the bet so the end-of-season roll-up can split your performance by market. Line is the specific number you took, including the sign for spreads.
The three odds columns are where the work gets done. American format because that is what most published sheets use. Decimal because the maths is cleanest. Fractional because that is what you actually saw on the slip when you placed the bet. Having all three on the same row means you can sanity-check the price you took, and you can compute payout from either decimal or fractional without scrambling for a converter.
Stake is the money in. Return is the money out, if any. Profit and loss is the difference, and it lives in its own column so the running total at the bottom of the page is one column-sum away. Closing line value — the gap between your entry price and the line at kickoff — is the column most punters never add, and it is the most important diagnostic on the entire sheet for whether you are a profitable bettor in the long run.
Eleven columns. Fits on a single A4 page in portrait if you keep the columns tight. Fits on a single Google Sheets tab without horizontal scrolling. That is the template.
The header row, designed once and never touched again
The header row gets designed once and never touched again, which is exactly why getting it right matters. Three weeks into the season, you do not want to be redrawing the column widths or repositioning the title block. Treat the header as infrastructure — built once, frozen, then used.
At the top of the page, before the column headers, sit four pieces of metadata. Season and week number on the top left — “2026 NFL — Week 7”, written large. Date range of the slate on the top right — “16-20 October 2026”, covering Thursday through Monday. A running bankroll figure on the right under the date, showing where your account sat at the start of the week. And a small space for a one-line note about the slate — “wind forecast in Chicago, watch the totals”, or “Hurts ruled out, Jalen Hurts moneyline pulled”, or whatever single fact you want to anchor the week around.
Below the metadata block, the column headers themselves. Eleven columns from left to right, with widths sized so the longest plausible entry in each column fits without truncation. Fixture is the widest at roughly twelve characters — long enough for “Bills @ Dolphins”. Kickoff is six characters — “01:15F” or “18:00S” with a letter suffix denoting the day. Market type is four — “SPRD”, “TOTL”, “MNLN”, “PROP”. Line is six — “-3.5”, “47.5o”, “EVENS”. The three odds columns are five each. Stake is six. Result is eight. Return is seven. Profit is seven. CLV is six.
Total width when you add it up is under eighty characters across the page, which means the whole template fits on standard A4 in landscape with margins comfortable enough to write in. In portrait, the same eleven columns work but with slightly tighter widths and slightly smaller text in the fixture column. I print landscape for the working sheet and portrait for the archive sheet at the end of the week, but either orientation is fine.
The one design rule I would push hard on. The first column — fixture — gets a thicker left border to anchor the eye, and the last column — CLV — gets a thicker right border to mark the analytical end of the row. Everything between them is the bet record. Everything after is the diagnostic. That visual separation is small but it makes the sheet much easier to read at a glance once you have thirty rows on it.
Three odds formats, side by side, every week
The three odds columns are the part of the sheet that gives me the most arguments from new readers. Why three? Why not just one? The answer comes down to what each format is good at, and the answer is different for each.
The American column is the cross-reference column. It is what you wrote down when you read the published US sheet earlier in the week. It is what you saw on Twitter when somebody discussed the line. It is the lingua franca of NFL betting analysis, even in the UK, because almost every published commentary uses it. Without an American column on your sheet, you have to convert every time you read someone else’s analysis, and that conversion takes time you do not have on a Sunday evening.
The decimal column is the working column. It is what you use for arithmetic — payout calculations, implied probability, break-even percentages. The break-even threshold on standard minus 110 odds is 52.38 percent, and the way you compute it is by inverting the decimal 1.909. The decimal column is the one your spreadsheet formulas live on. If you only had one column, decimal would be the column to keep.
The fractional column is the record column. It is what the bookmaker actually displayed when you placed the bet, and it is what the bet slip will show when the bet settles. If there is ever a dispute — and over a long season, there will be at least one — the fractional column is the audit trail. UK shops settle on the displayed fractional, not on a computed decimal, so recording the fractional you actually saw is the only way to verify the settlement matches the bet.
The discipline I would push hardest on is filling all three columns at bet placement time, not retrospectively. If you back the Bills at 5/6 on bet365, write 5/6 in the fractional column, write -120 in the American column, write 1.833 in the decimal column, all in the same minute. Doing it later means relying on memory or a screenshot, and both are unreliable across a sixteen-game slate. Three formats, one bet, recorded once.
One final note on the column. The bet365 default display is fractional, switchable in settings — and most of the UK shops behave the same way. Most published US sheets are in American. The decimal column is the bridge between the two, computed from one and validated against the other. Three columns, three perspectives, one bet — and a sanity check baked in.
Stake and result columns — the two that decide whether you are profitable
Stake and result. Two columns, three or four characters each, and they decide more about your end-of-season story than any other pair of columns on the sheet. The maths underneath them is trivial. The discipline of filling them honestly is the hard part.
Stake is the column where most beginners cheat themselves. The temptation is to round up — to call a £23 bet a £25 bet because the round number looks cleaner — or to round down on losses to soften the sting. Don’t. The stake column is the only column on the sheet that tells you how much real money was at risk on this bet, and any fudging at this step contaminates every downstream calculation. Write the exact stake, in pounds and pence if necessary. £23.50 is £23.50. £100 is £100. Round numbers are nice; accurate numbers are non-negotiable.
Stake size is also where the discipline of bankroll management shows up most. A common framework is the flat-stake unit — every bet is the same percentage of your starting bankroll, regardless of how confident you feel. One percent per bet on a £1,000 starting bankroll means every wager is £10. Two percent means £20. The reason flat staking matters is that it removes a category of variance from your sheet — the variance introduced by you betting more on the games you “feel good about” and less on the games you feel uncertain. Sharp bettors typically wager on twenty to thirty percent of available games, focusing only on spots where they identify genuine edges, and a 55 percent win rate at minus 110 odds is considered excellent and profitable — but a 55 percent win rate at flat stakes turns into profit. A 55 percent win rate at wildly variable stakes can lose money if your losers happen to be the bigger bets.
The result column gets one of four entries. W for a winning bet. L for a losing bet. P for a push (stake refunded). V for void (bet cancelled, usually a postponement or a player withdrawal triggering a void rule). The four-letter system covers every settlement outcome on an NFL bet. Anything more elaborate adds noise.
The return column computes from stake, result, and decimal odds. Win: stake times decimal. Push or void: stake refunded. Loss: zero. The profit column is return minus stake — positive on a win, zero on push or void, negative on a loss. Sum the profit column at the bottom of the week and you have your net result. Sum it across weeks and you have your season.
The closing line value column, and why it tells more than the win column
The CLV column is the one I add to every sheet I build, and the one almost no beginner template includes. Closing line value is the gap between the price you took when you placed your bet and the line at kickoff. Track it across a season and it tells you more about whether you are a profitable bettor in the long run than the win-loss column does.
The reason CLV is so diagnostic is that the closing line — the price the market settles on right before kickoff — is the sharpest estimate of the true probability of each outcome that the market ever produces. Every piece of information, every injury update, every weather forecast, every sharp money flow has had its chance to move the price by the time the game starts. The closing line is, in effect, the consensus answer to “what is the actual probability here”. If you consistently bet at prices better than the closing line, you are picking the market off in a measurable way, and over volume that beats variance.
The mechanics are simple. When you place the bet, record the price you took in the three odds columns. When the game kicks off, look at the line on a comparison site or your preferred sportsbook and record the closing line in the CLV column. The CLV value itself is the difference, usually expressed in points for spreads and totals, or in pennies of decimal odds for moneylines and props.
A worked example. You back the Bills at -3 on Thursday at 10/11. By Sunday kickoff, the closing line has moved to Bills -3.5 at 10/11. Your CLV is positive half a point — you took a better line than the close. Even if the Bills lose by exactly three and your bet pushes, you had positive CLV on the bet. Positive CLV across a season is a leading indicator of profit, even when results-based variance is masking the picture in any single month.
The framework I use to read the CLV column is straightforward. Three groups, divided by sign. Positive CLV bets — you took a better line than close. These are the bets where your timing or your read was sharper than the market. Negative CLV bets — you took a worse line than close. Either you were impatient or the news moved against you. Zero CLV bets — the line did not move between your entry and kickoff. Most bets fall in this bucket, especially on stable mid-week markets.
Over a hundred bets, the distribution of CLV signs is the most reliable signal of whether you are a winning bettor or a losing one. Win the CLV column and the profit column will follow, even if it lags by weeks or months. The full case for why this metric matters more than win rate, and the methodology for tracking it across multiple operators, is something I would point readers toward the dedicated CLV walkthrough for if they want the full mechanics.
Paper versus spreadsheet, and where each one wins
The most common question from readers who have decided to build their own template is whether to use paper or a spreadsheet. The honest answer is both, and the reason is that the two formats are good at fundamentally different things.
Paper is fast. Marking up a printed sheet with a pen in front of a screen is the lowest-latency way to record a bet that has ever been invented, and on a Sunday evening when the early slate is wrapping up and the late slate is starting, latency matters. You see the line, you place the bet on the app, you write the row on the sheet, and you are done in under thirty seconds. No tab switching, no app opening, no two-step authentication on a banking app. Pen on paper.
Spreadsheets are accurate. A Google Sheet or an Excel file can compute decimal odds from American or fractional automatically, can compute return from stake and decimal, can compute profit from return and stake, and can sum the profit column across weeks without any manual arithmetic. Paper sheets accumulate small errors over time — a multiplication done in your head at midnight, a column total miscounted, a result entered as W when it was actually a push. Those errors are inevitable on paper and almost impossible in a properly-constructed spreadsheet.
The hybrid workflow I settled on years ago uses paper for the live week and a spreadsheet for the archive. Monday morning of the following week, I copy the previous week’s paper sheet into a spreadsheet tab, double-checking each row as I type. The act of copying is the audit — if anything looks wrong, the typing process catches it. The spreadsheet tab becomes the permanent record, with formulas that compute CLV trends, win rates by market type, and profit-and-loss roll-ups across the season.
One operational note worth flagging. If you choose pure spreadsheet without the paper layer, set up the formulas before week one and test them on dummy bets. A spreadsheet with a broken formula is worse than paper, because it gives you wrong numbers that look authoritative. Half an hour of pre-season testing on a Saturday in August has saved me from compounding errors more than once.
How the sheet fills up through a typical NFL week
The sheet does not get filled in one sitting on a Sunday. It gets filled across the week, in three or four distinct passes, each of which serves a specific purpose. Treat it as a weekly cycle rather than a single event and the work becomes steady and manageable instead of a Sunday-evening scramble.
Pass one is Tuesday evening, the night after the previous week’s Monday Night Football. I print the blank sheet for the new week, fill in the fixture column from the upcoming slate, write in the kickoff times converted to UK time, and add the slate-note line at the top of the page. This pass takes ten minutes. The output is a sheet with rows but no bets, ready to receive entries through the week.
Pass two is Thursday morning. I read the four operator tabs I shop across, identify which lines have moved into my range since the openings were published, and shortlist the games I want to bet on. Shortlisted games get a small mark in the margin — a triangle is my convention for “watch list” — but no row entries yet. The bet itself waits until Saturday or Sunday morning, when the line will have stabilised and any mid-week injury news has been fully priced in.
Pass three is bet placement, usually Saturday afternoon or Sunday morning depending on the fixture. For each bet I actually place, I fill in the corresponding row in real time — line, odds in three formats, stake — and tick the margin to indicate the bet is live. This is the discipline pass. Every bet placed goes onto the sheet at placement time, not retrospectively. Retrospective entries are the gateway drug to fudged records.
Pass four is post-game, usually Monday morning after Monday Night Football wraps up. I fill in the result, return, profit, and closing-line-value columns for every bet from the week. I also sum the profit column and update the running bankroll number at the top of the page. The total time across all four passes is about an hour and a half, and the result is a complete weekly record that ties cleanly to the next week’s sheet and to the spreadsheet archive.
The end-of-week roll-up that turns sixteen rows into a season picture
The Monday morning roll-up is where the week’s sheet becomes part of the season’s story, and it is the step almost every casual punter skips. Without the roll-up, each week is an island, and you have no way to spot the patterns that take three or four weeks to become visible.
Three numbers go on the season tracker every Monday. Net profit for the week — the sum of the profit column on the paper sheet. Number of bets placed — count the rows that have a result entry. CLV summary — count of positive-CLV bets, negative-CLV bets, and zero-CLV bets. Those three figures, written in three columns of a season-long log, are the spine of any meaningful analytical review.
Over a five-week stretch, the patterns you can read from those three numbers are surprisingly rich. A run of negative weeks with positive CLV is usually variance — you are betting well, the results just have not landed yet, and the spreadsheet is asking you to keep doing what you are doing. A run of positive weeks with negative CLV is usually luck — you are betting against the closing line consistently, the results have masked it for a while, but the regression to the mean is coming. A run with no clear CLV trend either way is usually a slate problem — you have not been finding edges and you have been guessing.
The week’s sheet itself, the paper one, gets filed at this point. I keep them in a clip folder in chronological order, with the season tab number written in large at the top right corner. By Super Bowl week the folder has nineteen or twenty pages in it, and I can flip back to any specific week and see exactly which bets I placed and how they performed. The British gambling industry as a whole posted £12.6 billion in gross gambling yield across the financial year to March 2025, a 9.3 percent rise year on year, and a meaningful share of that figure comes from 24.4 million active gambling accounts with roughly £1.0 billion in customer funds held — a real fraction of those accounts are people who do not track their bets at all. The roll-up turns a betting habit into a structured practice. The folder turns the practice into a season-long record. Both are cheap, both are simple, and both are unusual enough that the discipline alone gives you an edge over the unstructured punter.
Template questions that come up after the first month of use
Four questions cover almost every template query I receive. They tend to come from readers a month or two into the season, once they have used the sheet long enough to notice what works and what does not. The answers below are the conclusions I have reached across eight years of building and rebuilding my own templates — covering a slice of the audience that the NFL counts at more than 13 million UK fans, with roughly 4 million classified as avid.