Before you start
Gather four things for the same period. If one is missing, the reconciliation will have holes.
- The activity of the building’s account, downloaded from online banking as a data file (CSV or a spreadsheet), not as a PDF.
- The list of charges for the period: the dues each unit owed.
- The payments you already recorded by hand, for example those received in cash.
- Each unit’s payment reference.
Step 1. Give every unit a reference
Most of the work in reconciling is guessing whose deposit it is. You avoid that beforehand: give each unit a unique reference and ask owners to enter it on every transfer. Transfers through SPEI, Mexico’s interbank system, let the payer enter a numeric reference (referencia numérica) that travels with the payment.
Use references that cannot be mistaken for one another. If unit 1 and unit 12 have references that start the same way, sooner or later a payment will land on the wrong unit.
Step 2. Download the whole period
Download the activity from the first to the last day of the month, complete, and keep the original file untouched. Work on a copy. Check that the file’s opening balance equals last month’s closing balance: if it does not, you are a day short or a day over.
Step 3. Set aside what is not dues
Not everything that enters the account is a dues payment. Set these aside first:
- Interest the bank pays and fees it charges.
- Transfers between the building’s own accounts, for example into the reserve fund.
- Vendor refunds and reimbursements.
- Other income, such as rent for a common area.
What remains are the deposits that have to be assigned to a unit.
Step 4. Match by reference and by amount
Start with what is certain and move toward what is doubtful.
- Exact reference and amount. The reference belongs to one unit and the amount is what that unit owed. Record it.
- Right reference, different amount. It is a partial payment, a payment for several months or a payment with interest. Record what arrived, not what you expected.
- No reference, unique amount. If only one unit owed exactly that sum, it is a clue, not proof. Confirm with the owner before recording it.
- No reference, repeated amount. Several units pay the same. Without a receipt there is no way to know: go to step 5.
| Deposit | Reference | What to do |
|---|---|---|
| 8,600.00 | 0204 | Matches unit B-204 and its dues. Record it. |
| 17,200.00 | 0311 | Unit C-311, two months. Record it in full and apply it to both periods. |
| 7,950.00 | No reference | Only A-102 owed that amount. Confirm with the owner. |
| 8,600.00 | No reference | Six units pay those dues. Leave it as unidentified. |
Step 5. Resolve the unidentified deposits
Keep a list of unidentified deposits with the date, the amount and whatever the description says. Ask owners who do not see their payment reflected to send their transfer receipt, and match on date, amount and tracking key (clave de rastreo). Never assign a deposit by elimination: a wrongly assigned payment creates two problems, the owner who paid and shows as owing, and the one who did not pay and shows as current.
Step 6. Close and leave a record
Before calling the month closed, run three checks:
- Bank opening balance, plus deposits, minus withdrawals, equals the bank closing balance.
- Total dues deposits equals total payments recorded plus unidentified deposits.
- Every payment recorded by hand as a transfer has its deposit at the bank.
Keep the bank file together with the reconciliation and note who did it and when. Report the unidentified deposits on the building’s statement: hiding them is the fastest way to lose owners’ trust.
The order in which a payment is applied
When an owner owes several things and pays part, it matters what is paid off first. Check your bylaws and your state’s law. In Quintana Roo, for example, the law provides that payments are applied in chronological order, first to fines, interest, penalties and legal fees, and then to regular dues, special assessments and the reserve fund.
Common mistakes
- Reconciling against the bank’s PDF and typing figures by hand. Every keystroke is a chance for error.
- Recording the payment on the day the owner says they paid rather than the day it reaches the bank.
- Merging two deposits from the same unit into one entry, or splitting one into two.
- Leaving unidentified deposits out of the report.
- Reconciling every three months. The longer you wait, the fewer people remember what they paid.
How Atriovia does it
Atriovia follows this same method. Each unit has its reference, you upload your bank’s CSV file, the app suggests which unit each deposit belongs to and you confirm: exact matches together and doubtful ones one at a time. Nothing is recorded as a payment without your confirmation. The details are in dues and bank reconciliation.
Sources
- Ley de Propiedad en Condominio de Inmuebles del Estado de Quintana Roo, text with the latest reform published on November 12, 2021 (Quintana Roo State Congress, PDF in Spanish). Article 43, on the order in which payments are applied.
- Banco de México, SPEI information module (MI SPEI, in Spanish). On the numeric reference in SPEI transfers.
This page is general information, not legal advice. In Mexico, condominiums are governed by the law of each state and by each building’s constitutive deed and bylaws, so the rules change from place to place. For a specific case, ask a lawyer or a notary in your state.