Rental Property Micro-ERP
a landlord with a handful of doors who’s outgrown a spreadsheet but can’t stomach paying for a full property platform.
Keep four simple CSV files, properties, leases, payments, and repairs, and it works out exactly what each tenant owes as of today, lists who’s behind, warns you about leases ending inside the next 60 days, and tallies your open maintenance.
$24 a month for a portfolio up to 15 units. No tenant portal, no bank connection, no per-door fee. Cancel any day and your CSVs and reports stay on your disk.
The monthly question every landlord actually asks
It’s the same short list every month. Who paid, who didn’t, whose lease is almost up, and what’s still broken. You don’t need software that talks to your bank and runs a tenant login and does accounting. You need those four answers, and a spreadsheet gives them to you right up until you have enough units that the formulas start lying and you stop trusting the total.
That’s the awkward middle. Too many doors for a spreadsheet, not enough to justify AppFolio at its price and setup. So the arrears number drifts, a lease renewal sneaks up on you, and a repair you meant to chase sits open for two months.
Load, compute, flag
- It loads your data from the folder, requiring only
properties.csvandleases.csv. Ifpayments.csvormaintenance.csvis missing it just treats that set as empty rather than crashing. - It builds the rent roll by counting whole months from each lease start up to your as-of date or the lease end, multiplying by rent, and subtracting the payments received, so a positive balance means that tenant owes.
- It raises the flags you’d otherwise track by hand: anyone in arrears, any lease ending within the renewal window, and every repair not marked done, with the total you’ve spent.
What the reports tell you
- A
RENT_ROLL.mdwith the balance on every active lease, so the whole portfolio’s position is one file. - An
ARREARS.mdthat names only the tenants who owe, which is the page you actually act on. - A
LEASE_EXPIRATIONS.mdlisting the leases inside the 60-day window, so a renewal conversation happens before the lease lapses, not after. - A
MAINTENANCE.mdof everything still open plus what the repairs have cost you. - A
portfolio.jsonwith units, occupancy percentage, monthly rent potential, collected, and outstanding, if you want the headline numbers somewhere else.
Who it fits, and who it doesn’t
Owner-operators with 1 to 15 units who keep their own records and want the month’s real numbers without a subscription that assumes a leasing office.
Not for you if you want tenants paying rent through an online portal, or bank-fed transactions, or accounting built in. That’s exactly what the big platforms are for, and if you need those, pay for one. This is deliberately the read-only owner’s-eye view, not a system tenants log into.
What it replaces, and what those do better
AppFolio and Buildium at the top, a homemade spreadsheet at the bottom. Those platforms are honestly better where they earn their price: online rent collection, tenant and maintenance portals, bank sync, and full property accounting. A spreadsheet is free and bends to any layout you like.
What neither end does well for a small landlord is give you a trustworthy rent roll and arrears list from plain files, cheaply, without moving in. This computes the numbers the owner checks and stops there, which at 15 doors is usually all you wanted.
Where your records stay
Everything runs on your disk. The CSVs are read locally and never sent anywhere, and the only writes are the reports, all under your output folder, at 0600 permissions, with every path checked so it stays put.
Your leases, your tenants’ payment history, and your repair log never touch a server, because there’s nothing built to send them. Cancel and the reports are still markdown and JSON on your machine.
$24 a month, and the first rent roll
Drop the CSVs in a folder, set the output folder, optionally set an as-of date or a different renewal window, and run it. First rent roll in under a minute for a small portfolio. Update the payments file and re-run whenever you want a fresh read.
Security and privacy
Handles landlord/tenant data (names, rent amounts, payment history, property addresses). Security is designed in.
Principles
– Local-first. DATA_FOLDER is read from disk and never transmitted anywhere; nothing in this tool touches the network. Nothing is uploaded, no telemetry, no cloud dependency.
– Non-destructive. Source CSVs are only read, never modified or deleted.
– Least privilege. Reads from DATA_FOLDER, writes only under OUTPUT_FOLDER.
Protections implemented (v0.1.0)
– Path-traversal defense — every output filename is sanitized (safeSegment) and every write is checked with assertWithinRoot(), so reports can’t be written outside OUTPUT_FOLDER.
– Fail-fast config validation — clear errors for missing/invalid DATA_FOLDER/OUTPUT_FOLDER/RENEWAL_DAYS/AS_OF before any file is touched.
– Restrictive permissions — every generated report (RENT_ROLL.md, ARREARS.md, LEASE_EXPIRATIONS.md, MAINTENANCE.md, portfolio.json) is written 0600.
– Defensive parsing — the CSV, currency, and date parsers never throw on malformed input (missing fields default to empty string, unparseable amounts default to 0, unparseable dates default to null); a bad row degrades that lease’s numbers rather than crashing the run.
– Tolerant of missing optional inputs — payments.csv and maintenance.csv are optional; a missing file is treated as an empty data set instead of an error. properties.csv and leases.csv are required and fail fast with a clear message if absent.
– Secrets discipline — .env and generated Reports/ output are git-ignored; no secrets or client data in the repo.
Distribution / AV trust
Known limitations / roadmap
– Rent-owed calculation uses whole calendar months elapsed, not day-level proration — a tenant who moved in mid-month will show a slightly different balance than a day-prorated ledger until the proration feature ships.
– Payment-to-lease matching is by lease_id only; if payments.csv contains a lease_id that doesn’t match any row in leases.csv, that payment is silently excluded from every lease’s balance (it does not corrupt another lease’s numbers).
– Maintenance “open” vs “closed” is determined by a fixed status vocabulary (done, closed, complete, completed, resolved); other status strings (e.g. in progress, scheduled) are treated as open by design.
Reporting
Report suspected vulnerabilities privately to the maintainer before public disclosure.
Frequently asked questions about Rental Property Micro-ERP
What does the rental property micro-ERP software do for a small landlord?
The rental property micro-ERP software keeps everything about a small rental operation in one place. Properties, units, tenants, leases, repairs, and rent all live together instead of being scattered across a spreadsheet, a shoebox of receipts, and your memory. It is built for the landlord with a small handful of units who has outgrown a workbook but cannot justify the price or weight of a platform like AppFolio or Buildium. The idea is simple. Give a side-of-the-desk landlord a real system without the overhead of an enterprise one.
Getting started is straightforward. You add your properties, units, and tenant or lease details. You log rent payments and repair requests as they happen. Then you check the dashboard to see what is due, what is late, and what needs attention. That is the daily loop. Instead of hunting through old messages to remember whether unit three paid this month, you glance at one screen and know. The tool is sized for up to about fifteen units, which is exactly the range that spreadsheets start to fail and big platforms start to feel absurd.
Keeping this information organized is not just convenience, it is part of running a rental as a real business. A landlord has income and expenses to report, and the records behind them need to survive for years. the IRS guidance on how long to keep business records sets out how long a business must keep the documents that support its return, and rental income, repair costs, and lease terms all fall under that. A spreadsheet that gets overwritten or a receipt that fades in a drawer is a poor way to hold something you might need at tax time or in a dispute.
The micro-ERP treats those records as records. Rent history, repair logs, and lease details stay stored and searchable, so when you need to show what a tenant paid or when a repair was done, the answer is right there. That reliability is the quiet value. It is not exciting, but it is the difference between confidence and a frantic search the night before your accountant needs numbers.
The tool is aimed at owners managing rentals on the side, not property-management companies with hundreds of doors. If you have a few units and a full life otherwise, it fits the way you actually work. You can see how a first property gets set up on the product page, which walks through the basics. There is no long onboarding and no per-door minimum to clear before it starts making sense for you.
The honest scope is deliberately small. The rental property micro-ERP software does not try to do accounting, marketing, and screening all at once the way the big suites do. It does the core tracking a small landlord actually needs and leaves the rest alone. For small-business operators who moonlight as landlords, that focus is the point. It handles the essentials well rather than burying you in features you will never open, which is exactly why a spreadsheet felt safer than a big platform in the first place.
How does the tool help me handle rent income and a Form 1099-K?
More landlords collect rent through payment apps and online transfers every year, and that changes how the income shows up at tax time. When rent flows through a card processor or a third-party payment network, you may receive a Form 1099-K reporting the gross amount those channels paid you. If your own records are a jumble, matching that form to what you actually collected turns into a headache. The rental property micro-ERP software helps by keeping a clean, dated record of every rent payment as it comes in.
The daily habit does the work. You log rent payments against each tenant and unit as they happen, and the tool holds that history in one place. So when a 1099-K arrives, you have your own trustworthy ledger to check it against, tenant by tenant and month by month. That is a far better position than reconstructing a year of deposits from bank statements and vague memory in April.
It helps to understand the form. the IRS guidance on Form 1099-K explains that a 1099-K reports the payments you received for goods or services through cards and third-party networks, as a gross figure. Because it is gross, it will not automatically match your net rental income after any fees or adjustments, which is exactly why a clean payment record on your side matters so much. You need something to reconcile the form against, and the micro-ERP gives you that.
Keeping the record straight also protects you if a number is ever questioned. A dated rent log tied to specific tenants and units is evidence, not guesswork. If the gross on the form looks higher than you expected, you can walk through your own history and see where the difference comes from, whether it is a deposit, a fee, or a payment that spanned a boundary between months.
None of this makes the tool a tax preparer, and it should not be mistaken for one. The rental property micro-ERP software does not file anything or give tax advice. What it does is make sure the raw record your preparer or your software starts from is complete and organized, so the 1099-K stops being a scary mismatch and becomes something you can explain in a few minutes.
There is a broader lesson here that applies well beyond one form. The moment your rent stops being a check in the mail and becomes a digital payment, good recordkeeping stops being optional. The tool builds that habit into your daily routine without asking you to think about it.
For an owner, the payoff is a calmer tax season and fewer surprises. You collect rent, you log it, and the record is ready whenever a form or a question shows up. You can see how payment tracking works on the product page. For small-business operators renting out a few units on the side, having your income already reconciled against the paperwork the payment networks send is exactly the kind of quiet advantage that keeps tax time boring in the best way.
Is my tenants’ personal information safe in this system?
A rental operation collects a surprising amount of personal information. Names, contact details, lease terms, payment history, and sometimes far more sensitive material all pass through your hands. That makes it fair to ask how the rental property micro-ERP software handles it. The tool stores tenant and lease details so you can run your properties from one place, which means it is holding data that deserves genuine care. Knowing what you keep is the first step to keeping it responsibly.
The plain-language standard worth applying comes from the FTC guide Protecting Personal Information, which tells businesses to take stock of the data they hold, scale down to what they truly need, lock down what they keep, and pitch what they no longer use. Landlords are notorious data pack rats, holding onto old applications and copies of identity documents long after a tenant has moved on. Using a single system is a chance to scale down, keeping the details you actually need to manage a lease and not a pile of sensitive paper you forgot you had.
Locking it down is easier in a real system than in a spreadsheet or a folder of scanned documents. A workbook of tenant information can be copied and emailed by anyone who has it. The micro-ERP keeps that information in one controlled place behind your login, so it is not floating around in a dozen copies on different devices. One protected door is far easier to guard than many you have lost track of.
Disposal matters too, and it is the step landlords skip most. Old tenant records carry risk long after they stop being useful. Clearing information you no longer need is the pitch-it step the FTC guide describes, and it shrinks what you would lose if anything ever went wrong. A system that keeps records organized also makes it far easier to see what has aged out and can be cleared.
The honest caveat is that no tool removes your responsibility to handle tenant information carefully. The rental property micro-ERP software gives you a controlled place to keep it and the organization to manage it well, but the habits are still yours. Use a real login rather than a shared password, keep access limited to people who genuinely need it, and do not hoard sensitive documents out of inertia.
It also helps to think about who can reach the data. If you use a bookkeeper or a co-owner, they should have their own access rather than everyone sharing one account, so you always know who looked at what. That simple discipline turns a pile of tenant records into something accountable.
For an owner, the takeaway is that a dedicated system tends to lower your exposure, because it replaces scattered documents with one organized, controlled place. You can see how tenant records are stored on the product page. For small-business operators managing rentals alongside everything else, that move from loose files to a single protected system is one of the more meaningful privacy upgrades you can make without hiring help.
How is the rental property micro-ERP software different from AppFolio, Buildium, or a spreadsheet?
The rental world has two poles and a painful gap in the middle. On one side are spreadsheets, cheap and familiar but fragile and forgetful. On the other are platforms like AppFolio and Buildium, powerful but priced and built for property-management companies with large portfolios. The small landlord with a few units sits in the gap, too big for a workbook and too small for the suites. The rental property micro-ERP software is built specifically for that gap.
Against a spreadsheet, the difference is structure and memory. A workbook has no real record of who changed what, no rules to catch a bad entry, and no dashboard to tell you what is late. The micro-ERP holds properties, tenants, leases, repairs, and rent in a connected system, so the information stays organized as it grows instead of collapsing into a tangle of tabs the moment you add a third unit.
Against AppFolio and Buildium, the difference is scope and price. Those platforms assume you are running a management business with staff, accounting, marketing, and screening all bundled in, and they charge accordingly, often with minimums that make no sense for a handful of doors. The tool does the core tracking a small landlord needs and stops there, which keeps it affordable and simple enough to actually use on the side.
There is a useful way to frame the value of moving from a spreadsheet to a real system. the NIST Cybersecurity Framework organizes reliability around identifying your important information and protecting it with controls like access management and dependable records. A spreadsheet identifies and protects nothing, while a dedicated system gives your rental records a real home with a login in front of them. The micro-ERP delivers that step up without asking you to run enterprise software.
Scope discipline is the whole design philosophy. The suites try to be everything, which is why they cost what they cost and take real effort to set up. Being sized for up to about fifteen units lets the tool stay focused, so setup is measured in an afternoon rather than a project. You keep the simplicity that made a spreadsheet tempting and gain the reliability it never had.
You can see how the tool compares to both a workbook and the big platforms on the product page, which lays out where it fits. The honest positioning is that it is not trying to beat AppFolio at AppFolio’s game. It is serving the owner that game was never priced for. This is a real chasm in the market, not a marketing one, which is why nothing on either side has ever quite served the small owner well.
The blunt truth is that most small landlords stay on spreadsheets not because they are ideal but because the alternative felt like overkill. The rental property micro-ERP software removes that false choice. It gives small-business operators who happen to own a few rentals a system that fits their actual size, which is exactly why neither the workbook nor the enterprise suite ever felt right.
How do rent and repair tracking work day to day?
The daily value of the rental property micro-ERP software comes down to two ordinary but constant tasks, tracking rent and tracking repairs. Both are easy to let slip when you manage rentals around a full life, and both cause real trouble when they slip. The tool is built so these tasks take seconds and leave a clean record behind, which is what keeps a small rental operation from descending into guesswork by the third month.
Rent tracking works by logging each payment against the tenant and unit it belongs to. Over time that builds a history you can actually trust, so the dashboard can show you what is due, what is late, and what is paid at a glance. Instead of scrolling through a bank feed trying to remember who sent what, you see the status plainly. Late rent gets noticed early, when a gentle reminder still works, rather than after two months of silence.
Repair tracking works the same way. When a tenant reports a problem, you log the request, and it stays visible until it is resolved. Nothing falls through the cracks between a text message and your intention to deal with it later. You also build a repair history for each unit, which is genuinely useful. It shows patterns, supports your expense records, and settles disputes about what was fixed and when.
Those repair and payment records also carry weight for protecting tenant and financial information, which is why organization matters as much as convenience. the FTC Safeguards Rule describes the kind of written program a business should keep to protect customer information, built on administrative, technical, and physical safeguards with access limited to those who need it. Keeping rent and repair records in one controlled system, behind a real login, is a practical piece of that same discipline for a small landlord.
The dashboard ties it together. Rather than checking three places to understand where things stand, you open one screen that surfaces what needs attention. That is the whole point of keeping rent and repairs in the same system. The information talks to itself, so a late payment and an open repair for the same unit are both in front of you at once.
It is worth being honest about what this is not. The tool will not chase tenants for you or fix the leak. It makes sure you know what is outstanding and keeps the record straight, but the follow-up is yours. What it removes is the forgetting, which is where most small-landlord headaches actually begin. That honesty is deliberate, because a tool that overpromises is worse than one that quietly does the job it claims.
For an owner, the result is control over the two things that matter most day to day. You can read how the dashboard surfaces due and late items on the product page. For small-business operators renting out a few units, having rent and repairs tracked in one place with the rental property micro-ERP software is the difference between running your rentals and having them run you.
| Attributes | Value |
|---|---|
| Deployment |
Cloud |
| Platform |
Web |
| License Type |
Subscription |
| Billing Period |
Monthly |
| Target Customer |
Small Business & Retail |
| Free Trial |
Yes |
Frequently bought together
-
Browser Workspace / Tab Context Organizer
$35.00 -
Data-Entry Killer (email -> records)
$35.00 -
Excel-to-Vertical-App Converter
$39.00 -
KPI Dashboard Autobuilder / Desktop Command Center
$39.00 -
Local Demand Forecaster
$39.00 -
Local Video Transcription / Private Note Taker
$75.00 -
SMB Ops Reconciliation OS / Owner Control Center
$75.00 -
SOP & Tribal-Knowledge Engine
$39.00








