[OFBiz] Dev - Modified GeneralChartOfAccounts.xml file

[David Jones]

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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2363 bytes
Desc: not available
Url : http://lists.ofbiz.org/pipermail/dev/attachments/20040806/672d7d62/smime.bin