---
title: "Reconcile a Bank Account in Sage Intacct"
sidebarTitle: "Intacct bank rec"
description: "The full Sage Intacct bank reconciliation procedure — starting the rec, importing an auto-match file, reading the reconciliation screen, entering transactions, and finalizing."
icon: "building-columns"
---

> **For AI agents:** the complete documentation index is at [llms.txt](/llms.txt). Append `.md` to any page URL for its markdown version.

| Field | Value |
|---|---|
| **Owner** | Unassigned — needs an owner |
| **Department** | General Accounting |
| **Effective date** | Not set in source |
| **Scope** | Performing a bank reconciliation in Sage Intacct, including the auto-match import and entering each type of missing transaction. Assumes familiarity with [bank reconciliation concepts](/internal/sops/accounting/general/bank-reconciliation-concepts). Does not cover rule-based automation — see [bank transaction automation](/internal/sops/accounting/general/bank-automation-setup). |
| **Source** | `General Accounting/02 - Bank Reconciliation/Intacct Bank Reconcilliation.docx` |

<Warning>
  **All bank reconciliations must be completed at the top level**, not the entity level.
</Warning>

## Start the reconciliation

<Steps>
  <Step title="Open the reconciliation screen">
    From the **top level**, go to **Cash Management → All → Bank**.

    <Frame caption="Cash Management → All → Bank">
      <img src="/images/accounting/intacct-bank-reconcilliation/image1.png" alt="Sage Intacct Cash Management bank menu" />
    </Frame>
  </Step>

  <Step title="Enter the period details">
    Choose the bank account, enter the period or month end date, and enter the period or month end bank balance.

    Attach supporting documentation:

    | Client type | Attach |
    |---|---|
    | **Month-end clients** | The bank statement |
    | **Period-end clients** | The bank activity for the period |
  </Step>
</Steps>

## Import a file for auto-match

Intacct can auto-match transactions that have cleared the bank instead of requiring someone to clear each one manually. This requires uploading a file of bank transactions — typically just checks.

<Steps>
  <Step title="Open the import dialog">
    Click the **Import** link under **more options**.

    <Frame caption="The Import link under more options">
      <img src="/images/accounting/intacct-bank-reconcilliation/image2.png" alt="Sage Intacct bank reconciliation import link" />
    </Frame>
  </Step>

  <Step title="Download the template">
    In the import files dialog box, click the **Bank reconciliation transaction template** link to download the template.

    <Frame caption="The import files dialog with the template download link">
      <img src="/images/accounting/intacct-bank-reconcilliation/image3.png" alt="Sage Intacct import files dialog box" />
    </Frame>
  </Step>

  <Step title="Complete the template">
    Add the transactions to be auto-matched, entering:

    | Column | Value |
    |---|---|
    | **Posting date** | The date the check cleared the bank |
    | **Transaction type** | Withdrawal |
    | **Doc type** | Check |
    | **Doc / check number** | The check number |
    | **Amount** | **Must be negative** |

    <Frame caption="The completed auto-match template">
      <img src="/images/accounting/intacct-bank-reconcilliation/image4.png" alt="Sage Intacct bank reconciliation auto match template" />
    </Frame>

    Save the template as **CSV** in the bank docs folder.

    <Warning>
      Before closing, confirm the amount column is formatted as a **number**. The import fails with any other format.
    </Warning>
  </Step>

  <Step title="Upload the file">
    Back on the reconciliation screen, click **Choose File**, select the completed file, and click **Done**. Click **Continue** when returned to the Reconciliation screen.
  </Step>
</Steps>

## Read the reconciliation screen

The reconciliation screen has four components. Knowing what each number means is what makes the rest of the work fast.

### Top left — matched and unmatched summary

<Frame caption="Summary of matched and unmatched transactions">
  <img src="/images/accounting/intacct-bank-reconcilliation/image5.png" alt="Sage Intacct reconciliation matched and unmatched summary" />
</Frame>

- **Matched transactions** have been matched to activity from the bank account. If you imported a bank transaction file for auto-matching checks, any transactions present in both the file and Intacct appear in **Matched checks and debits** or **Matched deposits and credits**. If you did not import a file, both matched totals start at zero.
- **Unmatched transactions** have been entered into Intacct but are not in the bank activity.

### Top right — balances

<Frame caption="The balance summary that drives the reconciliation">
  <img src="/images/accounting/intacct-bank-reconcilliation/image6.png" alt="Sage Intacct reconciliation balance summary" />
</Frame>

