---
title: "Query Workday Financials Cost Centers & Spend in AI Chat"
description: "How cost-center managers and FP&A leads query open purchase orders, supplier invoices, and spend categories in Claude or ChatGPT under Workday security."
url: https://kiweely.com/blog/finance-cost-center-budget-vs-actuals-queries-in-claude
---

# Querying Workday Financials Cost Centers, Spend Categories, and Supplier Status in AI Chat

Department heads and FP&A analysts spend days before month-end chasing open purchase order balances, supplier invoice statuses, and spend-category actuals. Running live WQL and RaaS queries under each user’s Workday Financials security puts live spend answers in Claude, ChatGPT, and Gemini.

-   By Kiweely
-   November 15
-   5 min read

Every month-end close, FP&A analysts and Accounts Payable teams field dozens of ad-hoc Slack messages and emails from Cost Center Managers: *“Did we pay the supplier invoice for our Q3 cloud tooling yet?”*, *“How much open obligation is left on Purchase Order PO-40819?”*, and *“Why did Software Spend Category actuals spike in Cost Center CC-310 this month?”* Connecting Claude, ChatGPT, or Gemini to Workday Financials via live WQL and RaaS under each manager’s own Workday security answers those questions immediately—without exporting stale Excel workbooks.

Department leaders own a budget target in Workday, yet many rarely log into Workday Financials except to approve a requisition or expense report. When they need to check remaining budget or answer a vendor’s payment inquiry, navigating Foundation Data Model (FDM) prompts (`Company`, `Book Code`, `Ledger`, `Plan Structure`, `Time Period`, `Cost Center Hierarchy`) feels built for accountants rather than operating managers.

## Matching Financial Questions to Workday’s Data Architecture

Workday Financial Management and Spend Management expose operational transactions cleanly through WQL and REST, while multi-cube **Budget vs. Actuals** comparisons rely on Workday’s Composite Reporting engine. Pairing both gives Cost Center Managers and FP&A teams header-level variance math *and* line-level transactional drill-down:

| Finance / Manager Question | Best Workday Interface | Delivered Data Source / Endpoint | Key Fields Returned |
| --- | --- | --- | --- |
|  *“How is CC-310 tracking against Q4 Plan across Spend Categories, including open PO commitments?”* |  **Web-Service-Enabled Report (RaaS)** | Existing Composite or Matrix Variance Report (`Web Services -> View URLs`, `format=json`) | Ledger Account / Spend Category summary, Plan/Budget amount, Actuals, Obligations (Open POs), Commitments (Open Requisitions), Remaining Variance |
|  *“Which Purchase Orders in my Cost Center still have unpaid open obligation balances?”* |  **Live WQL** (or `procurement/v5` `/purchaseOrders`) | `purchaseOrders` or `purchaseOrderLinesAndLineSplitsIndexed` | `supplier`, `purchaseOrderStatusAsText`, `totalPOAmount`, `amountSpentForSpendSpendAnalysisType` (invoiced), `amountSpentForObligationSpendAnalysisType` (open PO balance), `paymentStatusForReportingTransactionAsText` |
|  *“Has Supplier Invoice INV-88412 been approved and paid yet, and what Spend Category was it coded to?”* |  **Live WQL** (or `accountsPayable/v1` `/supplierInvoiceRequests`) | `supplierInvoices` or `supplierInvoiceLinesAndLineSplitsIndexed` | `supplier`, `operationalTransactionAmountInBaseCurrency`, `paymentStatusForReportingTransactionAsText`, `cf_AmountPaidAsOfReportingDate`, `cf_SpendCategoryFromSupplierInvoiceLines` |
|  *“What are our active Cost Centers, hierarchy parents, and assigned Cost Center Managers?”* |  **Live WQL** | `costCenters` | Cost Center ID, `costCenter_Name`, `costCenter_Manager`, `costCenter_OrganizationTop`, `costCenter_PrimaryLocations` |

### Concrete WQL Drill-Down: Open Purchase Order Obligations

When a marketing or infrastructure director sees `$85,000` tied up in **Obligations** on their budget summary and asks *“Which open POs make up that obligation balance?”*, a live WQL query against `purchaseOrders` retrieves the exact breakdown in real time:

