How to Accurately Show Interest Payments in Home Equity Loan

This is driving me crazy.  Does anyone have a good workaround?

I transfer $1000 out of my checking to my Home Equity Loan in MS Money.

Checking statement show $1,000 going out (nice and simple to reconcile)

Home Equity Loan statement shows $951 coming in and $49 interest payment 
($1,000 total).

It appears MS Money can't split the transfer into 2 transactions (one for 
the principal and one for the interest) to coincide how the bank shows the 

Any ideas?


TLMc (1)
4/5/2007 5:26:03 AM
money 28651 articles. 7 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 48

Well, if entering transactions by hand, this is simple.

Money can split the transaction into two components (assuming Money 05-07 
Advanced Registers or M04 or earlier and not Money Essential (MEss)). What 
at issue is that the downloaded data looks like two transactions, neither of 
which match the $1,000. If the bank downloaded the $1,000 payment credit and 
the $interest debit, you'd be fine.

Have you tried editing the first $1,000 transaction downloaded into a 
Transfer:[home equity loan account] and then accepting it and then, when 
downloading the other two, matching the $principal with the $1,000 and just 
let the Interest turn into a separate Expense transaction in the account? 
(New Balance = Old Balance - $1,000 + $interest). I don't know if Money will 
let you do this; I just enter transactions by hand and avoid dependence on 
the poorly formed and frequently incomplete download data that all too many 
FIs/Yodlee/CashEdge provide.

"TLMc" <> wrote in message
> This is driving me crazy.  Does anyone have a good workaround?
> I transfer $1000 out of my checking to my Home Equity Loan in MS Money.
> Checking statement show $1,000 going out (nice and simple to reconcile)
> Home Equity Loan statement shows $951 coming in and $49 interest payment
> ($1,000 total).
> It appears MS Money can't split the transfer into 2 transactions (one for
> the principal and one for the interest) to coincide how the bank shows the
> transaction.
> Any ideas?
> Thanks.
> Thanks. 

4/5/2007 12:45:23 PM

Similar Artilces:

outlook express shows header info in html mail
Hi i've sent an email thoruh a form in a php page; in some outlook express client the mail is shown with some header info and with html tag as they were plain text. I receive the email just as it should be, while my collegue (which is beside me in the same office) and my client don't. I already unchecked the 'Read message in plain text' checkbox. Has anyone any idea about it? NB: i used the phpmailer class in php. Thanks Vitto I presume that you are talking about something like Yahoo Groups where you send a message to the group and it is then sent to as...

New fonts do not show up in Visio 2003
I purchased a new font in both postscript and trutype formats. After installing them, they do not appear in the font list in Visio. They do however show up in the font list of other Office products. ...

How to select record in the subform and to show it in the main form? 09-27-07
Hi I have subform with datasheet view and I need to know how to select record in the subform and to show it in the main form? Thanks Forget my last post. I misuderstood your question. The code I gave will give the record "number" (sort o count from the table start) not the refered to record. -- Wayne Manchester, England. "Wayne-I-M" wrote: > Hi > > There are other methods but a simple one to use would be > > DoCmd.GoToRecord acForm, "MainFormName", acGoTo, > Forms!MainFormName!SubFormName.Form!LinkIngPrimaryField > > Chan...

Exchange 2003 Home Server
I have an Exchange 5.5 and an Exchange 2003 server with a separate Windows Server 2003 as the "main" Active Directory controller. My mailbox sits on the Exchange 2003 server. Yesterday, I used the Active Directory Users/Computers on the Domain Controller to move another user's mailbox to the Exch 2003 server (MAIL) from the Exch 5.5 Srvr (SMTP). It all looked OK until I started getting this: "A configuration error in the e-mail system caused the message to bounce between two servers or to be forwarded between two recipients. Contact your administrator." Use...

rep commission payment
I would like to be able to pay the reps without reentering the info as bills I'd have to look but I seem to recall I wrote something that automatically generated payables documents when you ran the transfer commissions. It would generate a document per commission record so if you ran your commissions in summary it would make one payables invoices (or credit memo if negative commissions). Or if in detail, then one document per commission record. Email me if you are interested in details. I'd have to see where it might be and if I have a demo or not if you are interested. If ...

