Managing rental property involves much more than collecting rent. Every building produces rent due and rent received, security deposits, repairs, utility bills, staff costs and payments to owners. When these live in separate spreadsheets, registers and notebooks, nobody can say with confidence how much a building earned, which tenants still owe, or what is payable to each owner.
Rental property accounting software connects these records to the books, so the owner's statement, the tenant balance and the profit and loss all come from the same entries. This guide explains how rental property accounting works, which records you need, where spreadsheets break down, and what to look for in software, with examples in rupees. The figures are illustrative and do not describe any actual customer.
What is rental property accounting?
Rental property accounting is the recording, classifying and reporting of the money that moves through one or more rental properties. It covers the whole cycle: rent charged to tenants, receipts, deposits held, expenses paid, balances still owed, and what is due to owners.
A property business usually thinks in this structure:
Property → Building → Floor → Apartment, shop or room → Tenant → Lease → Rent → Expense → Accounting
If every transaction stays attached to that chain, you can trace a figure from the portfolio down to one tenant in one room, and back up again. That traceability is the difference between a rent register and rental property accounting.
Why it gets difficult as you grow
One building with a few tenants fits in a sheet. The trouble starts with several buildings, several owners and dozens of leases:
Rent received in the bank may belong to several tenants and several months, so collections never match what was billed. Repairs, electricity, cleaning and security are paid without saying which building they belong to. A tenant pays part of the rent, pays late, or settles several invoices at once, and a monthly total hides what is still due. Deposits are mixed into rent income. Owner statements are rebuilt by hand every month. A building looks profitable only because its costs were booked against another. Rent billed is not rent collected
Suppose a commercial tenant's rent is Rs 100,000 and the tenant pays Rs 70,000 before month end.
| Description | Amount |
|---|---|
| Rent billed | Rs 100,000 |
| Payment received | Rs 70,000 |
| Still receivable | Rs 30,000 |
On an accrual basis, billing the rent is recorded as a debit to the tenant receivable and a credit to rental income, both for Rs 100,000. When the tenant pays, cash or bank is debited and the tenant receivable is credited for Rs 70,000. The remaining receivable of Rs 30,000 stays on the tenant's ledger until it is paid.
Software should let you see each tenant's balance and open it down to the invoices and receipts behind it. In OneAccounts Property Management, every tenant has a ledger with the opening balance, each invoice and payment, and the running balance, and a room-wise receivables report shows for each apartment what was invoiced, what was received and what is still receivable.
Security deposits are not income
A refundable deposit increases your bank balance, but it also creates an obligation to the tenant. It is generally recorded as a liability, not as income. For a Rs 200,000 deposit the simplified entry is a debit to bank and a credit to a refundable deposit liability for Rs 200,000.
When the tenancy ends, the deposit may be refunded in full, or reduced by deductions that are valid under the agreement. If Rs 20,000 is rightly applied against an amount due, the refund is Rs 180,000 and the settlement must record both parts. The right treatment of a deduction depends on what it is for: unpaid rent, a repair charge and a forfeited deposit are not the same kind of item, so they should not all be booked as the same income.
A good system keeps the deposit visible as money held for the tenant until it is settled. In OneAccounts Property Management you can receive a deposit, hold it and settle it at move-out with itemised deductions, and the settlement is printed as a PDF.
Expenses: record them against the right building
Typical costs are repairs and maintenance, cleaning, security, electricity and water for common areas, staff and administration. Recording the expense is only the first step. You also need to know which building it belongs to.
| Expense (Building A, one month) | Amount |
|---|---|
| Repairs and maintenance | Rs 35,000 |
| Security services | Rs 25,000 |
| Common-area electricity | Rs 20,000 |
| Cleaning | Rs 10,000 |
| Total | Rs 90,000 |
When one cost serves several buildings, split it on a basis you can explain and apply every time, such as floor area or the number of units. In OneAccounts Property Management a single expense can be split across buildings, monthly recurring expenses can be generated each month, and each staff member's cost can be spread across the buildings they look after.
Rental property profitability
Rental income alone does not show how a building performs. A useful first measure is net operating income (NOI):
Net operating income = operating income − operating expenses
| One month, one building | Amount |
|---|---|
| Rental income recognised | Rs 600,000 |
| Other operating income | Rs 20,000 |
| Operating expenses | Rs 170,000 |
| Net operating income | Rs 450,000 |
NOI is not the same as net profit or cash flow. Loan repayments, depreciation, capital spending and other items may need separate treatment. Use the same periods and the same classifications for every building, or the comparison means little.
Owner statements and settlements
If you collect rent and pay costs for owners, the accounting must separate your own money from money held for them.
| Monthly settlement (illustrative) | Amount |
|---|---|
| Rent collected for the owner | Rs 500,000 |
| Approved property expenses | Rs 60,000 |
| Management fee, if agreed | Rs 25,000 |
| Net payable to the owner | Rs 415,000 |
The statement must reconcile to the entries beneath it. It should not be a separate sheet that someone has to keep in step. In OneAccounts Property Management each owner has a ledger showing what was collected, what was spent on the building and what is due, and the statement, settlement and payout all come from that ledger. An expense charged to an owner is netted off when you pay that owner.
Why double-entry accounting matters
Property operations should not sit outside the books used for financial statements. A rent invoice creates a tenant receivable and rental income. A receipt reduces the receivable and increases cash or bank. An expense affects the expense account and a cash, bank or payable account. Deposits go to a liability.
Lease → Rent invoice → Tenant receivable → Receipt → Ledger → Financial reports
When every event is posted this way, the trial balance, profit and loss and balance sheet are a by-product of daily work rather than a month-end project.
Excel or rental property accounting software?
A spreadsheet is fine for a small portfolio with simple transactions and strong habits. As buildings, tenants and owners grow, the same sheet has to be kept consistent by hand.
| Need | Spreadsheet | Accounting software |
|---|---|---|
| Rent and balances | Separate sheets to keep in step | Charges, receipts and balances linked |
| Deposits | Often in a separate schedule | Held as a liability until settled |
| Expenses by building | Depends on manual coding | Recorded against a building |
| Owner statements | Rebuilt every month | Produced from the owner ledger |
| Audit trail | Depends on version history | Change history kept in a log |
| Several users | Risky to share one file | Roles and access by building |
A well-run spreadsheet can still work for a small operation, and badly set up software can still produce poor results. The aim is traceability, not replacing Excel for its own sake.
What to look for in rental property accounting software Integrated accounting. Property transactions should post to a general ledger and produce a trial balance and financial statements. Tenant receivables. You should see invoices, receipts and the balance for each tenant, and the amount owed room by room. Deposit control. Deposits should be kept apart from income, with refunds and deductions recorded. Building-wise reporting. Income and expenses should be reportable by building as well as for the whole portfolio. Owner ledgers. If you manage for third-party owners, check that statements, settlement and payouts come from a ledger. Lease handling. Renewals, changing charges, move-out settlement and warnings about leases that are about to end save a great deal of manual follow-up. Control and audit. Look for roles, access limited by building, and a log of who changed what. Migration and support. Check how tenants, leases and opening balances come in, and whether you can export your data to Excel. How OneAccounts Property Management supports this
OneAccounts Property Management is a separate application at properties.oneaccountsbysiqbal.com, built to the same double-entry standard as OneAccounts. It organises buildings, floors and rooms, with owners, tenants and leases attached. Rent is invoiced in batches with PDF receipts, security deposits are held and settled, and every invoice posts straight into the books. Utility bills are uploaded from an Excel template and land on the tenants' invoices. Building expenses and staff costs sit next to the rent they earn.
For reports, you get receipts by head, security deposits, tenant ledger, room-wise receivables, expenses by category, expenses by month and collection against bills, together with the owner ledger and the full accounting reports. Access is role-based, can be limited to the buildings a user looks after, and every action is kept in an audit log. Existing owners, buildings, apartments, tenants and leases can be imported from Excel templates, and your data can be exported to Excel at any time.
See the full feature list on the Property Management page. There is no free trial for Property Management, but we give a demo on request: message us on WhatsApp and we will show it with your kind of building. The price is Rs 5,000 per month.
Frequently asked questions What is rental property accounting software?
It is software that records rent, tenant receivables, deposits, property expenses and owner settlements in real accounting entries, so tenant balances, owner statements and financial reports all come from the same records.
Is property management software different from accounting software?
Property management software holds buildings, tenants, leases and rent. Accounting software holds the ledgers and statements. An integrated system posts property events into the books so the two never disagree.
How should security deposits be recorded?
Refundable deposits are generally recorded as a liability, not as rental income. Refunds and valid deductions are then recorded when the deposit is settled, according to the agreement and the accounting rules that apply to you.
Can software show unpaid rent?
Yes, if it invoices rent and records receipts against the invoices. Each tenant's balance then shows what was billed, what was paid and what is still owed.
What is the difference between rental income and net operating income?
Rental income is the income earned from letting property. Net operating income is operating income less operating expenses. It is not the same as net profit or cash flow, because financing, depreciation and capital spending are treated separately.
Can one system handle several buildings and owners?
Many can. Check that transactions can be reported by building and by owner while the company's main accounts stay consolidated.
Is Excel enough for rental property accounting?
For a small portfolio with simple transactions and careful habits, it can be. As buildings, tenants and owners grow, software helps with consistency, traceability and reporting.
How do I choose property management software in Pakistan?
Look at accounting integration, tenant receivables, deposit handling, building-wise reports, owner ledgers, lease renewals, access control, import and export, and local support. Ask for a demo with your own kind of building before deciding.