My Personal Finance Journey

Personal finance observation, musing and decisions in a journey toward financial independence by 36 with at least $1 million.

HOT DEALS

Best Cashback Card:
Citi CashReturns(SM) MasterCard®
5% off EVERYTHING during introductory period. (review)

Best Sign-Up Bonus:
Citi Professional Card
$100 gift card after 1st purchase (review)

Best 0% APR Card:
Discover More Card
0% APR for purchase and balance transfer for 12 months (review)

Best Business Card:
Business Gold Rewards Card from American Express: Up to 40,000 bonus points in the 1st year (review)

Best Student Card:
Citi® mtvU™ Platinum Select® free music, gift cards and more (review)

Best Savings Account:
ING Direct Savings Account (4.30% APY)

Best Interest Checking:
Electric Orange from ING DIRECT. (Free Bill Pay. Earn up to 5.00% APY)

Free Stock Trading:
100% Free Stock Trading from Zecco.com

Free Credit Score:
Free Credit Report and Score from Experian



By Topics

Overall:
| Progress (82)
| Key Analysis (113)
| Resources (119)

My Finance:
| Credit (61)
| Insurance (11)
| Car & Home (21)
| Services (11)
| Savings (27)
| Tax (28)
| Others (31)

My Readings:
| Credit (45)
| Insurance (11)
| Car & Home (43)
| Services (5)
| Savings (21)
| Tax (44)
| Investments (71)
| Economy (16)
| Others (70)

My Portfolio:
| General (63)
| Transactions (44)
| Analysis (31)

Everything Else:
| About PFBlog (49)
| My Accounting (7)
| Misc (12)


MONTHLY ARCHIVE

May 2008 (1)
Apr 2008 (5)
Feb 2008 (3)
Jan 2008 (15)
Dec 2007 (32)
Nov 2007 (6)
Oct 2007 (8)
Sep 2007 (9)
Aug 2007 (24)
Jul 2007 (2)
Jun 2007 (1)
May 2007 (3)
Apr 2007 (4)
Mar 2007 (4)
Feb 2007 (13)
Jan 2007 (6)
Dec 2006 (3)
Nov 2006 (7)
Oct 2006 (7)
Sep 2006 (6)
Aug 2006 (4)
Jul 2006 (10)
Jun 2006 (1)
May 2006 (3)
Apr 2006 (2)
Mar 2006 (6)
Feb 2006 (6)
Jan 2006 (3)
Dec 2005 (1)
Nov 2005 (9)
Oct 2005 (8)
Sep 2005 (13)
Aug 2005 (25)
Jul 2005 (16)
Jun 2005 (17)
May 2005 (19)
Apr 2005 (20)
Mar 2005 (24)
Feb 2005 (23)
Jan 2005 (36)
Dec 2004 (40)
Nov 2004 (34)
Oct 2004 (17)
Sep 2004 (21)
Aug 2004 (59)
Jul 2004 (37)
Jun 2004 (30)
May 2004 (29)
Apr 2004 (52)
Mar 2004 (49)
Feb 2004 (49)
Jan 2004 (31)
Dec 2003 (48)
Nov 2003 (52)
Oct 2003 (29)
Sep 2003 (8)
Aug 2003 (5)
Jul 2003 (2)
Jun 2003 (2)
May 2003 (5)
Apr 2003 (2)
Mar 2003 (2)
Feb 2003 (3)
Jan 2003 (29)





 

My Offline Excel Models #1: Monthly Snapshot

Contributed by mm | May 3, 2005 7:49 AM PST

As many of you know, I use Microsoft Money to manage my personal finance -- I believe personal finance software like Microsoft Money and Quicken is essential to family money handling. On the other hand, I also use Microsoft Excel on top of Microsoft Money to produce certain reports/models that are beyond the scope of Microsoft Money. I am not advocating that everyone should try the combo -- it is unnecessary for most people, but I am happy to share my reports from time to time. Today, the disclosure of my monthly snapshot view.

The report is produced to summarize key monthly financial information in a concise manner. It resolved several limitation of a traditional personal finance suite:

1. With Excel, I can have different kinds of data shown in one view. Microsoft Money is incapable of showing both balance sheet and income statement data in one place, not to mention all these % calculation.

