Atriovia
ESEN
Request a demo

Guide for administrators and treasurers

How to reconcile dues against the bank statement.

Reconciling means checking two things: that every deposit that reached the bank is recorded as a payment from a unit, and that every recorded payment exists at the bank. With a method, month-end stops being a lost afternoon.

Updated November 17, 2026

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.

  1. Exact reference and amount. The reference belongs to one unit and the amount is what that unit owed. Record it.
  2. 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.
  3. 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.
  4. No reference, repeated amount. Several units pay the same. Without a receipt there is no way to know: go to step 5.
Example: four deposits on the same day.
DepositReferenceWhat to do
8,600.000204Matches unit B-204 and its dues. Record it.
17,200.000311Unit C-311, two months. Record it in full and apply it to both periods.
7,950.00No referenceOnly A-102 owed that amount. Confirm with the owner.
8,600.00No referenceSix 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:

  1. Bank opening balance, plus deposits, minus withdrawals, equals the bank closing balance.
  2. Total dues deposits equals total payments recorded plus unidentified deposits.
  3. 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

Shall we look at it with your building?

Atriovia is in early access. Write to us and we will show you the product with sample data, in English or Spanish.

Or write to us directly at hola@atriovia.com