Bank reconciliation step by step for small businesses in Honduras
Balance the bank against the books without hunting line by line, and without reconciling what is not a match.
The steps
- Download the bank statement for the period, in Excel.
- Import it: each row needs a date, a description and an amount. Banks in Honduras do not all deliver the same format: some bring one amount column with a sign and others bring separate debit and credit columns. Both work.
- Match each statement line with its accounting line: same amount and a nearby date.
- Record what is in the bank and not in your books: fees, security charges, interest, debit and credit notes.
- Explain what is in your books and not in the bank: checks issued but not yet cashed and deposits in transit.
- Check that the reconciled balance matches the bank balance, and save the month’s reconciliation.
How to match without getting it wrong
A sensible automatic match only suggests when there is a single possible partner: the same amount and a date within a few days. If there are two candidates for the same line, it does not guess: it leaves it for a person to resolve. Guessing wrong and reconciling what is not a match is worse than suggesting nothing.
Each statement line must match exactly one accounting line. If a bank charge corresponds to several parts, the bank is recorded for the total and the other side is split among the accounts that apply.
What is in the bank and not in your books
Every month the statement brings the same charges: the maintenance fee, the security charge, the payment to the same supplier. Recording them one by one before you can reconcile is repeated work.
- One entry per line, with its own date: a fee from August 5 stays dated August 5, not today.
- One consolidated entry that groups several lines under the date you choose, still carrying one bank line per statement line so each reconciles exactly.
Better still if the system learns from your reconciliations: each time you reconcile a line against an account, that choice is remembered and proposed next time. But a rule proposes, it never posts on its own: a person confirms.
What is in your books and not in the bank
- Checks issued and delivered that the payee has not yet cashed.
- Deposits made at the end of the month that the bank credits the next month.
- Transfers recorded in your books before the bank processes them.
These items are not errors. They are timing differences that are explained and carried to the next month, where they should show up in the bank.
Common mistakes
- Reconciling only the ending balance and not the transactions.
- Using the bank account on the other side of the entry (it balances but says nothing).
- Leaving items in transit from months ago without investigating.
- Recording a fee without reconciling it, and then counting it twice.
- Closing the month without reconciling.
How PymesPros helps
PymesPros imports the Excel statement (with a signed amount or with debit and credit columns), suggests matches only when there is a single partner, builds the entries for fees and small charges per line or consolidated, learns the accounts you use and leaves the final decision in your hands. A reconciled month feeds the accounting close.
This guide is informational and does not replace the advice of a licensed public accountant. Rates, ceilings and dates are adjusted by the authorities from time to time: confirm them at the official source before applying them.
Frequently asked questions
How often should I reconcile?
Every month at the very least, before closing. If volume is high, every week avoids accumulating differences.
What do I do with a check that is never cashed?
You investigate with the payee. If it is voided, it is voided in the books with its justification; it is not deleted.
Why does the bank show a charge I do not recognize?
Investigate it with the bank before recording it. Recording a charge you do not understand only hides the problem.
Can I reconcile if the statement has a summary at the end?
Yes. Some banks add a summary after the transactions table; the importer ignores everything from the first row without a date.
Keep reading
Monthly accounting close for small businesses
A checklist to close the month without surprises and deliver financial statements on time.
Read the guide →Cash flow and collections for small businesses: how to forecast and reduce late payments
Know today what balance you will have in a few weeks, and collect on time without relying on someone remembering.
Read the guide →How to choose accounting software in Honduras
Ten questions to compare any system, ours included, before you pay.
Read the guide →Accounting and bookkeeping
Books that are up to date, reconciled and ready for your bank, the tax authority or your shareholders, without building an accounting department.
See accounting →Want to see it working in your company?
Request a free 14-day demo, with sample data and no card. Leave your details and we will contact you to activate it, or write to us directly.
contacto@pymespros.com · Business hours, Honduras time (UTC−6)