sql

```
SELECT supplier,
       purchaseOrderStatusAsText,
       totalPOAmount,
       amountSpentForSpendSpendAnalysisType,
       amountSpentForObligationSpendAnalysisType,
       paymentStatusForReportingTransactionAsText
FROM purchaseOrders
WHERE purchaseOrderStatusAsText = 'Issued'
  AND amountSpentForObligationSpendAnalysisType > 0
ORDER BY amountSpentForObligationSpendAnalysisType DESC
LIMIT 50
```

Because Workday separates `amountSpentForPotentialSpendAnalysisType` (unapproved/requisition commitments), `amountSpentForObligationSpendAnalysisType` (issued open POs not yet fully invoiced), and `amountSpentForSpendSpendAnalysisType` (accounted invoice spend), the AI assistant can explain in plain English which contracts have unbilled PO headroom that can be closed (`requisitions/{ID}/close` or PO close) before quarter-end vs. invoices already sitting in Accounts Payable.

## Why Reusing Existing Financial RaaS Reports Beats Rebuilding FDM Logic

FP&A teams invest months perfecting Workday **Composite Reports** that align Ledger Actuals (`Actuals` ledger), Procurement Commitments/Obligations, and Plan/Budget versions (including Workday Adaptive Planning or native Workday Budgets) across custom `Book Codes`, elimination rules, and currency translation rates.

Never ask an AI model or external middleware to re-aggregate raw journal lines and guess accounting rules from scratch:

1.  **Reuse Validated RaaS Reports:** Take the exact Budget-vs-Actuals custom or composite report your Controller already signed off on, check **Enable as Web Service** in the report definition, and expose its JSON output (`Prompt%21WID=...&format=json`) as a read tool. Every variance number in chat matches the Controller’s close deck to the penny.
2.  **Drill Down with WQL:** When the manager asks *“Why is Outside Services $22,000 over plan in November?”*, the assistant follows up with a targeted WQL query on `supplierInvoiceLinesAndLineSplitsIndexed` filtered to that Cost Center, Spend Category, and accounting period to list the exact vendor invoices driving the variance.

## Preserving SOX Controls, Cost Center Boundaries, and Supplier Bank Privacy

Finance and Internal Audit teams evaluate any Workday Financials integration against three strict criteria:

-   **Constrained Cost Center Security:** A department head holding `Cost Center Manager` on `CC-310 (Cloud Platform)` must never see spend in `CC-410 (Corporate Development)` or individual salary lines inside payroll journals. Connecting via a user-delegated Workday API client (`Register API Client`, Authorization Code Grant with PKCE)—rather than an Integration System User—forces Workday to evaluate that manager’s exact constrained role-based security group on every RaaS and WQL call.
-   **Zero Supplier Bank Details in Context:** Supplier records in Workday contain tax IDs (`cf_SupplierTaxID`) and settlement bank accounts. Even if an AP specialist holds domain access to view supplier details, financial chat tools should strip supplier bank routing numbers and tax identifiers in RAM so they never enter an LLM prompt window.
-   **Network & Residency Controls for Financial Data:** Public companies subject to SOX IT General Controls (ITGCs) often restrict where financial API calls can originate.

