---
title: "Workday Projected Time-Off Balances as of a Future Date"
description: "How Workday Absence Management computes Balance as of Date across accrual frequency methods, pending requests, carryover limits, and lower limits."
url: https://kiweely.com/guides/workday-accrued-time-off-balance-as-of-future-date
---

# How Workday Calculates Projected Time-Off Balances as of a Future Date

Workday computes a projected time-off balance dynamically from the worker’s last stored balance date through the target future date by adding scheduled period accruals, applying carryover and upper accrual caps in sequence, and subtracting both approved and pending time-off requests.

-   **Checked** against Workday on November 15
-   Applies to **Workday Absence Management**
-   7 min read
-   Published November 15
-   By Kiweely

Workday Absence Management calculates a worker’s future time-off balance dynamically—not from a static counter—by starting from the worker’s most recent stored balance snapshot and stepping forward period by period to the requested **As Of Date**. Along the way, the calculation engine evaluates period accruals, carryover forfeitures at balance period boundaries, upper accrual caps, lower balance limits, and every **Approved** or **Pending** time-off request through that date.

When an employee sees a different number on **Absence Balance** (or **Time Off Balance**) than they expected on a future holiday date, the discrepancy almost always traces back to period boundary timing, unapproved requests in the queue, or a stale stored balance snapshot.

## The Projected Balance Formula in Workday UI

On a time-off plan configured with **Track Balance** enabled (`Create Time Off Plan` / `Edit Time Off Plan`), Workday renders the **Projected Balances** grid during **Request Time Off**, **Revise Time Off**, and **Review Time Off Corrections** tasks:

$$\\text{Available} = \\text{Accrued (through As Of Date)} - (\\text{Approved Requests} + \\text{Pending Requests})$$

$$\\text{Remaining} = \\max(\\text{Available} - \\text{Paid Units in Current Request},\\ \\text{Time Off Lower Limit})$$

Four rules govern how Workday populates the **Projected Balances** columns:

1.  **Saved for Later Excluded:** Requests in `Saved for Later` status do not deduct from `Available`. As soon as a worker clicks **Submit**, the pending event immediately reduces `Available` for any future **As Of Date** on or after that request.
2.  **Lower Limit Floor on Remaining:** If `Time Off Lower Limit` is `0` and `Unpaid Time Allowed?` is `Yes`, a worker with `6` available hours who requests `8` hours sees `Remaining: 0` and (for reviewers) `Unpaid: 2`. If `Time Off Lower Limit` is `-4`, requesting `8` hours against a `6`\-hour balance yields `Remaining: -2` and `Unpaid: 0`.
3.  **Corrections Show the Delta:** When a worker corrects an already approved request from `4` hours to `6` hours, `Available` already reflects the approved `4` hours, and `Requested` displays `+2` (or `-2` when reducing from `6` to `4`).
4.  **Termination Adjustments Included:** If an active future-dated termination exists for the worker and termination adjustments are enabled on the plan, projections on or after the termination date reflect those adjustments.

## How Period Timing, Carryover, and Caps Change Future Numbers

Workday does not simply multiply a monthly rate by the number of months until the future date. It simulates every absence period along the plan’s **Period Schedule** and **Balance Period** in strict chronological sequence.

| Configuration Setting | Task / Location | Effect on Future Projected Balance |
| --- | --- | --- |
|  **Accrual Frequency Method: Start of Period** | `Edit Time Off Plan` or `Edit Accrual` | Adds the period’s accrual first, enforces the **Upper Limit** (forfeiting excess hours immediately), then deducts time off taken during that period, and finally checks the **Lower Limit**. |
|  **Accrual Frequency Method: End of Period** | `Edit Time Off Plan` or `Edit Accrual` | Deducts time off taken during the period first, checks the **Lower Limit** (potentially forcing unpaid hours mid-period), then adds the period’s accrual at the period end date, and checks the **Upper Limit**. |
|  **Same-Day Processing Order** | Engine rule on identical date | When carryover, an accrual, and a time-off entry fall on the exact same calendar date, Workday processes **Carryover first**, **Accrual second**, and **Time Off deduction third**. |
|  **Accrual Priority & Time Off Priority** | `Calculation` tab on `Edit Time Off Plan` | Lower priority numbers run first (`Priority = 1` before `Priority = 2`). When two accruals share a plan cap of `120` hours, Priority 1 fills the cap first and Priority 2 forfeits the overflow. |
|  **Carryover Limit at Balance Period Boundary** | `Balance` tab -> `Carryover` section on `Edit Time Off Plan` | When a future projection crosses into a new **Balance Period** (for example, January 1 on a calendar-year plan), Workday caps the carried-over balance at the configured constant or conditional calculation (such as `80` hours, or `120` hours for California workers) before adding new-year accruals. |
|  **Accrual Expiration** | `Concept: Accrual Expiration` / `Override Accrual Expiration` | Grants or carryover balances with an expiration rule drop out of `Available` on dates after their expiration boundary. |

### Worked Example: Start of Period vs. End of Period Near an Upper Cap

Suppose a *Vacation* plan has an **Upper Limit** of `120` hours, accrues `12` hours per month, and a worker starts the month at `110` hours while taking `8` hours of vacation mid-month:

-   **Start of Period:** Workday adds `12` hours on day 1 (`110 + 12 = 122`), trims `2` hours at the `120` upper cap, and subtracts the `8` vacation hours, leaving a projected end-of-month balance of **`112` hours**.
-   **End of Period:** Workday subtracts the `8` vacation hours first (`110 - 8 = 102`), adds `12` hours on the period end date (`102 + 12 = 114`), checks the `120` cap (no forfeiture), and leaves **`114` hours**.
-   **Querying Mid-Month:** If the worker checks their balance **As Of** the 15th of that month on an *End of Period* plan, the current month’s `12`\-hour accrual has not posted yet—it only appears when the **As Of Date** reaches or passes the period end date.

## Stored Balances vs. Retroactive Changes

To prevent timeouts when projecting years of period history, Workday caches checkpoints using the **Schedule Time Off Calculated Balance Process** task (plus an automatic background fallback on the third Sunday of every month at 01:00 local time for plans whose last stored date is more than 13 months old).

When diagnosing an unexpected future balance, check whether a retroactive change occurred **before** the worker’s last stored balance date:

-   **Retroactive Time-Off Requests or Corrections:** Workday automatically accounts for retroactive absence events even if they fall before the last stored balance date.
-   **Retroactive Job Changes or Plan/Accrual Edits:** Workday does **not** automatically invalidate balances stored after a retroactive FTE change, work-state transfer, or accrual-rate edit. You must run **Remove Stored Balances** or **Recalculate Balances for Workers** starting from a date earlier than the retroactive effective date.

To inspect period-by-period math directly in the UI, open the worker’s profile and select **Related Actions** -> **Time and Absence** -> **View Time Off Results by Period**. Inspect the closing balance of the last period of the current year alongside the opening period of the next year to see exact carryover and forfeiture figures.

## Reading Future Projected Balances via Workday APIs

Integrations, custom employee screens, and AI assistants have three supported paths to read time-off balances, but they differ in how they accept an effective future date.

### 1\. Absence Management REST API (`absenceManagement/v5`)

`GET /balances` is the cleanest REST endpoint for projected worker balances because it accepts both `worker` (required) and `effective` (`yyyy-mm-dd`) query parameters, and enforces contextual worker security (`Self-Service: Time Off Balances`, `Self-Service: Leave of Absence Entitlements`, or manager/admin `Worker Data: Time Off` domains):

http

```
GET /ccx/api/absenceManagement/v5/{tenant}/balances?worker=3aa5550b7fe348b98d7b5741afc65534&effective=2027-07-15&category=7bd6531c90c100016d4b06f2b8a07ce
Accept: application/json
```

Key parameter behavior on `GET /balances`:

