Go Back   CDN Business Directory > Main Category > Microsoft Money

 
 
Thread Tools Display Modes
  #4  
Old 08-26-2008, 07:05 PM
Tracy
Guest
 
Posts: n/a
Default Re: Lending money from #6 account to another person

None of the suggestions that were received did exactly what I wanted to.
However, I did combine a few and came up with my own solution:

All done in MS Money:
Created a cash account called Son Cash Loan
Created a bank savings account called #14 (also created at the actual bank)
Transferred 15K out of #6 and into Son Cash Loan
changed Son Cash Loan to a Closed Account
Any time a deposit (payment) is physically made at the bank:
the deposit is made into #14 (also at the bank)
I show my hidden accounts
transfer from Son Cash Loan to #14
hide closed accounts.

This procedure will not raise my Bank Accounts Subtotal,
nor will it raise my Total Account Balance of all accounts
The only time it will raise is when he makes a payment.
Also....using the cash account and the #14 account allows me to see how much
is paid (by viewing the #14 account)
and how much is still owed (by showing hidden accounts).

When the 15K is paid off, all the money can then be transferred back into
the #6 account.

Tracy



"Tracy" <INVALID[at]INVALID.com> wrote in message
news:Y5idnazD84lUJTTVnZ2dnUVZ_judnZ2d[at]comcast.com...
- quote -

> I want to set up an account in money to keep track of where the money went
> and when it gets paid back.
> However...I've run into a problem that, to me, doesn't make sense.
> I told money that I wanted to create a new loan account. That I am
> lending money to my son in the amount of $15,000 and 0% interest for 100
> payments.
> Now...the problem comes in when I look at my account list. It shows that
> I still have the $15,000.
> I am loaning him the money from my #6 account.
> I would THINK that when I loan money to someone, that Money would ask me
> 'from what account do you want to remove $15,000 for this lending account'
> so that my account summary would drop by that same amount.
> Hence, Money doesn't know that I even gave him $15,000. The only way I
> can do that is to create an entry in the #6 account and just "take it out
> in cash".
> But...doing that doesn't help in setting up the loan I want to create for
> loaning my son the money.
> This scenario actually ADDS $15,000 to my account summary
> What in the world am I doing wrong? Or is Money just "thinking" the way I
> am?
> Tracy



  #3  
Old 08-19-2008, 08:46 PM
Kocureq
Guest
 
Posts: n/a
Default Re: Lending money from #6 account to another person

Tracy pisze:

- quote -

> I told money that I wanted to create a new loan account. That I am lending
> money to my son in the amount of $15,000 and 0% interest for 100 payments.


I usually create a special account to hold the money lent to someone.


--
/\ /\ [ Jakub 'Kocureq' Anderwald ] /\ /\
=^;^= [ [nick][at][nick].com ] =^;^=
/ | [ GG# 1365999 ICQ# 31547220 ] | \
(___(|_|_| [ kocureq[at]jabber.org ] |_|_|)___)
  #2  
Old 08-18-2008, 09:40 PM
Dick Watson
Guest
 
Posts: n/a
Default RE: Lending money from #6 account to another person

Money Loan Accounts should allow for the initial proceeds/funding to be a
Transfer to/from some other Money account. They don't. See
http://umpmfaq.info/faqdb.php?q=193 for a workaround.

"Tracy" wrote:

- quote -

> I want to set up an account in money to keep track of where the money went
> and when it gets paid back.
> However...I've run into a problem that, to me, doesn't make sense.

  #1  
Old 08-18-2008, 08:20 PM
Scott Tyler
Guest
 
Posts: n/a
Default Re: Lending money from #6 account to another person


"Tracy" <INVALID[at]INVALID.com> wrote in message
news:Y5idnazD84lUJTTVnZ2dnUVZ_judnZ2d[at]comcast.com...
- quote -

> I want to set up an account in money to keep track of where the money went
> and when it gets paid back.
> However...I've run into a problem that, to me, doesn't make sense.
> I told money that I wanted to create a new loan account. That I am
> lending money to my son in the amount of $15,000 and 0% interest for 100
> payments.
> Now...the problem comes in when I look at my account list. It shows that
> I still have the $15,000.
> I am loaning him the money from my #6 account.
> I would THINK that when I loan money to someone, that Money would ask me
> 'from what account do you want to remove $15,000 for this lending account'
> so that my account summary would drop by that same amount.
> Hence, Money doesn't know that I even gave him $15,000. The only way I
> can do that is to create an entry in the #6 account and just "take it out
> in cash".
> But...doing that doesn't help in setting up the loan I want to create for
> loaning my son the money.
> This scenario actually ADDS $15,000 to my account summary
> What in the world am I doing wrong? Or is Money just "thinking" the way I
> am?
> Tracy


Although it's possible to set up a loan with a $0.00 balance and $0.00
payments, enter a transfer to reflect the movement of money between the loan
and account #6, and then go through the "Change Loan Terms" dialog to set
the actual payment amount and frequency, it often isn't worth the trouble to
do this. Loan accounts are difficult to work with. The transfer has to
originate in the loan account (even though the money is coming from account
#6) and the date of the transfer can be no more than one month (assuming
monthly payments, I haven't tested this with other payment frequencies)
before the first payment is due. If you want to play around with this, I'd
suggest creating a new Money file. I did this a few years ago to verify
that it is possible to do this. Make sure the backup from the test file
doesn't overwrite the backup from your active file.

An easier solution would be to create a cash account "Loan to son" with
a -$15K starting balance in account details (which offsets the $15K starting
balance for the loan you set up), enter a $15K transfer from account #6 to
the cash account, and then close the cash account so that it doesn't appear
in the account list. You would then end up with $15K in the loan account
that you've already set up, $0.00 in the cash account created to facilitate
the transfer, and $15K less in account #6.

Money treats money lent as an asset, so your net worth will remain the same
once you square away the $15K lent. If you wanted to treat the money lent
as a liability so that your net worth drops by $15K until the loan is
repaid, it would be easier to delete the loan account, create a
category/subcategory for the money lent, enter a payment for -$15K against
that category/subcategory, and then enter payments for $150 against that
category/subcategory for each payment made. You could set up and save a
customized report to monitor the balance owed.

--
Scott Tyler
agent_scotty-at-hotmail-dot-com

 
Old 08-18-2008, 07:47 PM
Cal Learner-- MVP
Guest
 
Posts: n/a
Default Re: Lending money from #6 account to another person

In microsoft.public.money, Tracy wrote:

- quote -

> I want to set up an account in money to keep track of where the money went
> and when it gets paid back.
> However...I've run into a problem that, to me, doesn't make sense.
> I told money that I wanted to create a new loan account. That I am lending
> money to my son in the amount of $15,000 and 0% interest for 100 payments.
> Now...the problem comes in when I look at my account list. It shows that I
> still have the $15,000.
> I am loaning him the money from my #6 account.
> I would THINK that when I loan money to someone, that Money would ask me
> 'from what account do you want to remove $15,000 for this lending account'
> so that my account summary would drop by that same amount.
> Hence, Money doesn't know that I even gave him $15,000. The only way I can
> do that is to create an entry in the #6 account and just "take it out in
> cash".


Money assumes that the loan is an asset worth $15000. Unfortunately
it doesn't take money out.

- quote -

> But...doing that doesn't help in setting up the loan I want to create for
> loaning my son the money.
> This scenario actually ADDS $15,000 to my account summary


This is a deficiency of Money. It does not take into the account the
initial transfer of Money in setting up a loan. To work around this,
you can enter a Withdrawal, with no category, into you checking
account.

- quote -

> What in the world am I doing wrong? Or is Money just "thinking" the way I
> am?


Since you are not charging interest, you could just set the loan up
with an asset account called LoanToSon. Transfer $15000 to savings,
and do a transfer or deposit as you get payments. That does not
produce the nice loan schedule tho.
  #-1  
Old 08-18-2008, 05:58 PM
Tracy
Guest
 
Posts: n/a
Default Lending money from #6 account to another person

I want to set up an account in money to keep track of where the money went
and when it gets paid back.
However...I've run into a problem that, to me, doesn't make sense.

I told money that I wanted to create a new loan account. That I am lending
money to my son in the amount of $15,000 and 0% interest for 100 payments.

Now...the problem comes in when I look at my account list. It shows that I
still have the $15,000.
I am loaning him the money from my #6 account.
I would THINK that when I loan money to someone, that Money would ask me
'from what account do you want to remove $15,000 for this lending account'
so that my account summary would drop by that same amount.

Hence, Money doesn't know that I even gave him $15,000. The only way I can
do that is to create an entry in the #6 account and just "take it out in
cash".
But...doing that doesn't help in setting up the loan I want to create for
loaning my son the money.
This scenario actually ADDS $15,000 to my account summary

What in the world am I doing wrong? Or is Money just "thinking" the way I
am?

Tracy


 

Tags
account, lending, money, person
Similar Threads
Thread Forum Replies Last Post
Lending Money
Carolyn: When I write the check to lend money (an amortized loan with a Promissory Note), how do I categorize it? It's not an income or expense item. And...
Microsoft Money 5 04-30-2005 02:08 AM
Lending Money
JML: How does everyone track loans to others? Seems that the way to do it is to set up an asset account as a loan. What confuses me is how to record...
Microsoft Money 10 04-12-2005 06:40 PM
How to use money for a self-employed person
Gina: I am self-employed, operating several different types of small businesses. My income comes from a list of sources, periodically, but irregularly....
Microsoft Money 1 09-23-2004 11:11 PM
Lending Money
david: How to record a transaction of lending money to someone else? Please give a guide, thanks.
Microsoft Money 1 11-01-2003 12:59 PM
Add a person to money?
Kenneth Pardue: Hello all, I was adding a 401(k) plan to my fiancee's money account, and came across the Add a Person dialogue, where it asked me for birthdate,...
Microsoft Money 1 10-17-2003 03:53 AM



Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off

All times are GMT. The time now is 03:43 AM.