Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Get this document free

Llps

VIEWS: 6 PAGES: 5

Llps document sample

More Info
									   ff6d9e89-7274-4783-8caa-ff6120e2fdcc.xls                                                                        Data item data definition                                                                                     Printed on 7/9/2010

Version:    1
Date:       12 October 2007
Based on:   Handbook Instrument 2007/10 (25 January 2007)                (legal instrument setting out this data item with guidance)
            IRR (Amendment) Instrument 2007/45 (July 2007)               (instrument formalising further changes since 2007/10)

Reference                                  Label                                           XML Name                        Data Type            Validation     Error code                           Additional Information
FSA029      Balance Sheet                                                FSA029-BalanceSheet
                                                                                                                                                                            An attribute of the data item element, indicating the ISO currency code
                                                                            @currency                                       LimCurr
                                                                                                                                                                            applicable to all monetary values in the data item, eg "GBP"
                                                                                                                                                                            An attribute of the data item element, indicating the units applicable to
                                                                            @units                                            Units
                                                                                                                                                                            all monetary values in the data item, eg "thousands"
  1 to 4    Fixed Assets                                                    FixedAssets

    1A      Intangible assets                                                  IntangibleAssets                               Mon
    2A      Tangible assets                                                    TangibleAssets                                 Mon
    3A      Investments                                                        Investments                                    Mon          Σ
                                                                                                                                       Mandatory              ERR0080
    4A      Total fixed assets                                                 TotalFixedAssets                               Mon
                                                                                                                                       4A = (1A:3A)           ERR0030
  5 to 13   Current assets                                                  CurrentAssets
    5A      Stocks and investments                                            StocksInvestments                               Mon
  6 to 7    Trade debtors                                                     TradeDebtors
    6A      Due within 90 days                                                    Within90                                    Mon
    7A      Due after 90 days                                                     After90                                     Mon
    8A      Non-trade debtors                                                 NonTradeDebtors                                 Mon
    9A      Sundry debtors                                                    SundryDebtors                                   Mon
   10A      Loans & other assets                                              LoansOtherAssets                                Mon
 11 to 12   Cash at bank and in hand                                          Cash
   11A      Segregated                                                            Segregated                                  Mon
   12A      Non segregated                                                        NonSegregated                               Mon           Σ
                                                                                                                                       Mandatory              ERR0080
   13A      Total current assets                                               TotalCurrentAssets                             Mon
                                                                                                                                       13A = (5A:12A)         ERR0030
 14 to 55   Current liabilities                                             CurrentLiabilities
   14A      Creditors                                                         Creditors                                       Mon
   15A      Sundry creditors                                                  SundryCreditors                                 Mon
   16A      Accruals                                                          Accruals                                        Mon
                                                                                                                                                                            NB. This XML element has been added to aid understanding of the
 17 to 20                                                                      LoansWithin1year
                                                                                                                                                                            XML and does not appear on the form
   17A      Bank loans and overdrafts segregated due within 1 year                BankLoansSegregated                         Mon
   18A      Bank loans and overdrafts non segregated due within 1 year            BankLoansNonSegregated                      Mon
   19A      Short term subordinated loan due within 1 year                        ShortTermSubLoan                            Mon
   20A      Long term subordinated loan due within 1 year                         LongTermSubLoan                             Mon            Σ
                                                                                                                                       Mandatory              ERR0080
   55A      Total current liabilities                                          Total                                          Mon
                                                                                                                                       55A = (14A:20A)        ERR0030
                                                                                                                                       Mandatory              ERR0080
   21A      Net current assets (liabilities)                                NetCurrentAssets                                  Mon
                                                                                                                                       21A = 13A - 55A        ERR0010
 22 to 27   Long term liabilities                                           LongTermLiabilities
   22A      Creditors                                                          Creditors                                      Mon
                                                                                                                                                                            NB. This XML element has been added to aid understanding of the
 23 to 26                                                                      LoansAfter1year
                                                                                                                                                                            XML and does not appear on the form
   23A      Bank loans and overdrafts segregated due after 1 year                 BankLoansSegregated                         Mon
   24A      Bank loans and overdrafts non segregated due after 1 year             BankLoansNonSegregated                      Mon
   25A      Short term subordinated loan due after 1 year                         ShortTermSubLoan                            Mon
   26A      Long term subordinated loan due after 1 year                          LongTermSubLoan                             Mon            Σ
                                                                                                                                       Mandatory              ERR0080
   27A      Total long term liabilities                                        TotalLongTermLiabilities                       Mon
                                                                                                                                       27A = (22A:26A)        ERR0030
                                                                                                                                       Mandatory              ERR0080
   28A                                                                      TotalAssetsLiabilities                            Mon
            Total assets less total liabilities                                                                                        28A = 4A + 21A - 27A   ERR0010
 29 to 54   Capital                                                         Capital
 29 to 43   For incorporated entities only                                    IncorporatedEntities
   29A      Ordinary shares                                                       OrdinaryShares                            MonPos
 30 to 31   Non cumulative preference shares                                      NonCumulativePreferenceShares
   30A      Fixed term                                                               Fixed                                  MonPos
   31A      Non fixed term                                                           NonFixed                               MonPos
 32 to 33   Cumulative preference shares                                          CumulativePreferenceShares
   32A      Fixed term                                                               Fixed                                  MonPos
   33A      Non fixed term                                                           NonFixed                               MonPos
   34A      Total cumulative preference shares                                       Total                                  MonPos     34A = 32A + 33A        ERR0030
   35A      Share premium account                                                 SharePremiumAccount                        Mon


                                                                                                                         Page 1 of 4
   ff6d9e89-7274-4783-8caa-ff6120e2fdcc.xls                                          Data item data definition                                                                                          Printed on 7/9/2010

