The rule in plain words
In each of "Forecast - end current year" (column 0010) and "Forecast - end next year" (column 0020) of Balance Sheet: Forecast data [Equity] (FF01.03.01.01): "Total equity and total liabilities" (row 0310) must equal "Total assets" (row 0380) in Balance Sheet: Forecast data [Assets] (FF01.01.01.01).
What to do if your return fails it
- 01Open the tables below and find the cells the rule reads.
- 02The two values must be the same. Find which of the two is right, and correct the other one.
- 03The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 04It runs only when your filing indicators mark FF01.01.01 and FF01.03.01 as reported.
- 05This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Balance Sheet: Forecast data [Assets] (FF01.01.01.01)
Row
- R0380Total assets
Columns
- C0010Forecast - end current year
- C0020Forecast - end next year
Balance Sheet: Forecast data [Equity] (FF01.03.01.01)
Row
- R0310Total equity and total liabilities
Columns
- C0010Forecast - end current year
- C0020Forecast - end next year
A worked example
With simple numbers.
Total equity and total liabilities, Forecast - end current year must then be 1,200.
A file that reports 1,200 passes. One that reports 1,300 fails, by 100.
The numbers are illustrative, reported to the unit, so the rounding tolerance does not change the result.
Which returns it applies to
Line4 Check runs it on the PRA 104, 105, 106, 107 IFRS based balance sheet and profit & loss forecasts (PRA_IFRS) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to PRA 104, 105, 106, 107 IFRS based balance sheet and profit & loss forecasts (PRA_IFRS) returns, as a blocking check.
The Bank’s own words and formula
The plain words above spell out the Bank’s formula, with each cell named from its templates. In the Bank of England’s list of validations, word for word:
boe_v0783_m_1: [FF 01.03.01 (C0010-0020)] {FF 01.03.01, r0310} = {FF 01.01.01, r0380}
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: FF01.03.01.01, r: 0310} = {t: FF01.01.01.01, r: 0380}Where it applies, in the Bank's words (its scope):
scope({t: FF01.03.01.01, c: 0010; 0020, seq: False, f: banking, fv: financialstatements}, {t: FF01.01.01.01, c: 0010; 0020, seq: False, f: banking, fv: financialstatements})Other rules on Balance Sheet: Forecast data [Equity] (FF01.03.01.01)
- Balance Sheet: Forecast data [Equity]: a total must equal the sum of its parts (boe_v0784_m_1)Blocking
- Balance Sheet: Forecast data [Equity]: a total must equal the sum of its parts (boe_v0785_m_1)Blocking
- Balance Sheet: Forecast data [Equity]: "Total equity" must equal the sum of 12 cells (boe_v0780_m_1)Blocking
- "Total equity and total liabilities" must equal the sum of 10 rows in Balance Sheet: Forecast data [Liabilities] plus "Total equity" (boe_v0775_m_1)Blocking
- Balance Sheet: Forecast data [Equity]: every value in the cells it covers must be zero or less (boe_v2060_s_1)Blocking
- Balance Sheet: Forecast data [Equity]: every value in the cells it covers must be zero or more (boe_v3899_s_1)Blocking
Every PRA banking rule on FF01.03.01.01
Checks like this one, run at the point of submission, are the first step to real-time supervision. Line4 builds SupTech software for financial regulators that runs checks like these as each return arrives.
