---
title: Reconcile a Bank Account - Connected Banks
description: Learn how to reconcile a bank account by comparing your ledger balance against the bank statement.
---

[Skip to content](https://help.joinpropio.com/en/reconcile-a-bank-account#main-content)

- [English](https://help.joinpropio.com/en/reconcile-a-bank-account)
- [Español - Estados Unidos](https://help.joinpropio.com/es-us/conciliar-una-cuenta-bancaria)

English

Show submenu for translations

[![teal-logo-2](https://help.joinpropio.com/hs-fs/hubfs/teal-logo-2.jpg?width=169&height=55&name=teal-logo-2.jpg)](https://help.joinpropio.com/?hsLang=en)

Open main navigation

Close main navigation

- - [English](https://help.joinpropio.com/en/reconcile-a-bank-account)
    - [Español - Estados Unidos](https://help.joinpropio.com/es-us/conciliar-una-cuenta-bancaria)

  English
  
  Show submenu for translations

 This is a search field with an auto-suggest feature attached.

- There are no suggestions because the search field is empty.

1. [Propio Knowledge Base](https://help.joinpropio.com/en?hsLang=en)
2. [Banking & Reconciliation](https://help.joinpropio.com/en/banking-reconciliation?hsLang=en)

# Reconcile a Bank Account - Connected Banks

Bank reconciliation confirms that your client's books in Propio match the actual bank records. For clients with connected bank accounts, Propio pulls transactions automatically and calculates the balance for each month — so you're not comparing line by line, you're reviewing and resolving what doesn't match.

#### **The Reconciliation Matrix**

Click **Reconciliation** in the left sidebar to open the matrix view. Each row is a connected account (checking, debit, savings, credit card, etc.) and each column is a calendar month. A **Progress** bar on the right shows how far along each account is.

A banner at the top always shows the next unreconciled month and account — click **Reconcile →** to jump straight to it.

 

![](https://help.joinpropio.com/hs-fs/hubfs/image-png-Apr-29-2026-02-52-05-2221-PM.png?width=670&height=289&name=image-png-Apr-29-2026-02-52-05-2221-PM.png)

Each cell in the matrix has a status, shown as a color-coded icon:

| Icon | Status | Meaning |
| --- | --- | --- |
| Green checkmark | **Reconciled** | Period finalized |
| Pulsing blue dot | **Next to Reconcile** | Your next recommended step |
| Amber dot | **Needs Re-Review** | A previously reconciled period has changed |
| Empty circle | **Pending** | Not yet reconciled |
| Purple lock | **Locked** | Period protected by a migration lock |

Reconciled cells may also show a small **lock badge** — this means the period was auto-locked when you finalized it, protecting it from accidental edits.

You can filter accounts by status using the **All / Pending / Stale / Done** tabs, or search by account name.

#### **Steps**

1. Click **Reconciliation** in the left sidebar.
2. Hover over any month cell to see its details: 
     - **Reconciled** months show the beginning balance, credits, debits, ending balance, the date it was reconciled, and the lock period. Click **Review** to re-examine the period.
     - **Next to Reconcile / Pending** months with no discrepancy show a "Ready to Reconcile" message and a **$0.00 discrepancy**. Click **Finalize Reconciliation** to lock it without opening the review, or **Review** to inspect the transactions first.
     - **Next to Reconcile / Pending** months with a discrepancy show the dollar amount of the gap and a **Start Review** button.
3. Click **Start Review** (discrepancy) or **Review** (to inspect) to open the account's reconciliation detail page for that month.
4. On the detail page, the **Needs Review** tab shows all transactions that require attention. Review and post each one — the reconciliation summary updates in real time, showing the current difference between your ledger balance and the bank balance.
5. Once the difference reaches **$0.00**, click **Finalize Reconciliation**. Propio records the reconciliation date and automatically locks that period, preventing further edits to transactions dated on or before it.

🔒 **Period lock system:** If you try to modify a transaction that belongs to a finalized period, Propio will warn you before allowing the change. Administrators can unlock a period when needed — doing so returns the period to "Needs Re-Review" status and it will need to be reconciled again.

**Tip:** Reconcile monthly rather than at year-end. Catching a discrepancy in the same month it occurs takes minutes to resolve — catching it six months later can take hours.

#### **Two Ways to Reconcile**

Inside the detail page for each month, Propio offers two approaches:

**Auto mode (default)**  
Propio calculates balances from the bank's imported transactions and compares them against your ledger. If everything matches, you can finalize the reconciliation in one click — no manual data entry required. This is the fast path for most months.

**Statement Mode**  
For a more detailed review — such as when you want to audit a period or verify transactions one by one — click **Statement Mode**. This view presents the information visually so you can go through each transaction individually and compare it against the bank statement.

From either mode, you can click **Analyze** to open the AI assistant. The assistant reviews the full reconciliation and can help you identify inconsistencies, missing transactions, duplicates, or any other issue causing a discrepancy — without having to manually scan every line.

#### **Matrix vs. List View**

Use the **Matrix / List** toggle in the top-right corner to switch views. The Matrix view shows all accounts and months on a grid — best for spotting gaps across multiple accounts at once. The List view shows each account as a card — better for focusing on one account at a time.

#### **Common Issues**

- **Discrepancy won't reach zero?** Check for duplicate transactions, missing entries, or transfers that weren't properly matched. You can also click **Analyze** to let the AI assistant identify the source of the difference. Use Drill Down from Reports to Transactions to investigate specific balances.
- **Transactions missing from Needs Review?** Confirm the bank account is still connected and syncing correctly.
- **Month shows "Needs Re-Review" (amber)?** A previously reconciled period was changed after it was finalized. See [*How Propio Determines When a Reconciled Period Becomes Stale*](https://help.joinpropio.com/en/how-propio-determines-when-a-reconciled-period-becomes-stale?hsLang=en) for what triggers this and how to resolve it.

#### **Related Articles**

- [How Propio Determines When a Reconciled Period Becomes Stale](https://help.joinpropio.com/en/how-propio-determines-when-a-reconciled-period-becomes-stale?hsLang=en)
- [Reconcile a Bank Account — Bank Statements](https://help.joinpropio.com/en/reconcile-a-bank-account-bank-statements?hsLang=en)
- [Record Transfers Between Accounts](https://help.joinpropio.com/en/record-transfers-between-accounts?hsLang=en)
- [Drill Down from Reports to Transactions](https://help.joinpropio.com/en/drill-down-from-reports-to-transactions?hsLang=en)

- [Getting started](https://help.joinpropio.com/en/getting-started?hsLang=en)
- [Transactions](https://help.joinpropio.com/en/transactions?hsLang=en#main-content)

    - [Manual Entry](https://help.joinpropio.com/en/transactions?hsLang=en#manual-entry)
    - [Import](https://help.joinpropio.com/en/transactions?hsLang=en#import)
    - [Categorization](https://help.joinpropio.com/en/transactions?hsLang=en#categorization)
    - [Journal Entries](https://help.joinpropio.com/en/transactions?hsLang=en#journal-entries)
    - [Tags](https://help.joinpropio.com/en/transactions?hsLang=en#tags)
    - [Advanced](https://help.joinpropio.com/en/transactions?hsLang=en#advanced)
- [Banking & Reconciliation](https://help.joinpropio.com/en/banking-reconciliation?hsLang=en)
- [Reports](https://help.joinpropio.com/en/reports?hsLang=en#main-content)

    - [Profit and Loss](https://help.joinpropio.com/en/reports?hsLang=en#profit-and-loss)
    - [Balance Sheet](https://help.joinpropio.com/en/reports?hsLang=en#balance-sheet)
    - [Tax Reports](https://help.joinpropio.com/en/reports?hsLang=en#tax-reports)
    - [AI Reports](https://help.joinpropio.com/en/reports?hsLang=en#ai-reports)
    - [Trial Balance](https://help.joinpropio.com/en/reports?hsLang=en#trial-balance)
    - [Advanced](https://help.joinpropio.com/en/reports?hsLang=en#advanced)
- [Migration & Chart of Accounts](https://help.joinpropio.com/en/migration-chart-of-accounts?hsLang=en)
- [AI Categorization](https://help.joinpropio.com/en/ai-categorization?hsLang=en)
- [Contacts](https://help.joinpropio.com/en/contacts?hsLang=en)
- [AI Assistant](https://help.joinpropio.com/en/ai-assistant?hsLang=en)
- [Organization Management](https://help.joinpropio.com/en/organization-management?hsLang=en)
- [Communications](https://help.joinpropio.com/en/communications?hsLang=en)
- [Bank Integration](https://help.joinpropio.com/en/bank-integration?hsLang=en)
- [Industry Guides](https://help.joinpropio.com/en/industry-guides?hsLang=en#main-content)

    - [Real Estate](https://help.joinpropio.com/en/industry-guides?hsLang=en#real-estate)

[![Propio-logo-teal-2](https://help.joinpropio.com/hs-fs/hubfs/Propio-logo-teal-2.png?width=112&height=35&name=Propio-logo-teal-2.png "Propio-logo-teal-2")](https://help.joinpropio.com/?hsLang=en)