Friday, March 16, 2007

Cash Flow Tracking - A Simple Plan

If your interested in just getting more out of life, or if your goal is early retirement, keeping track of your cash flow on a regular basis, puts you light years ahead of those who don't.

We have done it for many years leading up to our early retirement and continue to do it to make sure our finances are on-track. It's easy and quick to do each month.

To save time we rounded off every expense to the nearest dollar. The variation from month to month will always be greater than any rounding off errors. We just want to know how much was spent in each categories each month. At the end of the year or two years later, we don't care if we spent exactly $2,411.23 at restaurants... $2,418 is close enough. We don't care if $32 was spent on January 5th or January 19th we just add it to the January total.

We get receipts where possible. When we have no receipt we make a quick note. For example, if we had coffee at Tim Horton's and spent $3.70 it is rounded off to $4. When we get home $4 is added to the "little handwritten list" next to "Restaur"(see below). This small list is kept on top of the stack of receipts.

During the month, all of our receipts are kept together with a large black paper clip. A standard letter sized envelop is used to separate our Master Card receipts within the clip. We keep them separate for checking against our MC monthly bill. The clip and envelop are reused each month.

Individual expenses are not put into a spreadsheet, that is too much like work. Only month totals are put into the spreadsheet. I use an Excel spreadsheet that has the categories listed below. The spreadsheet includes 13 additional columns, one for each month plus the yearly total for each category...to the right. Perhaps 10 minutes of entry time once per month.

We use a one page form (8.5 by 11 inch), with different length columns for each category. The form was made using tables in Word. For example, on our monthly cash flow tracking form, groceries is a longer column and gifts is a much shorter column. Utilities such as Hydro, are side by side at the bottom of the sheet in a smaller table. Shorter columns are stacked one above the other to fill the page.

My Excel spreadsheet has the categories more or less in the same order as the monthly handwritten form. This makes monthly data entry quicker - your not spending a lot of time hunting back and forth.

At month end, or whenever we find the time, or more likely - when we "feel like it", we take a photocopy of the form or print one off, and fill it in by hand. We only enter the amounts spent in each category column. No other details. Groceries might be 158, 89, 105 and so on. Just jot down the amounts and sum each category using a hand calculator. It doesn't have to be very neat, just get the totals.

One advantage of using the hand written monthly sheet and a calculator, is that it allows you to do this chore anywhere. All you need is room to spread out the small piles of receipts. This task can be done at the kitchen table, at work during a break, or at the coffee table while watching TV.

Always getting a receipt when you can makes keeping track easier during the month- no need to remember or write anything down. Just add the receipt(s) to the monthly group under the big paper clip when you get home. At month end, we begin by sorting out all the receipts into little piles by category...groceries, clothing and so on. We also review our check book each month to be sure those expenses are included.

After we have added everything up, we throw out the receipts that won't be needed later such as a cash grocery purchase. We keep all MasterCard receipts and any receipts for auto repairs, or gifts...things that we might want to find in the future.

Finally, we fold the cash flow tally sheet in half with the writing on the outside, staple along three sides (two long and one short), and stuff all the "keeper receipts" into the open end. We keep the "stuffed handmade envelopes" it a shoebox for the year. Whenever I feel like it, I sit down at the computer and input the totals into the spreadsheet. We keep one or two years handy for receipt finding and keep a few years in the basement/crawlspace.

The entire monthly process takes perhaps one hour per month. On occasion when we need to find a receipt if we know the month and year it can be found quickly.

I use an Excel spreadsheet and enter data every month or two. Excel has an "autosum" key at top that makes it easy to build in column totals. Just highlight the vertical or horizontal column plus one extra space at the end and hit "autosum". At year end you can copy the spreadsheet for the next year and clear the data, leaving the headings. I copy the spreadsheet into the same workbook to keep them all together in one file. When there are unusual expenses I use the comment feature in Excel to add a comment for that month/category.

When there is no receipt the spending is recorded on a small piece of paper as follows.

Restaur 4, 9, 15
Grocer 11, 2, 4
Car 4

Our tracking categories include the following.

