Free template · Excel
Annual condominium budget
An Excel template that works out the monthly fee each unit needs, with the reserve fund, the contingency and late payers already counted.
- Expenses by month: staff, utilities, the power plant, maintenance, insurance and administration, with example amounts in pesos.
- The reserve fund and contingency as percentages you set, and other income such as renting the party room.
- The monthly fee per unit, equal or by each unit’s share, adjusted for the part of the fees that arrives late.
- Every total is a formula: change a number and the whole budget updates.
When you’re ready to leave the spreadsheet
Condovera generates the dues every month, each owner sees their statement, and Vera, the AI assistant, answers “how much do I owe?” for you.
- Who approves the budget?
- The owners’ assembly, as your condominium’s bylaws and Law 5038 of 1958 provide. The template helps you prepare the proposal; check the details with your advisor.
- Does it work in Google Sheets?
- Yes. Upload it to Google Drive and open it with Sheets, or use it in Excel or LibreOffice.