2. I have more than 70 accounts set up in my Money file, but when it comes to financial analysis, I really don't need to see the details for every single account ($1 in ING Direct is not different from $1 in VirtualBank -- they are all savings). Excel allows me to do custom grouping and get a view that is truly meaningful. Same way, I leverage my Excel workbook to group expense categories. (Want to produce your own view? Hint: A. you can export a standard Microsoft Money report to Excel by right clicking for "Export to Excel" option. B. Use VLOOKUP function to do customer grouping.)

Final words: this report is provided on an "as is" basis -- I don't intend to share this view in the general public on a monthly basis, nor do I intend to answer any questions. Nevertheless, this view includes new information that I haven't disclosed before. Enjoy!

financials-2005-04.jpg

(The actual report includes every month side by side. The above view is reformatted for illustration purposes.)

More PFBlog Articles You Might Find Interesting ...


This Post Has Received 12 Comments. Share Your Opinions Too.


neil harrington Commented on May 3, 2005

Whats TRIC mean?


Adam Commented on May 4, 2005

If you could provide the excel file you use for this, and which Money reports you paste in to do it, that would be tremendous! I'm a huge fan of MS Money, but I've really been wanting to produce more detailed reports, exactly like the one above. The "monthly report" in Money is nice, but limited. Thanks a lot!!


damian Commented on May 5, 2005

Seventy accounts? No offense, but you are seriously pushing it with seventy accounts. The administrative burden alone is not worth the hassle. The multinational corporations I have worked for have hardly had seventy accounts. I would recommend you consolidate some of these. My general problem with your site is that you nickel and dime your finances too much. You sign up for offers to get like $25, you have seventy accounts, you use ridiculously detailed spreadsheets to track your finances... When do you have time to actually live your life?

For most people, your model of tracking your finances would never work. However, for you it is great. The most meaningful way for a person to make money is to increase their potential income.

Sure, tracking your finances is important, but if you are a janitor, no matter how many hours a month you spend planning and budgeting, you're never going to be rich.

For you, all this tracking represents a potential source of income. Maybe you sell ads on your site, or you write a book or something, and you can make something off of it. However, the volume of reports and tracking you do are simply a huge waste of time for the average janitor.

Instead of "making a quick $100 opening a banc of america account," the janitor's time would be better served by taking night classes, or learning a trade, opening his own business etc...

I realize you probably agree with all i've said and i dont mean to mischaracterize you and the intention of your site. You're great at what you do. You aren't promising to make people rich, just share your personal finance experiences.

However, I just want to make sure people are focusing on the right things.

Thanks.


MM Commented on May 5, 2005

Thank you Damian. Great feedback!

As I pointed out in the post, such level of details are unnecessary for most people, although I don't see it as aburden. It takes me about two hours to build the report, and every month, it only takes me 2 minutes to refresh it. You have to admit it gives me additional insight into my finance. I see it is a spirit of running personal finance as if it were a business.

And I have to agree with you that most of my net worth increase recently is driven by income increase -- fortunately I earn a bit more than a janitor.

I will share details of my 70+ accounts in another post.


Sam Commented on May 5, 2005

I would also appreciate the excel template if possible. Please let me know if we can download it or if you can email it to us.

thanks


AA Commented on May 5, 2005

Great information. Thanks for posting it. How does the Net Worth statement that Money generates differ from your Excel spreadsheet ? Like you, I would like to track my change in net worth from month to month. However, my financial situation is much simpler. 2 IRAs, 2 401ks, 1 income source, 2 stock portfolio accounts, no mortgage, etc. Will Money Deluxe suit my needs ?


Damian Commented on May 6, 2005

Thanks for not taking my comments the wrong way. Hm... so many people want the spreadsheet that took you 2 hours to develop...maybe they'd be willing to pay ya for it?

And yes i see how you are running personal finances from a business perspective. Its a good framework.


neil harrington Commented on May 6, 2005

I would pay for it in a heart beat, not even a second thought.

Cheers!


Glyn Simpson Commented on May 7, 2005

Exporting all of your reports from Money to Excel could be time consuming - thought about using MoneyLink to help with this?

Thanks for sharing the information though


Robert Chang Commented on May 9, 2005

