250 likes | 396 Views
XBRL Instances & Taxonomies SLA-NY Business & Finance February 11, 2009. Clinton E. White, Jr (Skip) Professor of Accounting & MIS Lerner College of B&E University of Delaware (www.buec.udel.edu/whitec/NYFeb2009). Instances Using Rivet Dragon Tag. Open Excel With browser, go to:
E N D
XBRL Instances & TaxonomiesSLA-NY Business & FinanceFebruary 11, 2009 Clinton E. White, Jr (Skip) Professor of Accounting & MIS Lerner College of B&E University of Delaware (www.buec.udel.edu/whitec/NYFeb2009)
Instances UsingRivet Dragon Tag • Open Excel • With browser, go to: • www.buec.udel.edu/whitec/NYFeb2009 • Click • 3M Current Assets and Liabilities (xls)
Before starting markup, save a copy to your flash drive: 3MCurrentAssetsAndLiabsStart.xls
(3) Enter new entity Rivet Entity Profile (2) Create new entity (1) Entity profile icon (4) Locate taxonomy
Complete entity profile: Green icon Info from taxonomy
Rivet Starting Markup (1) Markup icon
(2) Drag & Tag balance Rivet Drag & Tag (1) Open taxonomy & find appropriate element
Marking Assets How would you markup Inventory, Raw Materials and Supplies?
Inventory Disclosures Find the Disclosure – Inventory taxonomy Right-click & Select Copy
Rivet Copy/Paste Right-click Inventory, Raw Materials Select Paste & fill in dialog box
Rivet New Element How would you markup Short-term Borrowings & Current Portion of Long-term Debt?
Rivet New Element Wizard Right-click Short-term Borrowings, Total Select Insert element after
A Markedup Spreadsheet How would you markup Accrued Income Taxes Payable?
Calendar Markup Select Calendar & Drag & drop on entire clolumns
(2) Review markup details Reviewing Markup (1) Select item & click review icon
Select validation icon Validation
Select Export XBRL icon Exporting XBRL
XBRL Today • The US GAAP XBRL V1.0 taxonomy • Over 10,000 financial reporting concepts represented as elements • Physically: One very large set of files containing all US GAAP reporting concepts • Logically: A number of US GAAP industry taxonomies (a.k.a. “industry entry points”) reflecting common practice in a particular industry • And, a number of non-GAAP, special-purpose taxonomies for financial reporting
Creating Financials • Rule 1: • Use elements from the XBRL US GAAP Taxonomy whenever possible • The reality: • All companies today need to create extension taxonomies for their SEC filings!
Other Resources • XBRL US GAAP Taxonomies (xbrl.us/Pages/US-GAAP.aspx): • Preparer’s Guide • Case studies • Sample XBRL instance documents • Others: • www.sec.gov … www.xbrl.org … AICPA …
Resources • Textbooks: www.skipwhite.com • The Accountant’s Guide to XBRL • The Guide & Workbook for Understanding XBRL • www.rivetsoftware.com • Dragon Tag and Genesis • www.ubmatrix.com • Processing engine and ERP suite • www.fujitsu.com • InterstageXwand • www.windowslive.com • FR Live • www.tryxbrl.com • www.sec.gov
The future is already here – its just unevenly distributed! William Gibson Thanks for your attention! Skip