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.
Tag: Accounting
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.
Set Up Your Reporting Model
Use the Run Set Up Reporting Model task in Workday to configure how OfficeConnect Financials reports are structured.
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.
Financials vs. Adaptive Planning Data Sources
Key differences in Workday OfficeConnect behavior depending on whether you’re using the Adaptive Planning or Financials data source.
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.
Fix Data Discrepancies Between OfficeConnect and Workday
OfficeConnect shows different figures than Workday Report Writer or the Workday UI for the same account and period — common causes and how to diagnose them.
Build a Multi-Entity Consolidations Report
Build a consolidated P&L across legal entities with intercompany eliminations called out as a separate column.