%Interest for Bank Accounts (NON-Investment Accounts)

Money has all the good features that provide Return On 
Investment (ROI %) OR Interest Earned for Investment's 
(i.e all Brokerage acounts, Mutual funds etc..)

However I am unable to find basic %Interest Earned reports 
Or ROI numbers for Non-Investment acounts (i.e Bank 
Acounts).

Hence I have created a report from hell in Money that 
exports account details (by Bank Account). Next, I export 
this data into MS Excel, & apply more formulas to 
calculate the average daily balance, Sicne I havethe Time 
& Interest numbers..I then reverse engineer & calculate 
the "Interest Earned".

Please help me SIMPLIFY.. IS there a quick way in Money to 
find out the Interest Earned (% not dollars) for Bank 
Accounts. 

Thanks in advance!
0
anonymous (74722)
2/2/2004 12:41:50 PM
money 28651 articles. 7 followers. Follow

2 Replies
381 Views

Similar Articles

[PageSpeed] 14

Why not simply call them an investment account then and stop fighting? Maybe
this won't work, but what about paing bills and such in the cash
transactions and placing the interest in an investment transaction?

"NeedHelp" <anonymous@discussions.microsoft.com> wrote in message
news:8bc901c3e989$edfe8e60$a601280a@phx.gbl...
> Money has all the good features that provide Return On
> Investment (ROI %) OR Interest Earned for Investment's
> (i.e all Brokerage acounts, Mutual funds etc..)
>
> However I am unable to find basic %Interest Earned reports
> Or ROI numbers for Non-Investment acounts (i.e Bank
> Acounts).
>
> Hence I have created a report from hell in Money that
> exports account details (by Bank Account). Next, I export
> this data into MS Excel, & apply more formulas to
> calculate the average daily balance, Sicne I havethe Time
> & Interest numbers..I then reverse engineer & calculate
> the "Interest Earned".
>
> Please help me SIMPLIFY.. IS there a quick way in Money to
> find out the Interest Earned (% not dollars) for Bank
> Accounts.
>
> Thanks in advance!


0
2/4/2004 3:23:43 AM
Thanks! Refreshing idea.
I will try both & see which is the lesser of the 2 evils...

>-----Original Message-----
>Why not simply call them an investment account then and 
stop fighting? Maybe
>this won't work, but what about paing bills and such in 
the cash
>transactions and placing the interest in an investment 
transaction?
>
>"NeedHelp" <anonymous@discussions.microsoft.com> wrote in 
message
>news:8bc901c3e989$edfe8e60$a601280a@phx.gbl...
>> Money has all the good features that provide Return On
>> Investment (ROI %) OR Interest Earned for Investment's
>> (i.e all Brokerage acounts, Mutual funds etc..)
>>
>> However I am unable to find basic %Interest Earned 
reports
>> Or ROI numbers for Non-Investment acounts (i.e Bank
>> Acounts).
>>
>> Hence I have created a report from hell in Money that
>> exports account details (by Bank Account). Next, I 
export
>> this data into MS Excel, & apply more formulas to
>> calculate the average daily balance, Sicne I havethe 
Time
>> & Interest numbers..I then reverse engineer & calculate
>> the "Interest Earned".
>>
>> Please help me SIMPLIFY.. IS there a quick way in Money 
to
>> find out the Interest Earned (% not dollars) for Bank
>> Accounts.
>>
>> Thanks in advance!
>
>
>.
>
0
anonymous (74722)
2/5/2004 8:23:14 PM
Reply:

Similar Artilces:

Portfolio value by investment account
At the moment I have two accounts of investment and I would like to compare their results for a period of determined time. Like January till September, It could obtain a line chart with its results? ...

Send automatic reply through specific account
I have setup my Outlook 2002 to work with 3 different email accounts. I also have rules to send automatic replies for 2 of those accounts. However, the problem is, the SMTP servers of the 2 accounts through which the auto replies are routed allow only 1 outgoing message per day. The third account (being a hotmail account) does not work with the rules wizard. So, can somebody out there tell me how Outlook can be set up such that all outgoing messages are routed through the third (hotmail) account (because hotmail seems to have no such limit)? Thanks in advance. you'll need to find a SMTP t...

email accounts #6
I tried to open email accounts, but I receive an error message that says the following: the operation failed due to a registry or installation problem. restart outlook and try again. if the problem persists, please reinstall. I re-installed outlook xp and it still gives me the same problem. I have been using express meanwhile. help!!! AS ...

Infomercial / TV Merchant Account
Infomercial / TV Merchant Account or MLM Merchant Accounts American Merchant Systems (AMS) specializes in merchant services for high-risk and high-volume merchants (mail order, telephone order, adult websites, online gambling sites, outbound telemarketing, travel, telecom, timeshares, viagra/herbal supplements, online pharmacies, subscription / membership services, tickets, multi-level marketing, companies facing high chargebacks, etc.). We offer U.S. based processing, Offshore processing and 3rd party processing, and complete or partial fulfillment services. If you're looking ...

