1 / 29

xfy with XBRL Extends Financial Application Kunio OHNO Justsystems, Inc.

xfy with XBRL Extends Financial Application Kunio OHNO Justsystems, Inc. Agenda. 1. Introduction 2. “ ｘｆｙ for XBRL” Technology 3. ” xfy for XBRL” Prototype System Financial Reporting Financial Analysis Loan Analysis 4. Conclusion. Introduction. Oct. 2003. April 2004.

kato-witt
Download Presentation

xfy with XBRL Extends Financial Application Kunio OHNO Justsystems, Inc.

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. xfy with XBRL Extends Financial ApplicationKunio OHNOJustsystems, Inc.

  2. Agenda • 1. Introduction • 2. “ｘｆｙ for XBRL” Technology • 3. ”xfy for XBRL” Prototype System • Financial Reporting • Financial Analysis • Loan Analysis • 4. Conclusion

  3. Introduction

  4. Oct. 2003 April 2004 Presented XBRLeddata of the listed companies via internet XBRL-Japantried the 1st proof experiment. April 2003 National Tax Agency adopted for electronic declaration. Feb. 2006 Started XBRL registrationof financial info. to Tokyo Stock Exchange. Bank of Japan started sending/receiving XBRLdata. Financial Services Agency started receiving XBRL data. Feb. 2004 XBRL in Japan

  5. XBRL Experiments by XBRL-Japan • 1st Phase (Spring in 2004) • Confirmed XBRL data usability • 2nd Phase (Autumn in 2004) • Developed taxonomy for bank lending • 3rd Phase (Autumn in 2005) • Verified by actual systems • Implemented a prototype system covering the following processes: • Banks accept application forms and financial data. • Banks analyze for loan examination.

  6. Planned 3rd Phase Experiment by xfy Borrower Bank Common Area of Pilot Limited Area of Banks Operator Analysis Entry xfy AnalysisOption Transfer Financial Data (B/S P/L) xfy XBRLOption XBRL Instance document xfy DBOption 電子申告用 財務情報 B/S P/L 電子申告用 財務情報 B/S P/L Plus Acceptance -Manual entry -Automatic entry Clerk XFY DBOption Taxonomy for Bank Lending DB2 or Oracle Save/View View

  7. xfy for XBRL Technology

  8. Basic Concept of xfy xfy has ability for users to read, write, compound and utilize any XML

  9. Basic Feature of XVCD • xfy + XVCD = XML Application • Editing XML data needs a view. However, many XML data do not have view. • XVCD can define a view. • Data（XML） and View（XVCD） can be separately managed. • Features of Vocabulary Connection Descriptor (VCD) • Transformation rules (like XSLT) • Edit　（XSLT can not do this）

  10. XVCD File（addressbook.xvcd） XVCD Sample <?xml version="1.0"?> <xvcd:xvcd xmlns:xvcd="http://xfy.com/xvcd" xmlns="http://www.w3.org/1999/xhtml" xmlns:ab="http://xfy.com/tutorial/addressbook" version="1.0"> <xvcd:vocabulary name=“AddressBook” match="ab:addressbook" call-template="root"/> <xvcd:template name="root"> <html><body> <table border="1" width="100%"> <tr> <th width="150">Name</th> <th>Address</th> </tr> <xvcd:apply-templates select="ab:entry"/> </table> </body></html> </xvcd:template> <xvcd:template match="ab:entry"> <tr> <td><xvcd:apply-templates select="ab:person"/></td> <td><xvcd:apply-templates select="ab:address"/></td> </tr> </xvcd:template> <xvcd:template match="ab:person"> <xvcd:text-of select="." /> </xvcd:template> <xvcd:template match="ab:address"> <xvcd:text-of select="." /> </xvcd:template> </xvcd:xvcd> Sample Data（addressbook.xml） <?xml version="1.0"?> <ab:addressbookxmlns:ab="http://xfy.com/tutorial/addressbook"> <ab:entry> <ab:person>George Adams</ab:person> <ab:address>Rochester, NY, USA</ab:address> </ab:entry> <ab:entry> <ab:person>Betty Jackson</ab:person> <ab:address>Denver, Colorado USA</ab:address> </ab:entry> </ab:addressbook> Apply template If “ab:entry” is matched, apply the template. Apply template Refer to source data

  11. View Generator • RAD tool to make use of existing XML resources. XVCD is generated from : • XML data file and its scheme file • Only XML data file • XSLT • Easy to use XML XVCD View Generator XML Schema ＋ XSLT

  12. Process of XVCD Generation View Generator <?xml version="1.0"?> <ab:addressbookxmlns:ab="http://xfy.com/tutorial/addressbook"> <ab:entry> <ab:person>George Adams</ab:person> <ab:address>Rochester, NY, USA</ab:address> </ab:entry> <ab:entry> <ab:person>Betty Jackson</ab:person> <ab:address>Denver, Colorado USA</ab:address> </ab:entry> </ab:addressbook> XVCD xfy Basic Edition

  13. ”xfy for XBRL” Prototype System - Financial Reporting - Financial Analysis - Loan Analysis

  14. Financial Reporting ３．Generate Instance View ５．Edit Annual Report like on Word Processor ２．User Customization (Parameter Edit) XBRL Taxonomy ４．Edit Instance １．Create Taxonomy View ６．Create analysis report from multiple reports XBRL Schema Create Binding File Taxonomy View Create View Instance View 財務 報告書 財務 報告書 Annual Report LinkBase Binding File (XML) XBRL Instance Financial Analysis Report System View Template Financial Report System xfy ViewGenerator

  15. Financial Report Creation and Management XML Scheme XML Scheme Link base Link base 計算 計算 名称 名称 表示 順序 表示 順序 参照 参照 Financial Report System B/S taxonomy For example, to make financial statements… • Several instances are generated from specific taxonomies. Instances are embedded into a report. • The user writes text and assign values in tables. Values in tables are linked to texts inside the report. • “Financial Analysis Data” is inserted. • The user stores the report. １．Corporate Group ２．Management Policies ３．Consolidated Financial Statements B/S XVCD Generation P/L taxonomy The sales this year is $○○ P/L Generate Instance Document Link to value in the table Financial Analysis Data Refer to Select “Financial Analysis Data” in tool bar menu or context menu. Present financial analysisdata from values of B/S and P/L. B/S 個人消費は、個人所得の伸び悩みから本格的な回復と はいえず、昨年経済成長に大きく寄与した中国経済市場も不透明感が漂いはじめました。 P/L Marking at places for good or bad factor.

  16. Screen Sample 1

  17. [Business & personal related business] The sales environment for package software at points-of-sales faced a severe situation. However, following release of “Ichitaro 2005” and “Hanako 2005”, their option products; “Neta-no-Tane”, “Calking-J” and “Zukai-Master” subsequently launched onto the market did well, contributing to maintenance of more or less the same level as the previous term as a whole. As for “ATOK”, the sale of its series combined with online dictionaries with a recommended retail price of 11,550 yen exceeded its single version Screen Sample 2

  18. Example of Financial Analysis P/L Add “Financial Analysis Data” B/S Analysis for - Stability- Profitability- Productivityetc.

  19. Financial report for 2004 Financial report for 2003 Financial report for 2002 Multiple Financial Reports Management Financial Analysis Report System • Financial reports for input data are given. • For each financial report, financial analysis data are computed and displayed. • The user adds chapters and section for writing his comments and interpretation for analysis. • The user stores the analysis report. １．Input Data 　　・2004　　・2003　　・2002 ２．Results Table of Financial Analysis data ３．Good Factors 　　・2004　　・2003　　・2002 Marked (tagged) “Good” and “Bad” factors are listed for each report. ４．Bad Factors 　　・2004　　・2003　　・2002 Present financial data for each annual, for each quarter, and for each enterprise.

  20. Loan Analysis Model XBRL Loan Instance (template） xfy View Generator for XBRL Dynamic Financial Analysis View Free Financial Analysis XBRL Loan Instance Automatic Generation Financial Report XBRL Loan Taxonomy XBRL FR Taxonomy Automatic Generation Financial Analysis XBRL FR Instance Basic Financial Analysis View XBRL FR Instance (template）

  21. Taxonomy for Loan Analysis Taxonomy for Loan Customer Info. Customer Info Detail Balance of Debt from Banks Loan Information Loan Application Basic Taxonomy Additional Info. B/S B/S Taxonomy for e-Tax P/L P/L Production Cost Statement Production Cost Statement Retained Earnings Statement Retailed Earnings Statement

  22. Dynamic Analysis Example Analysis Report １．Corporate Group ２．Management Policies ３．Financial Results Balance Sheet 123,456 Profit and Loss Link 234,567 ４．Status of Loan Information of Loan 345,678 ５．Analysis of Loan Table for Dynamic Analysis ・・・ ・・・ ・・・

  23. Conclusion

  24. Other XBRL System vs. xfy for XBRL Seamless & Timeliness Connectivity & Originality

  25. Commercial Product Development • Based on the “xfy for XBRL” prototype, client server architecture commercial product is under development. • Sever side feature • Database connection • XBRL resource management • XBRL & Web Services orchestration

  26. DB Server xfy for XBRL Server Outside of enterprise タクソノミー 文書 インスタンス 文書 Index タクソノミー 文書 インスタンス 文書 Taxonomy Instance Distribution （example: FSA） Search Management xfy for XBRL Client Component for Analysis Creation Analysis Design Taxonomy Instance Calculation Verification View User “xfy for XBRL” Client Server Model

  27. “xfy for XBRL” Client Server Architecture User xfy XBRL Client Taxonomy Automatic Visualization Taxonomy Design XBRL Documentation Input/Edit LinkBase Design Instance Free Composition Ruled Validation XBRL Instance Design Automatic Calculation XML-Signature Instance Document Design XBRL Analyze Iterative Design Built-in Analysis User-defined Analysis DB Connection（dynamic generation of XQuery） xfy XBRL Server Web Service XBRL&WebService Orchestration XBRL Resource Mng. Taxonomy Operation Instance Operation Conversion Communication Publication External Sysytem Administration Access Control Taxonomy Repository Document Repository XMLDB Taxonomy Versioning Component Repository RDB Meta Instance Repository Automatic Validation Database

  28. Advantage of “xfy for XBRL” • Seamless • Further speed-up of work • Further improvement of business quality • Timeliness • Accuracy of data • Connectivity • Awareness based on broad range of information • Originality • Each user’s discovery

  29. See the Future ？ www.xfytec.com

More Related