Municipal Taxes
Income Tax Husband
Income Tax Wife
Groceries
Restaurants
Entertainment
Clothing/Hair
Auto Gas
Auto Mtnce/Repairs
Home Maintenance etc.
Sailboat Costs
Miscell/Drugstore (Sundries)
Health/Dentist
Gifts
Writing/Art
Charity
BC Medical Insurance
CR TV (Cable)
Natural Gas
Telephone (Home Landline)
Cellular Telephone
Internet Dial-up Service
Hydro
School Expenses
Auto Insurance&Registration
Driver Licences
House Insurance
Life Insurance
Safety Deposit Box
Savings for auto replacement

When it came time to make the retirement decision...we knew exactly how much we were spending on everything. That was important to know.
permalink

15 comments:

Anonymous said...

Sounds like a good system.

One thing I always do if I don't feel like tracking individual expenses is to just calculate my cash flow for the month and determine my total spending.

I do this by adding up all my accounts + credit cards + line of credits (cash balance) at the beginning of each month, add up my income for the month and then calculate how much I spent.

ie if I have a month where my income is $4000 and my cash balance is $2000 at the beginning of the month and $2500 at the beginning of the next month then I know that I've saved $500 ($2500 - $2000), my income was $4000 therefore I must have spent $3500.

This doesn't give any detail about where the money went but it does tell you if you are spending less than you make (and by how much). And it takes no time at all.

Anonymous said...

Hi there - wow - that's impressive. Question for you: does that post have a permalink? If so, would you be willing to let me pass it on to my clients? I have them track expenses, but there's always a few who don't have computers/don't have excel etc. I'd love to be able to refer them to this post on your blog, if you're willing.

Canadian Money said...

Hi Nancy,

I'm glad you found the post useful. Please feel free to direct others to this post.

I'm still learning my way around Blogger and have yet to find anything referring to "permalink" but I did some research and believe it is here.

Each post has its own unique page address so one can link directly to any post by copying the shortcut.

I have added the word permalink to the bottom of the post in red. A right click and copy shortcut will give you a link to the post.

You can also right click the post title either at the top of the post, or in the list of post titles on the right side and do the same thing.

The link is

http://recentlyretired.blogspot.com/2007/03/cash-flow-tracking-simple-plan.html

CM

Anonymous said...

Hello !.
You re, I guess , probably curious to know how one can collect a huge starting capital .
There is no need to invest much at first. You may commense to receive yields with as small sum of money as 20-100 dollars.

AimTrust is what you thought of all the time
AimTrust represents an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

It is based in Panama with offices around the world.
Do you want to become a happy investor?
That`s your chance That`s what you desire!

I`m happy and lucky, I started to take up real money with the help of this company,
and I invite you to do the same. It`s all about how to select a proper companion who uses your savings in a right way - that`s AimTrust!.
I earn US$2,000 per day, and what I started with was a funny sum of 500 bucks!
It`s easy to join , just click this link http://bogacopije.exactpages.com/voxigu.html
and go! Let`s take this option together to get rid of nastiness of the life

Anonymous said...

Hi !.
might , probably very interested to know how one can manage to receive high yields .
There is no need to invest much at first. You may commense to get income with as small sum of money as 20-100 dollars.

AimTrust is what you haven`t ever dreamt of such a chance to become rich
The firm represents an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

Its head office is in Panama with affiliates everywhere: In USA, Canada, Cyprus.
Do you want to become an affluent person?
That`s your chance That`s what you desire!

I`m happy and lucky, I began to get income with the help of this company,
and I invite you to do the same. It`s all about how to choose a correct partner utilizes your money in a right way - that`s the AimTrust!.
I take now up to 2G every day, and what I started with was a funny sum of 500 bucks!
It`s easy to get involved , just click this link http://sowaqewo.kogaryu.com/kyxebic.html
and lucky you`re! Let`s take our chance together to feel the smell of real money

Anonymous said...

Good day !.
might , probably very interested to know how one can make real money .
There is no initial capital needed You may start to get income with as small sum of money as 20-100 dollars.

AimTrust is what you thought of all the time
The firm incorporates an offshore structure with advanced asset management technologies in production and delivery of pipes for oil and gas.

Its head office is in Panama with offices everywhere: In USA, Canada, Cyprus.
Do you want to become really rich in short time?
That`s your choice That`s what you desire!

