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.
Build a live trial balance in Excel using OfficeConnect’s Financials data source — pulling posted GL actuals directly from Workday Financial Management.
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 a 12-month GL actuals trend report in minutes — the same report that takes hours to configure in Workday’s native report writer.
Filter an OfficeConnect Financials report to a specific cost center or worktag to see GL actuals for a single department or team.
Use OfficeConnect’s effective date setting to report against your organization’s structure as it existed on a specific date — essential after a reorganization.
Scope an OfficeConnect Financials report to a specific legal entity, or build a multi-company view showing each entity in its own column.
Use OfficeConnect’s Financials data source to report on intercompany transactions and eliminations — with options to include or exclude eliminations from consolidated views.
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 formatted balance sheet in Excel using OfficeConnect’s Financials data source — assets, liabilities, and equity drawn live from Workday Financial Management.
Build an indirect-method cash flow statement in Excel using OfficeConnect’s Financials data source — operating, investing, and financing activities from Workday Financial Management.
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.
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.
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.
Troubleshoot and explain differences between OfficeConnect figures and Workday Report Writer output — common causes of discrepancies and how to resolve them.