Dimensions?
Tom K. Weckstrom
Tom.K.Weckstrom@F-Secure.com
Tue, 26 Sep 2000 16:51:39 +0300
This was not the root of the problem.
I know it is possible to manage even quite complex aacoint treees like you
suggested, and roll-ups work fine in GnuCash as far as I have used them.
The problem is, if I happened to have two totally different aspects to the
expenses.
For example:
Expenses:Clothes:Shoes
Expenses:Clothes:Hats
Expenses:Clothes:Socks
Expenses:Clothes:Jackets
-------
Expenses:Sports:Sports-wear
Expenses:Sports:Licenses
Expenses:Sports:Excercise-shift-fees
Expenses:Sports:Equipment-rents
-------
Expenses:Rents:Home
Expenses:Rents:Sports
Expenses:Rents:Equipment-rents
Now, how do I make one sigle purchase of sports shoes visible in:
Expenses:Clothes:Shoes
AND
Expenses:Sports:Sports-wear
and in their respective roll-up-sums, too?
Another examples can be generated from the above account structure.
E.g. I bought a sports jacket. I want to see the expense in two different reports:
Expenses:Clothes:Jackets
Expenses:Sports:Sports-wear
A third one can be generated from the Equipment-rents. I'll leave that as an
exercise. ;-)
I know that like this my reports would show way bigger sums than what I would have
actually spent. That problem could be avoided by making the roll-ups only include
the transactions with their "primary" dimension on the respective account, and
only take the "lower level" dimension transactions into account in reports - if
desired.
Hope this clarified my idea.
Regards,
Tom
Christopher Browne wrote:
> On Tue, 26 Sep 2000 09:27:51 +1000, the world broke into rejoicing as
> "Phillip Shelton" <shelton@usq.edu.au> said:
> > No it is not a split. The shoes cost $50 so I want to have the clothes
> > account debited with $50 and the shoes account debited with $50 and the bank
> > account credited with $50.
>
> What you're probably looking for is the notion of "account roll-ups," or
> "account hierarchy."
>
> The above situation does _not_ involve having 3 $50 amounts; it only
> involves 2.
>
> What you have is something like:
> DR CR
> Clothing: Shoes $50
> Bank Account $50
>
> Where the account structure isn't just a list, but a tree, where you
> have a "main account," Clothing, and a "subaccount," Clothing:Shoes,
> which is a child of Clothing.
>
> The $50 is associated with "Clothing:Shoes," and is associated with all
> the parents moving on up the tree.
>
> If we have balances in various clothing-related accounts, we can look
> at them directly:
>
> Clothing: Shoes: $150
> Clothing: Hats: $75
> Clothing: Pants: $225
> Clothing: Socks: $25
>
> Or we can "roll them up," to get
> Clothing: $475
>
--
Tom Krister Weckström tel +358 9 8599 0133
F-Secure Corporation http://www.F-Secure.com
F-Secure products: Securing the Mobile Distributed Enterprise