Guidance Note: Validation and verification of the '9.3 Additional Detail' Sheet (JIBS-9.3, March 2019)

Summary

This is a technical guidance note from the Jersey Financial Services Commission explaining the validation and verification checks applied to the '9.3 Additional Detail' sheet within the JIBS (Jersey Income and Balance Sheet, prudential) reporting template used by Jersey international banks (JIBs). It does not create new substantive obligations beyond existing prudential reporting requirements, but sets out exactly how submitted data will be checked and what error or warning messages a reporting institution will see if entries fail validation.

• Purpose: Documents the automated Excel and JFSC-side checks run on the '9.3 Additional Detail' sheet each time a JIB submits its prudential return.
• Scope of checks: Covers cells expecting data entry (Sheet name, Sheet Item number, This Quarter and Last Quarter monetary values) for up to 100 additional detail line items (AD.1 to AD.100), each with its own validation rule and cell reference.
• Validation rules: Monetary amount cells must be whole numbers between -1,000,000,000 and +1,000,000,000 (representing up to plus or minus 1 trillion at the £1,000 reporting unit); Sheet entries must match a valid sheet name from the 'Contents' list; Sheet Item entries must be a valid item number of 1 to 7 characters.
• Submission process: Submitting the template triggers the JFSC's checks; if all checks pass the submission is accepted and the JIB is notified along with any warnings; failed checks generate a specific error message keyed to a unique 'Check' identifier that can be matched against this guidance.
• Limits of Excel validation: Built-in Excel validation only applies to direct manual input and is not a failsafe, so JIBs are expected to check their own data in addition to the JFSC's checks on submission.

Overall, the note is a reference tool for compliance and reporting staff at Jersey international banks to understand and resolve validation error messages encountered when completing and submitting the 9.3 Additional Detail sheet as part of periodic prudential reporting.

Key obligations

• JIBs should check their own data for accuracy before and after Excel validation, since Excel checks are not a failsafe.
• Monetary amount entries in the This Quarter and Last Quarter columns must be whole numbers within the range -1,000,000,000 to +1,000,000,000.
• Sheet entries in the Additional Detail sheet must reference a valid sheet name from the 'Contents' sheet list.
• Sheet Item entries must be a valid item number between 1 and 7 characters corresponding to the item for which detail is being provided.

Applies to

Jersey international banks (JIBs)