Tipskey
Unlock Practicality
Daily Expenses Sheet Template
Although recording down daily expenses is a little troublesome and some may think that it is not that important, but it does help in financial budgeting. It is difficult not to be frugal if daily expenses are recorded because we will be surprised with the amount of money we have spent. "Hmm... now I know why my bank account is always empty." It will actually make us frugal almost automatically. We may even feel proud if there are days with zero expenditure. If one still feels that it is troublesome to record all expenses, recording only the purchase of non-edible physical items may be an alternative.

Besides helping keep track of expenses, the record also serves as a diary. You would remember what you did on a certain day by looking at the things you spent. I actually retrieve my vehicle maintenance date here to to estimate whether my vehicle needs for example an oil change already.

You should update your expenses before or at the end of everyday. Anytime when you suddenly think of it, update it. Do not procrastinate or else you will waste time trying to recall the expenditure. You may highlight the ones that should not be spent or are spent by mistake while entering the figures. You can start recording the daily expenses on the first day of any week, not necessarily on the first day of the month or the year.

You do not need accounting knowledge to perform such record. You just need to have a spreadsheet software (e.g. Excel) installed.

Keep the spreadsheet in the mobile phone so that you can put in new entry anytime.

For husband and wife, each should keep his/her own daily expenses record and consolidate later.

Explanation for the spreadsheet template

This template is not best used in hardcopy. It should be used as softcopy.

"Mode" column is for you to write "Cash", "Card", "Check" ("Cheque" for UK English) or TT (telegraphic transfer). If you do not use payment card and check, then you can delete the whole "Mode" column or leave it blank. "Trigger" column is for you to write "Self", "Family" or somebody's initial. It is for you to know who triggers you to spend the money.

You can write more details in a cell by using "Insert Comment" function.

To know the total to-date, select the cell where the last-updated total is. Selected cell has a tick black border with a tiny black square at the lower right corner Fill handle. Then move the mouse pointer to the tiny black square (called "fill handle") until the pointer changes from white cross to black. After that hold the left mouse button and drag down.

After one month of putting in the value, you can start doing analysis using the filter function (indicated by the down arrow button on the table heading). For example if you have "fuel" in the "Details" column and to know the fuel spent in that month, click on the down arrow button Down arrow button on "Detail" column heading and choose "Fuel". The other categories you may be interested are food, entertainment, socialization etc.

Day, week and month column do not have to be filled manually for every new row. Just fill in when the day, week or month changes. Later when you need to use the filter function, drag down the day, week or month to fill up the empty cells below.

sort

If you want to know the ten biggest expenses within a period of time, just highlight all the filled cells within that period and click "Data > Sort..." on the menu bar.

"Weekly Chart" and "Monthly Chart" sheets are included with line graph readily built-in. When you fill in at least two figures in the table (you need two points to form a line, right?), the graph will start to appear by itself. If you do not want to do analysis and just want to quickly jot down something everyday, I include a simplified template below.

This is how you can keep track of your expenditure. The template sheet can be modified for small company use too.

Download: 1) daily_expenses.xls 2) example_expenses_2007.xls 3) daily_expenses_simplified.xls
Posted: 2007-01-18; updated: 2014-04-06 by Ong Seng Aun.
I categorize this article under Money. Other articles are accessible from home page.
External pages that link to this article:
  1. Notepad On Personal Finance
  2. Debt Management
  3. How to Solve Money Worries
  4. Financial Planning
  5. College And Finance
Home       About       Privacy       XHTML 1.0 Strict