Bank Feed Connection & Reconciliation Setup

Daily bank feed pull from connected bank accounts via the accounting software's native feed integration. Transactions are automatically ingested into the staging area.

Automation platform compares incoming transactions against the ledger and recent imports to flag and suppress duplicates. Reversed entries are identified by amount and date proximity.

Automation platform matches bank transactions to open invoices, bills, and transfers using amount, date, and reference number. Partial payments and timing differences are handled by fuzzy matching rules.

The automation analyzes transaction description, amount, and historical patterns to assign the correct expense or income account. High-confidence categorizations are applied automatically.

Decision node checks if any transactions fall below confidence threshold or require human judgment (e.g., unusual amounts, new vendors, or policy exceptions).

Low-confidence or policy-exception transactions are logged and Google Sheet for the bookkeeper to review and approve before reconciliation closes.

Once all transactions are matched or flagged, the automation marks the bank account as reconciled or and updates the reconciliation status.

Automation sends a summary email to the accounting manager and client contact with reconciliation date, balance, and any flagged items requiring attention.