Bridge cash flow: reconcile the change in cash

To bridge cash flow, add the period's cash movements to opening cash and explain how they produce closing cash. A cash flow bridge is a reporting reconciliation: each movement has a sign, a category and source transactions that support it.

The useful question is why cash changed, rather than whether the ending balance increased. Borrowing can raise cash while operations consume it, so the movement categories matter as much as the total.

Define the balances before categorizing movements

Closing cash = Opening cash + Operating movements + Investing movements + Financing movements + Exchange-rate effect, where applicable

Specify the company, period, currency and included accounts above the report. Use the same scope for both balances and every movement. A bridge of checking accounts cannot reconcile directly to a statement balance that also includes cash equivalents or restricted cash unless those differences are addressed.

The SEC's guide to financial statements describes cash flow statements in three activity groups: operating, investing and financing. Those groups also provide a useful structure for a management cash bridge. The existing cash flow statement example covers the statement layout; this method focuses on explaining the balance movement.

The example below covers a US distributor's USD checking accounts for September 2026. Opening cash is $200,000, independently confirmed closing cash is $230,000, and there are no foreign-currency accounts or exchange-rate effects. Transfers between included accounts have been removed in matched pairs.

Prepare an export with signed cash amounts

Start from settled bank movements, supported by the cash ledger for categorization. Retain references so each summarized line can be traced back. For an actual bridge, an invoice issued but not collected is not a cash receipt, and an unpaid equipment invoice is not a cash payment.

Create a sheet named Raw. Use columns A through D exactly as shown, with the header in row 1 and transactions in rows 2 through 8. Amounts are positive for cash entering the included accounts and negative for cash leaving them.

This is a deliberately small export so every movement remains visible. For a larger ledger, keep the same fields and extend the ranges to include every row. Resolve unknown classifications before reporting; leaving an activity blank can produce a bridge that silently excludes transactions.

The principal payment and debt proceeds are separate financing components. For the provider-side measure, see cash flow to creditors; cash flow to owners covers the distribution measure. Neither needs to replace the signed transactions in this bridge.

Build the bridge in Excel or Google Sheets

Create a sheet named Bridge with activity labels in A2:A6 as shown below. Column B contains the opening balance or signed movements; column C contains the running balance. The formulas use the matching-criteria sum documented by Microsoft and Google.

B2 = 200000
B3 = SUMIFS(Raw!$D$2:$D$8,Raw!$C$2:$C$8,A3)
B4 = SUMIFS(Raw!$D$2:$D$8,Raw!$C$2:$C$8,A4)
B5 = SUMIFS(Raw!$D$2:$D$8,Raw!$C$2:$C$8,A5)
B6 = SUM(B2:B5)
C2 = B2
C3 = C2+B3
C4 = C3+B4
C5 = C4+B5
C6 = C5

Operating cash is $450,000 minus $260,000 minus $100,000, or $90,000. Investing uses $80,000. Financing supplies $60,000 less $30,000 of principal and $10,000 of distributions, or $20,000.

The net movement is therefore $90,000 minus $80,000 plus $20,000, or $30,000. Add it to opening cash of $200,000 to reach $230,000. All amounts are exact whole dollars, with no rounding.

For a waterfall chart, opening and closing cash are total bars. Operating, investing and financing are floating movement bars; closing cash is not another inflow. The table already contains the values needed to explain the movement without a chart.

Reconcile every transaction and the ending balance

Enter the independently confirmed closing cash of 230000 in E2 on Bridge. Run these checks outside the table:

=SUM(B3:B5)-SUM(Raw!D2:D8)
=B6-E2
=C5-B6

Each returns zero. The first checks that the grouped movements equal the export total. The second checks the bridge against the bank balance. The third checks that the running total agrees with the stated closing cash.

A zero total does not prove each transaction is classified correctly. Also match row references to the export, review blank categories and inspect unusual entries. The IRS guide to business records explains checking-account reconciliation, including bank charges and errors; unexplained differences need investigation rather than a balancing entry called other.

If the bridge includes foreign-currency accounts, translating opening and closing balances can create an exchange-rate effect. Show that supported amount separately and extend the identity and formulas. Do not label the difference operating cash simply to make the ending balance match.

Turn the movement into a management question

Here, operations generated $90,000 while equipment consumed $80,000. Financing added $20,000, and cash increased by $30,000. That makes the financing contribution visible rather than attributing the whole increase to trading performance.

As a single-input sensitivity, change the equipment payment from $80,000 to $100,000 and leave every other row unchanged. Investing becomes negative $100,000, net movement falls to $10,000, and closing cash becomes $210,000. The $20,000 reduction in closing cash comes entirely from the larger equipment payment.

Finance owns the reconciliation, with treasury confirming bank balances and the controller reviewing activity classifications. Use the explanation to ask whether collections, spending or financing changed as expected. For future payment timing, move to the cash flow forecast method rather than treating the historical bridge as a prediction.

Where a cash flow bridge goes wrong

• Starting with different account scopes. An account included only at period end creates an apparent movement that needs explanation.
• Mixing profit and cash. Do not add depreciation or net income to a bridge already built from direct bank transactions.
• Counting internal transfers. Matched transfers inside the account boundary create no change in company cash.
• Reversing payment signs twice. A negative bank debit remains negative when it enters the movement column.
• Forcing the residual into operations. Missing transactions, exchange effects and scope differences need their own documented treatment.

Covirage is not affiliated with Microsoft or Google.

Reconcile your cash movement in Covirage

Upload your cash transaction export or Google Sheet with the opening and closing balances so Covirage can map the columns and its tools can compute and check the bridge. The external AI model explains the categorized movements, with every figure traced to its rows. Create a free Covirage account and bring a sample of your own data.

See finance planning and reporting for the supporting business context.