You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@ofbiz.apache.org by wp...@gmail.com,
wp...@gmail.com on 2019/04/05 15:04:51 UTC
Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)
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
Re: Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)
Posted by Pierre Smits <pi...@apache.org>.
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 <pi...@apache.org> 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 <pa...@cohsoft.com.au>
> 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 <pi...@apache.org> 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 wp.rauchholz@gmail.com <
>> > wp.rauchholz@gmail.com> 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: +61 3 9585 6788
>> Web: http://www.coherentsoftware.com.au/
>> Email: info@coherentsoftware.com.au
>>
>
Re: Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)
Posted by Pierre Smits <pi...@apache.org>.
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 <pa...@cohsoft.com.au> 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 <pi...@apache.org> 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 wp.rauchholz@gmail.com <
> > wp.rauchholz@gmail.com> 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: +61 3 9585 6788
> Web: http://www.coherentsoftware.com.au/
> Email: info@coherentsoftware.com.au
>
Re: Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)
Posted by Paul Foxworthy <pa...@cohsoft.com.au>.
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 <pi...@apache.org> 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 wp.rauchholz@gmail.com <
> wp.rauchholz@gmail.com> 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: +61 3 9585 6788
Web: http://www.coherentsoftware.com.au/
Email: info@coherentsoftware.com.au
Re: Need help: SPANISH GENERAL ACCOUNTING PLAN (SPC)
Posted by Pierre Smits <pi...@apache.org>.
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 wp.rauchholz@gmail.com <
wp.rauchholz@gmail.com> 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
>
>
>