[OFBiz] Dev - Modified GeneralChartOfAccounts.xml file
G. David Butler
gdb at dbSystems.com
Fri Aug 6 19:10:15 EDT 2004
I hope this is not old hat nor the start of a religious discussion...
Have you looked over the chart of accounts Compiere suggests?
Once you download their .zip file, they are in: Compiere2/data/import.
Also there is this:
http://www.compiere.org/support/implement/chartOfAccounts.html
David
----- Original Message -----
From: "Adrian Crum" <adrianc at hlmksw.com>
To: <dev at ofbiz.dev.java.net>
Sent: Friday, August 06, 2004 5:57 PM
Subject: Re: [OFBiz] Dev - Modified GeneralChartOfAccounts.xml file
> David Jones wrote:
> > I'm familiar with XBRL, but I didn't know they had any sort of a
> > recommended chart of accounts. I spent a minute looking at that page
> > and I still don't see anything like a chart of account there. Do you
> > have a more specific link?
>
> No. The whole idea behind XBRL is to detach the accounting data from GL
> account numbers. It's an interesting concept, but I'm not suggesting
> OFBiz go that route. The XBRL "solution" addresses the problem I've been
> stating all along - every accountant has their own numbering system.
>
> > You are correct that the ABA chart of accounts is industry specific. We
> > would like to have a good generic chart of accounts in OFBiz, so this
> > is just a starting point. In general we also want to have some sample
> > organizations that represent smaller businesses in specific industries
> > and that can be copied for their current organization, or divisions or
> > whatever in the organization. So, the general or global chart of
> > accounts will be a large superset of what most companies will use, but
> > can hopefully make it easier for each company to get their chart setup
> > initially.
>
> Understood. I'll go over it with our accountant and make sure there is a
> valid generic chart of accounts available. I'll leave the
> industry-specific stuff to someone else.
>
> Give me a few weeks for this.
>
>
> >
> > -David
> >
> >
> > On Aug 6, 2004, at 4:35 PM, Adrian Crum wrote:
> >
> >> Thanks - that looks like a chart of accounts for a specific industry.
> >>
> >> Try looking at this:
> >>
> >> http://www.oasis-open.org/cover/xbrl.html
> >>
> >>
> >> David Jones wrote:
> >>
> >>> This was the result of a few Google searches to find some sort of
> >>> standard chart of accounts, and it is from the American Booksellers
> >>> Association. You can see more at:
> >>> http://www.bookweb.org/misc/member/scoa.html
> >>> -David
> >>> On Aug 6, 2004, at 4:25 PM, Adrian Crum wrote:
> >>>
> >>>> Our accountant is familiar with AICPA. What does ABA stand for?
> >>>>
> >>>> David Jones wrote:
> >>>>
> >>>>> Adrian,
> >>>>> That would be great. I guess what we need is a high level review
> >>>>> of the chart of accounts as we have it now, but there are some
> >>>>> particular things to look at. For example, there are a number of
> >>>>> areas where contra-asset type accounts exist and I'm not sure if
> >>>>> the glAccountClassId is appropriately set for these. For example
> >>>>> the following accounts: 191900, 249000, 311000, 321000 (and
> >>>>> sub-accounts), 334000 & 335000, certain other DISTRIBUTION
> >>>>> accounts, all of the 500000 series (COGS) accounts, 607900, etc.
> >>>>> So, in general it would be nice to have a good review of the whole
> >>>>> to see how much everything makes sense, but if you have a
> >>>>> limited time to look at it (which I'm sure you do) then the
> >>>>> items listed above are the best to look at.
> >>>>> Thanks for your help.
> >>>>> -David
> >>>>> On Aug 6, 2004, at 1:45 PM, Adrian Crum wrote:
> >>>>>
> >>>>>> I can help. What are the things you're not sure about?
> >>>>>>
> >>>>>>
> >>>>>> David Jones wrote:
> >>>>>>
> >>>>>>> Adrian,
> >>>>>>> Of course we don't do it that way, that's not what I was
> >>>>>>> referring to. For verification, you should take a look at the
> >>>>>>> entity definitions or even this seed data file that we are
> >>>>>>> referring to. Certain accounts were originally put in that
> >>>>>>> way by our tech writer who did all of the data entry for
> >>>>>>> these 354 accounts because he wasn't sure what to do with
> >>>>>>> them, and I was in another country.
> >>>>>>> I anyone has any feedback on the chart of accounts, or access to
> >>>>>>> an accountant who could spend some time reviewing it that
> >>>>>>> would be great. It is based on the ABA standard chart of
> >>>>>>> accounts, but there are still some issues or things that we
> >>>>>>> aren't totally sure about.
> >>>>>>> -David
> >>>>>>> On Aug 6, 2004, at 9:52 AM, Adrian Crum wrote:
> >>>>>>>
> >>>>>>>> David,
> >>>>>>>>
> >>>>>>>> GL account numbers should NOT be formatted specifically for
> >>>>>>>> Income or Expense. GL account 12345-123 could be Income,
> >>>>>>>> Expense, Fixed Asset, etc - depending upon the accountant. A
> >>>>>>>> field in the account determines what type of account it is.
> >>>>>>>>
> >>>>>>>> -Adrian
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> David Jones wrote:
> >>>>>>>>
> >>>>>>>>> Brett,
> >>>>>>>>> The account numbers in the "-XXXXXX-" form are accounts that
> >>>>>>>>> are reversed, ie INCOME instead of EXPENSE, etc. I started
> >>>>>>>>> over with the file and went through and fixed all of these
> >>>>>>>>> (though we still need an accountant to review this at some
> >>>>>>>>> point), and I did the search/replace for all of the
> >>>>>>>>> invalid glAccountTypeIds and added the missing
> >>>>>>>>> glAccountClassId, etc after looking at the changes you made
> >>>>>>>>> to get a head start...
> >>>>>>>>> Anyway, it's all cleaned up now and imports fine. The changes
> >>>>>>>>> are in CVS.
> >>>>>>>>> -David
> >>>>>>>>> On Aug 6, 2004, at 6:58 AM, Brett wrote:
> >>>>>>>>>
> >>>>>>>>>> David,
> >>>>>>>>>>
> >>>>>>>>>> I had to modify the GeneralChartOfAccounts.xml to import the
> >>>>>>>>>> data into the
> >>>>>>>>>> accounting module. There were some incorrect account types.
> >>>>>>>>>> I also found
> >>>>>>>>>> some accound IDs formatted as "-XXXXXX-". This format
> >>>>>>>>>> didn't seem
> >>>>>>>>>> consistent with the other IDs so I removed the "-" characters.
> >>>>>>>>>>
> >>>>>>>>>> Also, there were some accounts at the end of the file that
> >>>>>>>>>> I commented out
> >>>>>>>>>> because of missing glAccountClassId or glResourceTypeId.
> >>>>>>>>>>
> >>>>>>>>>> Let me know if I missed something.
> >>>>>>>>>>
> >>>>>>>>>> Thanks,
> >>>>>>>>>>
> >>>>>>>>>>
> >>>>>>>>>> Brett
> >>>>>>>>>> <GeneralChartOfAccounts.xml>-----------------------------------
> >>>>>>>>>> -- -- -- -- --------------------------
> >>>>>>>>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
> >>>>>>>>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>>
> >>>>>>>> -----------------------------------------------------------------
> >>>>>>>> -- --
> >>>>>>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
> >>>>>>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>>
> >>>>>> -------------------------------------------------------------------
> >>>>>> --
> >>>>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
> >>>>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
> >>>>
> >>>>
> >>>>
> >>>> ---------------------------------------------------------------------
> >>>> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
> >>>> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
> >>
> >>
> >> ---------------------------------------------------------------------
> >> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
> >> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: dev-unsubscribe at ofbiz.dev.java.net
> For additional commands, e-mail: dev-help at ofbiz.dev.java.net
>
>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 2794 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/dev/attachments/20040806/d4e9acaf/smime.bin
More information about the Dev
mailing list