• ProvidentLiving.org.nz
  • Frugal Abundance
  • Family Garden
  • Preparedness 4 Calamities
  • Make & Store Food
  • Lite email alert
Home » Budgeting & Frugal Finance » Keep track of cash
Dec11 0
Keep track of cash

Keep track of cash

Posted by Hank in Budgeting & Frugal Finance

I didn’t like to write down every time I spent money.

Then I made a discovery. If you find it hard to keep track of where you spend your money, there’s an easy way.

This is how I keep track of spending without writing anything down on paper.

If you use your plastic bank card for all your spending then you’ll leave a spending track that is easy to follow just like animal footprints in the sand.

  • Buy everything with a bank card – not cash. Use a debit card for online purchase. Destroy your credit card.
  • Let the card statement keep track of your expenses.
  • If you have a credit card (e.g. VISA), pay it off in full, before it is due, every month. No Visa, no worry.
  • Every 3 days or so, go into internet banking.
  • Select then copy your transactions for the past 3 days.
  • Paste them into a blank Microsoft XL worksheet.
  • Add details about each purchase while you still remember them. More than 3 days and I forget what I spent.
  • At the end-of-month, save the work-sheet.
  • Name your worksheet. e.g. ACCOUNTS-Feb-2012.xls
  • Keep a different XL file for each month.
  • Use a different worksheet for each account, all in the same file for that month.

References and Credits

1. Photo of tracks in the sand by Heidi Bakk-Hansen http://www.flickr.com/photos/8669065@N06/2058473079/

Select right from the start. Selecting appears tricky but easy when you select the whole table from the start. Then it fits into the XL cells perfectly every time!

Leave a Comment Cancel reply

Your email address will not be published. Required fields are marked *

*

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

The Frugal Five

  • Make & Store Food
  • Grain Mills
  • Frugal Abundance
  • Family Garden
  • Preparedness 4 Calamities

About Provident Living

  • Home
  • Jobs
  • Purpose, Mission and Philosophy
  • Contact Hank
  • Spiritual Preparation

Who's Online

1 visitors online now
Map of Visitors

© 2011 | Designed by Elegant Themes | Powered by WordPress