Skip to Content
This question has been flagged
1 Reply
1475 Views
Avatar
Fern wealth

I am using V14 and would like to divide my administrative department expenses among several analytic accounts.

Ex: We pay rent, IT, telephone bills each month and I want to divide their cost equally between 2 departments:

1. Dept A - 50%

2. Dept B - 50%

 How can I do this?

I tried this configuration:

Step 1: I create 2 analytic accounts for each Dept A and B (leaving Group and customer blank)

Step 2: I create my analytic tag "Admin costs" and tick the Distribution box adding two lines for each of my Dept A and B with 50% allocation.

Step 3: I book a Vendor bill and add the "Admin costs" tag to it and post it. 

Step 4: I run a Profit & Loss, I can see my expense. When I select one of the Dept and the Admin Dept Tag on the "Analytic" button, nothing happens... I thought this would show me half of my bill cost?  Am I missing something?

Thank you,

Avatar
Discard
Avatar
sgsii
Best Answer

I suggest you assign an Analytic Account to each department and when creating a bill split your costs into two lines with respective departments assigned against each line. Then you can run analytic reports for each department.

You can also create a filter based on analytic accounts and use it in your P&L reports. It will allow you to view each department costs side by side. With analytic tags you can only view one at a time. Good luck.

Avatar
Discard