"Show Placeholders" in options/view menu does'nt work.
I have a macro that places a large number of pictures on a spreadsheet. I would like the pictures to show as "placeholders" to speed up viewing/editing. The only problem is that this feature (under Tools/Options/View) does not work. All the images are being display normally. I have tried this in Excel 2000/2003/XP with the same result. This feature works great in MS Word. Please help. To see what I'm talking about. Go to Tools/Options/View and check the "Show Placeholders" option. Now insert a picture or clipart. The image will be displayed normally instead of just a b...

Finite Difference Spreadsheet
Have a look at the sumif statement that populates the temperature array I didn't think it would work but it seems to. Regards, Tim Fabe -- Message posted from ...

RMS 2.0 hangs when processing Payment
Hi, I have a back office 'server' and two registers. All are XP SP2. Most sales are rung up on Reg. 2 and Reg. 1 is used primarily for lookups and receiving. Reg 1 is also the PC Charge 'server'. Lately when it gets busy Reg 2 has been getting slower and slower on the Processing payment screen. Eventually it just freezes - not just the register but all of RMS. All three computers have to be rebooted for the system to work. There is no rhyme or reason that I can find. The DB is 10560KB, there is not a single item or payment type that is used when it freezes and au...

show info commandbutton
Hi, I have a commandbutton start and I want it to show a description botton with the word form when I put the mouse over. Thanks!! I'm not certain what you mean. Do you mean you want a form to appear when you hover over the button? This is not possible. You must click on the button. And it must have a macro assigned to it to display the form you create. Robert Flanagan Productivity add-ins and downloadable books on VB macros for Excel "canvas" <> wrote in message news:060e12f9-68c5-4221-ac9e-d22509f7b8f7...