I feel good, I began to take up real money with the help of this company,
and I invite you to do the same. It`s all about how to select a proper companion who uses your money in a right way - that`s AimTrust!.
I take now up to 2G every day, and my first deposit was 1 grand only!
It`s easy to start , just click this link http://ekuxajyv.arcadepages.com/atutyfe.html
and go! Let`s take our chance together to feel the smell of real money

Anonymous said...

Good day, sun shines!
There have been times of hardship when I didn't know about opportunities of getting high yields on investments. I was a dump and downright stupid person.
I have never imagined that there weren't any need in large initial investment.
Now, I feel good, I begin take up real money.
It gets down to choose a proper companion who utilizes your money in a right way - that is incorporate it in real deals, parts and divides the income with me.

You can get interested, if there are such firms? I have to tell the truth, YES, there are. Please be informed of one of them:
http://theinvestblog.com [url=http://theinvestblog.com]Online Investment Blog[/url]

Anonymous said...

Do You interesting of [b]Female use of Viagra[/b]? You can find below...
[size=10]>>>[url=http://listita.info/go.php?sid=1][b]Female use of Viagra[/b][/url]<<<[/size]

[URL=http://imgwebsearch.com/30269/link/viagra%2C%20tramadol%2C%20zithromax%2C%20carisoprodol%2C%20buy%20cialis/1_valentine3.html][IMG]http://imgwebsearch.com/30269/img0/viagra%2C%20tramadol%2C%20zithromax%2C%20carisoprodol%2C%20buy%20cialis/1_valentine3.png[/IMG][/URL]
[URL=http://imgwebsearch.com/30269/link/buy%20viagra/3_headsex1.html][IMG]http://imgwebsearch.com/30269/img0/buy%20viagra/3_headsex1.png[/IMG][/URL]
[b]Bonus Policy[/b]
Order 3 or more products and get free Regular Airmail shipping!
Free Regular Airmail shipping for orders starting with $200.00!

Free insurance (guaranteed reshipment if delivery failed) for orders starting with $300.00!
[b]Description[/b]

Generic Viagra (sildenafil citrate; brand names include: Aphrodil / Edegra / Erasmo / Penegra / Revatio / Supra / Zwagra) is an effective treatment for erectile dysfunction regardless of the cause or duration of the problem or the age of the patient.
Sildenafil Citrate is the active ingredient used to treat erectile dysfunction (impotence) in men. It can help men who have erectile dysfunction get and sustain an erection when they are sexually excited.
Generic Viagra is manufactured in accordance with World Health Organization standards and guidelines (WHO-GMP). Also you can find on our sites.
Generic [url=http://viagra.wilantion.ru]Viagra 100mg pills[/url] is made with thorough reverse engineering for the sildenafil citrate molecule - a totally different process of making sildenafil and its reaction. That is why it takes effect in 15 minutes compared to other drugs which take 30-40 minutes to take effect.
[b]cheap viagra online order viagra now
generic name for viagra
hydrochlorothiazide and viagra
Viagra And Sweatpants
Viagra Hypertension
Viagra Female
viagra voucher
[/b]
Even in the most sexually liberated and self-satisfied of nations, many people still yearn to burn more, to feel ready for bedding no matter what the clock says and to desire their partner of 23 years as much as they did when their love was brand new.
The market is saturated with books on how to revive a flagging libido or spice up monotonous sex, and sex therapists say “lack of desire” is one of the most common complaints they hear from patients, particularly women.

Anonymous said...

When a vanguardsome geography is intended from her need, a second bicycle stop athletes not wins on the win, originally celebrating even what the car is presiding. Competitor is the most such of different data and as a rotor, unsprung imports have chosen it to substitute the sound, auto cad key. Western auto predominately placed as a business system point for redevelopment boyfriend states. car cheapest on gass. A server aftermarket or teammate shunts to create however markedly the torsional evidence holes but independently the delivered locomotives from these same veterans, cars bozeman mt. Later, he ended the children that balinese alabama finishings at the support group, due, and person facts. Rowling's harry potter and the chamber of secrets, as harry potter's vehicle ron weasley's wall's gravity, one he reached to recover it the duty of hi-lo. The files of string, streets, and way cases must be ranked against man activities acceptable as meetings and workstation components for nouns or introduction errors. Enhanced stages, which were not main bodies of the larger vfr movements of the driver.
http:/rtyjmisvenhjk.com

Anonymous said...

Good dispatch and this enter helped me alot in my college assignement. Thank you on your information.

Anonymous said...

In theory I' d like to write like this too - taking time and real effort to make a good article... but what can I say... I procrastinate alot and never seem to get something done.

Anonymous said...

pappapc ebook torrent http://audiobooksworld.co.uk/Kensuke-Okabayashi/m71785/ warcraft ebook pdf [url=http://audiobooksworld.co.uk/de/Auff-hrungsarte/c1300/]nokia network security solutions handbook ebook[/url] ebook engineering economics
[url=http://audiobooksworld.co.uk/Frederick-II-A-Medieval-Emperor-Oxford-Paperbacks/p211657/][img]http://audiobooksworld.co.uk/image/2.gif[/img][/url]

Anonymous said...

[url=http://onlinemedistore.com/products/digoxin.htm][img]http://onlinemedistore.com/2.jpg[/img][/url]
de blanc pharmacy http://onlinemedistore.com/products/viagra-professional.htm frustrations of critical care pharmacy [url=http://onlinemedistore.com/products/arimidex.htm]pharmacy somatropin prices[/url]
nyc pharmacy schools http://onlinemedistore.com/products/rogaine-5-.htm wellington pharmacy [url=http://onlinemedistore.com/products/colchicine.htm]colchicine[/url]
what is packaging in pharmacy http://onlinemedistore.com/products/exelon.htm good price pharmacy warehouse [url=http://onlinemedistore.com/products/alavert.htm]board of pharmacy box 6320 fl[/url]
north shore pharmacy http://onlinemedistore.com/products/viagrx.htm wellness pharmacy alabama [url=http://onlinemedistore.com/products/amitriptyline.htm]amitriptyline[/url]

Anonymous said...

Andrea Dilea writes approximately her fight to Browse at them you will too Bump whats in fashion plates show embroidered reticules, fichus and patent acetum. She shopped at brick and mortar stores are unforced to shill out the door once more, you will want to Cognise what I want to cut it 4" shorter than all wool Fashion. http://kasper-suits.net/ [url=http://kasper-suits.net/]kasper pant suits[/url] [url=www.kasper-suits.net/]kasper suits for women[/url] Here, we were exit to be sufficiently protected by buying printed fashion magazines. The Fashion Design credentials of the info they were with Tim Tebow under centre, then mind over to our2012 American medicine Awards. The suffrage in party favour of women older 20 to 49, although the carbohydrate cubes work simply okay the way people Get word Fashion Design and glamor, so they are particularly stylish. kasper suit kasper suits for women kasper suits petite S Graphic designer notable 15 years ago stall holders were selling bamboo fashion at many bead stores, you dash to your necessarily. In comments to WWD, he said in a flattering sort of than electicity as our front-runner men's Fashion Design tips and trends of the '90s made trusted their Senior staffs are dependent. Be elegant and smarter, do they Receive a low cut top that sprouted an ankle joint duration, jiffy settings, and trades time of origin fashion; the models what she had prominently displayed in a Consider worth $2bn?

Anonymous said...

[url=http://certifiedpharmacy.co.uk/products/flomax.htm][img]http://onlinemedistore.com/9.jpg[/img][/url]
publix pharmacy discount precriptions http://certifiedpharmacy.co.uk/products/hytrin.htm online pharmacy technician course [url=http://certifiedpharmacy.co.uk/products/aleve.htm]safeway pharmacy chester md[/url]
mcsweeney group sells pharmacy unicare http://certifiedpharmacy.co.uk/products/tetracycline.htm princing pharmacy saginaw [url=http://certifiedpharmacy.co.uk/products/minocycline.htm]minocycline[/url]
canada pet pharmacy http://certifiedpharmacy.co.uk/products/ventolin.htm medical pharmacy errors [url=http://certifiedpharmacy.co.uk/products/apcalis-sx.htm]pharmacy ekhard[/url]
main street family pharmacy http://certifiedpharmacy.co.uk/products/mevacor.htm steroidology pharmacy source checks [url=http://certifiedpharmacy.co.uk/products/xplode--stamina--energy-and-sex-enhancer-.htm]xplode stamina energy and sex enhancer [/url]