A free month-end close and variance model in Excel, for financial controllers
The close corrections and their effect on EBITDA, a hospital contract allocated by standalone selling price with deferred revenue, budget against actual split into volume, price and cost, and the covenant certificate: seven sheets, no macros.
The file runs a fictional instruments company through a controller's quarter. At the June close, freight invoices not accrued and an accrual booked twice cut second-quarter EBITDA from $10.4 million to $9.8 million. A $1.5 million hospital contract is split by standalone selling price across an instrument, installation and a three-year service plan, leaving $284,314 deferred at year end. Third-quarter gross margin misses budget by $1.88 million, split into volume, price and cost. The covenant certificate shows leverage of 3.07 times against a 3.5 maximum.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
Month_End_Close_and_Covenant_Model.xlsx (16 KB)
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This file is one worked case from The Financial Controller. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 19 paperbacks by Julian R. Sterling on markets, funds and compliance, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
Seven sheets. Inputs are yellow cells with blue figures.
Read Me and Inputs
Close errors, the contract and standalone prices, budget and actual volumes, prices and costs, and the covenant terms.
Close
The corrections and corrected EBITDA.
Revenue
Allocation of the contract price by standalone selling price, revenue recognized in the year and deferred revenue.
Variance
Budget against actual for revenue, cost and gross margin, and the volume, price and cost variances.
Covenant
Reported EBITDA, add-backs against the cap, covenant EBITDA, leverage and the cushion.
Checks
The book's figures against the formulas.
What the worked case returns
Measure
Value
Preliminary and corrected Q2 EBITDA
$10.4m and $9.8m
Contract discount against standalone prices
11.8%
Revenue recognized in 2026
$1,215,686
Deferred revenue at year end
$284,314
Q3 gross margin against budget
-$1.88m
Volume, price and cost variances
-$1.30m, +$1.15m, -$1.73m
Covenant leverage
3.07x (max 3.5x)
EBITDA at which leverage hits the maximum
$34.3m
The covenant leverage of 3.07 times relies on $3.1 million of add-backs; on reported EBITDA alone it is 3.33. The cushion is real, but nearly two thirds of it is the add-backs.
How to use it on your own company
Enter the close errors on Inputs and read corrected EBITDA.
Enter a contract's price and standalone prices to allocate it.
Enter budget and actual volumes, prices and costs for the variances.
Enter EBITDA, add-backs and debt for the covenant certificate.
Questions people ask about it
Is this template really free?
Yes. It is a companion file to a book. The file costs nothing. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Does it use macros or circular references?
No macros and no circular reference.
How is a contract allocated under ASC 606 or IFRS 15?
The transaction price is spread over the performance obligations in proportion to their standalone selling prices. Here the $1.5 million price is 88.2% of the $1.7 million of standalone prices, so each obligation gets 88.2% of its own.
Can I use it for my own company?
Yes, by replacing the inputs. The company and its figures are fictional.
The rest of the files
This template is the companion workbook for The Financial Controller; the companion page also carries the other files that go with it. Free, like this one.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
This template comes from The Financial Controller. The book is on Apple Books and Google Play.
If this book helped, or didn’t, a rating where you bought it is worth more than it looks: it is what the next reader goes on. The template stays free either way.