Build a Trial Balance Report with OfficeConnect (Financials)
Build a live trial balance in Excel using OfficeConnect’s Financials data source — pulling posted GL actuals directly from Workday Financial Management.
Financials Data Source
Build OfficeConnect reports against Workday Financial Management (GL actuals) — for accounting teams reporting on posted transactions.
This section covers OfficeConnect with the Financials data source — Workday Financial Management’s general ledger actuals. If your organization uses Workday Financial Management alongside Adaptive Planning, accounting teams use this data source to report on posted journal entries, trial balances, and actuals by cost center.
Not sure which data source you’re on? See Adaptive Planning vs. Financials Data Source for a full comparison.
Drill Through to Workday Journal Lines from OfficeConnect
Use OfficeConnect’s Show Details feature to see the individual journal lines behind any GL balance — and drill through to the source transaction in Workday.
Build an Actuals Trend Report in OfficeConnect (Financials)
Build a 12-month GL actuals trend report in minutes — the same report that takes hours to configure in Workday’s native report writer.
Report on Actuals by Cost Center
Filter an OfficeConnect Financials report to a specific cost center or worktag to see GL actuals for a single department or team.
Use Effective Date Reporting After a Reorganization
Use OfficeConnect’s effective date setting to report against your organization’s structure as it existed on a specific date — essential after a reorganization.
Filter Reports by Company in OfficeConnect (Financials)
Scope an OfficeConnect Financials report to a specific legal entity, or build a multi-company view showing each entity in its own column.
Report on Intercompany Eliminations in OfficeConnect
Use OfficeConnect’s Financials data source to report on intercompany transactions and eliminations — with options to include or exclude eliminations from consolidated views.
Multi-Currency Reporting with the Financials Data Source
Report in your chosen currency using Workday Financial Management’s currency conversion — select transaction currency, company currency, or a converted reporting currency in OfficeConnect.
Build a Balance Sheet with OfficeConnect (Financials)
Build a formatted balance sheet in Excel using OfficeConnect’s Financials data source — assets, liabilities, and equity drawn live from Workday Financial Management.
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.
Month-End Close Workflow with OfficeConnect
Use OfficeConnect to run a faster month-end close — verify trial balances, check journal completeness, and produce final financial statements directly from Workday Financial Management.
Variance Analysis by Journal Source in OfficeConnect
Break down account variances by journal source in OfficeConnect — see how much of a balance movement came from manual journals, system-generated entries, or specific subledgers.
Report on Worktag Combinations in OfficeConnect
Build reports that slice GL actuals by multiple Workday worktags simultaneously — Cost Center and Fund, or Cost Center and Project — using OfficeConnect’s dimension filters.
Reconcile OfficeConnect Values to Workday Reports
Troubleshoot and explain differences between OfficeConnect figures and Workday Report Writer output — common causes of discrepancies and how to resolve them.