這樣一來，我，更確定我是喜歡冬天的 =)
是因為習慣而喜歡，還是喜歡而習慣呢? 嗯... 喜歡就好，想那麼多幹嘛！
Thursday, 23 July 2009
Thursday, 9 July 2009
Daily Book-Keeping Spreadsheet v0907
Introduction
I started to have the habit of recording my daily expenses on a spreadsheet since university, which is like 7 years ago.
Initially the purpose of doing so was to give my parents a figure of living cost as they were my financial supplier. Slowly, it has became my habit, and it comes very handy when you want to know exactly where you spent the money to or when you want to have some budgeting over a period of time.
Through out the past 7 years I have been modifying the spreadsheet to make it easier to use while able to capture data in more detail. Now, I think it is mature enough to be the first version to share with people, so everyone can start building this good habit of bookkeeping. If you use this spreadsheet correctly, it can be as accurate as your bank account statement, and it might come handy when doing tax return.
Download Daily Book-Keeping Spreadsheet v0907
Excel 2003 or earlier version...download here
Excel 2007 or later version... download here (recommended!!)
Quick start guide
Let me have a quick go through of how to start using this spreadsheet, from now on I will refer daily book-keeping spreadsheet as "DBS".
First, you need to give the spreadsheet some initial data to start with. This only needs to be done once every year.
In the "Start" worksheet as shown below, you can fill in some details of your current financial status so that DBS can use these values as a base for calculations.
The total wealth section shows your net wealth position each month (taken out bills payable and includes all investments).
The credit amount (red) in bank summary section keeps track of your credit card expense according to your billing cycle, the calculation depends on the billing cycle end date you entered in start page.
The expense summary section breaks down your expense into 8 categories of your choice (you can rename these categories, but you don't have to use all 8), and gives you weekly/monthly average. Some example category can be food, travel, bills and rent.
Now lets look at the work sheet for month. This is where you keep all your expense details, as you can see from the screen shot below. The expenses are split into 3 major groups : cash (green), credit (blue) and EFPOS (gray), each group is divided further into categories as defined in summary sheet. The expenses recorded under credit group will affect the credit amount displayed in summary page, where the EFPOS expense will directly deduct the amount from your bank 1 account.
Red colored section are non expense transactions, it will affect the bank 1 amount but should not be considered as expense, for example credit card bill payment and withdraw.
If you do the transfer between accounts (bank 1 to bank 2, bank 1 to share account etc), you can use the purple column to record. Currently it only support transfers from primary bank account, you record positive amount when deposit into bank 1, negative when transfer out of bank 1.
hint: You can hide the category columns that you don't use so the page will look neater.
I hope the above intro can get you started with DBS, the fastest way to get familiar is to give it a quick play. Just keep in mind that don't overwrite the cells that are filled with formula, if you find certain amount does not match with real data, most of the time you should be able to trace back your records and find out the source of mismatch.
Finally feedback and recommendation are welcome, and please do let me know if you found any bug or have any question =) Thanks!
I started to have the habit of recording my daily expenses on a spreadsheet since university, which is like 7 years ago.
Initially the purpose of doing so was to give my parents a figure of living cost as they were my financial supplier. Slowly, it has became my habit, and it comes very handy when you want to know exactly where you spent the money to or when you want to have some budgeting over a period of time.
Through out the past 7 years I have been modifying the spreadsheet to make it easier to use while able to capture data in more detail. Now, I think it is mature enough to be the first version to share with people, so everyone can start building this good habit of bookkeeping. If you use this spreadsheet correctly, it can be as accurate as your bank account statement, and it might come handy when doing tax return.
Download Daily Book-Keeping Spreadsheet v0907
Excel 2003 or earlier version...download here
Excel 2007 or later version... download here (recommended!!)
Quick start guide
Let me have a quick go through of how to start using this spreadsheet, from now on I will refer daily book-keeping spreadsheet as "DBS".
First, you need to give the spreadsheet some initial data to start with. This only needs to be done once every year.
In the "Start" worksheet as shown below, you can fill in some details of your current financial status so that DBS can use these values as a base for calculations.
Financial Year/Month: Year and month that the financial year starts, eg 2009 July - Bank name / balance: For up to 2 bank accounts, enter the balance as at the day you start book keeping. Bank 1 should be your primary transaction account. You can also give them names e.g. savings
- Share Trading balance: (optional) enter the amount that you have invested on share
- Managed Fund balance: (optional) enter the amount that you have invested on managed funds.
- Outstanding card bill: The credit card bill outstanding since your last paid bill.
- Monthly card bill end day: Day of month which the credit card bill cycle ends.
The total wealth section shows your net wealth position each month (taken out bills payable and includes all investments).
The credit amount (red) in bank summary section keeps track of your credit card expense according to your billing cycle, the calculation depends on the billing cycle end date you entered in start page.
The expense summary section breaks down your expense into 8 categories of your choice (you can rename these categories, but you don't have to use all 8), and gives you weekly/monthly average. Some example category can be food, travel, bills and rent.
Now lets look at the work sheet for month. This is where you keep all your expense details, as you can see from the screen shot below. The expenses are split into 3 major groups : cash (green), credit (blue) and EFPOS (gray), each group is divided further into categories as defined in summary sheet. The expenses recorded under credit group will affect the credit amount displayed in summary page, where the EFPOS expense will directly deduct the amount from your bank 1 account.
Red colored section are non expense transactions, it will affect the bank 1 amount but should not be considered as expense, for example credit card bill payment and withdraw.
If you do the transfer between accounts (bank 1 to bank 2, bank 1 to share account etc), you can use the purple column to record. Currently it only support transfers from primary bank account, you record positive amount when deposit into bank 1, negative when transfer out of bank 1.
hint: You can hide the category columns that you don't use so the page will look neater. I hope the above intro can get you started with DBS, the fastest way to get familiar is to give it a quick play. Just keep in mind that don't overwrite the cells that are filled with formula, if you find certain amount does not match with real data, most of the time you should be able to trace back your records and find out the source of mismatch.
Finally feedback and recommendation are welcome, and please do let me know if you found any bug or have any question =) Thanks!
Saturday, 4 July 2009
周杰倫2009世界巡迴演唱會
2009年7月3號是讓身在澳洲的周杰倫迷們為之瘋狂的一天，因為，這天是周董出道十年以來第一次在雪梨舉辦演唱會！
早在三個月前，也就是四月初左右，幾個好友就約好一起預購門票，而且我們瘋狂的訂了AUD$268的票！！畢竟這是大牌明星的演唱會，排場一定不同一般，坐太遠就浪費了 (藉口一堆...哈)
我們七點左右就抵達位於Olympic Park的會場 - Acer Arena。雖然離開演還有一段時間，但是現場早已人山人海，我是第一次在澳洲看到這麼多華人聚集在一起的說...
隨著開場時間一分一秒的逼近，彷彿全澳洲的華人都聚集到這裡來一樣，人源源不絕的湧進會場。終於，演唱會在8點20分左右正式開始！！ 果然大牌明星就是不一樣，整個演唱會氣氛從頭high到尾，周董也不吝嗇的唱了足足兩個半小時，舞蹈 鋼琴 各種樂器樣樣來。表演中參插著各種不同的舞台特效像是燈光甚至小型煙火和火焰都沒少！！
總而言之這是一場令人難忘的演唱會，讓我親眼見證了巨星的風采，就算在身在西方國家，歌迷的熱情也絲毫不減。希望以後能有更多的歌手也能來澳洲巡迴演唱，造福這邊的歌迷 =)
更多的照片請看這邊！
早在三個月前，也就是四月初左右，幾個好友就約好一起預購門票，而且我們瘋狂的訂了AUD$268的票！！畢竟這是大牌明星的演唱會，排場一定不同一般，坐太遠就浪費了 (藉口一堆...哈)
我們七點左右就抵達位於Olympic Park的會場 - Acer Arena。雖然離開演還有一段時間，但是現場早已人山人海，我是第一次在澳洲看到這麼多華人聚集在一起的說...
隨著開場時間一分一秒的逼近，彷彿全澳洲的華人都聚集到這裡來一樣，人源源不絕的湧進會場。終於，演唱會在8點20分左右正式開始！！ 果然大牌明星就是不一樣，整個演唱會氣氛從頭high到尾，周董也不吝嗇的唱了足足兩個半小時，舞蹈 鋼琴 各種樂器樣樣來。表演中參插著各種不同的舞台特效像是燈光甚至小型煙火和火焰都沒少！！
總而言之這是一場令人難忘的演唱會，讓我親眼見證了巨星的風采，就算在身在西方國家，歌迷的熱情也絲毫不減。希望以後能有更多的歌手也能來澳洲巡迴演唱，造福這邊的歌迷 =)更多的照片請看這邊！
Subscribe to:
Posts (Atom)