| A | B | C | D | E | |---|---|---|---|---| | Unit # | Owner name | Millesimi totali | % share | Contact | | 1 | Mario Rossi | 120 | =C2/1000 | mario@email.com | | 2 | Laura Bianchi | 85 | =C3/1000 | ... | | ... | ... | ... | ... | ... | | | | =SUM(C2:C100) | 100% | | Check: sum of millesimi must be exactly 1000. Step 2 – Expense Categories & Budget Sheet Create "Budget" sheet:
| Source | Language | Features | |--------|----------|----------| | | English | Basic HOA tracker | | Template.net – Condo Fee Ledger | English | Payment tracking | | Google Sheets – Condominium Manager | Multi | Real-time collaboration | | Italian Excel forum (forum.excel.it) | Italian | Millesimi + verbale included | software condominio excel gratis
Assume you enter a total expense in cell (e.g., €1,200). Then in column A list all units, column B their millesimi (from Anagrafe), column C the individual share: | A | B | C | D
| Unit | Owner | Expense date | Description | Due amount | Paid | Balance | Status | |------|-------|--------------|-------------|------------|------|---------|--------| | 1 | M. Rossi | 01/02/2025 | Heating share | 144 | 144 | 0 | Paid | | 2 | L. Bianchi | 01/02/2025 | Heating share | 102 | 50 | 52 | Overdue | | | | | =SUM(C2:C100) | 100% |
This formula automatically recalculates when you change B1. Create "Pagamenti" sheet: