Irvine Analytics Get in touch
Analytics Catalog/Workday/Financials/General ledger/Balance as of any date
Explore the catalogModulesGeneral ledgerThe as-of hubLabor cost report
Workday · Financials · Report

The ledger, as of any date

Ask for last March’s balance and most systems rebuild it backwards from today, inheriting every later fix. The stored answer stays what it was, and this page proves it with three month-ends payroll already published.

RuleStore ledger balances daily, per account and worktag set, so any past date answers in one read, exactly as the payroll side already proved.
Neverreconstruct history from current balances and activity. The as-of answer that recomputes is the as-of answer that eventually disagrees with itself.
Balances move daily journals never stop Stored, per day not recomputed later Any date, one read and it always ties
The as-of family, extended to the ledger: the answer is stored the day it was true, so it stays true.
◆ One account, three month-endsthe accrual balance payroll already published.
2100 · Accrued payroll, as ofBalance
31 March 20264,500,345.00
30 April 20264,551,330.00
31 May 20264,663,142.08

Three dates, three balances, and every one is a number this catalog already proves: they are the monthly labor totals the payroll module publishes, seen from the ledger’s side. An as-of answer that ties to another module’s history is the whole point of storing rather than rebuilding. Sample values are illustrative, never client data.

◆ Why stored beats rebuiltthe same argument, every platform.

Rebuilding a past balance from today minus activity inherits every later correction and reclass, which is how two runs of the same question disagree. This catalog documents the identical failure on SAP open items and Oracle stock; the as-of hub collects the family, and the ledger joins it here.

◆ The owned answerfct_ledger_balance, daily, derived and kept.

The GL star’s balance fact is derived from lines and stored per day, so as-of is a filter, audits read the number that was true then, and the monthly proof pins each stored day to the lines beneath it.

Use case
Problem
Auditors ask for balances as they stood, the system rebuilds them from today, and the rebuilt answer drifts from what was reported at the time.
What we build
Daily stored balances per account and worktag set, derived from landed lines, pinned by the monthly proof, answering any date as a filter.
What you get
As-of answers that match what was presented then, audit requests that take minutes, and one more module in the as-of family that behaves.
Can your ledger answer last March in one read?
We build the daily balance store the as-of family runs on.
Talk to us
Terms on this page
GL
General ledger, the books this module lands and proves.
SAP
The sibling platform; its as-of failures are documented in this catalog.
as-of balance
The balance on a stated past date, stored not rebuilt.
rebuilt balance
Today minus activity; drifts with every correction.
daily balance fact
One stored row per account, worktag set, and day.
the as-of family
This catalog’s cross-platform pattern for past dates.