Concept: Reporting on the Financial Modeled Data Source

Workday provides the financial reporting data model that you can set up to create the financial modeled data source. You can use the financial modeled data source in OfficeConnect to query Workday Financial Management data directly, enabling easy, performant reporting.

OfficeConnect is a Microsoft Excel add-in that enables you to create reports in Excel securely using up-to-date financial data in Workday directly from the financial modeled data source. With OfficeConnect, you can create financial reports using the Excel interface you’re familiar with, using data backed by Workday, such as journal lines.

OfficeConnect updates the data when you run or refresh your report in real time. These reports are based on model elements like ledger accounts, time period, and worktags.

You might want to use OfficeConnect to perform ad hoc analysis on journal line data.

When creating and editing a report, you can:

Use Excel formatting capabilities.

Use Excel cell formulas and calculations.

Expand and collapse hierarchies in the data model.

Filter Workday data.

Example: You can use OfficeConnect for Financial Reporting to:

Create an income statement.

Create a balance sheet.

Perform ad hoc dimension analysis.

Perform salary and benefit analysis.

Calculate product and customer margin.