u/Acceptable_Tap567

For those using Workday Financials, how are you leveraging organization roles specifically for reporting access?

Do you find that having a Cost Center Analyst role (or equivalent) is enough for most financial reporting needs, or have you created/used additional roles to provide more granular access?

For example, do you assign separate analyst/reporting roles at the Cost Center, Gift, Grant, Project, Program, or other organization/worktag level?

Would love to hear what your org-role/security model looks like and what has worked well—or become difficult to maintain.

I have a question for Workday report writers:

Do you ever feel like being the “report person” becomes a career dead end?

A lot of requests I get aren’t actually report limitations—they’re Workday design/security constraints.

Examples:

• Trying to cram 20 control fields into a composite report
• Requesting segmented access to PCard verification data that security won’t support

But users often hear: “the report writer can’t do it.”

How do you handle that perception?

how do you reposition yourself?

I’m trying to implement a rule-based text matching approach in Workday Worksheets similar to what I can do in Excel with dynamic arrays.

In Excel, I’m able to:

• Search a text string against a list of keyword rules
• Evaluate all rules at once using SEARCH with a range
• Identify matches (ISNUMBER)
• Then return the best match (e.g., first match or longest match)

However, this approach does not appear to work in Workday Worksheets when passing a range into functions like SEARCH. The formula works correctly in Excel, but generates an error in excel when used as a formula column added to a live data ("The formula returned an error: The lookup array and return array must have the same number of rows.. The error type is #VALUE!."

Below is the excel formula:

=LET(txt,J4,ruleA,Rules!$A$2:$A$5000,ruleB,Rules!$B$2:$B$5000,XLOOKUP(TRUE,ISNUMBER(SEARCH(ruleA,txt)),ruleB,""))

I’m working with a client where some cash receipt / AR transactions are being “reconciled” through manual journal entries instead of using Workday bank reconciliation functionality (First Notice rules, Ad Hoc Bank Transactions, or manually matching/reconciling the bank statement lines).

Example:

• A bank transaction comes in on the statement
• Instead of matching/reconciling the line in Workday Bank Reconciliation, the AR team books a manual journal entry against cash/AR
• The original bank statement line therefore remains permanently in an “Unreconciled” status in Workday

From my perspective, this seems problematic because the bank statement activity and reconciliation process become disconnected from the accounting entries.

My questions:

• Are there downstream impacts or risks to leaving bank statement lines unreconciled indefinitely?
• Have others seen this approach used in practice?
• Does this create audit, reconciliation, reporting, or operational issues later on?
• Would you consider this an anti-pattern in Workday Banking & Settlement?

How can we provide Cost center managers access to project/gift/grants statement and make sure they only have access to those projects/gifts/and grants related to their cost centers.

many suggest to assign them specific gifts/grants/projects roles but it can become frustrating having to assign all these roles.

any idea?