Most rental portfolios begin in Excel: a sheet with apartments, tenants, rents and a column for what each owes. It works until the portfolio grows or an owner asks for proof. This guide explains how to move from an Excel rent register to property management software without losing accuracy, with special attention to the part that goes wrong most often: the opening balances.
When Excel stops being enough Two people have two versions of the sheet. Month-end takes days of copying and totalling. You cannot show an owner exactly how a figure was reached. A tenant disputes a balance and you cannot trace it. One person leaves and nobody understands the file.
If these sound familiar, read why accounting goes wrong in spreadsheets and then follow the steps below.
Step 1: Choose your start date Pick the first day of a month as your go-live date. Everything before it is history that becomes an opening balance; everything from it onward is recorded in the system. Starting on a month boundary makes the first reports clean.
Step 2: Clean your data Before you import anything, fix what the spreadsheet hides.
One row per apartment, with a unique code. One name per tenant, with CNIC and phone number. One record per owner, with the apartments they own. Lease start dates, rents and extra charges filled in. No merged cells, no notes in number columns.
Cleaning takes longer than importing. Do it first.
Step 3: Import in the right order Records depend on one another, so load them in this order:
Owners Buildings Rooms or apartments Tenants Leases
Use the import templates and read the error list after each file. A good import reports each bad row with a reason instead of loading half the data silently.
Step 4: Opening balances An opening balance is what each tenant owed (or had paid in advance) on your go-live date. Get this wrong and every future statement is wrong.
| Tenant | Apartment | Owed on 1 January |
|---|---|---|
| A. Khan | B-101 | 45,000 |
| S. Ahmed | B-102 | 0 |
| R. Malik | B-103 | 90,000 |
| Total | 135,000 |
Work out each tenant's balance from the spreadsheet at the go-live date. Record it per tenant and apartment, so it shows on the right statement. Check the total against the total receivable in your old file. Do not invoice months already covered. If a lease starts before your go-live date, its old months are in the opening balance; billing them again would charge the tenant twice. Step 5: Security deposits
Record the deposit received for each lease, so that the deposit report and the future refunds are correct. A lease imported without its deposit has nothing to refund against.
Step 6: Run in parallel for one month For the first month, keep the spreadsheet going and compare:
| Check | Spreadsheet | Software |
|---|---|---|
| Total rent billed | ||
| Total received | ||
| Total receivable at month end | ||
| Deposits held |
When the figures agree, switch off the spreadsheet. If they do not, find the difference before you go on.
Step 7: Train the people who enter data
Decide who enters invoices, who records payments, and who may reverse or discount. Giving everyone full access on day one invites mistakes.
Common mistakes Importing messy data. Duplicates and spelling variants become permanent. Wrong go-live date. Mid-month starts make reconciliation painful. Missing opening balances. Tenants appear to owe nothing. Billing old months again. The tenant is charged twice. Switching off Excel too early. You lose your cross-check. How OneAccounts Property Management helps
OneAccounts has Excel templates for importing owners, buildings, rooms, tenants and leases, with a row-by-row error report so a bad row is explained rather than silently loaded. Opening balances are entered through a journal entry tagged to the tenant and apartment, and the room-wise receivables report shows each room's opening balance, what was invoiced and received in the period, and what is receivable. You can back up and restore your data at any time. We are happy to help you set up your first building. See OneAccounts Property Management.
Frequently asked questions How long does it take to move from Excel?
For a small portfolio, a few days of cleaning and a month in parallel. Larger ones take longer, mostly in cleaning the data.
Do I need to import old invoices?
Usually not. Carry the balance forward as an opening balance and keep the old file for reference.
What if my spreadsheet balances are wrong?
Find out before you import. A wrong opening balance in new software is still a wrong balance.
Can I import part of my portfolio first?
Yes. Many managers start with one building, check the results, then add the others.
What should I keep from the old system?
The spreadsheet, the last month's closing balances and any signed agreements.