General Question About Accounts

This is a discussion on General Question About Accounts within the Microsoft Money forums in Microsoft Tools category; This may sound very dumb but I am having a problem getting my individual accounts to balance. For example, I purchased textbooks for $100, but later i received a credit in the amount of $50 as a refund. I use the education:textbooks category for the initial expense and thought I could use the the same account for the refund (just saving as a deposit rather than a expense) Shouldn't this offset the original balance? For some reason the credit is totaled into the total expense. This is evident when I open the category to see the transactions. Any ideas as ...

Go Back   Application Development Forum > Microsoft Tools > Microsoft Money

Object Mix

Register FAQ Calendar Search Today's Posts Mark Forums Read
  #1  
Old 09-10-2007, 03:24 PM
=?Utf-8?B?Y3JhaWd3Nzk=?=
Guest
 
Default General Question About Accounts

This may sound very dumb but I am having a problem getting my individual
accounts to balance. For example, I purchased textbooks for $100, but later
i received a credit in the amount of $50 as a refund. I use the
education:textbooks category for the initial expense and thought I could use
the the same account for the refund (just saving as a deposit rather than a
expense) Shouldn't this offset the original balance? For some reason the
credit is totaled into the total expense. This is evident when I open the
category to see the transactions. Any ideas as to why, or even better, a
solution to solve this problem? I hope I explained the situation in enough
detail.

Thanks!
Reply With Quote
  #2  
Old 09-10-2007, 03:50 PM
=?Utf-8?B?S3lsZQ==?=
Guest
 
Default RE: General Question About Accounts

I would suggest creating some kind of suspense account (many people call it
"in transit").

So, keeping your example going...when you made the purchase, I would do $50
as a charge to your "education: textbooks" account and $50 as a "transfer:
[suspense acount name]". When your credit comes in, you simply categorize
the amount as a "transfer: [suspense account name]" and the net effect is
zero. This keeps your "true" textbook expense of $50 in-tact. I do the same
thing when I receive rebates.

When I began using Money, I did what you're trying to do, which does work,
but I ran into problems when I was trying to run reports and sometimes Money
would only give me the balance of all the expenses but would ignore any
contra-entries (so it wouldn't give me the net balance).

"craigw79" wrote:

> This may sound very dumb but I am having a problem getting my individual
> accounts to balance. For example, I purchased textbooks for $100, but later
> i received a credit in the amount of $50 as a refund. I use the
> education:textbooks category for the initial expense and thought I could use
> the the same account for the refund (just saving as a deposit rather than a
> expense) Shouldn't this offset the original balance? For some reason the
> credit is totaled into the total expense. This is evident when I open the
> category to see the transactions. Any ideas as to why, or even better, a
> solution to solve this problem? I hope I explained the situation in enough
> detail.
>
> Thanks!

Reply With Quote
  #3  
Old 09-10-2007, 05:52 PM
=?Utf-8?B?Sm9hbmVlZQ==?=
Guest
 
Default RE: General Question About Accounts

There may be differences depending on what version of money you are using,
but...if you are using Reports to analyze the categories, be sure you check
how the reports are customized. For instance, the Spending by Category
report defaults to using only Expense transactions. If you Customize using
the Details tab, and select All Transactions, it will include the negative
expenses resulting from your rebate. At least, this works for me - I use
your method for rebates and refunds. Hope this helps.
--
Joaneee


"craigw79" wrote:

> This may sound very dumb but I am having a problem getting my individual
> accounts to balance. For example, I purchased textbooks for $100, but later
> i received a credit in the amount of $50 as a refund. I use the
> education:textbooks category for the initial expense and thought I could use
> the the same account for the refund (just saving as a deposit rather than a
> expense) Shouldn't this offset the original balance? For some reason the
> credit is totaled into the total expense. This is evident when I open the
> category to see the transactions. Any ideas as to why, or even better, a
> solution to solve this problem? I hope I explained the situation in enough
> detail.
>
> Thanks!

Reply With Quote
  #4  
Old 09-11-2007, 12:10 AM
=?Utf-8?B?Y3JhaWd3Nzk=?=
Guest
 
Default RE: General Question About Accounts

Thank you both for your quick responses. I changed the customizable options
in the report and it did exactly what I needed it to. Thanks again!
"Joaneee" wrote:

> There may be differences depending on what version of money you are using,
> but...if you are using Reports to analyze the categories, be sure you check
> how the reports are customized. For instance, the Spending by Category
> report defaults to using only Expense transactions. If you Customize using
> the Details tab, and select All Transactions, it will include the negative
> expenses resulting from your rebate. At least, this works for me - I use
> your method for rebates and refunds. Hope this helps.
> --
> Joaneee
>
>
> "craigw79" wrote:
>
> > This may sound very dumb but I am having a problem getting my individual
> > accounts to balance. For example, I purchased textbooks for $100, but later
> > i received a credit in the amount of $50 as a refund. I use the
> > education:textbooks category for the initial expense and thought I could use
> > the the same account for the refund (just saving as a deposit rather than a
> > expense) Shouldn't this offset the original balance? For some reason the
> > credit is totaled into the total expense. This is evident when I open the
> > category to see the transactions. Any ideas as to why, or even better, a
> > solution to solve this problem? I hope I explained the situation in enough
> > detail.
> >
> > Thanks!

Reply With Quote
Reply


Thread Tools
Display Modes


All times are GMT -5. The time now is 02:25 AM.


Powered by vBulletin® Version 3.7.2
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.2.0
vB Ad Management by =RedTyger=

In an effort to better serve ads to our visitors, cookies are used on objectmix.com. For more information, check out our Privacy Policy.