Hope this formula can helping you to record and control your daily spending budget.
Good luck and hopefully successful ...
Original Sample by Eiky Syam |
|
|
|
|
|
Your Own Budget |
30 |
$ |
|
| Months |
Mar-14 |
Mar-14 |
Apr-14 |
YTD |
|
| Earning |
Budget |
Actual |
Budget |
Act + Bdg |
|
| Earning 1 |
- |
- |
- |
35.600.000 |
|
| Earning 2 |
- |
- |
- |
32.500.000 |
|
| Earning 3 |
- |
- |
- |
13.000.000 |
|
| Earning Other |
- |
- |
- |
- |
|
| Earning |
- |
- |
- |
81.100.000 |
|
| Z&Contribution |
|
|
|
- |
|
| Z-PrevM |
- |
- |
- |
640.000 |
|
| Z-CurM |
- |
- |
- |
562.500 |
|
| Z-THR |
- |
- |
- |
33.333 |
|
| Z-Other |
- |
- |
- |
- |
|
| C-PrevM |
- |
- |
- |
128.000 |
|
| C-CurM |
- |
- |
- |
112.500 |
|
| C-THR |
- |
- |
- |
6.667 |
|
| C-Other |
- |
- |
- |
- |
|
| Z&Contribution |
- |
- |
- |
1.483.000 |
|
| Exp |
|
|
|
- |
|
| Lodging |
- |
- |
- |
4.800.000 |
|
| Transport |
- |
- |
- |
1.715.000 |
|
| Telcom |
- |
- |
- |
480.000 |
|
| Meals |
- |
- |
- |
3.675.000 |
|
| Laundry |
- |
- |
- |
960.000 |
|
| Daily Usage |
|
- |
- |
400.000 |
|
| Family Outing |
- |
- |
- |
9.950.000 |
|
| Refreshment |
- |
- |
- |
1.250.000 |
|
| New Asset |
- |
- |
- |
- |
|
| Spec Req |
- |
- |
- |
400.000 |
|
| Entertaiment |
- |
- |
- |
324.000 |
|
| Other |
- |
- |
- |
196.333 |
|
| Exp |
- |
- |
- |
24.150.333 |
29,8% |
| Saving |
|
|
|
|
|
| Bank 1 |
- |
- |
- |
33.400.000 |
|
| Bank 2 |
- |
- |
- |
22.066.667 |
|
| Saving |
- |
- |
- |
55.466.667 |
68,4% |
|
#DIV/0! |
#DIV/0! |
#DIV/0! |
68,4% |
|
| Balance |
- |
- |
- |
- |
|
|
|
|
|
|
|
| CashFlow |
|
|
|
|
|
| Cash In Hand |
- |
- |
- |
- |
|
| Cash Card |
- |
- |
- |
- |
|
| Bank 1 |
- |
- |
- |
- |
|
| CF Exp |
- |
- |
- |
- |
|
| Bank 2 |
- |
- |
- |
12.400.000 |
|
| Bank 3 |
- |
- |
- |
22.066.667 |
|
| CF Exp &
SV |
- |
- |
- |
34.466.667 |
|
|
|
|
|
|
|
| Defisit/Surplus |
- |
- |
- |
- |
|
|
|
|
|
|
|
|
|
|
|
Created By : |
|
|
|
|
|
|
|
|
Eiky Syam
Hope this formula can helping you to record and control your daily spending budget.
Good luck and hopefully successful ...
| |
|
|
|
|
|
No comments:
Post a Comment