Cash Track
Comments
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
Still loading...
ABC
1
Use this template to help you understand your cash spending patterns and get your budget under control.

Knowing what you actually spend your cash on is the missing link in anyone's budgeting system. It is relatively easy to go through your credit card statements and analyse your historical spending patterns, but this doesn't help you understand where your notes and coins are going. Just add up all your ATM cash withdrawals from your bank statements - you might be surprised at how much cash you are spending. And, on what?
2
Instructions
3
1Enter all your cash transactions in the yellow shaded area of the CASHTRACK worksheet - a link to this worksheet is at the bottom of the screen. I've put some sample entries there to show you how the model works. When you're ready, take a copy of this spreadsheet (File>Create a copy) then select the sample data I've entered and hit delete. You need a google account in order to save a copy.
4
5
Columns
6
i)Date = date of transaction in dd/mm/yy format
7
ii)Description = short description
8
iii)Amount = amount in dollars
9
iv)X = put "X" in this column if you want to ignore this entry from the analysis - for example if you spend $50 on a cleaner but you have already budgeted for this elsewhere - you may still want to track what you actually spent but don't want to double count it in your budget
10
v)Who = initials of the person who spent the cash, as you'll probably want all members of your household (limit of 5 people) to record their cash spend. Google docs has great sharing capabilities, so everyone in your household can access this spreadsheet
11
vi)Category = a category for the transaction e.g. food, entertainment, travel, etc (max of 17 categories)
12
13
2Some rules to obey with this model:
14
i)never insert rows or columns into any of the worksheets - this will definitely mess things up
15
ii)you can add transactions in any order in the CASHTRACK worksheet and then re-sort by date (or other field) - hover your mouse over the thick grey border under the headings and you'll get the sort options
16
iii)if you run out of rows (100 have been provided) please email me at darren@sumwise.com to let me know, as it means the spreadsheet has been useful to you ;) I'll even tell you how to add more rows
17
18
3As you enter transactions, the model will calculate your total cash spend and, more importantly, your "implied annual" spend based on the transactions you have entered. For example if you have spent $100 in 5 days, the implied annual spend will be calculated as $7,300 (i.e. $100/5x365). The longer you use this cash tracking model the more accurate and informative the annual calculation will be. I suggest using it for at least a few weeks to get a good picture of your annual cash spend.
19
20
4View charts and analysis of your cash spend. These are contained in the DASHBOARD worksheet.
21
22
5Advanced Topic: if you forget to update this spreadsheet for a few days but you want to start adding transactions again, you can go to the DASHBOARD worksheet and tell the model to skip certain days. Just put a "Y" in the [ ] column against each day that you want to skip. For example if you go away for four days and lose track of what you spent your cash on, instead of guessing, just tell the model to ignore these four days and start entering transactions again from day 5 onwards. All calculations will be correctly calculated and your implied annual spend calculation will be accurate.
23
24
6Share this spreadsheet with other members of your household and get them to put their cash spending data here too. Click the Share button at the top right and go from there.
25
26
If you have any comments, questions or feedback please email me at darren@sumwise.com or post a comment on my blog http://blog.sumwise.com.
27
Copyright Sumwise Pty Ltd
Loading...
 
 
 
INSTRUCTIONS
Sheet18
CASHTRACK
DASHBOARD