-   `worker`: Workday ID (WID) of the worker.
-   `effective`: Target projection date in `yyyy-mm-dd` format (for example, `2027-07-15`). Workday runs the absence calculation engine through that date and returns dynamic balances per eligible plan.
-   `category`: Optional WID filter restricting results to **Time Off** (`7bd6531c90c100016d4b06f2b8a07ce`), **Leave of Absence Type** (`17bd6531c90c100016d74f8dfae007d0`), or **Absence Table** (`17bd6531c90c100016da3f5b554007d2`).

To pair the projected balance with the individual approved or pending dates subtracting from it, call `GET /workers/{ID}/timeOffDetails?fromDate=2026-11-15&toDate=2027-07-15`.

### 2\. Custom RaaS Report with Effective Date Prompt

If your organization needs custom columns—such as Accrued YTD, Carryover Remaining, Pending Units, and Projected Ending Balance side by side—build a custom report on a time-off balance data source (such as `timeOffPlanCalculatedAndOverrideBalancesForWorker` or `calculatedBalancesForOrganizationByWorker`), expose the report’s **Effective Date** prompt, and enable **Enable as Web Service**. Pass the future date to the RaaS JSON endpoint under the caller’s OAuth session.

### 3\. SOAP `Get_Time_Off_Plan_Balances` (`Absence_Management`)

The `Get_Time_Off_Plan_Balances` SOAP operation retrieves dynamic Time Off Plan Balances by `Employee_Reference`, `Time_Off_Plan_Reference`, or `Organization_Reference` with `Contextual Security: Yes`. Use `Response_Filter` (`As_Of_Effective_Date`) when querying balance state as of a target date from SOAP-based integrations.

## Diagnostic Checklist for Mismatched Future Balances

1.  **Check Pending Events:** Open the worker’s **Absence Requests** (or **Time Off and Leave Requests**) tab and filter for `Submitted` / `In Progress` requests between today and the target date.
2.  **Verify Period End Date vs. Target Date:** Confirm on `Edit Time Off Plan` whether the accrual posts at `Start of Period` or `End of Period`. Asking for a balance as of August 14 on a semi-monthly `End of Period` schedule excludes the August 15 accrual.
3.  **Check Year-End Carryover Boundary:** If the target date crosses into the next **Balance Period**, inspect `View Time Off Results by Period` across the boundary period to verify how much unused balance forfeited at midnight.
4.  **Check Hours-Worked Accruals:** Plans whose accrual calculation sums `Payroll Hours Related Result Lines for Period` accrue zero hours in future uncalculated pay periods because future payroll results do not exist yet—only scheduled fixed/rate accruals project automatically into future periods.
5.  **Check Stored Balance Snapshots:** Run `View Schedules for Time Off Calculated Balance Process` and recalculate the worker’s balances if a retroactive FTE or eligibility edit predates the last stored snapshot.

