Bulk Calculate FRS 102 Transition Balances

Calculate FRS 102 transition opening balances for many leases in one click, instead of one at a time.

When To Use Bulk Calculate

If you are bringing 10 or more existing operating leases onto the balance sheet under FRS 102 Section 20, Bulk Calculate runs the same modified retrospective math as the single-lease Calculate, just batched. Every lease in the batch shares one transition date; the discount rate is set per lease, pre-filled from each lease's own maintained rate.

Selecting Leases

On the Transition screen, every lease in the Required group has a checkbox in the leftmost column. The header checkbox selects every visible Required lease in one click. The action bar at the top of the table shows your selection count and a Calculate Selected (N) button. Only Required leases are selectable; Transitioned, Post-Transition, and Concluded leases are not (they either already have opening balances or do not need them).

Running The Calculation

The Bulk Calculate modal takes one transition date for the whole batch and a discount rate per lease. The Rate column is pre-filled from each lease's own maintained rate and every cell is editable, exactly like the Prepaid and Accrued columns; each lease's prepaid and accrued rent come from its lease record (set by AI extraction at import, or by manual edit). The optional Batch Rate box is a fill tool: Fill blanks enters the batch rate only into leases with no rate, and Replace all rewrites every rate in the column after telling you how many existing rates that replaces. The Calculate button stays disabled while any lease is missing a rate. The endpoint loops the same calculation logic the single-lease Calculate uses, so opening liability, opening right-of-use asset, and the prepaid/accrued reclassification are computed identically.

FRS 102 Reference: FRS 102 para 1.51(a)

Reading The Results

The result panel shows a Total / Succeeded / Failed count and two tables: per-lease success rows with opening liability, opening ROU, and the prepaid/accrued reclassification; and a failure list with a one-line reason per lease. A failure for one lease does not roll back the others.

One rate or many?

FRS 102 asks for a rate for each lease at the transition date (para 1.51(a)), and para 1.53(a) permits a single rate across a portfolio of leases with reasonably similar characteristics, such as a similar remaining term, asset class and economic environment. If you apply one rate to the whole batch, the modal reminds you of that condition; where the leases differ, keep their individual rates in the Rate column.

Audit Trail

Each successful calculation is recorded as a transition event in the Audit Trail, tagged as part of the batch (bulk_batch=true, bulk_batch_size=N), so you can group the operation when reviewing audit history.

FRS 102 Reference: FRS 102 para 1.47-1.53

Back to FRS 102 Transition