advice on (sub)/categories please


K

KRK

Hello,

I have MN2001

I am trying to tidy up my records to make budget & cash flow forecasting
easier. Over the years my categories & subcategories have got a bit out of
control, and I need some general advice.

For example, I have a category 'Car' , with subcategories 'Petrol' ,
'Servicing' , 'Tax & insurance' , 'New Car'. Petrol is a monthly
expenditure, Servicing, tax, insurance is annual, and 'New Car' is every 8
years or more.

Is it sensible to keep 'new car' in the same category as 'petrol' ? Or
should I put it somewhere completely different, eg with other 'rare'
expenditures.

Another example. I have a category 'Energy' which has subcategories
'electricity' and 'gas'. These are both monthy direct debits, but under
'gas' I also put my annual gas boiler servicing costs. Would it be better to
put this elsewhere, eg under 'Home/maintenance' ?

I know this question is a bit woolly, but I do need some general advice on
which way to go before I start re-categorising (and hopefully simplifying)
my records.

With thanks for all ideas

KK
 
Ad

Advertisements

M

Mark

Hello,

I have MN2001

I am trying to tidy up my records to make budget & cash flow forecasting
easier. Over the years my categories & subcategories have got a bit out of
control, and I need some general advice.

For example, I have a category 'Car' , with subcategories 'Petrol' ,
'Servicing' , 'Tax & insurance' , 'New Car'. Petrol is a monthly
expenditure, Servicing, tax, insurance is annual, and 'New Car' is every 8
years or more.

Is it sensible to keep 'new car' in the same category as 'petrol' ? Or
should I put it somewhere completely different, eg with other 'rare'
expenditures.
I guess it really depends on where it would be most useful. Something
like this I would put in a separate category, especially since Money
is not very good at handling irregular expenses like this.
Another example. I have a category 'Energy' which has subcategories
'electricity' and 'gas'. These are both monthy direct debits, but under
'gas' I also put my annual gas boiler servicing costs. Would it be better to
put this elsewhere, eg under 'Home/maintenance' ?
I put it under Home maintenance.
I know this question is a bit woolly, but I do need some general advice on
which way to go before I start re-categorising (and hopefully simplifying)
my records.
--
(\__/) M.
(='.'=) Due to the amount of spam posted via googlegroups and
(")_(") their inaction to the problem. I am blocking most articles
posted from there. If you wish your postings to be seen by
everyone you will need use a different method of posting.
[Reply-to address valid until it is spammed.]
 
T

teabag

It probably doesn't matter how you allocate subcategories - though the way
you do it may affect the freedom you have to create composite Reports.

I put: solid fuel, electricity, gas, water, telephone, ISP as subcategories
under Bills.
Petrol, Diesel, MOT, Servicing under Car.
Council Tax, Income Tax, Road Fund Licence, TV Licence, Passport renewal
under Tax.
House Insurance, Contents Insurance, Car Insurance, Travel Insurance under
Insurance.

Individual subcategories are more important to me than categories (groups of
2 or more subcategories) - but I suspect this is just a matter of taste.
There is certainly no prescribed Right and Wrong way.

teabag
 
C

ChrisW

On Thu, 5 Nov 2009 13:28:07 -0000, "KRK"

I am trying to tidy up my records to make budget & cash flow forecasting
easier. Over the years my categories & subcategories have got a bit out of
control, and I need some general advice.
I have to confess to regularly getting my categories and sub-
categories in a mess. One thing that regularly frustrates me is
Money's inability to ever accept that a Category/sub-category can
exist as both Income and Expense.

One of the uses I make of Money is to help me manage a charity's
finances. I wish to setup a category for an event which then has both
income and expense sub-categories but Money won't allow that. A
Cateory cannot exist as both. I find various ways to work around
this but am never happy doing so. Is there a simple answer somwehere
that I am missing? It makes producing reports complicated.
 
T

teabag

I found Sage's TAS Books 1 (now Instant Accounts) ideal for a small charity
that I am involved with - much better than MS Money.

Reverting to the MS program which I use at home, I guess you simply input a
negative number to force Money to accept income into an expense category or,
similarly, a debit into an income category - and then disregard the 'nag'.
What other tricks have you found to work around this income & expense
limitation?

teabag
 
C

Cal Learner

On Thu, 5 Nov 2009 13:28:07 -0000, "KRK"



