The rule in plain words
The sum of assets and liabilities shall add up to the total amount
In column "Amount" (0010) of Memorandum items for SDDTs (CA4 SDDT) (SC04.00.01.01): "Total fair valued assets and liabilities" (row 0870) must equal the sum of "of which: Assets" (row 0880) and "of which: Liabilities" (row 0890).
What to do if your return fails it
- 01Open the table below and find the cells the rule reads.
- 02Add up the parts in your return and compare the result with the total.
- 03If they differ, a part is missing, a value sits in the wrong cell, or the total is out of date.
- 04The Bank of England allows a small rounding difference, worked out from the decimals each value is reported with.
- 05It runs only when your filing indicators mark SC04.00.01 as reported.
- 06This is a blocking check. A return that fails it is normally rejected, so fix it before you submit.
The cells it reads
Memorandum items for SDDTs (CA4 SDDT) (SC04.00.01.01)
Rows
- R0870Total fair valued assets and liabilities
- R0880of which: Assets
- R0890of which: Liabilities
Column
- C0010Amount
A worked example
With simple numbers.
Total fair valued assets and liabilities must then be 2,000.
A file that reports 2,000 passes. One that reports 2,100 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 own funds for SDDTs (PRA116) return on Bank of England banking taxonomy 4.1.1. The Bank of England applies it to own funds for SDDTs (PRA116) returns, as a blocking check.
The Bank’s own words and formula
The first paragraph of the plain words above is the Bank of England’s own, word for word, from its list of validations. The second spells out its formula, with each cell named from its templates.
Show the formulaShowHide
The Bank of England's formula. Cells are written as {t: table, r: row, c: column}.
{t: SC04.00.01.01, r: 0870, c: 0010} = {t: SC04.00.01.01, r: 0880, c: 0010} + {t: SC04.00.01.01, r: 0890, c: 0010}Other rules on Memorandum items for SDDTs (CA4 SDDT) (SC04.00.01.01)
- Memorandum items for SDDTs (CA4 SDDT): the referenced cells shall be exceed or be equal to zero (boe_b1035_ss)Blocking
- Memorandum items for SDDTs (CA4 SDDT): total fair valued assets and liabilities shall not exceed 13 billion (boe_b1034_ss)
- Memorandum items for SDDTs (CA4 SDDT): every value in 75 rows in column "Amount" must be zero or more (boe_b0079_ss)Blocking
- Memorandum items for SDDTs (CA4 SDDT): a total must equal the sum of its parts (boe_b0021_ss)
- Memorandum items for SDDTs (CA4 SDDT): a total must equal the sum of its parts (boe_b0020_ss)
- Memorandum items for SDDTs (CA4 SDDT): a total must equal the sum of its parts (boe_b0019_ss)
Every PRA banking rule on SC04.00.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.
