Dues tracking sheet (CSV)
A free dues tracking sheet with plan, period charge, payment, receipt number and balance per member; opens in Excel with accented characters intact.
Enter your yearly and monthly shared costs and work out dues per member or unit, by headcount or by share, with an instalment plan, in your browser.
Set this plan up in Elele
Instead of redoing the sums by hand each period, put them on record; collections, receipts and reminders follow on their own.
The tool splits a year of shared costs across members or units and divides it into instalments. You can do the same calculation on paper:
The amounts in this example are illustrative.
Take a building with 24 flats: cleaning costs 6,000 a month, common-area electricity and water 1,500 a month, lift maintenance 9,600 a year and insurance 4,800 a year.
| Step | Calculation | Result |
|---|---|---|
| Yearly cost | (6,000 + 1,500) × 12 + 9,600 + 4,800 | 104,400 |
| Reserve (10%) | 104,400 × 0.10 | 10,440 |
| Total needed per year | 104,400 + 10,440 | 114,840 |
| Per flat per year | 114,840 ÷ 24 | 4,785 |
| Monthly instalment | 4,785 ÷ 12 = 398.75 → rounded up | 399 |
| Rounding surplus | 399 × 12 × 24 − 114,840 | 72 |
Split by share instead, a shop with a share of 48 out of 96 carries half the total and pays 57,420 a year; a flat with a share of 24 pays 28,710.
The calculation runs in your browser; nothing you enter is sent to a server or stored. To keep the result, use Copy result or Download CSV.
Instead of redoing the plan by hand every period, set it up as a dues plan in Elele: charges, collections, numbered receipts and reminders then follow on their own.
Elele runs dues plans, collections, receipts and reports from one member list.