When employees ask “How many vacation hours will I have on July 15 if I take three days in March?”, tools like [Kiweely Bridge](https://kiweely.com/bridge) and custom absence screens built on [Kiweely Leaf](https://kiweely.com/leaf) (both coming next) pass the exact future `effective` date to Workday live under the employee’s own `Self-Service: Time Off Balances` permission rather than estimating accrual math outside the tenant.

## Frequently asked questions

### Does Workday include pending unapproved time-off requests in future balance projections?

Yes. Workday calculates Available time off as Accrued time minus both Approved and Pending time-off requests up to and including the target date. Requests with a status of Saved for Later are excluded.

### Why does changing Accrual Frequency Method from Start of Period to End of Period change a worker's projected balance?

Start of Period adds the period accrual and applies the upper accrual cap before subtracting time off taken in that period, whereas End of Period deducts time off and checks the lower limit before adding the period accrual.

### Why did a retroactive accrual rate change not update a worker's projected balance?

Workday does not automatically recalculate stored balances when job or plan configuration changes take effect before the worker's last stored balance date. Run Remove Stored Balances or Recalculate Balances for Workers from a date prior to the change.

### Which REST API parameter returns a worker's projected absence balance for a future date?

Pass the future date in yyyy-mm-dd format to the effective query parameter on GET /balances in the absenceManagement/v5 REST API along with the required worker Workday ID.

## Sources checked

-   [Workday Concept: Balance Projections for Time Off](https://doc.workday.com/admin-guide/en-us/human-capital-management/absence/time-off/time-off-plan-balances/dan1370797344039.html)
-   [Workday FAQ: Time Off Balances](https://doc.workday.com/admin-guide/en-us/human-capital-management/absence/time-off/time-off-plan-balances/tef1502717438935.html)
-   [Workday Concept: Accrual and Time Off Limits](https://doc.workday.com/admin-guide/en-us/human-capital-management/absence/time-off/set-up-accruals-period-schedules-and-balances/dan1370796789969.html)
-   [Workday Example: Calculate the Carryover Limit for a Time Off Plan](https://doc.workday.com/admin-guide/en-us/human-capital-management/absence/time-off/examples-time-off-setup/flm1629400630930.html)

## Related guides

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

-   [### Why Workday Absence Balances or Time Calculations Don’t Update After a Retro Job Change Workday keeps prior stored absence balances when a retroactive job change precedes the last stored balance date, and it skips automatic time recalculations after eligibility changes. Run Recalculate Worker Time Off Balances and Run Time Calculations for a Date Range to update both.](https://kiweely.com/guides/workday-time-tracking-absence-retro-recalculation-errors)
-   [### Should I use RaaS, WQL or the REST API to extract data from Workday? Use RaaS for a saved report’s output, WQL for a filtered, grouped or paged extract of up to 1 million rows, and REST for small, low-latency reads of one resource. Limits and sources are in the table.](https://kiweely.com/guides/workday-raas-wql-rest)
-   [### Why does my Workday calculated field return blank in a report? A calculated field returns blank when its function finds nothing to return, when its business object is not reachable from the report, or when the viewer cannot see a field it reads. Test one known instance first.](https://kiweely.com/guides/calculated-field-returns-blank)

### More guides on More Workday guides

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

-   [Resolving SSO Redirect Loops on the Workday OAuth Authorize Endpoint](https://kiweely.com/guides/workday-sso-saml-oidc-loop-external-oauth-authorize-endpoint)
-   [Managing Workday OAuth Refresh Token Expiration, Rotation, and Revocation](https://kiweely.com/guides/workday-oauth-refresh-token-expiration-rotation-revocation)
-   [Fixing Workday OAuth invalid\_client, unauthorized\_client, and Redirect URI Errors](https://kiweely.com/guides/workday-oauth-invalid-client-unauthorized-client-redirect-uri)
-   [Handling Hourly vs. Salaried Workday Absence Plans: Hours, Days, and Partial-Day Requests](https://kiweely.com/guides/workday-hourly-vs-salaried-absence-balances-hours-vs-days)
-   [How to Configure User-Delegated OAuth 2.0 Authorization Code Grant in Workday](https://kiweely.com/guides/workday-authorization-code-grant-user-delegated-oauth-setup)
-   [Troubleshooting Workday Compensation Cycle Eligibility, Proration, and Bonus Rounding Mismatches](https://kiweely.com/guides/workday-advanced-compensation-eligibility-bonus-rounding-errors)
-   [How to Fix Workday ACA 1095-C Code 2C Mismatches and Update Annual Affordability Thresholds](https://kiweely.com/guides/workday-aca-1095c-errors-affordability-setup)
-   [How to Reopen Workday Open Enrollment for One Employee After the Window Closes](https://kiweely.com/guides/workday-reopen-open-enrollment-single-worker)

### From the blog on More Workday guides

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

-   [Official Workday MCP vs third-party Workday MCP](https://kiweely.com/blog/official-workday-mcp-vs-third-party-mcp)
-   [What is Kiweely for Workday?](https://kiweely.com/blog/what-is-kiweely-for-workday)
-   [Employee Workday Q&A in ChatGPT without oversharing](https://kiweely.com/blog/employee-workday-qa-in-chatgpt-without-oversharing)

## Let Workday check the work.

Kiweely writes WQL and builds orchestrations in your own tenant, and Workday, not Kiweely, says whether they passed.

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

## Get the next guide in your inbox.

One email a month with new guides and one Extend tip. Nothing else.