How to have auto dialog box showing when selecting cell
I would like to have a dialog box appear each time a cell is selected in a column. I need the dialog box show the next cheque number and allow the user to change that if necessary. The cells cannot have a formula in it as that would cause problems when sorting. Is there a way to do this? Rob You could use data validation to do this. Firstly in an empty area of the worksheet define a cell that is equa to max(column range where the cehque numbers are shown) + 1. (ie max(a:a) + 1 Then set the data validation for the whole cheque input range to list list = the address of the new cell. Th...

Sounds, PPT 2004 11.3.5 ICONs show during slide show
I need help with sounds and not being able to hide the SOUND ICON from showing during the presentation. I have a large presentation and about 20 slides have sounds (bird songs, music clips) to go with the photos. I have used the same presentation and the sounds worked flawlessly many times over the last few years. I now have a problem. Unlike before, the sounds do NOT play for several of the slides, (except as explained below) On those slides for which I have wave files indicated by the icon that looks like a speaker (with a blue circle in the middle) the sounds work fine. I hide the icon by p...

How to compute Over short amount that shows in the z report
Hello, can anyone tell me how the over short amount in the z report is calculated? I am looking for the exact tables and its fieldnames for this computation. -- Thanks in advance, HNLuhar Hello HNLuhar....I copied and pasted this from the batch list reads the batch table to calculate "over/short"- hope this helps..... PaidOut + Dropped + LayawayClosed + PaidOnAccount + CustomerDepositRedeemed + ClosingTotal) - (OpeningTotal + Sales + Returns + Tax + Shipping + LayawayPaid + PaidToAccount + CustomerDepositMade + DebitSurcharge + CashBackSurcharge "HNLuhar...

outlook inbox showing (-1) emails & 4294967295 unread messages
Hi Peops Have a very strange problem with one of my users on the network and have not found any thing relating to this problem anywhere on the web. Whats happening is i have a user running outlook xp and even though he has no new emails in his inbox he has a blue (-1) sign next to his inbox, and in the bottom left of the screen it says he has 4294967295 unread messages... But once a new email comes in then it goes back to normal, once the user reads the email the figure goes back to -1 again, never come across this before in 6 years, any ideas would be greatly appreciated. Cheers ...

Outlook XP to Outlook Vista Home Premium
I have my old outlook stored on an external HDD as my old computer died. The new computer has Vista, but when I try to retrieve the old email from the E drive, I get stuck. Can someone help me with the steps to retrieve the old emails? Thank you very much! ...

show attachment in e-mail header
I would like to cosutomize the e-mail header that it shows the e-mail as example below: "from:" "sent:" "to:" "Subject" "Attachment" Thanks, Ursula A. and here's the question: At present my e-mail settings do not show the "Attachment", so when I send out an attachment it is not mentioned. How can I add this item? >-----Original Message----- >I would like to cosutomize the e-mail header that it >shows the e-mail as example below: >"from:" >"sent:" >"to:" >"Subject"...

show full account number in Dynamics GP GJ entry
show full account number in Dynamics GP GJ entry it does not make sense that you can't see the last 2 digits ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane.

Reading my home email while I'm at work
I have Outlook Express 6 on my computer at home and at work. Is there a way I can check my home email from my office computer? Try posting this in an Outlook Express news group - this is not one of them. Outlook is a part of Microsoft Office and is what this group supports. Outlook Express is a part of Internet Explorer and has its own news groups. You can also find some good Outlook Express information here: --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, a...

Which edition contains excel, Does Microsoft Home? Thanks
Excel comes with MS Office Suite or as a standalone application. Excel or Office Suite is not included with any Windows Operating System See this site for Office Suite comparisons. Gord Dibben MS Excel MVP On Thu, 12 Jan 2006 10:02:03 -0800, "vintage" <> wrote: ...

Outlook 2002 not showing url in status bar on scroll over
Previous versions of Outlook showed the url of a hyperlink in a message. But my Outlook 2002 wont show it. I have looked and searched everywhere to see if there is a setting for it, but no luck. I am not looking hard enough? Thanks, ...

file associations messed up in Vista Home Premium
Some how my file associations in Windows Vista got messed up. The program icon that appears to be MS Front Page 2003 does not open Front Page. When I try to associate Front Page with html and htm files, it open Internet Explorer and not Front Page. I have tried to manually associate Front Page with the appropriate programs but it will not take even going through the start, default programs. I have uninstalled Front Page 2003 [which is a stand alone protram. I also have Office 2003 as a stand alone suite.] and reinstalled it. Still can't associate files with Front Pa...

Simple hack to get $500 to your home.
Simple hack to get $500 to your home at Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone. ...

How to show the specific one in 2 distribution list ?
Our structure is as below...RD follow with RD1, RD2, RD3. There is one special guy who are belong to RD1 and RD2. How to make the distribution list to show the special guy both in RD1 and RD2 ? ...

Word 2007 bullets show arrows, but Htm shows 0 with slash through
The problem I’m having is the Word 2007 bullets. On my Word it shows the arrow point, but the web page shows the 0 with a slash through it. What am I doing wrong? ...

May I put publisher 2002 on my home computer and my office computer?
I am never in both places at once and no one else uses either computer. Am I allowed to load my one purchased copy on both computers? Bob Did it come with your computer or did you buy it separately? -- JoAnn Paules MVP Microsoft [Publisher] "Bob Boudewyns" <> wrote in message news:eAJOsuziGHA.5036@TK2MSFTNGP04.phx.gbl... >I am never in both places at once and no one else uses either computer. Am >I allowed to load my one purchased copy on both computers? > > Bob > I bought it separately, JoAnn. Bob "JoAnn Paules [MVP]&q...

I'm trying to work with XML/XSLT in the Visual Studio IDE (VS 2005) and when I select the menu option XML/Show XSLT Output I get a tab with the output showing the text HTML code. I'd like to have it display like it would in a browser instead. I'm working around it by coding the path to the XSLT into the XML file, keeping a browser open and hitting the refresh button which isn't a huge deal, but I was wondering if there's a configuration option or some way to have it display the way it would look in a browser in the IDE. Any links to documentation about this would be ...