Excel dashboard

It is necessary to develop a Google spreadsheet for managing finances

What functions need to be provided:

1. Create a general annual dashboard that will display annual statistics on income/expenses/savings/accounts
2. Create sheets that will display information for each month
3. Maintain current balances on cards where funds are received/from which expenses are deducted based on the completion of the table
4. Create a 50/30/20 dashboard to allocate funds 50% for basic needs, 30% for discretionary expenses, 20% for savings
5. A calendar for tracking the days when bills/utilities need to be paid + a calendar that will show on which days there were expenses and which days there were none

Design the table so that everything looks nice and using this table is easy for a person who did not develop it