Excel for a condo manager: which unit still has a remainder
The condo workbook on this page is the list you open before the morning chase of service charges. One row is one unit for one period word. You type the unit, the owner, the period, the amount called, and the amount received. The gap is called minus received while the row is still open. The window says short when that gap is above zero, clear when the two amounts match, and over when the received amount is above the call. This file is not a lease renewal calendar. That calendar answers which lease end is inside the notice you typed. This list answers which unit still has a remainder on the call you already sent. It is not a trade-receivable chase, and it is not a sales pipeline of apartments. You type both amounts. The sheet does not invent a charge. The guide below builds that call list. Elyx writes the gap and the window in the workbook you already keep. You still type the call and the receipt. The trial lasts 7 days, with no card.
- Build the service charge call list
- Lease end dates, a different list
- Trade receivable chase, also different
- SUMIFS, to add the short remainders
Frequently asked questions
What goes on a service charge call list?
One row per unit and period: called amount, received amount, and a window of short, clear, or over.
Is this the lease renewal calendar?
No. A lease calendar uses an end date and notice days. This sheet uses the two amounts you typed for a service charge call.
Does the sheet decide the charge?
No. You type the called amount and the received amount. The gap is only the difference of those two cells.