EBITDA to cash flow from operations: a reconciliation

An EBITDA cash flow from operations reconciliation shows how reported earnings become operating cash after interest, taxes and payment timing. Start with a documented EBITDA definition, use matched monthly exports and assign every adjustment once. A bridge that does not tie to the reported operating cash total is unfinished.

Set the starting point and the boundary

The SEC's EBITDA guidance defines the earnings starting point as GAAP net income. EBITDA adds back interest, taxes, depreciation and amortization; a differently calculated measure needs an appropriate label, such as adjusted EBITDA.

Operating cash flow = EBITDA − Operating cash interest paid − Operating cash income taxes paid − Increase in operating working capital + Other operating cash adjustments

Here, operating working capital excludes cash, debt, interest payable and income tax balances. Interest and tax timing are already handled by subtracting cash paid. Other operating cash adjustments capture items outside that defined working capital bridge, including relevant noncash expenses still deducted in EBITDA.

This is a management reconciliation, not a substitute for the statutory cash flow statement. It stops before capital expenditures. The EBITDA-to-free-cash-flow bridge covers that next step separately.

Assemble the monthly inputs

Use the income statement, EBITDA reconciliation, opening and closing trial balances, cash flow statement and interest and tax payment schedules. Export account codes, entity, currency, period and amounts with the rows. Include receivables, inventory, trade payables and operating accruals in the balance schedule.

Remove acquisitions, currency effects, transfers and noncash settlements from raw balance movements. The SEC's cash flow explanation describes the underlying indirect method: reconcile earnings using noncash adjustments and operating asset and liability changes.

For this illustrative US company, interest and income taxes paid belong in operating activities. There is no deferred tax, capitalized interest, interest income, stock compensation, impairment or asset disposal. Depreciation and amortization are the only noncash expenses. Those assumptions make the short bridge complete; a real export may require more lines.

Build the earnings and cash payment block

Place this table in Excel columns A and B, with headers on row 1. Enter the source values as numbers; calculate the subtotal rather than typing it.

In B6:

=SUM(B2:B5)

Microsoft documents SUM as adding values or ranges. Its documentation also notes that text in referenced cells is ignored, so confirm imported amounts are numeric before trusting a total.

Covirage is not affiliated with Microsoft.

The $180,000 subtotal is $90,000 + $20,000 + $30,000 + $40,000. Do not add depreciation again below it. Cash taxes of $35,000 are a payment schedule input, rather than an assumed tax rate applied to EBITDA.

Convert operating balance movements into cash effects

Put the next block in columns A through E, with headers on row 11. All amounts are whole USD; no rounding is needed. The movements have already been cleared of noncash changes.

Enter this in D12 and fill through D15:

=C12-B12

For the asset rows, E12 and E13 are:

=-D12
=-D13

For the liability rows, E14 and E15 are:

=D14
=D15

An asset increase consumes cash; a liability increase provides cash. The resulting operating balance effect is negative $45,000: −$40,000 − $25,000 + $15,000 + $5,000.

Finish the bridge and prove it another way

In B17, calculate operating cash flow:

=B6-B7-B8+SUM(E12:E15)

The result is $82,000: $180,000 − $18,000 − $35,000 − $45,000. Put the reported operating cash flow, $82,000 in this example, in B18. B19 is the unresolved difference:

=B17-B18

It must equal zero. Keep a visible difference until all reconciling items are explained.

The indirect route supplies an independent check. Interest payable rose from $5,000 to $7,000, matching $20,000 of expense less $18,000 paid. Income tax payable fell from $12,000 to $7,000, matching $30,000 of expense less $35,000 paid.

This second route starts after book interest and tax expenses, so their payable movements belong here. The first route subtracts cash interest and taxes, so those same payable movements are excluded there.

Where the bridge goes wrong

• Adding depreciation twice. EBITDA already removes the expense; a second add-back overstates cash.
• Combining cash payments with their accrual adjustments. Subtracting cash taxes and adjusting the tax payable balance again duplicates timing.
• Accepting adjusted EBITDA exclusions automatically. A restructuring expense may be excluded from adjusted earnings and still require cash.
• Using unrestricted balance differences. Noncash movements need removal before a balance change becomes a cash adjustment.
• Subtracting equipment spending here. Keep capital expenditures in the separate investing or free cash flow analysis.

Investigate each driver before drawing a conclusion about conversion quality. For a negative result, use the diagnosis of negative operating cash flow; put the expected reversal dates into the cash flow forecast.

Reconcile your own reporting file in Covirage

Upload your earnings export, payment schedule and operating balance movements; Covirage maps the columns, and its tools compute and check the figures. The external AI model explains the bridge with every figure traced to its rows. Create a free Covirage account in about a minute, then set up your business and bring a sample of your own data.

See financial planning and reporting for the finance reporting context.