Match the bank, close the month
Bank reconciliation is the bridge between the bank statement and the accounting records. Month-end is the routine that confirms the books are complete. Together they turn daily transactions into trustworthy financial reports.
This module is practical. You will import or enter a bank statement, match transactions to invoices and bills, and work through a month-end checklist. The goal is a repeatable routine, not a one-time cleanup.
Reconcile often: a weekly bank reconciliation is easier than a monthly scramble. The longer you wait, the more transactions you have to match and the harder it is to remember what each one was.
Learning objectives
By the end of this module, you should be able to:
- Import or enter a bank statement in Odoo.
- Reconcile bank transactions against customer invoices and vendor bills.
- Explain what to do with bank fees, interest, and unmatched transactions.
- Run aged receivables and aged payables reports.
- Complete a basic month-end checklist.
Core concepts
Bank journals and statements
Odoo represents each bank account as a bank journal. A bank statement is the list of transactions from the bank for a period. You can import a statement file or enter transactions manually. The statement is the bank's version of the truth; the reconciliation matches it to Odoo's version.
Reconciliation
Reconciliation matches a bank transaction to an existing accounting entry, such as a customer payment or a vendor payment. When the match is confirmed, the bank balance and the accounting balance agree for that transaction. Unmatched transactions remain visible until they are resolved.
| Transaction type | Typical match | What to do |
|---|---|---|
| Customer payment received | Customer invoice or payment record | Match the amount and the customer. Confirm the reconciliation. |
| Vendor payment sent | Vendor bill or payment record | Match the amount and the vendor. Confirm the reconciliation. |
| Bank fee or interest | No existing document | Create a bank fee or interest entry and reconcile it. |
| Unknown transaction | No match | Investigate before posting. Do not guess. |
Aged receivables and aged payables
The aged receivables report shows what customers owe, grouped by how long it has been outstanding. The aged payables report shows what the company owes vendors. These reports are the bookkeeper's follow-up list and the owners' cash-flow view.
Month-end checklist
A month-end checklist is a short, repeatable list of tasks. It does not need to be long. It needs to be completed and reviewed every period.
- Reconcile all bank and cash accounts.
- Confirm that all customer invoices and vendor bills for the period are posted.
- Review unposted journal entries and draft documents.
- Review aged receivables and follow up on overdue customers.
- Review aged payables and schedule vendor payments.
- Review the tax report and the tax liability.
- Run the profit and loss and the balance sheet.
- Review the inventory valuation and any stock adjustments.
- Lock the period if the company uses period locking.
Do not guess on an unmatched bank line. An unknown transaction may be a duplicate payment, a bank error, or a missing entry. Investigate before you post it. A wrong reconciliation is harder to find later.
Walkthrough
Follow along in the sandbox. Use the practice bank journal and the practice invoices and bills from Module 14.
-
Open the bank journal
Open the Accounting app and go to the bank section on the dashboard. Open the bank journal. Review the current balance and the transactions. This is where the bank statement will appear.
-
Import or enter a bank statement
Use the import statement action if a sample file is available, or create a manual statement line. Enter the date, the description, and the amount. If you are importing, review the column mapping before you confirm the import.
-
Match a customer payment
Find a bank line that corresponds to a customer payment. Odoo may suggest a match. Select the customer invoice or the payment record. Confirm the reconciliation. The bank line and the invoice should now be linked.
-
Match a vendor payment
Find a bank line that corresponds to a vendor payment. Match it to the vendor bill or the payment record. Confirm the reconciliation. The bill should be marked as paid if the amount matches.
-
Handle a bank fee
Find or create a bank fee line. There is no existing invoice or bill for a bank fee. Create a bank fee entry and reconcile it. This records the expense in the correct account.
-
Review the reconciliation
Confirm that the bank journal shows no unexpected unmatched lines for the period. Open the reconciled transactions and verify the links. The bank balance and the accounting balance should agree for the reconciled items.
-
Run the aged reports
Go to Reporting > Aged Receivable and Aged Payable. Review the open items and the aging buckets. Note any customer or vendor that needs follow-up. These reports are part of the month-end review.
-
Complete the month-end checklist
Work through the checklist in the concepts section. Mark each item as complete or note why it is not. The goal is a clean, documented close, not a perfect score on the first attempt.
Exercise
Reconcile and close
Complete these steps on your own in the sandbox.
- Open the bank journal and review the current transactions.
- Import or create a bank statement with at least one customer payment and one vendor payment.
- Reconcile the customer payment against the matching invoice.
- Reconcile the vendor payment against the matching bill.
- Create and reconcile one bank fee.
- Confirm that there are no unexplained unmatched lines for the period.
- Run the aged receivables and aged payables reports and note one follow-up item.
- Complete the month-end checklist and record any open item.
Expected result: the bank lines are reconciled, the related invoices and bills show the correct status, and the aged reports reflect the open balances. The month-end checklist is complete or has documented exceptions.
Check your understanding
Answer these questions before moving to the next module. Open each answer to check yourself.
1. What is bank reconciliation?
It is the process of matching bank statement transactions to existing accounting entries, such as customer payments and vendor payments, so the bank balance and the accounting records agree.
2. What should you do with an unknown bank transaction?
Investigate before posting. It may be a duplicate payment, a bank error, or a missing entry. Do not guess. Ask the bookkeeper or the bank if needed.
3. How do you handle a bank fee?
A bank fee has no existing invoice or bill. Create a bank fee entry in the correct expense account and reconcile it against the bank line.
4. What do the aged receivables and aged payables reports show?
Aged receivables show what customers owe, grouped by how long it has been outstanding. Aged payables show what the company owes vendors. Both are used for follow-up and cash-flow planning.
5. Why is a month-end checklist useful?
It makes the close repeatable and complete. It ensures the bank is reconciled, the documents are posted, the reports are reviewed, and the period is closed consistently.
Facilitator notes
Suggested timing: 15 minutes concepts, 30 minutes guided walkthrough, 35 minutes exercise, 10 minutes questions and close. The bookkeeper should lead the reconciliation and explain the company's real month-end routine.
- Before the session, prepare a sample bank statement file or a set of manual statement lines. Test the import mapping.
- Confirm that the practice invoices and bills from Module 14 are posted so there is something to reconcile.
- Include at least one bank fee and one unknown line so learners practice the exception path.
- Have the bookkeeper explain the company's real month-end checklist and who reviews it. This is the most valuable part of the module.
- Do not let learners post unknown transactions without investigation. Emphasize the audit trail.
Next steps
You can now reconcile the bank and close the month. The next module covers the financial reports and tax reports that the owners and the bookkeeper will use to review the business.