TTM explained: Trailing twelve months and how to roll it forward

Trailing twelve months is the most-used period in small business finance and one of the most often mangled. Valuations are quoted on TTM EBITDA. Lenders size facilities on TTM cash flow. Yet a request for "TTM financials" regularly comes back as the last calendar year, or twelve months ending yesterday.

This post defines TTM precisely, works through an example, compares it with the periods it gets confused with, and covers how to roll it forward each month without breaking your model.

What TTM means

Trailing twelve months is the twelve complete months ending at a stated month end. The key words are complete and stated.

If the last closed month is September 2026, TTM runs from October 1, 2025 through September 30, 2026. It doesn't matter that today is October 28. October isn't closed, so it isn't in the window.

LTM (last twelve months) means the same thing. Bankers tend to say LTM, operators and brokers tend to say TTM. Treat them as synonyms, and when in doubt, state the end date.

A worked example

Say a company's monthly revenue for the window looks like this:

When October 2026 closes, you roll forward one month. October 2025 drops out and October 2026 comes in. If October 2026 revenue is $197,000, TTM revenue becomes $2,238,000 − $182,000 + $197,000 = $2,253,000, now for the period November 1, 2025 through October 31, 2026.

That's the whole mechanic. The window keeps its length and slides forward one month at a time.

Why TTM, and not the last fiscal year

Fiscal year results go stale fast. In October 2026, a December 2025 fiscal year end is ten months old. If the business has grown or shrunk since then, the fiscal year number is wrong for valuation or credit purposes.

TTM also smooths seasonality. Any twelve-month window contains one of each month, so a landscaping company's winter and a retailer's December are both in there. A six-month annualized figure doesn't have that property.

TTM compared with other periods

Two notes on fiscal periods. First, YTD is fiscal year to date. If the company's fiscal year starts July 1, YTD at September 30 is three months, not nine. Second, "last complete fiscal year" depends on where the period end falls. At September 30, 2026, with a calendar fiscal year, the last complete year is 2025. At December 31, 2026, it becomes 2026.

Ask for monthly columns

A TTM P&L with a single total column gives you one number per line. A TTM P&L with twelve monthly columns gives you that number plus everything you need to question it: which months carried the year, whether the last three months are trending up or down, whether a large expense was booked in one lump.

Monthly columns also make roll-forward trivial in a spreadsheet. You drop the first column, add a new last column, and the TTM total formula moves with it.

Ask for it explicitly: "Profit and Loss, trailing twelve months ending September 30, 2026, accrual basis, columns by month."

The balance sheet isn't a TTM report

The P&L and cash flow statement cover a period. The balance sheet is a snapshot at a point in time. There's no such thing as a TTM balance sheet total.

What people usually want when they say "TTM balance sheet" is a set of balance sheets, one for each month end in the TTM window. In QuickBooks that's a Balance Sheet run over the date range with columns by month. You need those for average working capital and a working capital peg, and for checking that nothing odd happened to debt or equity at a quarter end.

Aging reports are the same. A/R and A/P agings are as of a single date. If you want to see receivables over time, ask for agings as of several month ends.

Pitfalls when rolling forward

Rolling TTM forward sounds mechanical. Three things make it less so.

Late closes

Don't roll forward until the month is actually closed. If you pull October on November 5 and the bookkeeper reconciles the bank on November 15, your October numbers will change. Ask when the month was closed, or agree on a close calendar with the seller.

Prior months change

Books get corrected. The accountant posts a year-end accrual in March for December. A misclassified expense gets reclassed from COGS to operating expenses across six months. Someone finds an invoice that was never entered and backdates it.

If you roll forward by appending only the new month to your existing data, you'll miss every one of these changes. Your model will show TTM that no longer matches what QuickBooks says for the same window.

Full re-pull versus new months only

This gives you a choice each time you roll forward:

• Full re-pull. Pull the whole TTM window again at the new period end. Slower and larger, especially for the general ledger, but it picks up every change to prior months.
• New months only. Pull just the month that was added. Faster, and fine when you're confident nothing earlier moved, but it can drift from the books over time.

A sensible pattern is new months only for routine monthly updates, and a full re-pull at quarter ends and before anything important, such as a final purchase price or a covenant test. Comparing the two at a quarter end also tells you how much the seller's books move after close, which is useful to know about the seller.

Writing a TTM request that rolls

Define every period relative to one period end, not with hard-coded dates:

• Profit and Loss, trailing 12 months, by month, accrual
• Balance Sheet, trailing 12 months, by month, accrual
• General Ledger, trailing 12 months
• A/R Aging Summary, as of period end
• Period end: September 30, 2026

Next month you change one line, the period end, and everything else follows.

Rolling forward in FinShare

FinShare requests work this way. Each report's period is relative to the request's period end: trailing N months, fiscal year to date, last N complete fiscal years, as of period end, or a fixed range if you really want one. The company's fiscal year start comes from QuickBooks, so "year to date" and "last complete fiscal year" resolve correctly for non-calendar years.

When a month closes, you roll the request forward to the new period end and choose full periods or new months only. Fixed-date reports are left out of a roll forward, since their dates don't move. The owner approves each roll forward unless they granted standing approval when they approved the original request, and only for the access window they agreed to. Nothing runs on a schedule; you decide when to roll.