Migrating Building Data from Excel to Management Software

To move building data from Excel into building management software, enter the list of units and their details first, then owner and tenant records, then each unit’s debit or credit balance as of one fixed date, and finally the charge calculation method — and reconcile those balances with residents before you issue the first charge. This simple order prevents the most common dispute after a building changes systems: “I never owed that much!”

Many building managers have run everything from one spreadsheet for years — a file that gains a new column every month, has been edited by several people, and where only the manager knows which colour means “paid”. Moving that file into building management software takes some patience and will not be finished in a day, but done properly it only has to be done once. If you are still deciding whether to stay with spreadsheets at all, see our comparison of Excel and building management software.

Before the Move: Clean Up Your Building’s Excel File

A building spreadsheet usually has several sheets: a resident list, a monthly charges table, an expense log and perhaps a “debtors” sheet. Before anything else, back up the original file and work on a copy. Then check the following:

• Each unit number appears once and in one format — not “12” in one place and “3rd floor, unit 2” in another.
• The owner and the current occupant are recorded separately; in rented units they are not the same person.
• Mobile numbers are complete and current; resident logins and text messages depend on them.
• Colours and notes inside cells are turned into numbers and clear columns; software does not understand yellow highlighting.
• Column totals are re-checked with a calculator or a fresh sum; broken formulas are common in old files.

How to Import Units, Owners and Tenants into HOA Software

Building structure first

Blocks, floors and units are the foundation of everything else. For each unit, collect the details that affect the charge: floor area, floor, number of parking spaces and number of occupants. Even if you split charges equally today, record this information anyway; the next owners’ meeting may decide to change the method.

Then the people

For each unit, record who the owner is, who currently lives there, and whether the occupant is a tenant or the owner. Board members, the accountant and the caretaker or concierge should also be identified separately, because each will have different access. If a unit has been sold or re-let in recent years, note the dates of those changes; they help answer the question “which resident does this debt belong to?” later.

Opening Balances: The Most Sensitive Part of HOA Software Data Import

This is where most disputes begin. The main rule: pick one fixed date (for example, the end of a month) and calculate each unit’s balance exactly as of that date. Any payment that arrives after that date is recorded in the new system, not in the spreadsheet.

As this hypothetical example shows, the figure in the spreadsheet is not always the final figure. Do not leave old debts in limbo either; if they are going to be pursued, our guide to collecting unpaid building charges sets out a polite, step-by-step approach.

Setting Up the Charge Calculation Method in Building Management Software

Before issuing the first charge in the new system, configure exactly the method that the owners’ meeting or the board has approved. These questions need clear answers:

• Are charges split equally, or by floor area, number of occupants, parking spaces or floor — or a combination?
• Which day of the month are payments due?
• Are one-off costs, such as an elevator repair, collected separately from the monthly charge?
• Has the building approved a late fee, or an incentive for early payment?

The best test is to recalculate last month’s charges with the new settings and compare them with the figures in your spreadsheet. If both match for every unit, the setup is right. For details of each method, see how to calculate building charges.

Payment and Expense History: How Much of the Past Should You Bring Over?

There is no need to re-enter every past year line by line. For most buildings, each unit’s confirmed balance on the start date is enough, and the old spreadsheet is kept as an archive. But if you are in the middle of a financial year and the board must present an income and expense report to the owners’ meeting at year end, it makes sense to migrate the current year’s income and expenses too, so the year-end report is complete.

Gather current contracts — cleaning, elevator servicing and the like — and the building’s important documents at this stage as well. They are rarely in the spreadsheet, but they belong in the new system.

Three Common Mistakes When Moving from Excel to a Building Management System

• Keeping two ledgers at once: if, after the start date, some payments are recorded in Excel and others in the new system, a few months later neither is correct. From day one, keep a single source of truth.
• Assigning a debt to the wrong resident: in rented units, make it clear whether an unpaid charge belongs to the current tenant, a previous tenant or the owner. That decision belongs to the board, not to whoever is typing in the data.
• Starting without telling residents: a resident who suddenly receives a text from an unfamiliar system will naturally be suspicious. A short notice before launch removes most of that worry.

Reconciling Balances with Residents Before Go-Live

Take this step seriously: residents’ trust in the new system is built right here. A simple, fair method:

1. Prepare a statement for each unit showing its confirmed balance on the start date.
2. Send it to residents with a short notice and a clear deadline for objections.
3. Review any receipt or evidence a resident provides and, if it holds up, correct the balance.
4. Once the deadline passes, finalise the balances and record them in the board’s minutes.

When residents see that their account is transparent and traceable, they accept online payment and system messages far more readily.

Data Migration in Hamkhoneh Building Management Software

With Hamkhoneh, P-Soft’s building management software and app, P-Soft’s team moves your building’s previous data from Excel or earlier software, and the scope of this service is agreed in the contract. In the Pro plan, phone support and entry of the building’s initial data are part of the plan’s services. Hamkhoneh is designed for buildings in Iran, and its interface is in Persian.

Everything you tidied up with this guide has its own place in Hamkhoneh: each unit’s details (floor area, floor, parking and number of occupants) are recorded under its block; owner, tenant and staff records are kept together with ownership and occupancy history; and for charges you can choose one of six methods — equal split, by floor area, by occupants, by parking, by floor, or a combination. Statements are print-ready and can be saved as PDF, and text-message announcements are included in every plan, so sending reconciliation statements to residents is straightforward. Residents sign in to the web portal with their mobile number and a one-time SMS code and see their own account. The Start plan covers a single building of up to 30 units, Pro up to 300 units, and Elite several buildings from one account.

Frequently Asked Questions

Can a building’s Excel file be imported directly into the software?

Yes, provided it is cleaned up first: consistent unit numbers, owners and occupants separated, and balances calculated as of one fixed date.

From which date should unit balances be calculated?

Pick a fixed date such as the end of a month; balances up to that day come from Excel, and everything after it is recorded only in the new system.

What if a resident disagrees with the migrated balance?

Review their receipt or evidence and correct the balance if it is valid; that is why it is best to announce an objection deadline before go-live.

Do we need to enter several years of history?

Usually not; each unit’s confirmed balance is enough. If you are mid-way through a financial year, migrate the current year’s income and expenses as well.

Who enters the data in Hamkhoneh?

P-Soft’s team transfers your previous data, with the scope set in the contract; in the Pro plan, entry of the building’s initial data is part of the support.

If your building’s spreadsheet is ready, explore Hamkhoneh building management software and request a demo so we can review the migration path together.

Further reading

• What Is Building Management Software and What Can It Do?
• How to Choose the Best Building Management Software: A Buyer’s Guide (2026)
• Best Way to Manage Building Service Charges for Residential Complexes

Complete guide: building management software