Reconcile cash balances in Google Sheets with OpenAI explanations

Cash Reconciliation Checker with Google Sheets, OpenAI & n8n

This workflow automatically compares internal cash balances with custodian or bank balances using Google Sheets, detects mismatches by accountid, calculates balance differences, logs matched records and sends mismatched records through OpenAI for a short explanation before saving them for exception review. It is designed to help teams reduce manual reconciliation work and quickly identify balance issues.

Quick Implementation Steps

1. Import the workflow into n8n. 2. Connect your Google Sheets OAuth2 credentials. 3. Point the three Google Sheets nodes to: - Internal balances sheet - Custodian balances sheet - Reconciliation / exception log sheets 4. Ensure both source sheets use the same accountid values. 5. Make sure balance fields are numeric: - internalbalance - custodianbalance 6. Connect your OpenAI credentials. 7. Adjust the Schedule Trigger frequency if needed. 8. Run the workflow once and verify: - matched records are logged - mismatched records are analyzed and appended correctly

What It Does

The Cash Reconciliation Checker automates a common finance operations task: comparing balances between two separate data sources. In this workflow, one Google Sheet holds internal balances, while another holds custodian balances. The workflow fetches both datasets, standardizes the required fields and matches records using the shared accountid.

After matching the accounts, the workflow calculates the difference between internal and custodian balances and checks whether the difference exceeds a built-in tolerance. If the balances match, the record is written to a reconciliation log as a successful result. If they do not match, the workflow routes the record into an exception path.

For mismatches, the workflow uses OpenAI (gpt-4o-mini) to generate a short possible explanation based on the values in the record. That enriched mismatch record is then prepared and appended to a separate logging sheet for investigation and follow-up.