Guidance Note: Validation and verification of the '3.8 SAC Netted Exposures' Sheet (JIBs)

Summary

This guidance note explains the automated and manual validation checks the JFSC applies to the '3.8 SAC Netted Exposures' sheet of the JIB (Jersey Incorporated Bank) prudential reporting template. It describes how Excel-based data entry restrictions work, how submissions are checked on receipt, and how error and warning messages relate to specific numbered checks.

• Input limits: Monetary amount cells only accept whole numbers between -1,000,000,000 and +1,000,000,000 (in units of £1,000), unless otherwise noted.
• Excel checks are not a failsafe: Validation only runs on direct input or manual request, so JIBs must check their own data before submission; the JFSC also checks data on submission.
• Submission process: Submitting the template triggers the JFSC's checks; if all pass, the JIB is notified of acceptance along with any warnings.
• Error messaging: Each check has a unique identifier ('Check' number) referenced in failure messages so the JIB can match the error to this guidance note.
• Checks listed: Section 2 sets out specific validation checks for cells on the '3.8 SAC Netted Exposures' sheet, covering Amount, Positive Mark-to-Market, Add-on Amount and Credit Equivalent Amount fields, each requiring a whole number in the stated range.

The note is purely explanatory and technical, intended to help JIBs correctly complete and submit this section of the reporting template rather than imposing new substantive requirements beyond existing prudential reporting obligations.

Key obligations

• JIBs should check their own data for accuracy before submitting the '3.8 SAC Netted Exposures' sheet, as Excel validation alone is not a failsafe.
• Monetary amount entries on the sheet must be whole numbers within the range -1,000,000,000 to +1,000,000,000 (representing units of £1,000) unless otherwise noted.

Applies to

JIBs (Jersey Incorporated Banks)