Bank reconciliation in Mexico: definition, steps and AI

What bank reconciliation means for a business in Mexico

To reconcile is to set two sources side by side and check that they tell the same story. On one side is the bank and its statement, the estado de cuenta: every credit, every debit and the closing balance for the period. On the other side are your records: the general ledger, the bank sub-ledger or, in many businesses, a Google Sheets or Excel file where you note who has paid.

The output is not just "it balances" or "it doesn't". It is a list of explained items: this deposit is the March fee for apartment 302, that one is a double payment that leaves a credit balance, this debit is a bank fee you have not booked yet. Whatever you cannot explain stays open as a reconciling item until it is resolved.

Money in Mexico moves in ways that make the job heavier than in many countries. Most collections arrive by SPEI transfer, the real-time interbank payment system run by Banxico, the central bank, and every bank prints the reference, the free-text description and the payer's name differently. The same customer may pay from their company account one month and from a relative's the next. The Mexican banking guides explain SPEI, CLABE account numbers and the other terms in detail.

Two reconciliations that answer different questions

People use "bank reconciliation" for two different jobs. Separating them clarifies what you actually need to solve.

	Ledger reconciliation	Collections reconciliation
Question it answers	Does the bank balance agree with my books?	Who paid me, which period does it cover and what is still owed?
Unit of work	Transactions and balances	Deposits against what customers owe
Who does it	Accountant or finance team	Administration, accounts receivable or treasury
Source of truth	Journal entries and bank sub-ledger	Collections sheet, receivables or open invoices
What it produces	A reconciliation schedule with reconciling items	Applied payments, updated balances and payments to review

A ledger reconciliation can balance perfectly even when you do not know who made half the deposits; all it needs is the total in the books. Collections reconciliation is stricter, because every peso has to land on a customer's account. Meses focuses on this second question and makes the first one easier, since the accountant receives collections that are already identified.

The four kinds of item that explain a difference

When the bank and your records disagree, the cause is almost always one of these:

1. Deposits the bank has recorded and you have not. Transfers that arrived without notice, or payments you have not identified yet. These unidentified deposits are the most common item in collections.
2. Entries you recorded that the bank has not. Deposits in transit on the last day, or cheques a supplier has not cashed.
3. Bank charges you did not book. Fees, VAT on fees, interest or direct debits.
4. Data-entry errors. An amount with transposed digits, a payment applied to the wrong customer or a deposit entered twice.

The first three are differences of timing or information; the fourth is a mistake to correct. A good reconciliation tells them apart instead of "adjusting" the difference until the balance agrees.

How to reconcile a bank account from start to finish

The method is the same in Excel, in an ERP or with AI. What changes is how much manual work each step leaves.

1. Gather sources for the same period. The bank's original statement PDF and your records for the month. Check that the cut-off dates match.
2. Check the opening balances. The bank's opening balance should equal the closing balance you reconciled last month. If not, the problem started earlier.
3. Match credits to what you expected to collect. First the obvious ones, by reference and exact amount. Then those that match only on amount or name.
4. Investigate what does not match. Read full references, payer names, the SPEI tracking key and the customer's history.
5. Book charges and fees that appear at the bank but not in your books.
6. Document open items with their reason and the pending action.
7. Close with totals that agree. The count and sum of reconciled deposits plus open items must equal exactly what the bank prints.

The help article on how to reconcile a month shows these steps inside Meses.

Why matching credits takes most of the time

Matching is where the day goes. A reference that says "PAGO MARZO" (March payment) does not say who sent it. Two families pay the same 4,500-peso tuition. A tenant pays two months at once. A customer deposits 10,000 pesos against three invoices of different amounts. None of these is solved by a lookup formula: each needs reading, comparing with earlier months and a decision.

That is why collections reconciliation scales badly. With 30 payments a month it takes an afternoon; with 300, it becomes someone's job.

How Meses reconciles a full month

Meses reads your bank statement PDF and your records in Google Sheets, Excel or CSV; AI proposes which customer and period each deposit belongs to, your team reviews the proposals, and Meses writes approved payments back to your sheet, with undo.

Inside Meses the flow looks like this:

• Reading the bank. Meses reads the transactions from the PDF itself; the bank statement file is never sent to an AI provider. Before going further, it checks that what it read agrees with the totals the statement prints.
• Reading your records. Meses finds your customers and what each one owes for the month in your sheet, without you changing your format or renaming tabs.
• Proposals with evidence. For each deposit, AI proposes customer, period and amount, and explains why in plain language, with the sheet, row and cell each fact comes from.
• Three clear statuses. Each deposit ends up matched, suggested or needs review. Nothing doubtful is forced into a match.
• Your team's review. You confirm, correct or assign by hand. Every decision is recorded with its history.
• Verified write-back. Meses writes to Google Sheets only the changes your team reviews and approves, and confirms each one was written correctly.

The whole process takes in minutes, not days. What your team reviews is the exceptions, not the hundreds of payments that match clearly. A good habit is to clear the suggested payments first, because they only need a yes or a correction, and leave the review items for when you can call a customer or ask for a receipt.

What the AI sees during reconciliation

Meses processes your statements securely: the PDF is not sent to an AI provider, and personal data is protected before any AI analysis. The names of your customers and payers are protected before any AI analysis; your results and your sheet always show the real names. The security page explains what Meses protects and what stays in your control.

How the traps differ by type of business

The method stays the same, but the traps change with how you collect:

Business	What complicates reconciliation
Private schools	Siblings in a single transfer, scholarships and early-payment discounts
Condominiums	Tenants paying on the owner's behalf, special assessments, advance payments
B2B distributors	One deposit against several invoices, partial payments and credit notes
Property managers	Rent from many tenants and security deposits
Gyms	Many small, identical amounts

For a team abroad, one more trap matters: the documents are in Spanish and follow Mexican conventions. A credit is an abono, a debit is a cargo, the payer is the ordenante and the free-text description is the concepto. Invoices are CFDI, the electronic invoices issued through the SAT, and a customer who pays an invoice issued as PPD (paid later or in instalments) also needs a payment receipt called a complemento de pago. None of this changes the reconciliation method, but it changes what each column means. If your shared-service centre reconciles a Mexican entity, agree on a glossary first, then on the matching rules.

When automation pays off and when it does not

Automating makes sense when matching takes you more than a few hours a month, when several people edit the sheet, or when unidentified deposits carry over from one month to the next. If you receive a dozen payments with perfect references, a well-built spreadsheet is enough.

Before changing tools, measure your starting point: how many deposits you receive a month, how many remain unidentified at close and how many hours your team spends matching. With those three numbers you can compare any option on your own data rather than on promises. If you decide to try Meses, onboarding starts by reviewing your real statement and sheet to confirm they can be read before you reconcile your first month. Pricing is shared during onboarding. And if you decide to keep doing it by hand, the method on this page still holds: only the time it costs you changes.