Malta ANST 08 A specific

How to include the ANT08 A and B NSTs in the annual return:
The new ANST08 (Underwriting/Binding agreements) templates are not currently covered by any of the existing Tabular return setup options. Therefore, at present to include these NSTs in the Tabular return this should be done via the QRT selection tab as ‘include override’ selection:

This can be done when creating new annual 31/12/2017 (or after) returns or editing an existing 31/12/2017 (or after) return.

How to populate the ANT08 A (via N.MT.08.01.01 AND N.MT.08.01.02):
ANST08_A is a special case where (due the specific layout of this NST in the MFSA Excel submission file) the NST had to be split into two sub-sheets for Tabular to be able to support this NST.

In the MFSA Excel file ANST_08A is a single worksheet that uses merged cells to capture information at the binding agreement level (coverholder name, agreement period, GWP etc.) but also at the sub-level of the lines of business and outsourced activities covered by the agreement.

For example, the same binding agreement could cover three lines of business, and for each the Underwriting; Claims Handling; and Distribution outsourced activity types could cover all three lines of business. This would be presented in the MFSA template ANST08 as below:

However, in Tabular, the use of merged cells in this way is not supported (and we think not advisable) so this one-to-many relationship is structured across two worksheets: N.MT.08.01.01 and N.MT.08.01.02:

• N.MT.08.01.01 – the blue outlined sections above are entered into N.MT.08.01.01. For each binding agreement (name of coverholder and period of agreement) there is one unique row in N.MT.08.01.01
• N.MT.08.01.02 – the orange outlined section above is entered into N.MT.08.01.02. For each binding agreement (name of coverholder and period of agreement) add as many rows as required in N.MT.08.01.02 to hold all of the lines of business and outsourced activity combinations (note the MFSA limitations section below)
  

The same information represented in the MFSA output file would be entered into Tabular as below in sheets N.MT.08.01.01 and N.MT.08.01.02:
- N.MT.08.01.01

- N.MT.08.01.02

Note that the N.MT.08.01.02 C0010 and C0020 should match exactly with the N.MT.08.01.02 for Tabular to link the two tables together.

MFSA limitations on ANT08 A:

Please note that in the MFSA output file they only support three lines of business by default per binding agreement line of business. If you require more than three lines of business for any binding agreement line of business then either:
- Contact us and we can modify the configuration data to support this
- Manually add this into the MFSA output file (first run the export to NST in Tabular and then insert a row in the appropriate place in the MFSA ANST08_A worksheet