Guidance Note: Validation and verification of the '9.6 FIRB Detail' Sheet (March 2019)

Summary

This guidance note explains the automated validation and verification checks that apply to the '9.6 FIRB Detail' sheet within the JFSC's prudential reporting template used by Jersey International Banks (JIBs). It describes how Excel-based input restrictions work and how the JFSC re-checks the data on submission, generating error or warning messages if checks fail.

• Input range: Monetary amount and RWA (FIRB and Standardised) cells for each FP line item (FP.1 through FP.26) must contain whole numbers between -1,000,000,000 and +1,000,000,000 (in units of £1,000).
• Excel checks are not sufficient: Excel only validates on direct manual input, so JIBs must independently verify their data rather than relying solely on the spreadsheet's built-in checks.
• Submission process: Submitting the completed template to the JFSC triggers the JFSC's own validation checks; if all checks pass, the submission is accepted and the JIB is notified, along with any warnings.
• Error identification: Each validation test has a unique 'Check' number that appears in any failure message, allowing the JIB to match the error to the specific item and cell described in this guidance.

The note is purely technical and procedural, intended to help JIBs correctly complete and validate this specific data sheet rather than imposing new substantive reporting policy.

Key obligations

• JIBs must ensure that Amount, RWA (FIRB) and RWA (Standardised) entries for each FP line item on the '9.6 FIRB Detail' sheet are whole numbers within the range -1,000,000,000 to +1,000,000,000.
• JIBs should independently check their submitted data rather than relying solely on the Excel template's built-in validation, since Excel only checks validation on direct manual input.

Applies to

Jersey International Banks (JIBs)