| Balance | Meaning |
|---|---|
| **Beginning balance** | The prior period's ending bank balance |
| **Statement balance** | The bank balance at the end of the current period, entered when starting the rec |
| **Book balance** | The GL balance at the end of the current period |
| **Difference** | Statement ending balance less book balance — the amount the reconciliation must account for |
| **Uncleared amount** | Total transactions entered in Intacct that have not been matched |
| **Amount to reconcile** | Difference less uncleared amount. **This must be zero to complete the reconciliation.** |

### Middle — filters

<Frame caption="Sorting and filtering tools">
  <img src="/images/accounting/intacct-bank-reconcilliation/image7.png" alt="Sage Intacct reconciliation filter tools" />
</Frame>

Filter by state (unmatched, matched, all), type (debit, credit), amount, or doc number. More filters are available under **show more filters**. Click **Apply filters** to run them, or **Clear Filters** to remove the criteria.

### Bottom — posted transactions

<Frame caption="Transactions posted in the general ledger">
  <img src="/images/accounting/intacct-bank-reconcilliation/image8.png" alt="Sage Intacct reconciliation transaction list" />
</Frame>

For transactions that have cleared the bank, select the boxes at the far left and click **clear transactions**. The status changes from unmatched to matched at the right of the screen.

<Tip>
  **The standard working method:** download the bank transactions and sort them in Excel. As you match transactions in the rec, highlight them in the spreadsheet too. Once everything possible has been matched and highlighted, whatever is left unhighlighted is the list of transactions you need to enter.
</Tip>

<Frame caption="Working the reconciliation against a sorted bank download">
  <img src="/images/accounting/intacct-bank-reconcilliation/image9.png" alt="Excel bank activity used alongside the reconciliation" />
</Frame>

## Enter missing transactions

Once all available transactions are matched, enter the transactions that have not been posted to the GL. Use the correct method for each type.

<Warning>
  **Do not post bank transactions as journal entries.** The only exception is payroll entries, entered as PYRJ type journal entries. Everything else uses one of the methods below.
</Warning>

### Deposits

Most deposits are entered through **other receipts**. The exception is deposits that need to post against an A/R invoice for clients generating invoices within Intacct.

Go to **Cash Management → Other receipts**.

<Frame caption="Creating a deposit through Other Receipts">
  <img src="/images/accounting/intacct-bank-reconcilliation/image10.png" alt="Sage Intacct other receipts entry screen" />
</Frame>

| Field | Guidance |
|---|---|
| **Receipt / Transaction / Deposit Date** | All three should be the same date. Daily sales deposits totaled for the period (credit cards, cash, delivery) are recorded on the **last day of the period**. Miscellaneous deposits unrelated to daily sales are recorded on the day they post to the bank. |
| **Payer** | The person or business who made the payment |
| **Description** | What the deposit was for |
| **Attachment** | Documentation for the deposit |
| **Deposit to** | Always use **Bank Account** |
| **Account** | The bank account the deposit was made to |
| **Entries → Account** | The credit side of the GL entry |
| **Entries → Amount** | All lines must total the deposit in the bank |
| **Entries → Department** | Only required for companies using departments |
| **Entries → Location** | The location or entity for the credit side. If this differs from the entity on the bank account, an intercompany entry is created. |
| **Entries → Memo** | Carries down from the description; override for line-level detail |

### Bank fees and interest

Go to **Cash Management → Interest and charges**.

<Frame caption="Recording bank fees and interest">
  <img src="/images/accounting/intacct-bank-reconcilliation/image11.png" alt="Sage Intacct bank interest and charges screen" />
</Frame>

| Field | Guidance |
|---|---|
| **Bank Account** | The account the transaction posted to |
| **Date** | The date the transaction posted to the bank |
| **Transaction Type** | Either **service charge** or **interest earned** |
| **Description** | Usually the month and type of transaction |
| **Attachment** | Not usually needed — the bank statement is the documentation |
| **Entries → Account** | Bank fees for charges, or interest income for interest deposits |
| **Entries → Amount** | All lines must total the bank deposit or withdrawal |

### Transfers between bank accounts

Money moved between two bank accounts that both exist in Intacct is recorded through **Cash Management → Funds transfer**.

<Frame caption="Recording a transfer between bank accounts">
  <img src="/images/accounting/intacct-bank-reconcilliation/image12.png" alt="Sage Intacct funds transfer screen" />
</Frame>

<Warning>
  **Do not use funds transfer for payments that need to be tracked as a 1099 payment** — for example rent paid by an operating entity to a real estate entity.
</Warning>

| Field | Guidance |
|---|---|
| **From Account** | The bank the money was withdrawn from |
| **To Account** | The bank the money was deposited at |
| **Date** | The date the transaction posted to the bank |
| **Description** | Optional — for tracking specific transfer information (for example `P5 intercompany balance`) |
| **Reference number** | Optional |
| **Dimensions** | Optional. Location is optional here since the entity comes from the bank account setup. |

