XBRL reporting for the SEC

[alan tenore <al...@att.net>]

Hello:

 

I was
interested in knowing if OpenOffice can create XBRL (Business reporting
language) files that are now required to be filed with the Securities and
Exchange Commission for company filings – 10Q 10K?  This is a very specific program

 

Microsoft
has a product called FXr Reporting.

 

Essentially,
it a database providing drop down menus for the various sections of a 10K

 

Thanks,

 

Alan

Re: XBRL reporting for the SEC

[Alexandro Colorado <jz...@oooes.org>]

On Thu, Jul 26, 2012 at 11:56 PM, alan tenore <al...@att.net> wrote:

> Hello:
>
>
>
> I was
> interested in knowing if OpenOffice can create XBRL (Business reporting
> language) files that are now required to be filed with the Securities and
> Exchange Commission for company filings – 10Q 10K?  This is a very
> specific program
>

As a sidenote, looking at Edgar 10Q for IBM it showed a very odd render of
an Excel file which is not able to be opened either by AOO or by Google
Docs, is a plain XML-HTML version which generates an odd mapping of the
document.
http://sec.gov/cgi-bin/viewer?action=view&cik=51143&accession_number=0001104659-12-027715&xbrl_type=v
It also resembles very little to the original taxonomy.

At first I thought it was OOXML but later found out is really an HTML
mapped through an XML. The mapping seems to be missing from this file,
which is hard to tell how Excel maps it's generic cells to the ifs taxonomy
which should be key to have some sort of relation.

There is also some extension that provides a mapping interface to route the
cells or lables to the right nodes. I am curious how excel produce the XBRL
starting from the generic cell-row format. Something similar to the Letter
Wizard duaring the field mapping section from the address book to the mail
merge.


>
>
>
> Microsoft
> has a product called FXr Reporting.
>
>
>
> Essentially,
> it a database providing drop down menus for the various sections of a 10K
>
>
>
> Thanks,
>
>
>
> Alan

Re: XBRL reporting for the SEC

[Alexandro Colorado <jz...@oooes.org>]

Is definitely possible, I have been looking at the multiple open source
frameworks for Firefox Chrome and is possible to go in different ways.

An OOo filter could be the most straight forward way to be able to change
XBRL to ODF. However the taxonomies from different regions will make this a
bit intensive  to code.

My simplest suggestion is to have a template using XForms which could
output to XBRL-compliant XML.

You can great an XML form with the tags you need on your XBRL and generate
it's output on a compliant fashion. Have a look at this tutorial, if you
want to know more about XForms in OO.
http://opendocument.xml.org/files/xforms_ooo_06_10_25.pdf

On Thu, Jul 26, 2012 at 11:56 PM, alan tenore <al...@att.net> wrote:

> Hello:
>
>
>
> I was
> interested in knowing if OpenOffice can create XBRL (Business reporting
> language) files that are now required to be filed with the Securities and
> Exchange Commission for company filings – 10Q 10K?  This is a very
> specific program
>
>
>
> Microsoft
> has a product called FXr Reporting.
>
>
>
> Essentially,
> it a database providing drop down menus for the various sections of a 10K
>
>
>
> Thanks,
>
>
>
> Alan

Re: XBRL reporting for the SEC

[drew <dr...@baseanswers.com>]

On Thu, 2012-07-26 at 21:56 -0700, alan tenore wrote:
> Hello:
> 
>  
> 
> I was
> interested in knowing if OpenOffice can create XBRL (Business reporting
> language) files that are now required to be filed with the Securities and
> Exchange Commission for company filings – 10Q 10K?  This is a very specific program
> 
>  
> 
> Microsoft
> has a product called FXr Reporting.
> 
>  
> 
> Essentially,
> it a database providing drop down menus for the various sections of a 10K
> 
>  
> 
> Thanks,
> 
>  
> 
> Alan

Hi Alan,

(note I am not certified for XBRL - but do have some EDGAR compliance
experience )

Good question - I'm curious why you would see AOO as a tool for this, is
there some specific in your business processes where you see AOO as the
natural tool for this?

Anyway - A couple of resources for you too consider:
http://www.xbrlwiki.info/index.php?title=Open_Source_and_XBRL

Thanks,

//drew