Sunday, May 13, 2018

Annual expense report should follow FY format (last 3 months of FY 2017-18)

In the beginning of 2018, I have realized there is too much to write. I need to write the year review for which the whole diary needs to be read. Again, I have to do the whole year financial calculation and write the financial review blog. This comes as burden to be honest since new year beginning usually comes with many other deliverables as well.
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
OUTFLOW Table:
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