Same category for Income and Expense

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
grachte
New MMEX User
Posts: 9
Joined: Mon Nov 22, 2021 10:04 am
Are you a spam bot?: No

Same category for Income and Expense

Post by grachte »

In the user manual I found the following note: "Don't use the same category for Income and Expense, as this will cause incorrect balance calculations.".
Can you elaborate on this, because I have the intention to use some mixed in/out categories, but I'm afraid to mess up my database.

Thanks,
Eric
Nikolay
MMEX Developer
Posts: 1535
Joined: Sat Dec 06, 2008 2:27 pm
Are you a spam bot?: No
Location: Sankt-Petersburg, Russia

Re: Same category for Income and Expense

Post by Nikolay »

This is just a recommendation, nothing more. You can use the categories at your discretion.
MartinArmstrong
MVP MMEX User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Same category for Income and Expense

Post by MartinArmstrong »

Nikolay wrote: Sat Dec 04, 2021 7:59 pm This is just a recommendation, nothing more.
I've always been puzzled by the purpose of the Notes about categories in the manual.

Similar notes appear in two sections:

Category notes.png
Category notes.png (60.11 KiB) Viewed 2567 times

As worded in section 9.2, it doesn't appear to be just a recommendation.

Does it cause incorrect balance calculations? If not, then what is the real reason for these notes?
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Same category for Income and Expense

Post by Renato »

I can't understand the point of this advice either.
Use this for years so and could not find any problems.
,
Example: Doctor's bill <> health insurance credit = effective health costs.
Of course, the time history can only tell you a little, since the credit notes arrive after the fact.
Renato Forum Administrator
mikhailo2608ilaol
New MMEX User
Posts: 17
Joined: Tue Feb 09, 2021 6:08 pm
Are you a spam bot?: No

Re: Same category for Income and Expense

Post by mikhailo2608ilaol »

Health care expenditures are a special case in which the recommendations make sense.

In the scenario cited where Doctor's Bills (expenses/withdrawals) less reimbursed health care credits (incomes/deposits) equals effective medical costs if you put them both into the same category the actual cost of medical care is obscured by the total - effective medical cost - rather than the components Doctor's Bills and Reimbursed Health Care credits. For most people Doctor's Bills equate to effective health care costs. Only those who are fortunate enough to have a portion of their doctor's bills reimbursed by their employers health insurance does the effective health care cost become lower than the the cost of the Doctor's bills. To accurately track your health care costs you need to keep the charges and the reimbursements separate. This is because you may not get those reimbursements in the future if you change employers or the new collective bargaining unit agreement with your company eliminates or reduces the reimbursement or you retire.

If you are only concerned with your total out of pocket health care costs then you should be comfortable with having a single category for both your Doctor's bills and the reimbursements. But you may find it advantageous to aggregate the expenses and the reimbursements separately - I do - then this requires a separate category for each. The downside of separate categories in an instance like this is that in order to find the effective health care costs (your out of pocket health care costs) you have to manually subtract the credits (reimbursements) from the expenses (Doctor's bills). The upside of separate categories in an instance like this is that you can accurately compare health care costs over time and not be concerned over with whether your employment status over a particular period had an effect on the actual health care costs as opposed to the out of pocket health care costs.
Last edited by mikhailo2608ilaol on Sun Dec 05, 2021 11:38 pm, edited 1 time in total.
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Same category for Income and Expense

Post by Renato »

That's absolutely right, the question is the level of detail you want.
Personally, I am interested in how much I spent.
The annual statement from the health insurance company shows me all the costs.
Renato Forum Administrator
Rodrigo
New MMEX User
Posts: 1
Joined: Fri Dec 24, 2021 12:30 pm
Are you a spam bot?: No

Re: Same category for Income and Expense

Post by Rodrigo »

grachte wrote: Sat Dec 04, 2021 3:43 pm In the user manual I found the following note: "Don't use the same category for Income and Expense, as this will cause incorrect balance calculations.".
Can you elaborate on this, because I have the intention to use some mixed in/out categories, but I'm afraid to mess up my database.

Thanks,
Eric
I've tried to use the same category that I use for Expense as an Reimbursement/Income, my expectation was that the values on the reports would compensate the Expense/Income and show the value that I actually got out of my pocket.

Here my findings so far:
  1. The Home Page shows the values as I expected.
  2. The "Where the Money Goes" report also shows the values as I expected.
  3. The "Income vs Expenses/Monthly" doesn't discount the Reimbursement on the Expense column, but it sums the Reimbursement on the Income column, so the Balance is ok.
You can check this behavior on the attached database.
Attachments
test.mmb
(256 KiB) Downloaded 131 times
Last edited by Rodrigo on Fri Dec 24, 2021 1:00 pm, edited 1 time in total.
whall3y
MMEX Developer
Posts: 343
Joined: Fri Aug 21, 2020 5:44 pm
Are you a spam bot?: No

Re: Same category for Income and Expense

Post by whall3y »

The "Income vs Expenses/Monthly" doesn't discount the Reimbursement on the Expense column, but it sums the Reimbursement on the Income column, so the Balance is ok.
Yes, this takes all WITHDRAWALS as Expense, and all DEPOSITS as Income. Which results in the correct balance as you note. MMEX does not view a 'Category' as either and Expense or Income so cannot account these any other way.
Post Reply