Build Reports

The core capability of Workday OfficeConnect is pulling live Adaptive Planning or Financials data into Excel. Learn how to use the Reporting pane, add accounts and time elements, filter data, and manage report properties.

Where to start

• New to OfficeConnect? Start with the Reporting Pane Tour, then Build Your First Report.
• Ready for FP&A scenarios? Try Rolling 12-Month Report, Budget vs Actuals Variance, or Department P&L Report.
• Reporting on general-ledger actuals? Jump into the dedicated Financials Reports sub-section for trial balance, balance sheet, cash flow, drill-through, intercompany, multi-currency, and the month-end close workflow.
• Working in Word or PowerPoint? Cross over to Word & PowerPoint for board books and linked decks.
• Submitting data back to Adaptive Planning? See Data Entry & Write-Back.

Featured

• Build Your First Report — the 10-step starter walkthrough.
• Quarterly Trial Balance — the Financials section’s flagship recipe.
• Formatted Executive Report — a presentation-ready monthly pack.

Articles in this section

Sub-sections

• Financials — Build OfficeConnect reports against Workday Financial Management (GL actuals) — for accounting teams reporting on posted transactions

Articles

• Reporting Pane Tour — A quick tour of the OfficeConnect interface in Excel — the ribbon tab and the Reporting pane
• Add Elements — How to drag accounts, time periods, versions, and levels into your Excel report
• Time & Contexts — Add time periods to your report and use contexts like YTD, QTD, and Beginning Balance
• Filter Data — Apply worksheet and workbook filters to limit which data appears in your report
• Cut, Copy & Move — How to move OfficeConnect elements within and between rows, columns, and cells
• Review Applied Elements — Use the Review tab to see exactly which elements are affecting any cell, row, or column
• Workbook Properties — Configure rounding, data clearing, filters, and display options for your reports
• Repeating Reports — Automatically generate one copy of a report per department, region, or any other level
• Cell Explorer — Explore the data behind any cell to understand what’s driving the numbers
• Build Your First Report — A complete walkthrough for creating a live Adaptive Planning report in Excel from scratch
• Rolling 12-Month Report — Build a report whose time columns automatically advance each month without manual updates
• Publish to PowerPoint — Link a live OfficeConnect Excel report into a PowerPoint deck so slides update with one refresh
• Budget vs. Actuals Variance — Build an OfficeConnect report that shows budget, actuals, and variance side by side — the most common FP&A report in Adaptive Planning
• Department P&L Report — Build a profit and loss report broken down by department or cost center using OfficeConnect’s Level dimension
• Year-over-Year Trend — Compare this year’s actuals against the prior year month by month using fixed time elements in OfficeConnect
• Compare Planning Versions — Add a second version column to any OfficeConnect report to compare Budget vs. Forecast, two plan iterations, or any two Adaptive Planning versions
• Headcount in Financial Reports — Mix workforce planning metrics (headcount, FTEs, salary cost) with financial accounts in a single OfficeConnect report
• Lock and Protect Reports — Protect an OfficeConnect workbook for distribution so recipients can’t accidentally break formulas — while keeping Refresh working
• Scenario Comparison — Compare planning scenarios side by side in OfficeConnect — useful for showing upside, base case, and downside in the same report
• Constant Currency Reporting — Use a constant currency version in Adaptive Planning to remove FX impact from OfficeConnect reports — useful for multinational teams comparing performance across periods
• Formatted Executive Report — Build a polished, print-ready executive summary report in OfficeConnect with custom formatting, logos, and page layout — ready to share as PDF or Excel
• Custom Dimensions and Attributes — Report on custom dimensions and attributes defined in your Adaptive Planning model — filter by product line, region, project, or any other custom segment your team uses
• Quarterly Board Pack — Build a multi-sheet OfficeConnect workbook — P&L summary, KPI page, variance commentary, cash snapshot — designed to feed directly into a PowerPoint board deck
• KPI Dashboard — Build a single-sheet executive dashboard with six to eight KPI tiles, each pulled live from Adaptive Planning and shown with a prior-period comparison
• OpEx Waterfall — Build a month-over-month OpEx walk showing prior period, adds, reductions, and current period — visualized as an Excel waterfall chart driven by OfficeConnect data
• Forecast Accuracy — Build a report that compares a prior forecast version to actuals and calculates absolute error and MAPE by account and period
• Workforce Plan with Attrition — Build a headcount forecast that layers attrition, hiring plan, and fully-loaded cost per FTE — broken out by organizational level with repeating rows
• Pipeline-to-Revenue Forecast — Build a probability-weighted revenue forecast from pipeline data — stages, probabilities, and expected close dates — using a Pipeline custom dimension in Adaptive Planning
• Multi-Entity Consolidations — Build a consolidated P&L across legal entities with intercompany eliminations called out as a separate column
• Cohort Revenue Retention — Build a SaaS cohort retention report — revenue by signup cohort, retained revenue by month, and net revenue retention percentage — using repeating rows
• CapEx Tracker — Build a project-level CapEx tracker with planned spend, actual spend, forecast remaining, and budget variance — driven by a Project Code custom dimension
• 13-Week Cash Forecast — Build a rolling 13-week cash forecast — weekly receipts, disbursements, and ending balance — in the treasury-standard format used for liquidity planning