How to implement activity based costing in ofbiz

[Vikrant.Rathore]

Hi Everyone,

Does anyone have an idea how to implement activity based costing in ofbiz? To be precise what I mean is in QuickBooks if you are running multiple stores you can have P & L (Profit and Loss) by store by using class which identifies what activity/program/function will be affected by the transaction or what funding source is affected.

But to have P & L for each store or business division the General Journal should have a store code or some cost center code similar to class in Quickbooks.

There are some customization which can be done to accommodate it. But does anyone can point to existing data model in accounting which can be used for similar purpose.

Regards,
Vikrant

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.7/830 - Release Date: 6/3/2007 12:47 PM
 

[Cameron Smith-6]

Dear Vikrant, you could create a Party (or PartyGroup)
to represent the internal organizational unit which
runs each store.

Then associate a certain GlAccount with this Party via
GlAccountRole.

The only drawback here is that GlAccountRole does not
have an organizationPartyId field.  Therefore if your
system runs the accounting for multiple distinct
organizations, and two of them use the same store, you
will have to be careful to avoid clashes between
GlAccountRoles.  Perhaps by creating distinct roles
with a certain unique prefix or suffix based on the
accounted' party's ID.

cameron

> > Subject: How to implement activity based costing
in

> ofbiz
> Date: Mon, 4 Jun 2007 17:32:04 +0800
> From: <[hidden email]>
> To: <[hidden email]>
>
> Hi Everyone,
>
> Does anyone have an idea how to implement activity
> based costing in ofbiz? To be precise what I mean is
> in QuickBooks if you are running multiple stores you
> can have P & L (Profit and Loss) by store by using
> class which identifies what
> activity/program/function will be affected by the
> transaction or what funding source is affected.
>
> But to have P & L for each store or business
> division the General Journal should have a store
> code or some cost center code similar to class in
> Quickbooks.
>
> There are some customization which can be done to
> accommodate it. But does anyone can point to
> existing data model in accounting which can be used
> for similar purpose.
>
> Regards,
> Vikrant

      ___________________________________________________________
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html 

[Vikrant.Rathore]

Hi Cameron,

The main problem in this approach is still the same suppose I have a company called ABC which has 3 stores now suppose I receive an invoice from a vendor for $1000.
This invoice is for 3 stores with $400, $300 and $300. This is of type expense so my accounting entry would be:
1. DR. Expense (Store 9000) $400
2. DR. Expense (Store 9010) $300
3. DR. Expense (Store 9020) $300
4. CR. AP (Vendor ABC) $1000

For any sales my entry would be like:
1. DR. AR (Store 9000) $20
2. CR. Revenue (Store 9000) $18
3. CR. VAT (Store 9000) $2
4. DR. Cash (Store 9000) $20
5. CR. AR (Store 9000) $20
For inventory and COGS we will have:
1. DR. COGS (Store 9000) $10
2. CR. INVENTORY (Store 9000) $10

So similar to concept of class in quickbooks I can have a single COA (Charts of Accounts) for the whole company and then use this store id dimension or class to segregate it across stores or cost center.

This would be able to generate a clean Profit and Loss and all the expense report by shop and by cost center.

Using party role id means creating a subsidiary. Indeed in store setup we already have a store id so it can be similar.

Regards,
Vikrant



-----Original Message-----
From: Cameron Smith [mailto:[hidden email]]
Sent: Tuesday, June 05, 2007 1:41 PM
To: [hidden email]
Subject: Re: How to implement activity based costing in ofbiz

Dear Vikrant, you could create a Party (or PartyGroup)
to represent the internal organizational unit which
runs each store.

Then associate a certain GlAccount with this Party via
GlAccountRole.

The only drawback here is that GlAccountRole does not
have an organizationPartyId field.  Therefore if your
system runs the accounting for multiple distinct
organizations, and two of them use the same store, you
will have to be careful to avoid clashes between
GlAccountRoles.  Perhaps by creating distinct roles
with a certain unique prefix or suffix based on the
accounted' party's ID.

cameron

> > Subject: How to implement activity based costing
in

> ofbiz
> Date: Mon, 4 Jun 2007 17:32:04 +0800
> From: <[hidden email]>
> To: <[hidden email]>
>
> Hi Everyone,
>
> Does anyone have an idea how to implement activity
> based costing in ofbiz? To be precise what I mean is
> in QuickBooks if you are running multiple stores you
> can have P & L (Profit and Loss) by store by using
> class which identifies what
> activity/program/function will be affected by the
> transaction or what funding source is affected.
>
> But to have P & L for each store or business
> division the General Journal should have a store
> code or some cost center code similar to class in
> Quickbooks.
>
> There are some customization which can be done to
> accommodate it. But does anyone can point to
> existing data model in accounting which can be used
> for similar purpose.
>
> Regards,
> Vikrant

      ___________________________________________________________
Yahoo! Mail is the world's favourite email. Don't settle for less, sign up for
your free account today http://uk.rd.yahoo.com/evt=44106/*http://uk.docs.yahoo.com/mail/winter07.html 

No virus found in this incoming message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.9/832 - Release Date: 6/4/2007 6:43 PM
 

No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.5.472 / Virus Database: 269.8.9/832 - Release Date: 6/4/2007 6:43 PM