### Manual payments

Withdrawals for payments are recorded either as manual payments or through pay bills:

- **Manual payments** — when an invoice and payment need to be created at the same time.
- **Pay bills** — when a payment applies to an invoice already posted.

<Note>
  In general, **the AP processor should be entering most vendor payments**, whether through pay bills or manual payments. See [Day-to-day AP transactions in Sage Intacct](/internal/sops/accounting/ap/intacct-ap-transactions).
</Note>

Go to **Accounts Payable → Manual payment**.

<Frame caption="Recording a manual payment">
  <img src="/images/accounting/intacct-bank-reconcilliation/image13.png" alt="Sage Intacct manual payment screen" />
</Frame>

| Field | Guidance |
|---|---|
| **Payment Method** | Check, cash, credit card, or record transfer (ACH) |
| **Bank** | The bank the money was withdrawn from |
| **Date** | The date the transaction posted to the bank |
| **Transaction Amount** | The total payment amount that cleared the bank |
| **Vendor** | Who the payment was made to |
| **Check no / Document Number** | Required for checks — use the number on the issued check. For all other types Intacct does not require it, **but PBI process is to always enter one**: an alphanumeric combination of payee and date. A payment to Recycling Ricky on 6/1/2025 becomes `RR060125`. |
| **Pay To** | Populates automatically from the vendor |
| **Bill number** | The invoice number if available; otherwise reuse the document number |
| **Memo** | Optional, for tracking specific payment information |
| **Entries → Account** | The debit side of the GL entry |
| **Entries → Location** | The location or entity for the debit side. A different entity than the bank account creates an intercompany entry. |

## Complete the reconciliation

<Steps>
  <Step title="Confirm the amount to reconcile is zero">
    After all bank activity has been entered and matched, the amount to reconcile should be zero.

    <Frame caption="Amount to reconcile at zero">
      <img src="/images/accounting/intacct-bank-reconcilliation/image14.png" alt="Sage Intacct reconciliation showing zero amount to reconcile" />
    </Frame>
  </Step>

  <Step title="Review all outstanding items">
    Use the filters to set state to **unmatched** and transaction type to **all**.

    <Frame caption="Filtering to review every outstanding item">
      <img src="/images/accounting/intacct-bank-reconcilliation/image15.png" alt="Sage Intacct reconciliation filtered to unmatched transactions" />
    </Frame>

    | Item | Rule |
    |---|---|
    | **Outstanding checks** | AP checks more than **3 months old** go to the AP processor for research. Payroll checks older than **6 months** move to the unclaimed payroll liability GL semi-yearly. |
    | **Deposits in transit** | Verify outstanding deposits posted at the bank after period end. Communicate any that did not post to the client. |
    | **Outstanding ACH payments** | There should be none. Research against post-reconciliation bank activity or review for a duplicate entry. |
  </Step>

  <Step title="Verify the book balance against the GL">
    Confirm the book balance matches the GL balance for the account.

    <Frame caption="Book balance on the reconciliation">
      <img src="/images/accounting/intacct-bank-reconcilliation/image16.png" alt="Sage Intacct reconciliation book balance" />
    </Frame>

    <Frame caption="The corresponding general ledger balance">
      <img src="/images/accounting/intacct-bank-reconcilliation/image17.png" alt="Sage Intacct general ledger account balance" />
    </Frame>
  </Step>

  <Step title="Reconcile and file the documentation">
    Click **Reconcile** in the top right corner.

    Then go to **Cash Management → View reconciliation histories** to pull an Excel version of the report. Copy and paste the report into the appropriate GL tab in the balance sheet reconciliation workbook in the period close folder.

    Include a screenshot from the bank, or the bank statement, on that tab to support the ending statement balance used in the reconciliation.

    <Frame caption="Reconciliation history export">
      <img src="/images/accounting/intacct-bank-reconcilliation/image18.png" alt="Sage Intacct view reconciliation histories" />
    </Frame>

    **Expected outcome:** the reconciliation is marked complete in Intacct, and the period close workbook holds both the reconciliation report and support for the ending statement balance.
  </Step>
</Steps>

## Related documents

- [Bank reconciliation concepts](/internal/sops/accounting/general/bank-reconciliation-concepts) — terminology and the standard steps
- [Bank transaction automation — rule setup](/internal/sops/accounting/general/bank-automation-setup) — replaces most of the manual matching above
- [Set up a basic check-matching rule set](/internal/how-to/accounting/intacct-bank-rule-sets) — the quick version for auto-matching checks
- [Day-to-day AP transactions in Sage Intacct](/internal/sops/accounting/ap/intacct-ap-transactions)
- [PBI vs. client responsibilities](/internal/sops/accounting/responsibilities)