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