Why spreadsheets fail for rental management
Spreadsheets work when you're disciplined about updating them immediately. Most rental property owners are not — because updating a spreadsheet is an admin task that competes with a dozen other priorities. Payments get logged in batches. Dates get approximated. Notes like "partial payment, balance next week" get written in cells that have no structured field for that information.
The second problem is that spreadsheets don't alert you. If a tenant is now 15 days overdue, your spreadsheet won't tell you — you have to go looking. And when you're managing 8 units across two buildings, overdue tenants can slip through for weeks before you notice.
The three things you need to track for every rental unit
Expected income: the monthly rent amount, due date, and any reservation fee or advance payment that offsets future rent.
Actual collections: when did the payment arrive, how much was it, via what method (GCash, bank transfer, cash, PDC), and what period does it cover.
Outstanding balance: the gap between expected and actual, flagged clearly so you know who owes what.
Every other detail — tenant name, unit number, lease term — is supporting context. The three numbers above are what drive your financial decisions.
How to handle GCash rent payments
GCash is now the most common way tenants in the Philippines send rent. The workflow: tenant sends payment, you get a notification, you screenshot it (maybe). Three weeks later you can't find the screenshot.
The better approach: export your GCash CSV weekly and upload it to Pipable. The AI identifies which incoming transactions are rent payments (by amount pattern or reference number) and logs them against the right unit. If you receive ₱8,500 every 5th of the month from the same sender, the system learns that pattern.
Tracking PDCs and installment payments
Post-dated cheques (PDCs) are still common for quarterly rent in the Philippines, especially for commercial units. A PDC dated three months from now is an asset — future expected income — but it's not cash yet. You need to log the PDC when you receive it (as a committed future payment), and then log the actual encashment date when you deposit it.
Partial payments require the same structure: log what was received, log what the promised balance is, and set a flag for the follow-up date. If you rely on memory for follow-ups, you will miss them.
What overdue tracking looks like in practice
With Pipable's rental module, each unit has an active rental card. The card shows the current rental period, the expected payment amount, and whether that payment has been received. When the due date passes without a payment logged, the card shows an overdue badge.
You do not need to check a spreadsheet or remember which tenants are late. The overdue units surface automatically. When you follow up and collect a partial payment, you log it against the unit and the system shows the remaining balance — without you having to calculate it.
Tracking expenses against rental income
Net rental income is gross rent minus property expenses: real property tax, maintenance and repairs, insurance, association dues, and any management fees. These costs arrive irregularly — a roof repair in April, an RPT payment in January, a quarterly association due in March.
Logging each expense against the property it belongs to gives you a true picture of each unit's profitability. Your most expensive unit to maintain may actually be your least profitable unit once costs are properly allocated.