In India we follow April to March financial year and I need to make lot of financial decisions in the month of February and March. Overall, what I found this year, following the calendar year for my financial year review blog-post does not make much sense.
Hence, I redesigned my expense tracking excel sheet from April2018 to March2019. That threw away the first three months of this calendar. In this post, along with the decision, let me also place the raw data for the first three months of calendar year 2018 or the last three months of the financial year 2017-18.
INFLOW Table:
|
Salary
|
Loan
Repay/ Rmbrsmt
|
Bank
Interest
|
Others
|
Maturity
of investment
|
Market
|
Total
|
|
|
Jan
|
108492
|
11420
|
2395
|
4872
|
127179
|
||
|
Feb
|
116380
|
17370
|
11167
|
144917
|
|||
|
March
|
111376
|
33600
|
11501
|
630
|
625868
|
3023
|
785998
|
|
Total
|
336248
|
62390
|
11501
|
3025
|
625868
|
19062
|
1058094
|
|
Upkeep
|
Food
|
Personal
|
Family
|
Investment
|
Transport
|
Travel
|
Gift
|
Recreation
|
Tax
|
Loan
|
Total
|
|
|
Jan
|
1373
|
5456
|
3299
|
1980
|
228163
|
788
|
6823
|
1165
|
1890
|
11800
|
1420
|
264157
|
|
Feb
|
22679
|
2289
|
2000
|
642
|
149368
|
2140
|
7422
|
14500
|
0
|
3916
|
7700
|
212656
|
|
March
|
14824
|
3394
|
300
|
1205
|
785413
|
1975
|
12846
|
2400
|
3001
|
3916
|
70434
|
899708
|
|
Total
|
38876
|
11139
|
5599
|
3827
|
1162944
|
4903
|
27091
|
18065
|
4891
|
19632
|
79554
|
1376521
|
|
Percentage
|
3.67%
|
1.05%
|
0.53%
|
0.36%
|
109.91%
|
0.46%
|
2.56%
|
1.71%
|
0.46%
|
1.86%
|
7.52%
|
130.09%
|
No comments:
Post a Comment