Community mailing list archives
Re: Using analytical account as cost centerby
I did just find this.
See the second response
"The key is to create a view only master analytic account for each split element. So using the above example: Projects View Only Project 1 Parent=Projects Project 2 Parent=Projects
Branches View Only AKL Parent=Branches WGN Parent=Branches
Setup required (same for sales & purchases): 1. In settings/purchases tick 'Use multiple accounts on purchase orders' 2. Accounting/Configuration/Analytic Accounts/Analytic Journals - add as required 3. Create the analytic accounts as shown above - having the view account is the critical element. 4. Under Accounting/Configuration/Analytic Accounting/MultiPlans/Analytic Plans create a plan and add two lines (assuming as in my case you want two distributions). For my example, plan name=projects, root account=projects(ie the parent view account), min=0, max=100. repeat for the second plan 5. Accounting/Configuration/Journals/Journal - for whatever journal you are using the analytic distribution with, you need to add both the analytic journal and the analytic plan.
Now to use - under accounting/suppliers/supplier invoices create a new. on the line click into the analytic distribution field and create new - add the distribution required and validate the invoice.
Now look in the analytic chart of accounts to confirm the posting."
- John Pia Jr
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:
Let me know your thoughts, I hope this helps
- John Pia JrOn Apr 1, 2016 7:27 PM, "Apoorv Soral" <email@example.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" <firstname.lastname@example.org> 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
> 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 JrOn Apr 1, 2016 1:57 PM, "Apoorv Soral" <email@example.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" <firstname.lastname@example.org> wrote:
Currently our cost center is built into the logic when creating a cost account,
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.
- John Pia Jr