Community mailing list archives

community@mail.odoo.com

Re: Using analytical account as cost center

by
Apoorv Soral
- 04/02/2016 08:06:54

Hi John,

There is a functionality called Analytic Plan. The menu entry is under Accounting > Configuration >Multi Plan.
You can also click on more on a form view of a partner record and click on Analytic Distribution but for what I can understand it is meant to spread the cost and not to do a selective input.

If someone can help me understand what Analytic distribution does that will be great.

On Apr 2, 2016 3:07 PM, "John Pia Jr" <jpiajr@southmill.com> wrote:

Apoorv,

I myself I'm trying to answer that same question. Somewhere I believe that I saw a module that will allow me to add multiple analytical accounts. If I can locate it I will post it here.

I did find a module called "cost centers", which basically is a copy of the analytical account module. Having both analytical accounts and the cost center module installed will allow you to identify a location, which would be the cost center, as well as an analytical account for project accounting.

The only objection I have to this as of now, which can be changed with a little bit of development, is that the cost center object is not included in the treasury analysis BI report.
All I need to do is add the cost center field to the bi reporting engine and I think that will be able to achieve what both you and I are looking to do.

Here is the cost center module:
https://apps.openerp.com/apps/modules/8.0/account_cost_center/

Let me know your thoughts, I hope this helps

- John Pia Jr

On Apr 1, 2016 7:27 PM, "Apoorv Soral" <soral.apoorv@gmail.com> wrote:

But how will I group or even assign two or more analytical accounts to an invoice. Like analytical account for location as well as department.

On Apr 2, 2016 3:07 AM, "John Pia Jr" <jpiajr@southmill.com> wrote:

After doing some research, I figured out a way to find what I was looking for.

I used the entry analysis report under reports > accounting >  entry analysis

I grouped all journal entries by

> Account Type
     > Account
         > Analytical Account.

This actually works much better for me, this way I can leave my chart of accounts as simple as possible, and just rely on the analysis pivot tables for profit / loss / costing analysis

- John Pia Jr

On Apr 1, 2016 1:57 PM, "Apoorv Soral" <soral.apoorv@gmail.com> wrote:

I'm also interested to know the answer as I've used account segmentation in the past to drill down to specific information and it worked for me.
I'd still consider myself new to this concept of using analytical accounting for segmentation, not to say it is any less powerful. Can someone help me understand the same example and how would report if you need to know the expense per location and what if I want to further classify another dimension as line of business.
So, expense by line of business
Expense by location
Expense by location by line of business

Please help.

On Apr 1, 2016 10:18 PM, "John Pia Jr" <jpiajr@southmill.com> wrote:

Currently our cost center is built into the logic when creating a cost account,

Example:

6-250- 100

6 = major account - Expenses
250 = cost account - Electrical
100 = cost center - Location A

Having our account structure setup like this, allows me to run a general ledger report, and under any given cost account, I am able to see the breakdown for that account as it relates to each cost center.

Example of current GL report

6-250 = Total Electrical Expenses for company
    6-250- 100 = Electrical expense for locationA
    6-250- 200 = Electrical expense for locationB
    6-250- 300 = Electrical expense for locationC

I intend on using analytical account as my call center, which will allow me to drop the last 3 digits in my account code and separate accounts from call centers.

I have two questions:

1. Is it possible to produce the same type of general ledger report I'm used to if I use analytical accounts as the cost center?

2. If possible, am I able to create a relationship between an analytical account and they cost account.

Any input would be wonderful.

Thank you

Example:
- John Pia Jr

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe