Before you move anything
- Name one person in charge. Not a committee. Someone who decides what goes where and answers questions for the first two months.
- Pick a cut-over date. The first day of a month, right after a month you have fully reconciled against the bank. Never the middle of a period.
- Get the committee’s agreement in writing. The opening balances you are about to load will become the new truth. The people who oversee the accounts should sign off on them.
- Tell owners early. One notice, in every language your owners read, saying what changes, when, and what stays the same: the bank account they pay into.
Take inventory of what you have
List where each piece of information lives today and who holds it. It is usually more places than anyone expected.
| Information | Where it usually hides |
|---|---|
| Units, with each one’s ownership share (indiviso) | The constitutive deed |
| Owners and tenants, with an email address and preferred language | The administrator’s phone, the chat, old emails |
| Each unit’s balance on the cut-over date | The collections spreadsheet |
| Current dues and any special assessment in progress | Assembly minutes |
| This year’s budget and expenses so far, with receipts | A spreadsheet, a folder, a shoebox |
| Balances of the operating and reserve funds | Bank statements |
| Each unit’s payment reference | Often nowhere: this is the moment to create them |
| Deed, bylaws and minutes | Paper, or one person’s laptop |
| Amenity rules and open maintenance issues | The chat |
Clean before you load
A new system does not fix bad data. It displays it more clearly, to more people.
- One row per unit, one name per unit. “B-204”, “B204” and “Depto 204 torre B” are the same unit and must become one.
- Close the last month properly. Reconcile it against the bank and resolve every unidentified deposit you can. The guide on reconciling dues against the bank has the method.
- Agree on the disputed balances. If an owner and the spreadsheet disagree, settle it now or load the balance with a note. Do not carry a silent disagreement into the new system.
- Check the shares add up. The indiviso of all units should total 100%. If it does not, go back to the deed.
- Ask before you load contact details. Tell residents what you will record and why, and keep only what the building needs.
Load it in this order
- Units and shares. Everything else hangs from them.
- People and roles. Who is an owner, who is a tenant, who is on the committee, who works at the front desk, and what each may see.
- Opening balances. One figure per unit, as of the cut-over date, signed off by the committee.
- Dues and assessments. The amounts the assembly approved and the day they fall due.
- Budget and funds. The year’s budget by category and the balance of each fund.
- Documents. Deed, bylaws and the last two years of minutes.
- Daily life. Amenities with their rules, and the maintenance issues that are still open.
History is optional. Loading three years of expenses is useful for comparing budgets; loading three years of chat is not.
Run one month in parallel
For the first month, keep the old spreadsheet going next to the new system and compare three totals at month-end: what was charged, what was paid, and the balance per unit. If they match, archive the spreadsheet as read-only and say so. If they do not, find the difference before the second month starts. Two sources of truth for longer than a month means you have none.
Retire the chat gently
- Announce where official notices live from now on, and post the first few in both places with a line saying which one counts.
- Keep the chat for neighbors. Stop using it for anything that needs a record: payments, bookings, complaints.
- When someone reports a leak in the chat, answer with where to report it. After two weeks most people follow.
Bring people in, in waves
- The committee and the administration, a week early, so they find the mistakes first.
- Staff: front desk and maintenance, with only what they need.
- Owners who live in the building.
- Owners abroad and tenants, with instructions in their language. They are the ones who gain most, and the ones nobody can walk through it in person.
Common mistakes
- Cutting over in the middle of a month.
- Loading balances nobody has checked.
- Changing the bank account or the due date at the same time as the system.
- Inviting every owner on day one, before the numbers have been compared once.
- Keeping the spreadsheet “just in case” and updating it for a year.
How this goes in Atriovia
In Atriovia you set the dues for the period and it splits them across the units by indiviso or equally. Each unit has its own payment reference, and you upload the bank’s CSV file to match deposits to units. Past expenses can be imported from a file so you do not start from a blank page. Deed, bylaws and minutes go into the building’s documents, with a courtesy translation next to them if you have one. The administration adds each person with their email address and a role, and each person reads in Spanish or English.
Owners keep paying the way they do now, by transfer or deposit to the building’s account: Atriovia records and reconciles those payments, it does not move money. Atriovia is in early access. Write to hola@atriovia.com and we will walk through this checklist with sample data. The features are described in dues and bank reconciliation and expenses and budget.