various problems with automatic account maintenance
I've had really quite a few problems with investment account updates over the years, with different brokers. I can't say that any of them really work well. Recently there's the problem with MMF prices being reported incorrectly. I also have accounts with many spurious "Add shares" transactions, followed a few days later by "Remove shares" transactions, all entered automatically. Dividend reinvestments are routinely added as purchases, followed by dividend received. Same for capital gains. I have account adjustments added from I don't know where, whic...

Reconciling Zero-Balance Payroll Account With Checks and ACH Activ
We have a zero-balance checking account for payroll disbursements, including checks and ACH direct deposits. How can I reconcile this to the bank statement at month-end? I've been looking at the various Financial series and ACH reports, but don't feel that I've come up with a very efficient approach yet. Thanks! Don, I'm not sure if this helps you but in various PEOs, they reconcile their Payroll Bank accounts in Excel using VLookup and other functions. The process is simple 1. Print as .csv, GL Detail Report from Financial=>Inquiry=>Detail for the date ran...

Pay lower interest first?! Why?
I went through the Money 2004 Debt Reduction Planner with all of my debt accounts and was quite puzzled by the results. To clear the clutter, I removed all the accounts from the plan except for my Discover Card and Providian card. Discover Card is at 0.0% APR for life until my old balance is paid off, as long as I make a minimum monthly purchase of $1.00 beginning in December charged at 9.9% APR on just the purchases. Because Microsoft Money does not acknowledge a difference of interest rates between purchases and balance transfers, I specified that the entire balance is at 0.0006% APR, which...

version 2002... Odd return calculation for investment
I have a fairly new account containing about nine funds. The account has lost $2931. In the Performance View of Portfolio, the ROI All Dates is -3.2%, and the Ann. Return is +158.2%. That doesn't look right to me. Anyone else seen this type of thing? Know what the problem might be? ...

Is there a non-exchange option for a (very) small business?
I'm on a team of 7 people spread out across the US and Canada. Three of us are Mac users (Entourage) and the others use PCs (Outlook). Exchange is out of our league. Outlook has multiple group calendar options that are cheaper and better suited to a small business. What options are there for my team? Thanks for your help! kelly fryer <kfryer@arenewalenterprise.com> wrote: > I'm on a team of 7 people spread out across the US and Canada. Three > of us are Mac users (Entourage) and the others use PCs (Outlook). > Exchange is out of our league. Outlook has multipl...

smarlist builder
Hello, I have a custom database used to collect information that I want to be able to display through a smartlist in GP. Issue is this database doesn't have all of the users the company databases have. I have made the own dynsa and added the dyngrp role, but again, the users aren't there. Short of adding every user to this databases, any ideas on how to access non-company database info through smartlist builder? And no, views use pass-through security info... Thanks, Jason Jason My understanding is you cannot add views from other database. If you got Smartlist Builder=3D>...

pop account #2
how can I pop my hotmail account with outlook 2000? Thanks for any help, Ken Hotmail accounts are not able to be pop3 accounts -- *Emails sent to personal account will not be read due to virus security* "kenbarton@hotmail.com" <anonymous@discussions.microsoft.com> wrote in message news:0fcf01c49d1f$667e8090$a501280a@phx.gbl... > how can I pop my hotmail account with outlook 2000? > > Thanks for any help, > Ken ...

Compose outlook 2003 mail from different accounts
Outlook lets you configure multiple email accounts to draw email into outlook.,ie account1 and account2 I also lets you respond through the mail servers that sent the mail ie account1 mail goes back through account1, account2 through account2 Outlook seems to be only able to compose email from the default account and use the email credentials from that account, ie account1 signature, servers and mail address. I want to be able to send email out of the same outlook as either account1 or other as well as from account2 Any ideas? Alan Richmond wrote: > Any ideas? You mean b...

Incorrect Account Appearing on General Transaction Edit List
If I go into my General Ledger and view a certain entry, on the input screen, it lists the correct accounts. However, if I print the edit list, one of the accounts is incorrect. In fact, it is an account that doesn't exist in our system. As shown in transaction entry screen: 51-6021-3500 Disability Insurance $478.24 12-1296-0000 Intercompany Rec/Pay - $478.24 As printed on edit list: 51-6021-1000 Disability Insurance $478.24...

I am interested in knowing some of your favorite Excel Add-ins
Hello - I have been too cheap to buy any excel add-ins or plug-ins, and then recently I downloaded one (i.e., the PUP v6 toolbar), and realized that it was worth much more than the $40 price tag. I would be interested to hear some of your favorite add-ins (either free or purchased) and why you find them to be valuable. It would also be helpful to have the link to where they can be found. Thanks! - M If you regularly write really complex formulas this add-in has some very useful functions: Morefunc - free download: http://xcell05.free.fr/english/ If you find yourself searching the inter...

