Validation and verification of the '9.2 Parent Accounts' Sheet (2019-09)

Summary

This is technical guidance from the JFSC explaining the automated validation and verification checks that run when an Other International Bank (OIB) submits the '9.2 Parent Accounts' sheet as part of its prudential reporting. It lists the specific cell-level checks, the error messages that will be returned if a check fails, and how those checks map to unique 'Check' reference numbers so a submitter can identify and correct the issue.

• Data entry checks: Sets out required formats for each cell in the sheet: certain text cells must be left blank, month fields must be between 1 and 12, year fields must be the current year or no more than two years prior, and monetary value fields must be whole numbers within specified ranges (e.g. -1,000,000,000 to +1,000,000,000, or -10,000,000,000 to +10,000,000,000 for some items).
• Calculation checks: Explains that certain cells (e.g. item A.4.0) are calculated automatically via a formula (sum of related cells) and are checked accordingly rather than manually entered.
• Submission process: Confirms that submitting the template to the JFSC triggers these checks; if all checks pass, the submission is accepted and the OIB is notified together with any warnings.

The note reminds OIBs that Excel's built-in validation is limited and only checks direct manual input, so it should not be relied upon as a failsafe; OIBs are expected to check their own data before submission, in addition to the JFSC's own checks on receipt.

Key obligations

• OIBs should check their prudential reporting data for accuracy and correct formatting before submitting the '9.2 Parent Accounts' sheet, since Excel's built-in validation only checks direct manual input and is not a failsafe.
• Certain designated cells in the '9.2 Parent Accounts' sheet must be left blank as specified.
• Monetary value cells must contain whole numbers within the specified ranges (e.g. -1,000,000,000 to +1,000,000,000, or -10,000,000,000 to +10,000,000,000 depending on the item).
• Month and year fields must fall within the stated constraints (month between 1 and 12; year equal to the current year or no more than two years prior).

Applies to

OIBs (Other International Banks subject to JFSC prudential reporting requirements)