# Accrued Expenses A 12-month accrued-liability roll-forward: accrual panel with reversal lag (months) and a monthly accrual plan per category, weighted-average lag, a 12x12 reversal matrix routing each month's accruals to the month they are paid in cash, a 12-month roll-forward (opening / accrual / reversal / closing) with implied accrual days each month, and a dashboard with peak-accrual and timing-distribution status. - Canonical: https://finamodel.com/templates/accrued-expenses - Excel download: https://finamodel.com/templates/accrued-expenses.xlsx - Category: Corporate Finance - Model type: Operating model - Difficulty: Intermediate - Audiences: CFOs & FP&A, Founders & operators, CFOs, FP&A teams, Controllers, Treasury - Tags: accrued expenses, accrued liabilities, working capital, reversal timing, month-end close ## Overview 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's included - 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) - Dashboard with average-lag and accrual-intensity traffic-light status against user-set thresholds - Accrual panel with reversal lag (months) and 12-month accrual plan per category - Accrual Master with annual accrual, % of panel, weighted-lag contribution, and timing bucket per category - 12x12 reversal matrix routing each month's accruals to the month they are paid in cash based on category bucket - 12-month accrued-liability roll-forward: opening, accrual, reversal, closing, implied accrual days each month - Peak accrual balance and the month it occurs, plus accrual intensity (closing / monthly accrual) at peak - Reversal timing distribution: % of annual accruals paid same month / +1 month / +2 months / +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. ## Built for cash-out timing on accruals When the question is "when does an accrued bonus, tax, or utility bill actually convert to cash?", an accrued-expenses roll-forward is the cleanest answer. This template feeds the operating-cash leg of a 13-week cashflow forecast, a 3-statement model, or a runway projection without you having to stitch accrual reversal timing together by hand. ## Designed for one-edit responsiveness Every category lag, bucket cutoff, threshold, and monthly accrual line is a named-range or named-cell input. Flex one number and the reversal matrix re-routes, the accrual balance path updates, and the dashboard status flips - no formula rewrites. ## Honest about timing precision Real accrual reversals have daily nuance and irregular settlement cycles; this template uses a four-bucket model (paid same month, +1, +2, +3) because the trade-off favours interpretability over false precision. The bucket cutoffs are user-set inputs, so you can tighten or loosen them to match how your accounting close actually works. ## Built for cash-out timing on accruals When the question is "when does an accrued bonus, tax, or utility bill actually convert to cash?", an accrued-expenses roll-forward is the cleanest answer. This template feeds the operating-cash leg of a 13-week cashflow forecast, a 3-statement model, or a runway projection without you having to stitch accrual reversal timing together by hand. ## Designed for one-edit responsiveness Every category lag, bucket cutoff, threshold, and monthly accrual line is a named-range or named-cell input. Flex one number and the reversal matrix re-routes, the accrual balance path updates, and the dashboard status flips - no formula rewrites. ## Honest about timing precision Real accrual reversals have daily nuance and irregular settlement cycles; this template uses a four-bucket model (paid same month, +1, +2, +3) because the trade-off favours interpretability over false precision. The bucket cutoffs are user-set inputs, so you can tighten or loosen them to match how your accounting close actually works. ## Workbook structure ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: accrual panel, monthly accruals, opening balance, bucket cutoffs, thresholds. - 8 categories with reversal lag (months) and a 12-month accrual plan per category - Opening accrual balance - Three bucket cutoff months (same-month, +1, +2) - Average-lag and accrual-intensity traffic-light thresholds (green / amber) ### Accrual Master Per-category lag, annual accruals, weighted-lag contribution, and timing bucket. - One row per accrual category - Annual accruals via SUM across the 12 monthly named ranges - % of panel and lag contribution (% of panel times lag months) - Bucket label via nested IF on the user-set cutoffs ### Reversal Schedule A 12x12 matrix routing each month's accruals to the month they are paid in cash. - Row r = accrual month, column c = reversal month - Cell (r, c) computed via SUMPRODUCT against category bucket labels - Post-period column captures reversals deferred past M12 - Column sums feed the Accrual Schedule reversal row ### Accrual Schedule 12-month accrued-liability roll-forward with implied accrual days each month. - Opening rolls from previous month's closing - Accruals per panel from the Assumptions monthly named ranges - Reversals pulled from the Reversal Schedule column totals - Closing = opening + accruals - reversals - Implied accrual days = closing / monthly accrual x 30 ### Dashboard Headline metrics with traffic-light status and reversal-timing distribution. - Weighted-average lag with On track / Watch / Stretched status - Peak accrual balance and the month of peak - Accrual intensity at peak with On track / Watch / Heavy status - Annual accruals, in-period reversals, and post-period spill - Bucket distribution: % of annual accruals reversed +0 / +1 / +2 / +3 months ### Cover Workbook overview, sheet legend, and tab-colour key for navigation. - Title and scope framing - Sheet-by-sheet purpose summary - Tab-colour legend ### Assumptions Every driver in one sheet: accrual panel, monthly accruals, opening balance, bucket cutoffs, thresholds. - 8 categories with reversal lag (months) and a 12-month accrual plan per category - Opening accrual balance - Three bucket cutoff months (same-month, +1, +2) - Average-lag and accrual-intensity traffic-light thresholds (green / amber) ### Accrual Master Per-category lag, annual accruals, weighted-lag contribution, and timing bucket. - One row per accrual category - Annual accruals via SUM across the 12 monthly named ranges - % of panel and lag contribution (% of panel times lag months) - Bucket label via nested IF on the user-set cutoffs ### Reversal Schedule A 12x12 matrix routing each month's accruals to the month they are paid in cash. - Row r = accrual month, column c = reversal month - Cell (r, c) computed via SUMPRODUCT against category bucket labels - Post-period column captures reversals deferred past M12 - Column sums feed the Accrual Schedule reversal row ### Accrual Schedule 12-month accrued-liability roll-forward with implied accrual days each month. - Opening rolls from previous month's closing - Accruals per panel from the Assumptions monthly named ranges - Reversals pulled from the Reversal Schedule column totals - Closing = opening + accruals - reversals - Implied accrual days = closing / monthly accrual x 30 ### Dashboard Headline metrics with traffic-light status and reversal-timing distribution. - Weighted-average lag with On track / Watch / Stretched status - Peak accrual balance and the month of peak - Accrual intensity at peak with On track / Watch / Heavy status - Annual accruals, in-period reversals, and post-period spill - Bucket distribution: % of annual accruals reversed +0 / +1 / +2 / +3 months ## Features - **Bucket-based reversal timing:** Each accrual category's reversal lag (in months) is mapped to a four-bucket timing model: paid same month, +1 month, +2 months, or +3 months. Cutoff months for each bucket are user-set named-range inputs, so a single edit to one cutoff cell reshapes the entire reversal matrix. - **12x12 reversal matrix:** Each row is an accrual month; each column is a reversal month. Cell (r, c) shows the dollars from month r's accruals that get paid out in month c, with a post-period spill column for accruals whose reversal lands beyond M12. Column sums feed the Accrual Schedule reversal row directly. - **Weighted lag not flat-averaged:** Weighted-average reversal lag is computed as the sum of each category's annual accrual share times that category's lag months, so big-accrual categories dominate the headline number the way they would in a real cash forecast. No equal-weight averaging. ## Use cases - **Cash-out timing for treasury:** Take a budgeted accrual plan, push it through the reversal lags, and read the month-by-month cash outflow off the Accrual Schedule reversal row. Pairs directly with a 13-week cashflow forecast or a runway model. - **Working-capital sizing for fundraising:** Accrual intensity at peak (closing accrual / monthly accrual) sizes how much short-term liability the business carries between expense recognition and cash payment; compare that against AP and AR sides for a full working-capital bridge. - **Month-end close review:** Controllers flex any accrual category or reversal lag in Assumptions, watch the weighted lag move, the bucket flip, the reversal matrix re-route, and the peak accrual balance respond. Useful for quantifying the cash impact of bonus deferrals, tax payment schedule changes, or vendor-terms shifts before they hit the books. ## Frequently asked questions ### 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. ## Related templates - [Working Capital Model](https://finamodel.com/templates/working-capital-model) - [AP Forecast](https://finamodel.com/templates/ap-forecast) - [3 Statement Model](https://finamodel.com/templates/3-statement-model)