Blog/Finance
ENAuf Englisch gezeigt — die Übersetzung fehlt noch.
How to track rental property cash flow without a bank feed
A practical system for recording income, expenses and debt payments while keeping every number explainable.
Start with the truth, not the automation
A bank feed can hide the thing you actually need: a number you can explain. If a deposit lands as “transfer” and an expense as a card swipe, the feed is complete and the story is not.
Start with what you already know. Rent received. A repair paid. A mortgage payment split into principal and interest. Write those down in the operating record first.
Separate operating cash
Keep the property’s operating cash distinct from personal spend and from the loan. A simple weekly view is enough:
- What came in as rent or recoveries
- What went out as operating cost
- What went to the lender
You do not need a second set of books. You need three buckets that a human can defend.
Record debt correctly
A mortgage payment is not “an expense” in one lump. Record the payment date, the cash that left, the interest portion, the principal portion, and the remaining balance.
That is the difference between a spreadsheet that drifts and a loan you can discuss with a lender.
Review exceptions
Once a week, look only at what is late, missing, or estimated. If a tenant paid late, say so. If a reading is missing, leave it missing — do not invent a tidy average.
Exceptions are the work. The rest is confirmation.
Use a weekly rhythm
Friday is enough. Open the portfolio, check the five numbers that matter, close the loop on anything unexplained. The product is there to hold the record; the rhythm is still yours.
Open the live app at rent.databoardapp.com when you want to test this with one real portfolio.
Finance
Apartment loans