A month ago I bought an apartment by taking a mortgage loan. From now on I will have to plan my finances more precisely to pay my mortgage on time. I decided to automate the planning process.
The idea was to make a budget plan for the years ahead once, then regularly enter the actual cache flow and track the difference between the planned and real income and expenses. As result I've created the calculator below. It can take considerable time to create a budget plan and enter your transactions, so you can evaluate the calculator performance using:
The file is very large. Browser slowdown may occur during loading and creation.
Monthly income and expenses
Date
Income, Plan
Income, Actual
Expenses, Plan
Expenses, Actual
Savings, Plan
Savings, Actual
Savings Estimation
Actual vs Planned
The file is very large. Browser slowdown may occur during loading and creation.
The file is very large. Browser slowdown may occur during loading and creation.
Last month planned expenses by category
Name
Actual
Plan up to date
%
Plan up to end of month
%
The file is very large. Browser slowdown may occur during loading and creation.
Last month unplanned expenses by category
Name
Sum
Unplanned expenses
Completed planned expenses
Underestimated expenses
The file is very large. Browser slowdown may occur during loading and creation.
Upcoming expenses
Name
Upcoming 7 days
Fri, 16th
Sat, 17th
Sun, 18th
Mon, 19th
Tue, 20th
Wed, 21st
Thu, 22nd
The calculator is not finished at the moment. Now it only reflects my initial vision of the family budget problem.
If you, like me, are interested in convenient and free software for managing the family budget, please write your ideas in the comments, I will take them into account in future updates of the calculator.
Comments