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!