TRIC = Total Return on Investable Cash


Roy Commented on May 14, 2005

Greetings from London. Great model, a 2 minute refresh every month for the level of detail is impressive. Here's an idea though, I use Excel as well (though nowhere as detailed) and I find creating a line chart to be extremely useful with my money decisions. For example; I was seeing that at times I was building up too much cash that needed to be allocated towards investments and at other times I didnt have enough 0% credit card debt (that I put into a 5% savings account). You probably have an Excel chart somewhere though I'll be more than happy to email you a snapshot of mine. Rgds.


Laura Commented on June 20, 2005

I love this level of detail-- I've been using Quicken since 1997 and haven't been able to figure out how to track trends, etc. Please add me to the list of people who would love the template, and who would pay for it. thanks!



Read More ... 31 Posts In The Same Category



Recommended Offers










This page was last rebuilt at May 12, 2008 10:33 PM PST.
 

RSS FEED



PREMIUM SPONSORS

Car Loans
Business Cash Advance
Car Finance
Bad Credit Loans - Free Quote
Homeowner Loans
Payday Loans
Car Insurance
Used Cars
Loans
Car Loans
Commercial Mortgages and Business Loans
Guaranteed Car Finance
Payday Loan
Personal Loan
Secured Loans


SITE REVIEWS

Low Cost Loans
Cheap Loans


PERSONAL FINANCE BLOGS I READ

Consumerism Commentary
Get Rich Slowly
My Money Blog
All Financial Matters
The Simple Dollar




SELECTED POSTS

Credit Cards:

Best 0% APR Intro Offers

Citi CashReturns MasterCard

Citi Payment Partner Program

American Express Blue Cash

Free Credit Report

Banking:

Emigrant Direct Savings Account

Investing:

Opening A Self-Employment 401(k) Account

Real Estate:

Most Affordable Housing Markets

Insurance:

Auto Insurance Saving Tips

Vehicle Insurance Ratings

Other Services:

ooma - free domestic calling for life



.

Featured Sites


Credit Cards from Credit Card Expert aims to provide a guide to UK Credit Cards so you can compare the credit cards available in the UK and find the best credit cards for you.

• Protected.co.uk compare over 300 life insurance plans to find the best deal from their providers.

• Search 300 life insurance plans from 12 leading providers.

Bad Credit Auto Loans are loans for people who have a poor credit history and cannot qualify for an auto loan. If you are able to secure a bad credit auto loan, you should consider it to be a second chance to improve your credit rating by making all auto loan payments on time.

Car Finance - The Uk's leading online car finance company. Buy any car from any UK dealership. Bad credit not a problem.

• Apply today for a fast UK payday loan to receive quick cash in your account almost instantly.

• SecuredLoansCentre.co.uk - 3 easy steps to compare over 200 secured loan plans for UK home owners in minutes

• Allmand & Lee's staff has over 20 years of experience combined in the Dallas area and they are the largest volume filer of consumer bankruptcy cases in the Dallas, Texas Division. Let one of their Dallas bankruptcy attorneys help you get out of debt now!

• Find a fast personal loan in the UK. Even if you have a bad credit history, arrears or CCJ's, Loansite's top lenders can help you compare loans and find a low APR secured loan, homeowner loan or tenant loan with fast approval in principle.

• If you need a fast cash advance, applying for an instant UK Payday Loan online can provide short term financial assistance until your next salary.

• Legal Helpers experienced bankruptcy lawyers can help you out of debt. Take advantage of our Free debt consultation. Our bankruptcy lawyers will help you understand your best option to eliminate your debt. Ask about our 100% guarantee.

Student Loan Consolidation - Need assistance with Student Loan Consolidation? Have a personal education finance advisor assist you with rates as low as 4.5%. -Quick, Easy Online Application w/E-sign!

Cheap Car Insurance - Provides Cheap Car insurance. Receive an instant quote online

Womens Car Insurance - Specialises in cheap car insurance for women

• Have a Personal Bankruptcy Lawyer assist with filing bankruptcy for a chapter 13 or chapter 7 bankruptcy case. Free bankruptcy evaluation tool.

secured loans - Any purpose low Cost secured Loans.

