[an error occurred while processing this directive]
PFBlog logo

My Personal Finance Journey

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

  Home | Feed: feed-icon.gif | About | Progress: June 07: $756,924 | Best of PFBlog | Product Reviews | PFBlog Digest | Disclaimer | Advertise | Contact Me

Practical Accrual Accounting in Microsoft Money and Quicken



Now that I explained why accrual-based accounting has its value even for individuals, let me share how I practice it in Microsoft Money. Believe me, it is actually easier than you thought, and the same can be performed if you use Quicken to manage your books.

for illustration purposes, let's continue to use the property tax example I described in the last post: I will need to pay $1,800 on April 30 for my property tax in the first half of 2005. I want to apply accrual-based accounting so in my monthly expense report, I can see a monthly charge of about $283.

The solution is simple:

1. Set up a cash account in the Microsoft Money or Quicken called "Installment."

2. In this "Installment" account, add six transactions for a total of $1,800:
1/1/2005 $300 (as "property tax")
2/1/2005 $300 (as "property tax")
3/1/2005 $300 (as "property tax")
4/1/2005 $300 (as "property tax")
5/1/2005 $300 (as "property tax")
6/1/2005 $300 (as "property tax")

3. Assuming you will pay your property tax from your checking account, add the following transaction to your checking account:
4/30/2005 $1,800 (as "Transfer to Installment Account")

You are all set. By adopting this approach, you will see the following desirable outcome:

1. In your monthly expense report, you will pay out $300 every month for property tax -- this is fair accounting for the same reason I explained last time.

2. In your net worth report, you will see the net effect of the property tax is $300 a month, instead of $1,800 for one particular month and $0 for the other five months if you adopt cash-based accounting.

3. You didn't disturb your checking account record by using the above method -- your Microsoft Money file still reflects the actual transactions in your checking account.

Isn't it simple?

null

This post has 3 comments. Read and share your opinions.
Similar Posts

My Offline Excel Models #1: Monthly Snapshot (May 03, 2005)
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 ... Read
A Quick $100 By Opening a Bank of America Checking Account (March 29, 2005)
Fatwallet Finance Forum is an amazing place to learn the latest personal finance deals. In the past, the Forum pointed me to the 10% restaurant cash rebate by MBNA Cashback Card (almost $500 value), the $100 Fidelity bonus for eBay customers, the free DeductionPro download ... Read
Why Do You Need Software For Personal Finance Management? (February 23, 2005)
In the last several months, I received at least four email asking me how I can manage my personal finance in Excel and whether I can share my Excel models. I guess it is because most of my illustrations at PFBlog, including the regular monthly ... Read
E*Trade Bank Let Customers Leave Too Easily (January 27, 2005)
Seven months ago, I blogged about the $175 bonus promotion from E*Trade Bank. The offer does require some little patience and a couple of hours of work, but it hands you $75 for opening a checking account, $25 for setting up bill payment, and $75 ... Read

Read all 32 articles in the same category.
Comments
>>> Joe Commented on March 13, 2005

It does not seem worth the effort. It is a little OCD.


>>> mm Commented on March 13, 2005

It's not about immediate simplicity by cutting the corner; the accrual method helps you to compare your monthly expenses in a much simpler way -- you don't have to manually take out these "big blows" before you can get an apple-to-apple comparison.


>>> KP Commented on March 14, 2005

With Quicken, you could also set up a savings goal. This will work much in the same way as setting up a cash account.


Add Your Comments









Remember personal information?







Mail This Post
Email addresses will never be collected or sold.
Email this entry to:

Your email address:

Message (optional):




Read More ... 32 Posts In The Same Category

PREMIUM SPONSORS

Car Loans
Dallas Bankruptcy Attorney
Personal Loans
Car Finance
Homeowner Loans
Cheap Car Insurance
Mortgages UK & CCJ Mortgage
Used Cars
Loans
Commercial Mortgages and Business Loans
Guaranteed Car Finance
Payday Loan
Personal Loan
Student Loan Consolidation.com
Secured Loans
Bad Credit Loans - Free Quote