Build a Cash Flow Statement with OfficeConnect (Financials)

Build an indirect-method cash flow statement in Excel using OfficeConnect’s Financials data source — operating, investing, and financing activities from Workday Financial Management.
Tags:

A cash flow statement built in OfficeConnect pulls balance changes and net income directly from Workday Financial Management, eliminating the manual work of reconciling figures from Workday Report Writer into Excel. This tutorial builds an indirect-method statement — the most common format for external financial reporting.

What you’ll build: A cash flow statement with Operating, Investing, and Financing Activities sections, all refreshable from Workday Financial Management.

What you’ll need:

  • OfficeConnect connected to the Financials data source
  • Workday Financial Management with a current period closed and journal entries posted
  • A completed balance sheet workbook is helpful for cross-referencing — see Build a Balance Sheet

Step 1 — Set up the version and period

1
Open Excel and activate OfficeConnect Open Excel, click OfficeConnect, and sign in. The Reporting pane should show the Financials data source.
2
Add version and time context Click B1 and drag Actuals from the Reporting pane. Click B2 and drag your reporting period (for example, Q2 2026 or the full fiscal year). Cash flow statements cover a period of activity, so use a range period (a full quarter or year) rather than a point-in-time date.

Step 2 — Operating activities (indirect method)

3
Add the Net Income starting line In A5, type OPERATING ACTIVITIES. Bold and underline. In A6, drag Net Income from the Reporting pane. This is the starting point for the indirect method — all adjustments are added or subtracted from net income.
4
Add non-cash adjustments In A7, drag Depreciation and Amortization (a non-cash expense — added back to net income). In A8, type Changes in Working Capital and bold it as a sub-section header.
5
Add working capital changes

In A9–A12, drag accounts that represent working capital changes:

  • A9: Accounts Receivable (change from prior period)
  • A10: Prepaid Expenses (change)
  • A11: Accounts Payable (change)
  • A12: Accrued Liabilities (change)

In A13, drag Net Cash from Operating Activities (the rollup for this section).

6
Populate Operating Activities data cells Click B6 — OfficeConnect creates a formula for Net Income in the selected period. Copy down through B13. Check that working capital change accounts show the period-over-period change, not a point-in-time balance — confirm with your chart of accounts setup.

Step 3 — Investing activities

7
Add investing activities

In A15, type INVESTING ACTIVITIES. Bold and underline. In A16–A17, drag:

  • A16: Capital Expenditures (purchases of PP&E — typically a negative number)
  • A17: Proceeds from Asset Sales (positive)

In A18, drag Net Cash from Investing Activities.

8
Populate Investing Activities data cells In B16, copy the formula structure from B6. Copy down through B18.

Step 4 — Financing activities

9
Add financing activities

In A20, type FINANCING ACTIVITIES. Bold and underline. In A21–A22, drag:

  • A21: Proceeds from Borrowings
  • A22: Repayment of Debt (negative)

In A23, drag Net Cash from Financing Activities.

10
Add net change in cash

In A25, type Net Increase (Decrease) in Cash. In B25, enter a plain Excel formula:

=B13+B18+B23

This sums the three activity sections. In A26, drag Cash at Beginning of Period and in A27, drag Cash at End of Period from the Reporting pane to cross-check the net change.

Step 5 — Refresh and verify

11
Refresh and verify the cash change Click Refresh. Check that B25 (the sum formula) equals B27 minus B26 (Cash End minus Cash Beginning). A discrepancy means a cash account is missing from one of the three sections or is double-counted.
12
Format the statement Apply Accounting number format. Bold all subtotal rows (Net Cash from Operating, Investing, Financing, and Net Increase in Cash). Add a thin border above each subtotal row and a double underline under the Cash at End of Period row.

Next steps