Reference                                  Label              XML Name                      Data Type              Validation             Error code                         Additional Information
   36A      Other reserves                            OtherReserves                             Mon
   37A      Revaluation reserve                       RevaluationReserve                        Mon
   38A      Retained earnings                         RetainedEarnings                          Mon
 39 to 41   Profit / (loss) current year              ProfitLossCurrentYear
   39A      Externally verified                           ExternallyVerified                    Mon
   40A      Unverified trading book                       UnverifiedTradingBook                 Mon
   41A      Unverified non trading book                   UnverifiedNonTradingBook              Mon
                                                                                                         Conditional:                    ERR0050
                                                                                                         If parent element is present,
                                                                                                                Σ
                                                                                                         element is mandatory
                                                                                                                Σ
   42A      Total capital                             TotalCapital                              Mon      42A = (29A:31A) +               ERR0010
                                                                                                                  (34A:41A)

                                                                                                         42A = 28A                       ERR0020
   43       Off balance sheet items                   OffBalanceSheet
                                                                                                                                                       Repeat as many times as there are reportable items. (Element 54A is
43B to 43C Items                                          Item
                                                                                                                                                       not required.)
                                                                                                                                         ERR0050
                                                                                                         Conditional: If Item row is
                                                                                                         present, field 43B is mandatory
                                                                                                                                          ERR0047
                                                                                                         If populated, field must contain
                                                                                                         one of following values:
                                                                                                             "Structured Products"
   43B      Type of off balance sheet item                       ItemType                       List         "OTCs"
                                                                                                             "Derivatives"
                                                                                                             "Operating Leases"
                                                                                                             "Offshore Entities"
                                                                                                             "Securitised Transactions"
                                                                                                             "Other"


                                                                                                         Conditional: If Items row is
   43C      Value                                                Value                          Mon      present, field 43C is           ERR0050
                                                                                                         mandatory
 44 to 49   For Partnerships or sole traders only   PartnershipsSoleTraders
                                                                                                         Conditional:
   44A      Capital account                           CapitalAccount                            Mon      If parent element is present,   ERR0050
                                                                                                         element is mandatory
   45A      Retained earnings                         RetainedEarnings                          Mon
 46 to 48   Current account current year              CurrentAccountCurrentYear
   46A      Externally verified                          ExternallyVerified                     Mon
   47A      Unverified trading book                      UnverifiedTradingBook                  Mon
   48A      Unverified non trading book                  UnverifiedNonTradingBook               Mon
                                                                                                         Conditional:                    ERR0050
                                                                                                         If parent element is present,
   49A      Total capital                             TotalCapital                              Mon      element is mandatory
                                                                                                         49A = ∑(44A:48A)                ERR0030
                                                                                                         49A = 28A                       ERR0020
   50       Off balance sheet items                   OffBalanceSheet
                                                                                                                                                       Repeat as many times as there are reportable items. (Element 54A is
50B to 50C Items                                          Item
                                                                                                                                                       not required.)
                                                                                                                                         ERR0050
                                                                                                         Conditional: If Item row is
                                                                                                         present, field 50B is mandatory
                                                                                                                                          ERR0047
                                                                                                         If populated, field must contain
                                                                                                         one of following values:
                                                                                                             "Structured Products"
   50B      Type of off balance sheet item                       ItemType                       List         "OTCs"
                                                                                                             "Derivatives"
                                                                                                             "Operating Leases"
                                                                                                             "Offshore Entities"
                                                                                                             "Securitised Transactions"
                                                                                                             "Other"


                                                                                                         Conditional: If Items row is
   50C      Value                                                Value                          Mon      present, field 50C is           ERR0050
                                                                                                         mandatory

                                                                                           Page 2 of 4
   ff6d9e89-7274-4783-8caa-ff6120e2fdcc.xls                                     Data item data definition                                                                                          Printed on 7/9/2010