The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address.
Please excuse the rookie question, I have been avoiding Exchange too long and now it has bitten me in the... elbow... I am attempting to set up Exchange to send mail... Whenever I send to a member of my domain (hosted externally) I get this error message... (I am using SBS, I have posted a similar message over there.) The e-mail account does not exist at the organization this message was sent to. Check the e-mail address, or contact the recipient directly to find out the correct address. It appears that email sent to other domains is delivered without incident. I need to get the squar...

Investing
I use Money 2004 Standard and I need to record a spinoff. The Help file says this should be an option within the 'Record a special activity" menu, but there I only have 'Transfer an Account' and 'Record a Split'. Mergers and demergers are absent. Is this a problem of my software or its configuration? Must I upgrade to a higher version to have this option? In microsoft.public.money, RNS wrote: >I use Money 2004 Standard and I need to record a spinoff. The Help file says >this should be an option within the 'Record a special activity" menu, but >...

INVEST $16 and make $1,000,000!!! FAST Don't believe me?
www.pro2010.com/192/invite.html Dear Friend Sound to good to be true? Of course it does but if you've made it this far then you've done the hardest part. No Joke it's brilliant! Many many people are working togeather to generate for themselves a million dollars. We are all sick of hype on the inernet that never pays off and this looks to be another doesn't it? Well scepticism in this case could cost you $1,000,000. This is real and I was as sceptical as you are right now until I myself stumpled upon the power of the MONEY TREE It is truely a godsent and I urge you to c...

Cannot Delete Account
I have recently started using Money 2007. I added an investment (401k) account and imported years worth of data (1000+ transactions). I decided that I don't need the historical data and instead of deleting each individual transaction I want to delete the account and re-add it with less data. When I try to delete the account I get an error "this operation cannot be performed". Why will money not allow me to delete this account? In microsoft.public.money, bigmike wrote: >I have recently started using Money 2007. I added an investment (401k) >account and imported years...

Analytical Accounting
As Dynamics GP is now our ERP solution for Public Sector, we really need to have the AA - now our grant, fund and budget solution all being able to work with Integration Manager. Our partner Raffa, was telling me today that they lost a deal on GP because the Integration Manager did not integrate to AA. I agree with previous posting that new key features should release and work or have a plan to release and work very shortly with Integration Manager. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for th...

2005: Banks online list FALSE
I purchased Money 2005 because two brokerages, Adventist Health Care and Great-West were listed with 2-way service under the Money 2005 website at microsoft.com/money when I get into Money 2005 they aren't listed as places that you can download from! What is going on!?!? I did further research... for example the money website shows nearly 100 brokerages starting with the letter A that are comptaible with 2-way download in 2005. In the actual program only 11 are listed. UNBELIEVABLE! MS are now going for keeping the web-site up to date rather than the list in the program. -- Re...

Outlook using multiple email accounts
I am using Outlook 2003 with 5 email account setup because I travel alot and have different ways of connecting to the internet such as my office LAN, cable modem at home, dial up through normal phone, dial up through Iridium phone, etc. The problem I am having is that when I reply or forward to an email which i am normally getting from the email account which is not my default account it wants to reply or forward from that same account. However I wanted and had expected it to use the account I have defined as the default. It will use the default account if I am sending a new email bu...

Account Names not showing when adding new user
Hi, I created a SharePoint site off of a 2007 Project Server install and when adding users to access the SharePoint site, directory services only returns admin users of the SharePoint/Project Server? How do I get AD to return all the users in the domain? Thanks! Steve Steve: What do you mean when you say "I created a SharePoint site off of a 2007 Project Server install?" Your description lacks a few details. "Steve" <Steve@discussions.microsoft.com> wrote in message news:EAA4C48D-9D6A-44C7-84BF-787AE762561E@microsoft.com... > Hi, >...

Large account integration case study
Hi group, I just found the following case study by Capstone Consulting for InfoTech 2004: http://www.capstonec.com/pages/archives/presentations/CRM.pdf It documents some issues I have already found in my limited testing of the MSCRM 1.2 product. Edwin Garst www.epconsystems.com ...

Change SA Account Password
As a result of an audit, control of our GP database is being transferred to IT and away from Finance (we have control of the hardware and OS, just not the application itself). No one in our group is well versed in GP and the immediate change that must be made is to change the SA password. What is going to break? GP10 Server 2003 SQL 2005 -- Jason Hancock Network Engineer Inspiration Ministries Indian Land, SC Dear, Normally nothing would be effected in the application, but if you have any customizations or tools that uses the SA user directly, it may be affected. Regards, -- Moham...

implementing auto-cc to certain mail accounts?
Hi all, I wonder if there's any way to enforce certain users to automatically cc their mails to designated email addresses? My company wants control over information flow both in and out of the company mail server. Is there any way to achieve this through server-side settings? -- Yours Sincerely, Y.H. Lee ...