Accrued Expenses
Corporate Finance Financial Model (Free Excel Download)
Track recurring accruals, reversals, and settlement timing to close the books accurately and understand how unpaid costs affect liabilities and cash flow.
professionals from Deloitte
Used by professionals from
About this model
An accrued-expenses model translates a monthly accrual plan into a 12-month projection of the accrued-liability balance and the cash outflow as each accrual reverses. This template lays the full mechanic on six sheets: an Assumptions sheet with a panel of eight accrual categories (wages, utilities, professional fees, interest, property tax, vacation, bonus, income tax), each with a reversal lag in months and a 12-month accrual plan, plus opening accrual balance, the four bucket cutoffs that map lag months to a reversal-timing bucket (paid same month / +1 / +2 / +3), and the average-lag and accrual-intensity traffic-light thresholds; an Accrual Master sheet that pulls each category's lag and annual accruals, computes its % of panel and lag contribution, and labels its timing bucket; a Reversal Schedule sheet with a 12x12 matrix that routes each month's accruals to the month they are paid in cash based on category bucket, with a post-period column for accruals whose reversal lands beyond the 12-month window; an Accrual Schedule sheet that rolls opening accrual, accruals, reversals, and closing accrual through 12 months with implied accrual days each month; and a Dashboard sheet with weighted-average lag, peak accrual balance, accrual intensity at peak, closing accrual at M12, annual accruals and reversals, and the reversal-timing distribution by bucket.
The reversal routing uses a SUMPRODUCT against the category bucket labels, so a single edit to a category's lag or to a bucket cutoff reshapes the entire reversal matrix and the accrual balance path. Weighted lag is computed properly - each category's share of total annual accruals is multiplied by its lag months and summed - so big-accrual categories dominate the headline number the way they would in a real cash forecast. The model maintains the accrual identity (opening + accruals - reversals = closing) at every month, and the post-period spill column ensures column sums tie to the underlying accruals.
CFOs, FP&A teams, controllers, and treasury managers use this template for cash-out timing (drive the operating-cash leg of a 13-week forecast off the Accrual Schedule reversal row), working-capital sizing (read accrual intensity at peak to size short-term liabilities carried by the business between expense recognition and cash payment), and month-end close diagnostics (flex one category's lag in Assumptions and quantify the cash impact on weighted lag and peak accrual before changes hit the books). The bucket model is intentionally caveman-simple - real accrual schedules have more nuance than four buckets - so the trade-off is interpretability and one-edit responsiveness over the false precision of a daily reversal calendar.
What every model includes
Live formulas, no hardcoded values
Outputs are driven by live formulas, so the workbook updates from its assumptions instead of relying on hardcoded results.
All assumptions in one tab
Inputs are clearly marked in the Assumptions tab and separated from calculations, making it clear what to change and what to leave intact.
Statements always balancing
For integrated-statement models, the balance sheet, cash flow, and supporting schedules tie through properly.
Distinct schedules for clarity
Debt, working capital, taxes, and cash flow can get messy quickly. We group calculations in clear schedules, not across disconnected tabs.
No hidden macros or external links
There are no unexplained external workbook links or macros to undermine auditability or portability.
Changes flow through the model
Update a key driver and see the impact carry through the forecast, financing, and return outputs. We never use hardcoded numbers in formulas.
What's inside the Accrued Expenses
- Accrual panel with reversal lag (months) and 12-month accruals plan per category
- Accrual Master with annual accrual, % of panel, weighted-lag contribution, and timing bucket
- 12x12 reversal matrix routing each month's accruals to the month they are paid in cash
- Post-period spill column capturing reversals deferred past M12
- 12-month accrued-liability roll-forward: opening, accrual, reversal, closing, implied days
- Weighted-average reversal lag across the panel weighted by annual accrual
- Peak accrual balance, the month it occurs, and accrual intensity (closing / monthly accrual) at peak
- Reversal timing distribution: % of annual accruals by bucket (+0 / +1 / +2 / +3 months)
Accrued Expenses Model: How the 12-Month Roll-Forward Works
This accrued expenses model is a 12-month roll-forward of accrued liabilities for a single operating entity. It tracks 12 categories, from wages and bonus to warranty and restructuring, using operating drivers and a direct integer-lag reversal.
The design suits readers evaluating how accrual timing, driver-based forecasting, and panel-level reconciliation fit together in one template.
Drivers Behind Each Monthly Accrual
Monthly accruals respond to operating drivers rather than raw dollar entries. Wages, bonus, income tax, and warranty re-compute under Bull and Bear scenarios, while the remaining eight categories use calibrated base monthlies.
- For example, wages depend on headcount, average salary, and an accrual percentage; bonus adds a pool percentage and eligibility rate; income tax uses an effective tax rate and pre-tax income relationship; warranty uses a warranty percentage and revenue-to-opex ratio. A manual override wins only when a positive number is entered, otherwise the driver base applies.
- Seasonality vectors, normalised to sum to 12, preserve the annual envelope while shifting monthly timing.
How Accruals Reverse Into Cash Payments
Each category reverses exactly its integer lag in months after booking. A 12x12 reversal matrix routes every month's accrual to the target month r plus the category lag.
- When the target exceeds month 12, the amount spills into a dedicated post-period column representing next-year cash deferral. This direct mechanic replaces legacy bucket schemes that mis-routed longer lags.
- Because the matrix is upper-triangular, a row never reverses before its accrual month. Row sums equal total panel accruals, and column sums equal current-year cash payments.
Lag-12 categories, such as bonus and income tax, push their full annual amount into the post-period column.
Panel Roll-Forward and Reconciliation Checks
The panel schedule ties opening, accrual, cash payment, prior-period payment, and true-up into a closing balance each month. Opening equals the prior month's closing, or the opening accrual in month one.
- Prior-period payments amortise the opening balance over a default three-month window. A global true-up factor adjusts accruals, typically for bonus and tax quarter-end estimates, and is bounded by a 10% materiality check.
- Fifteen integrity tests confirm the closing identity, non-negative balances, lag mechanic ties, weighted-lag tie, driver coverage, peak intensity, post-period capture, and balance-sheet reconciliation. These checks support auditability and help flag timing or driver errors.
Where the Outputs Are Used
Downstream sheets translate accrual activity into financial views. The income statement impact groups per-category expense by month into COGS, SG&A, interest, tax, and other.
- The balance-sheet view shows closing accrued liability per category with a materiality flag based on annual driver-level accrual. The cash-flow impact separates current-year cash payments from prior-period settlements and includes sources and uses by counterparty.
- A dashboard summarises 12 headline metrics with traffic-light status, reversal timing distribution, and annual accrual by P&L group. Sensitivity grids explore lag, intensity, bonus lag, tax rate, headcount, and salary, using closed-form proxies rather than full recalculations.
Formatted to IB standards
Named theme colors repaint the whole workbook in one click, on top of an investment-banking structure with clear input, output, and cross-sheet reference styling - brand-ready, institutional-grade, and fully auditable.
Created by ex-finance professionals
Hey, I’m Alex and I created Finamodel.
Over my years in the finance industry I kept building the same models over and over again. Same structure, same assumptions, different logo. So I started building frameworks to turn them into clean, reusable templates.
Every model here is one I’d actually use for a client, and I personally vet each one before it goes up.
I’m not an expert in every industry, but I’ve built enough models to know what belongs in one. And when something is completely foreign to me, I reach out to my network for experts to work on our models with us.
Having a template library on hand cuts a first build from hours to minutes.
Need help finding your model? You’ll find me in the Finamodel app!
Frequently asked
What is an accrued-expenses model?+
An accrued-expenses model tracks the timing gap between when an expense is recognised on the income statement (when the service is consumed) and when cash actually leaves the business (when the bill or payroll cycle settles). It rolls the accrued-liability balance forward month by month from opening + accruals - reversals, and it projects the cash outflow side directly.
How are category lags turned into reversal timing?+
Each category's reversal lag in months is mapped to one of four buckets via user-set cutoffs on the Assumptions sheet: same month, +1 month, +2 months, or +3 months. The model uses a SUMPRODUCT against the category bucket labels on the Accrual Master sheet to route each month's accruals into the right reversal column.
Why does the dashboard show reversals deferred past M12?+
Categories with longer lags (like annual bonus or income tax with a 12-month lag) can have accruals in the last few months of the forecast whose reversal lands beyond the 12-month window. The reversal matrix has a post-period column that captures this spill so the totals tie and you can see how much of the late-year accruing rolls over into the next year.
How is weighted lag computed here?+
Weighted lag is the sum of each category's share of total annual accruals multiplied by that category's lag months. So categories with bigger annual amounts get more weight, and the headline lag reflects the panel's actual cash-timing centre of gravity rather than a flat average across categories.
Can I add more accrual categories?+
Yes. Extend the category block on Assumptions, add the corresponding row on Accrual Master, and extend the named ranges for lags, accruals, and buckets to cover the new rows. The reversal matrix and Accrual Schedule will pick up the additions automatically through the named ranges.
Have more financial modelling questions? Contact us
Related templates
Working Capital Model
Model cash conversion cycle with DSO, DIO, and DPO to forecast working capital needs.
AP Forecast
12-month accounts-payable timing forecast with vendor terms and DPO.
3 Statement Model
Integrated income statement, balance sheet, and cash flow forecasts.
M&A Modeling & Valuation
Comprehensive M&A valuation with DCF, comparable companies, and precedent transactions analysis.
