|
#4
| |||
| |||
| 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
| |||
| |||
| Tracy pisze: - quote - > I told money that I wanted to create a new loan account. That I am lending
I usually create a special account to hold the money lent to someone.> money to my son in the amount of $15,000 and 0% interest for 100 payments. -- /\ /\ [ Jakub 'Kocureq' Anderwald ] /\ /\ =^;^= [ [nick][at][nick].com ] =^;^= / | [ GG# 1365999 ICQ# 31547220 ] | \ (___(|_|_| [ kocureq[at]jabber.org ] |_|_|)___) |
|
#2
| |||
| |||
| 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
| |||
| |||
| "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
Although it's possible to set up a loan with a $0.00 balance and $0.00> 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 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 |
| | |||
| |||
| In microsoft.public.money, Tracy wrote: - quote - > I want to set up an account in money to keep track of where the money went
Money assumes that the loan is an asset worth $15000. Unfortunately> 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". it doesn't take money out. - quote - > But...doing that doesn't help in setting up the loan I want to create for
This is a deficiency of Money. It does not take into the account the> loaning my son the money. > This scenario actually ADDS $15,000 to my account summary 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
Since you are not charging interest, you could just set the loan up> am? 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
| |||
| |||
| 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 | |
| |