Phase 5 · Module M15

Accounting: Bank Reconciliation & Month-End

Odoo 20.0 Training Program · Sage Business Vision migration

90 minutes Bookkeeper Owners (read-only) Prerequisites: M14

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.
Audience: bookkeeper, owners read-only Format: demo + hands-on Sandbox: required

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.

  1. Reconcile all bank and cash accounts.
  2. Confirm that all customer invoices and vendor bills for the period are posted.
  3. Review unposted journal entries and draft documents.
  4. Review aged receivables and follow up on overdue customers.
  5. Review aged payables and schedule vendor payments.
  6. Review the tax report and the tax liability.
  7. Run the profit and loss and the balance sheet.
  8. Review the inventory valuation and any stock adjustments.
  9. 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.

  1. 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.

  2. 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.

  3. 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.

  4. 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.

  5. 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.

  6. 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.

  7. 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.

  8. 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.