Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)

[wp.rauchholz]

I like to accomplish the following:
1 - setup spanish accounting plan in Ofbiz
2 - make it in form of xml files available to community

Problem: I am not a finance person.

Ask: a volunteer I can meet with on e.g. Skype to complete the task

Current status: I do have EXCEL version of  accounting plan in Spanish and English and started to map tthat to ofbiz, but due to lack finance skills, I cannot complete.


Thanks for getting in touch with me.

Wolfgang

 

[Pierre Smits-3]

Hi Wolfgang,

Great initiative! I recently started to undertake the same for the Dutch
 Gl Ledger schema (the so-called 'Grootboekschema'). The reference schema
has over 3700 rows in a spreadsheet, and is applicable to every industry
sector and for one-man operations to multinationals. It is also complete
regarding XBRL reporting.

As you can imagine, converting the spreadsheet rows to <GlAccount ../>
records is not a big deal (I had that done in under an hour), but mapping
each row to the correct GlAccountType, GlAccountClass and GlResource
reference is quite another story. Not to mention all the other associations
(invoice type, payment type, etc).

Keep up the good work.

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Fri, Apr 5, 2019 at 5:04 PM [hidden email] <
[hidden email]> wrote:

> I like to accomplish the following:
> 1 - setup spanish accounting plan in Ofbiz
> 2 - make it in form of xml files available to community
>
> Problem: I am not a finance person.
>
> Ask: a volunteer I can meet with on e.g. Skype to complete the task
>
> Current status: I do have EXCEL version of  accounting plan in Spanish and
> English and started to map tthat to ofbiz, but due to lack finance skills,
> I cannot complete.
>
>
> Thanks for getting in touch with me.
>
> Wolfgang
>
>
>

[Paul Foxworthy]

Another resource that might be helpful :

https://www.ifrs-gaap.com/examples-and-charts

provides free example charts of accounts for both GAAP and IFRS accounting
standards.

Cheers

Paul Foxworthy

On Sun, 7 Apr 2019 at 02:31, Pierre Smits <[hidden email]> wrote:

> Hi Wolfgang,
>
> Great initiative! I recently started to undertake the same for the Dutch
>  Gl Ledger schema (the so-called 'Grootboekschema'). The reference schema
> has over 3700 rows in a spreadsheet, and is applicable to every industry
> sector and for one-man operations to multinationals. It is also complete
> regarding XBRL reporting.
>
> As you can imagine, converting the spreadsheet rows to <GlAccount ../>
> records is not a big deal (I had that done in under an hour), but mapping
> each row to the correct GlAccountType, GlAccountClass and GlResource
> reference is quite another story. Not to mention all the other associations
> (invoice type, payment type, etc).
>
> Keep up the good work.
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
> since 2008*
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Fri, Apr 5, 2019 at 5:04 PM [hidden email] <
> [hidden email]> wrote:
>
> > I like to accomplish the following:
> > 1 - setup spanish accounting plan in Ofbiz
> > 2 - make it in form of xml files available to community
> >
> > Problem: I am not a finance person.
> >
> > Ask: a volunteer I can meet with on e.g. Skype to complete the task
> >
> > Current status: I do have EXCEL version of  accounting plan in Spanish
> and
> > English and started to map tthat to ofbiz, but due to lack finance
> skills,
> > I cannot complete.
> >
> >
> > Thanks for getting in touch with me.
> >
> > Wolfgang
> >
> >
> >
>

--
Coherent Software Australia Pty Ltd
PO Box 2773
Cheltenham Vic 3192
Australia

Phone: [phone]
Web: http://www.coherentsoftware.com.au/
Email: [hidden email]

[Pierre Smits-3]

Hi Paul,

Thanks for sharing that link. Based on information provided thereon I have
created a Chart of Accounts for the IFRS example.

It can be found here: https://github.com/ORRTIZ/ofbiz-CoA-IFRS-example

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Tue, Apr 16, 2019 at 10:04 AM Paul Foxworthy <[hidden email]> wrote:

> Another resource that might be helpful :
>
> https://www.ifrs-gaap.com/examples-and-charts
>
> provides free example charts of accounts for both GAAP and IFRS accounting
> standards.
>
> Cheers
>
> Paul Foxworthy
>
> On Sun, 7 Apr 2019 at 02:31, Pierre Smits <[hidden email]> wrote:
>
> > Hi Wolfgang,
> >
> > Great initiative! I recently started to undertake the same for the Dutch
> >  Gl Ledger schema (the so-called 'Grootboekschema'). The reference schema
> > has over 3700 rows in a spreadsheet, and is applicable to every industry
> > sector and for one-man operations to multinationals. It is also complete
> > regarding XBRL reporting.
> >
> > As you can imagine, converting the spreadsheet rows to <GlAccount ../>
> > records is not a big deal (I had that done in under an hour), but mapping
> > each row to the correct GlAccountType, GlAccountClass and GlResource
> > reference is quite another story. Not to mention all the other
> associations
> > (invoice type, payment type, etc).
> >
> > Keep up the good work.
> >
> > Best regards,
> >
> > Pierre Smits
> >
> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> > *Apache Directory <https://directory.apache.org>, PMC Member*
> > Apache Incubator <https://incubator.apache.org>, committer
> > *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
> privileges)
> > since 2008*
> > Apache Steve <https://steve.apache.org>, committer
> >
> >
> > On Fri, Apr 5, 2019 at 5:04 PM [hidden email] <
> > [hidden email]> wrote:
> >
> > > I like to accomplish the following:
> > > 1 - setup spanish accounting plan in Ofbiz
> > > 2 - make it in form of xml files available to community
> > >
> > > Problem: I am not a finance person.
> > >
> > > Ask: a volunteer I can meet with on e.g. Skype to complete the task
> > >
> > > Current status: I do have EXCEL version of  accounting plan in Spanish
> > and
> > > English and started to map tthat to ofbiz, but due to lack finance
> > skills,
> > > I cannot complete.
> > >
> > >
> > > Thanks for getting in touch with me.
> > >
> > > Wolfgang
> > >
> > >
> > >
> >
>
>
> --
> Coherent Software Australia Pty Ltd
> PO Box 2773
> Cheltenham Vic 3192
> Australia
>
> Phone: [phone]
> Web: http://www.coherentsoftware.com.au/
> Email: [hidden email]
>

[Pierre Smits-3]

And if anyone is looking for the GAAP variant, you can find it here:
https://github.com/ORRTIZ/ofbiz-CoA-GAAP-example

Best regards,

Pierre Smits

*Apache Trafodion <https://trafodion.apache.org>, Vice President*
*Apache Directory <https://directory.apache.org>, PMC Member*
Apache Incubator <https://incubator.apache.org>, committer
*Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
since 2008*
Apache Steve <https://steve.apache.org>, committer


On Tue, Apr 16, 2019 at 5:40 PM Pierre Smits <[hidden email]> wrote:

> Hi Paul,
>
> Thanks for sharing that link. Based on information provided thereon I have
> created a Chart of Accounts for the IFRS example.
>
> It can be found here: https://github.com/ORRTIZ/ofbiz-CoA-IFRS-example
>
> Best regards,
>
> Pierre Smits
>
> *Apache Trafodion <https://trafodion.apache.org>, Vice President*
> *Apache Directory <https://directory.apache.org>, PMC Member*
> Apache Incubator <https://incubator.apache.org>, committer
> *Apache OFBiz <https://ofbiz.apache.org>, contributor (without privileges)
> since 2008*
> Apache Steve <https://steve.apache.org>, committer
>
>
> On Tue, Apr 16, 2019 at 10:04 AM Paul Foxworthy <[hidden email]>
> wrote:
>
>> Another resource that might be helpful :
>>
>> https://www.ifrs-gaap.com/examples-and-charts
>>
>> provides free example charts of accounts for both GAAP and IFRS accounting
>> standards.
>>
>> Cheers
>>
>> Paul Foxworthy
>>
>> On Sun, 7 Apr 2019 at 02:31, Pierre Smits <[hidden email]> wrote:
>>
>> > Hi Wolfgang,
>> >
>> > Great initiative! I recently started to undertake the same for the Dutch
>> >  Gl Ledger schema (the so-called 'Grootboekschema'). The reference
>> schema
>> > has over 3700 rows in a spreadsheet, and is applicable to every industry
>> > sector and for one-man operations to multinationals. It is also complete
>> > regarding XBRL reporting.
>> >
>> > As you can imagine, converting the spreadsheet rows to <GlAccount ../>
>> > records is not a big deal (I had that done in under an hour), but
>> mapping
>> > each row to the correct GlAccountType, GlAccountClass and GlResource
>> > reference is quite another story. Not to mention all the other
>> associations
>> > (invoice type, payment type, etc).
>> >
>> > Keep up the good work.
>> >
>> > Best regards,
>> >
>> > Pierre Smits
>> >
>> > *Apache Trafodion <https://trafodion.apache.org>, Vice President*
>> > *Apache Directory <https://directory.apache.org>, PMC Member*
>> > Apache Incubator <https://incubator.apache.org>, committer
>> > *Apache OFBiz <https://ofbiz.apache.org>, contributor (without
>> privileges)
>> > since 2008*
>> > Apache Steve <https://steve.apache.org>, committer
>> >
>> >
>> > On Fri, Apr 5, 2019 at 5:04 PM [hidden email] <
>> > [hidden email]> wrote:
>> >
>> > > I like to accomplish the following:
>> > > 1 - setup spanish accounting plan in Ofbiz
>> > > 2 - make it in form of xml files available to community
>> > >
>> > > Problem: I am not a finance person.
>> > >
>> > > Ask: a volunteer I can meet with on e.g. Skype to complete the task
>> > >
>> > > Current status: I do have EXCEL version of  accounting plan in Spanish
>> > and
>> > > English and started to map tthat to ofbiz, but due to lack finance
>> > skills,
>> > > I cannot complete.
>> > >
>> > >
>> > > Thanks for getting in touch with me.
>> > >
>> > > Wolfgang
>> > >
>> > >
>> > >
>> >
>>
>>
>> --
>> Coherent Software Australia Pty Ltd
>> PO Box 2773
>> Cheltenham Vic 3192
>> Australia
>>
>> Phone: [phone]
>> Web: http://www.coherentsoftware.com.au/
>> Email: [hidden email]
>>
>