Automate invoice-bank statement reconciliation with Mistral AI and OpenAI GPT-4
Ready for 3.0Ready for 3.0. This template uses no nodes that n8n 3.0 removes. No removed nodes, versions or helpers found. Static check, last run 2026-10-19.
What this workflow does
This AI workflow has 9 nodes and runs manually, when you click “Execute workflow”. Along the way it connects Microsoft OneDrive, OpenAI Chat Model and Microsoft Excel 365.
How it runs
Trigger: Manually, when you click “Execute workflow”.
- Get Invoice Data (Microsoft Excel 365): get rows (table)
- Code: runs custom JavaScript code
- Get Bank Statement (Microsoft OneDrive): get
- Extract the Data from Unstructured File (Microsoft OneDrive): download
- Extract text (Mistral AI): uses Mistral AI
- Process the Invoice Vs Bank Statement Data (AI Agent): runs an AI agent, with model: OpenAI Chat Model
- Get Transaction, Matches, Summary (Code): runs custom JavaScript code
Services it uses
Before you upgrade to n8n 3.0
Nothing in this workflow is removed in n8n 3.0, so it should import and run after the upgrade.
Nodes used (7)
- Manual Trigger
n8n-nodes-base.manualTrigger - Mistral AI
n8n-nodes-base.mistralAi - Microsoft OneDrive
n8n-nodes-base.microsoftOneDrive - Code
n8n-nodes-base.code - OpenAI Chat Model
@n8n/n8n-nodes-langchain.lmChatOpenAi - AI Agent
@n8n/n8n-nodes-langchain.agent - Microsoft Excel 365
n8n-nodes-base.microsoftExcel
From the author
Cash Reconciliation with AI This template automates daily cash reconciliation by comparing your open invoices against bank statement transactions. Instead of manually scanning statements line by line, the workflow uses AI to: 1. Match transactions to invoices…