Home / Knowledge Base & Guides /Metro Accounting System User Guide

In Metro, you can reconcile bank statements against accounting entries, but Metro doesn’t directly read/reconcile from a PDF file. Instead, the workflow is like this:

1) Go to the Accounting Module. By Clicking on the 'Accounting' application.

2) Navigate to the Accounting > Bank Statements menu.

3) Click on the create button.

4) Fill in all the necessary details, including the journal, date, starting balance, ending balance, and transaction details, then click the 'Save' button.

Journal (DBS Bank):
Indicates which bank account (journal) this statement belongs to. In this case, it is linked to DBS Bank.

Date (18/09/2025):
The statement date, usually the date when the bank statement is issued or when it is entered.

Company (Metro Group Internal):
Shows the company that this bank statement is associated with.

Starting Balance (S$0.00):
Balance of the bank account at the beginning of this statement period. 

Ending Balance (S$0.00):
Balance of the bank account at the end of this statement period (after all listed transactions).

Manual Reconciliation (checkbox):
When checked, reconciliation will be handled manually instead of Odoo’s automatic reconciliation features.

Note: Ending Balance is amount set from the PDF.

Action

• Save:
  Saves the bank statement draft with the entered details.

• Discard:
  Cancels the current unsaved changes and resets the form.

• Post:
  Confirms (posts) the bank statement so that it can be reconciled with accounting entries.

5) Now, you need to click the 'Reconcile' button.

This screen shows the process of creating and posting a new bank statement in Metro. You enter the journal, company, balances, and once confirmed, click Post to move forward with reconciliation.

6) Now, view the Customer/Vendor Matching (Tab).

Used to reconcile the bank transaction against outstanding customer invoices or vendor bills.



In this view, you simply select the matching invoice or bill (PDF) that corresponds to the bank transaction. Metro will reconcile them automatically once validated.

Customer/Vendor Matching Tab = Match bank transactions to open invoices/bills for automatic reconciliation.

7) Now, view the Manual Operations (Tab).

Lets you reconcile a bank transaction manually when it cannot be automatically matched to invoices or vendors



This screen is for handling transactions that don’t directly tie to customer/vendor invoices, e.g., bank charges, adjustments, transfers.

Manual Operations Tab = Book unmatched entries manually to accounts.

8) Action



Save as Draft

• This button allows you to temporarily save the reconciliation without finalizing it.
• Useful if you want to review or adjust before confirming.
• The statement line remains in a draft state and is not yet posted to the accounting records.
  
  

Validate

• Clicking Validate finalizes the reconciliation.
• The transaction gets posted into the general ledger, and the bank statement line is marked as reconciled.

This ensures that the bank statement matches with accounting entries (e.g., invoices, payments).

9)  Finally, you will see the congratulatory screen.

To get more details on ​how do I reconcile a bank statement from a PDF in Metro Accounting System, please do contact us at  support@metrogroup.solutions