[Kiweely Bridge](https://kiweely.com/bridge) (coming next) is built specifically around these guardrails:

-   Connects to any standard Workday Financials + HCM tenant via user-delegated `Register API Client` OAuth—reaching Workday REST, live WQL, SOAP reads, and your existing web-service-enabled RaaS reports across **Claude, ChatGPT, and Gemini**.
-   Includes an **AI admin agent** that sets up Functional Areas (`Financial Accounting`, `Procurement`, `Supplier Accounts`) in Sandbox, configures RAM field redaction rules, and tests tool boundaries as real personas (`Cost Center Manager`, `Buyer`, `Financial Analyst`).
-   Keeps **zero stored payloads** (tokens sealed with AES-256-GCM on the client; schema-locked logs containing zero dollar figures or vendor names) and offers **Dedicated single-tenant** hosting (with a static outbound IP for Workday `Maintain IP Ranges` and `Manage Authentication Policies`) or a **Self-hosted stateless container** inside your own AWS, GCP, Azure, or Kubernetes VPC.

And when department heads also want a clean browser or Microsoft Teams screen for reviewing open POs and approving supplier invoice requests or expense reports without navigating Workday menus, finance admins can publish custom live views on [Kiweely Leaf](https://kiweely.com/leaf) (coming next) on the same zero-storage, employee-authenticated pass-through architecture.

## Frequently asked questions

### Can a Cost Center Manager see spend or salaries in another department's Cost Center?

No. When the connector uses user-delegated Workday OAuth (Register API Client), Workday enforces the user's constrained Cost Center Manager role-based security group and domain permissions, returning rows only for assigned Cost Centers and subordinate hierarchies.

### When should Finance expose a custom RaaS report instead of raw WQL for Budget vs. Actuals?

Use WQL for fast transactional drill-downs on purchaseOrders, supplierInvoices, and requisitions, and expose existing Composite Reports via RaaS for multi-source Plan/Budget vs. Ledger Actuals + Commitments + Obligations variance structures.

### How can we let engineering or marketing managers check vendor spend without exposing individual employee payroll lines?

Workday Financials separates journal line detail and payroll compensation security domains from procurement and supplier invoice domains, and admins can further strip or exclude payroll ledger accounts in the RaaS definition and connector field policy.

### Does querying Workday Financials in Claude or ChatGPT create an unapproved copy of financial records?

With a stateless pass-through connector like Kiweely Bridge (coming next), responses stream through memory with zero financial payloads, vendor bank details, or prompts stored to disk, databases, or logs, and self-hosted VPC deployment is available for strict SOX perimeters.

## Read next

[All posts](https://kiweely.com/blog)

-   [November 15 ### Stripping National IDs, Bank Details, and Peer Pay in Memory Before AI Sees Them](https://kiweely.com/blog/field-level-redaction-for-workday-ai-national-id-compensation)
-   [November 15 ### Clearing EU GDPR and Works Council Reviews with Pass-Through Workday Architecture](https://kiweely.com/blog/eu-gdpr-works-council-review-pass-through-workday-ai)
-   [November 15 ### Employee Chatbots vs. Custom Workday Screens: When a Chat Thread Isn’t Enough](https://kiweely.com/blog/employee-chatbots-vs-custom-workday-screens-moveworks-leena)

### More guides on More Workday guides

[All 46 guides](https://kiweely.com/guides#more)

-   [Scoping AI Workday Access for Contingent Workers and Alumni](https://kiweely.com/guides/scoping-ai-workday-access-contingent-workers-alumni)
-   [Correlating Workday Audit Events with AI Assistant Tool Calls](https://kiweely.com/guides/correlating-workday-audit-with-ai-assistant-calls)
-   [Workday Cost Centers and Workers to NetSuite After a Reorg](https://kiweely.com/guides/workday-cost-centers-workers-to-netsuite)
-   [Workday Headcount to Snowflake When Data Cloud Is Not Enough](https://kiweely.com/guides/workday-headcount-to-snowflake-beyond-data-cloud)
-   [Performance Check-In and Goals Screens Managers Will Open](https://kiweely.com/guides/performance-check-in-goals-screens-managers-open)
-   [Building an Open Enrollment Decision Screen on Live Workday Elections](https://kiweely.com/guides/open-enrollment-decision-screen-live-workday-elections)
-   [Mandatory Learning and Acknowledgements with Live Workday Status](https://kiweely.com/guides/mandatory-learning-acknowledgements-live-workday-status)
-   [Day-One Tax, Payment Election, and Form I-9 Pages as Pass-Through](https://kiweely.com/guides/day-one-tax-payment-i9-pass-through-pages)

## Your Workday work, done by AI.

Kiweely Vine is the AI agent that builds, deploys and tests Extend apps as real people, makes changes in any Workday task screen, answers from your real tenant and builds reports.

[Start for free](https://kiweely.com/download) [See how it works](https://kiweely.com/vine/how-it-works)

## Get the next one in your inbox.

One email a month for Workday teams: what’s changing in Workday and what to retest, one tip tried in a real tenant, and what’s new at Kiweely.
