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.
Tags:

When a number in your OfficeConnect report doesn’t look right, you don’t need to leave Excel. OfficeConnect’s Show Details feature opens a panel showing every journal line contributing to that cell’s balance. From there, you can drill through directly to the transaction in Workday Financial Management.

What you’ll need:

  • OfficeConnect connected to a Financials data source tenant
  • A report with at least one populated cell (actuals data for a ledger account, company, and period)

Step 1 — Build or open a Financials report

1
Open a report with Financials data Open any OfficeConnect workbook using the Financials data source and click Refresh to ensure cells are populated. If you need to build one from scratch, follow Build a Trial Balance Report first.

Step 2 — Open Show Details

2
Right-click a populated cell Right-click any cell containing an OfficeConnect Financials value (a cell with a balance, not a header or label cell).
3
Select Show Details In the context menu, click Show Details. A detail pane opens below or beside your report (depending on your OfficeConnect layout settings). This pane lists every journal line that contributed to the cell’s balance.
4
Review the journal lines

The Show Details pane shows each journal line with columns including:

  • Journal Source — where the entry originated (e.g., Accounts Payable, Payroll)
  • Journal Date — the accounting date of the entry
  • Ledger Account — the account charged
  • Amount — the debit or credit amount
  • Memo — the journal line description if one was entered

Step 3 — Drill through to Workday

5
Click a journal line to drill through Click any row in the Show Details pane. OfficeConnect opens the corresponding transaction in Workday Financial Management in your default browser — logged in as your current Workday user.
6
Review the source transaction In Workday, you’ll see the full accounting journal: all lines, the journal source, the preparer, any attachments, and the approval chain. This is the authoritative source of the posted entry.

Note: Drill-through requires that your Workday user account has access to view journals in Workday Financial Management. If the Workday page shows an error or access denied message, contact your Workday Security Administrator to verify your security role includes journal viewing permissions.

What Show Details vs. Explore Cell means

If you’re switching between Adaptive Planning and Financials tenants, note that the right-click menu is different:

Data SourceRight-click optionWhat it shows
FinancialsShow DetailsContributing journal lines, with drill-through to Workday
Adaptive PlanningExplore CellContributing dimension splits within the Adaptive Planning model

See Adaptive Planning vs. Financials Data Source for a full comparison.

Next steps