I have to confess to regularly getting my categories and sub-
categories in a mess. One thing that regularly frustrates me is
Money's inability to ever accept that a Category/sub-category can
exist as both Income and Expense.

One of the uses I make of Money is to help me manage a charity's
finances. I wish to setup a category for an event which then has both
income and expense sub-categories but Money won't allow that. A
Cateory cannot exist as both. I find various ways to work around
this but am never happy doing so. Is there a simple answer somwehere
that I am missing? It makes producing reports complicated.
You might want to consider using a Classification called Event. You
should be able to generate reports for the event. If you de-select
an Event type when you customise a report, then only the items with
the selected Event will show in the report. If you select all Events
then even transactions with the Event blank will show.

To create a Classification, click
Banking->AccountTools->Categories&Payees->Classification1 or
Banking->AccountTools->Categories&Payees->Classification2. Name that
appropriately.

To delete a To delete a classification called Events, click
Banking->AccountTools->Categories&Payees click Events in the left
column.
Then click DeleteClassification.



Experiment with a copy of your file.
 
Ad

Advertisements

T

TW

ChrisW said:
On Thu, 5 Nov 2009 13:28:07 -0000, "KRK"



I have to confess to regularly getting my categories and sub-
categories in a mess. One thing that regularly frustrates me is
Money's inability to ever accept that a Category/sub-category can
exist as both Income and Expense.

One of the uses I make of Money is to help me manage a charity's
finances. I wish to setup a category for an event which then has both
income and expense sub-categories but Money won't allow that. A
Cateory cannot exist as both. I find various ways to work around
this but am never happy doing so. Is there a simple answer somwehere
that I am missing? It makes producing reports complicated.
In Money 2001 you can turn off Income / Expense enforcement via ...

Tools | Options | Categories | Untick "Require the correct type of category
for each transaction"

Not sure about other versions but there may be something hidden in a similar
place.

Trev.
 
C

ChrisW

You might want to consider using a Classification called Event. You
should be able to generate reports for the event. If you de-select
an Event type when you customise a report, then only the items with
the selected Event will show in the report. If you select all Events
then even transactions with the Event blank will show.

To create a Classification, click
Banking->AccountTools->Categories&Payees->Classification1 or
Banking->AccountTools->Categories&Payees->Classification2. Name that
appropriately.

To delete a To delete a classification called Events, click
Banking->AccountTools->Categories&Payees click Events in the left
column.
Then click DeleteClassification.



Experiment with a copy of your file.
Many thanks. I had never considered or really understood
classifications. I will experiment with this and see if it does the
job.
 
C

ChrisW

I found Sage's TAS Books 1 (now Instant Accounts) ideal for a small charity
that I am involved with - much better than MS Money.

Reverting to the MS program which I use at home, I guess you simply input a
negative number to force Money to accept income into an expense category or,
similarly, a debit into an income category - and then disregard the 'nag'.
What other tricks have you found to work around this income & expense
limitation?

teabag
Nothing very sophisticated I am afraid. I just create two categories
- one call <event> income and the other <event> expenses. I shall now
experiment using the suggestion made by Cal
 
C

ChrisW

I found Sage's TAS Books 1 (now Instant Accounts) ideal for a small charity
that I am involved with - much better than MS Money.

Reverting to the MS program which I use at home, I guess you simply input a
negative number to force Money to accept income into an expense category or,
similarly, a debit into an income category - and then disregard the 'nag'.
What other tricks have you found to work around this income & expense
limitation?

teabag
Nothing very sophisticated
 
Ad

Advertisements

C

ChrisW

I found Sage's TAS Books 1 (now Instant Accounts) ideal for a small charity
that I am involved with - much better than MS Money.

Reverting to the MS program which I use at home, I guess you simply input a
negative number to force Money to accept income into an expense category or,
similarly, a debit into an income category - and then disregard the 'nag'.
What other tricks have you found to work around this income & expense
limitation?

teabag
Nothing more sophisticated than creating two separate categories for
the one event - "<event> income" and "<event> expenses". I shall now
experiment using the classification facility suggested by Cal Learner.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Categories and Sub-Categories 1
Sub Category 5
categories & sub-categories 1
Sub Categories 2
Sub Categories 10
Sub Categories 6
split category and sub-category 3
M05 Category and Sub-Categorys 1

Top