Tankless Water Heaters - Instant, On-Demand Hot Water Heaters Save Money, Energy, and Space.

• The Internet's most trusted credit card resource directory.

Frigidaire Parts

Fleet Dealer - Ford Fleet trucks and vans, cargo vans, cutaway vans, LCFs, work trucks, commercial trucks, ambulances, tow trucks, police squad vehicles, and other commercial vehicles like box vans, delivery vans, box trucks and dump trucks.

Bad Credit Auto Loans - Auto loans bad credit, bad credit auto loans, guaranteed credit approval, auto financing, credit lenders, car credit, automobile lenders, bad credit auto loans seattle, auto loans bad credit seattle.

Ford Dealer - One of the World's largest Ford Dealerships. Over 3,000 cars and trucks to choose from. Mega Volume Dealer. $1,000 price guarantee. Large Special Finance Store. Ford Dealer Seattle. Mustang, Edge, Explorer, F150, f250, fleet, build your own Ford.

Auto Loans Bad Credit - Bad Credit Auto Loans, auto loans bad credit, guaranteed credit approval, car credit car loans, automobile financing, credit lenders, bad credit auto loans seattle, auto loans bad credit seattle. (Home | Apply | Inventory | Credit Help | Contact Us)

PayDay Loans

Bad Credit Car Loan - Car Loans Bad Credit, Car Loans, Vehicle financing, car credit, bankruptcy car loan, bankruptcy car loan, Car loan bad credit, bad credit car loan, auto loans, nationwide car loans, instant credit approval, guarantee credit approval, slowpays, car financing, vehicle loan, vehicle loans.

• moneyeverything.com - Find the right credit card to suit you with our guide to the right card in the UK

• airaid.co.uk - Looking for credit cards in the UK? Find the right credit card to suit you with our guide to choosing the right card in the UK

Bad Credit Loans - find out some tips about improving your credit score and choosing the best bad credit lender.

• Consolidate debt with Bad Credit Personal Loans online or Personal Loans, consolidate Bad Credit Personal Loans or apply for Credit Cards including 0% deals.

• You may also want to look at UK Bank Accounts and get a Credit Report before comparing UK Credit Cards or finding out about UK Mortgages to refinance or move house.

• We provide personal loans for debt consolidation, home improvement, bad credit loans at cheap rates in the UK.

• If you are buying a car you may want to search for UK Car Insurance to get a car insurance quote online.

• Accepted.co.uk compare over 100 secured loans to find the best deal from their lenders.

• Accepted.co.uk compare over 100 secured loans to find the best deal from their lenders.

Sending money to family and friends has never been easy. Use iKobo, secure way to send money worldwide

Payday loan tips at paydayloanreport.net helps you to defeat cash-checking and payday loan traps.

• MM Money is an interesting money blogthat covers many aspects of personal financial matters.

• This insurance weblog covers all major types of insurance, including health, life and car insurance

• Bestcardguide.com offers independent review of best credit cards

• Real Bankruptcy offers excellent tips of bankruptcy and how to avoid them

Small Business Loans

Credit Card Debt Relief

Online Credit Card Processing

Stock Investments

online casino - reviews of goldenpalace, casino-on-net, and more. onlinecasinobluebook.com review guide.

Student Loan Consolidation - the student loan solutions provides students and their families with information and resources to help students get out of default and better manage their student debt.

Bad Credit Auto Loans - washington state's bad credit auto financing leader.

Home Loan - getsmart is a leading online financial marketplace, focused on smart consumers in a hurry.

Credit Cards - the best deals on uk credit cards compared, regularly updated

IRS Tax Lien - when you need help with your tax problems, call citizens tax relief.

bankruptcy - bankruptcy lawyers from around the country providing assistance with chapter 7, chapter 13, and debt issues

Credit Repair - repair my credit now credit services offers credit repair, restoration and education through our exclusive "v" phase process ™


Want to See Your Ads Here? Claim Your Ad Space at Personal Finance Weblog by Writing to Webmaster. Starting at $49/month, see your text ads in thousands of indexed pages at PFBlog, the Best Personal Finance Blog. Full Rate Card Available Here.

Copyright 2003-2006, PFBlog.com. All Rights Reserved. (Privacy Policy)