---
title: "Reconcile With Bank Automation Rules"
sidebarTitle: "Reconciling with rules"
description: "Upload a bank file to Sage Intacct, work the two-tab reconciliation created by automation rules, and review unmatched transactions across all bank accounts."
icon: "wand-magic-sparkles"
---

> **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 — staff accountants |
| **Effective date** | Not set in source |
| **Scope** | The day-to-day procedure for uploading a bank file and reconciling with create and match rules already in place. Assumes the rules and rule sets have been configured — see [Bank transaction automation: rule setup](/internal/sops/accounting/general/bank-automation-setup). |
| **Source** | `General Accounting/02 - Bank Reconciliation/Bank Automation - Staff Accountants.docx` |

Once rules are configured, deposits, bank fees, and transfers are created automatically when a bank file is uploaded, and checks and ACH payments auto-match. Your job shifts from clearing transactions one by one to reviewing what the rules did and handling the exceptions.

## Procedure

<Steps>
  <Step title="Upload the bank file">
    Go to **Cash Management → All → Bank transaction import files**.

    Click **add**, then select the bank account. The last upload date is displayed.

    Several file formats work: **BAI2, CAMT053, OFX, ASO, QIF, CSV, XLS(X)**. Click **Open file import guide** for details on each type.

    At a minimum the file must include **Date, Description, and Amount** — though several header variations are accepted (for example `Posting Date` instead of `Date`).

    <Frame caption="Header variations accepted in a four-column Excel import">
      <img src="/images/accounting/bank-automation-managers/image8.png" alt="Sage Intacct bank file import header variations" />
    </Frame>
  </Step>

  <Step title="Wait for processing to complete">
    Once uploaded, Intacct takes **5 to 10 minutes** to process.

    On the Bank Transaction Import File screen you can see the status of pending uploads and the full upload history.

    <Frame caption="Upload status and history">
      <img src="/images/accounting/bank-automation-managers/image9.png" alt="Sage Intacct bank transaction import file status screen" />
    </Frame>

    <Warning>
      Wait until the file status changes to **complete** before starting the bank reconciliation. Starting early means working against a partially loaded file.
    </Warning>
  </Step>

  <Step title="Start the reconciliation">
    Start the bank reconciliation as usual. The rec now has **two tabs** — one for Intacct transactions and one for bank transactions.

    <Frame caption="The two-tab reconciliation screen">
      <img src="/images/accounting/bank-automation-managers/image10.png" alt="Sage Intacct reconciliation with Intacct and bank transaction tabs" />
    </Frame>
  </Step>

  <Step title="Review the Intacct transactions tab">
    Review the Intacct transactions for anything that should have cleared — ACH payments and deposits — based on the create and match rules.

    Transactions that exist in Intacct and on the bank activity screen can be cleared by clicking **match** at the far right of the transaction, on either the Intacct or bank screen, then selecting the corresponding transaction from the pop-up.
  </Step>

  <Step title="Work the bank transactions tab">
    The bank tab defaults to filtering **unmatched** bank transactions.

    Deposits, bank fees, and transfers can be reviewed and created directly from the bank screen, which also clears them from the bank rec.

    <Tip>
      Anything you create by hand on this tab is a candidate for a new rule. Review these transactions to determine whether an additional create or match rule should be built — that is how the automation improves over time.
    </Tip>

    Any remaining vendor payments are sent to the AP processor to enter.
  </Step>

  <Step title="Finish the reconciliation">
    The reconciliation is complete when **the amount to reconcile is zero and the bank tab is cleared of unmatched transactions**.

    **Expected outcome:** both conditions met, with every rule-created transaction reviewed rather than assumed correct.
  </Step>
</Steps>

## Review unmatched transactions across all accounts

Two views help you monitor the whole client rather than one account at a time:

- Go to **Cash Management → Bank Transactions** to review all bank transactions.
- Enter `unmatched` in the reconciliation status column to generate a condensed list of unmatched transactions **across all bank accounts**.

## Related documents

- [Bank transaction automation: rule setup](/internal/sops/accounting/general/bank-automation-setup) — the configuration behind this procedure, plus sample rules
- [Intacct bank reconciliation](/internal/sops/accounting/general/intacct-bank-reconciliation) — the manual reconciliation procedure and how to read the reconciliation screen
- [Bank reconciliation concepts](/internal/sops/accounting/general/bank-reconciliation-concepts) — outstanding item rules that still apply