GN JIBs 10.1 Funding Concentrations Validation and Verification (March 2019)

Summary

This is a technical guidance note explaining the automated validation and verification checks applied to the '10.1 Funding Concentrations' sheet within the JFSC's liquidity supporting data submission template for Jersey International Banks (JIBs). It does not create new reporting obligations but documents how data entered in that sheet is checked for accuracy and format on submission.

• Input validation: Monetary amount cells across all funding concentration line items (SCP.1-15, SP.1-15, SC.1-5, etc.) accept only whole numbers between -1,000,000,000 and +1,000,000,000, expressed in units of £1,000.
• Excel limitations: Excel's built in validation only checks data on direct manual input, so it is not a failsafe; JIBs must check their own data, and the JFSC re-checks it upon submission.
• Submission process: When the template is submitted, the JFSC's checks run automatically; if all checks pass the submission is accepted and the JIB is notified together with any warnings.
• Calculated fields: Funding Total columns are automatically calculated via a formula summing the relevant time-band columns for each item, and are not subject to manual input validation.
• Error identification: Each validation test has a unique 'Check' identifier included in any failure message, allowing the JIB to match the error to the corresponding entry in this guidance note.

Overall, the note is a reference document for completing the funding concentrations sheet correctly rather than a source of new compliance duties; the underlying obligation to submit accurate liquidity supporting data to the JFSC arises from the JIB prudential reporting framework this guidance supports.

Key obligations

• JIBs should check their own funding concentration data for accuracy before and after entry, since Excel validation is not a failsafe.
• Monetary figures entered on the 10.1 Funding Concentrations sheet must be whole numbers within the range -1,000,000,000 to +1,000,000,000 (in £1,000 units).

Applies to

Jersey International Banks (JIBs)