Reference                               Label             XML Name                     Data Type              Validation             Error code                         Additional Information
 51 to 53   For LLPs only                       LLPs
                                                                                                    Conditional:
   51A                                            PartnersCashCapitalAccounts              Mon      If parent element is present,   ERR0050
            Partners Cash Capital Accounts                                                          element is mandatory
                                                                                                    Conditional:
   52A                                            PartnersCurrentAccounts                  Mon      If parent element is present,   ERR0050
            Partners current accounts                                                               element is mandatory
                                                                                                    Conditional:                    ERR0050
                                                                                                    If parent element is present,
   53A      Total Partners Capital                TotalPartnersCapital                     Mon      element is mandatory
                                                                                                    53A = 51A + 52A                 ERR0030
                                                                                                    53A = 28A                       ERR0020
   54       Off balance sheet items               OffBalanceSheet
                                                                                                                                                  Repeat as many times as there are reportable items. (Element 54A is
54B to 54C Items                                       Item
                                                                                                                                                  not required.)
                                                                                                                                    ERR0050
                                                                                                    Conditional: If Item row is
                                                                                                    present, field 54B is mandatory
                                                                                                                                     ERR0047
                                                                                                    If populated, field must contain
                                                                                                    one of following values:
                                                                                                        "Structured Products"
   54B      Type of off balance sheet item                    ItemType                     List         "OTCs"
                                                                                                        "Derivatives"
                                                                                                        "Operating Leases"
                                                                                                        "Offshore Entities"
                                                                                                        "Securitised Transactions"
                                                                                                        "Other"


                                                                                                    Conditional: If Items row is
   54C      Value                                             Value                        Mon      present, field 54C is           ERR0050
                                                                                                    mandatory




                                                                                      Page 3 of 4
ff6d9e89-7274-4783-8caa-ff6120e2fdcc.xls                                Handbook layout and sample data           Printed on 7/9/2010




FSA029
Balance Sheet

          Fixed Assets                                                                                     A
    1     Intangible assets
    2     Tangible assets
    3     Investments
    4     Total fixed assets

          Current assets
    5     Stocks and Investments
    6     Trade debtors Due within 90 days
    7                      Due after 90 days
    8     Non-trade debtors
    9     Sundry debtors
   10     Loans & other assets
   11     Cash at bank and in hand     Segregated
   12                                  Non segregated
   13     Total current assets

          Current liabilities
   14     Creditors
   15     Sundry creditors
   16     Accruals
   17     Bank loans and overdrafts segregated due within 1 year
   18     Bank loans and overdrafts non segregated due within 1 year
   19     Short term subordinated loan due within 1 year
   20     Long term subordinated loan due within 1 year
   55     Total current liabilities

   21     Net current assets (liabilities)

          Long term liabilities
   22     Creditors
   23     Bank loans and overdrafts segregated due after 1 year
   24     Bank loans and overdrafts non segregated due after 1 year
   25     Short term subordinated loan due after 1 year
   26     Long term subordinated loan due after 1 year
   27     Total long term liabilities

   28     Total assets less total liabilities

          Capital             For incorporated entities only
   29     Ordinary shares
   30     Non cumulative preference shares          Fixed term
   31                                               Non fixed term
   32     Cumulative preference shares              Fixed term
   33                                               Non fixed term
   34     Total cumulative preference shares
   35     Share premium account
   36     Other reserves
   37     Revaluation reserve
   38     Retained earnings
   39     Profit / (loss) current year   Externally verified
   40                                    Unverified trading book
   41                                    Unverified non trading book
   42     Total capital

          Off Balance Sheet items
                                                   A                           B                            C
   43                                           Item no         Type of off balance sheet item            Value
                                                       1
                                                      …
                                                      n
                                                                                                           A
          Capital          For Partnerships or sole traders only
   44     Capital account
   45     Retained earnings
   46     Current account current year          Externally verified
   47                                           Unverified trading book
   48                                           Unverified non trading book
   49     Total capital

          Off Balance Sheet items
                                          A                                    B                            C
   50                                  Item no                  Type of off balance sheet item            Value
                                              1
                                             …
                                             n
          Capital          For LLPs only
   51     Partners Cash Capital Accounts
   52     Partners current accounts
   53     Total Partners Capital




                                                                                  Page 4 of 5
ff6d9e89-7274-4783-8caa-ff6120e2fdcc.xls                  Handbook layout and sample data           Printed on 7/9/2010




          Off Balance Sheet items
                                          A                      B                            C
   54                                  Item no    Type of off balance sheet item            Value
                                              1
                                             …
                                             n




                                                                    Page 5 of 5

								
To top