Skip to main content

Claude MCP for Excel

Connect Claude AI to your iBanFirst account and sync your financial data — balances, payments, FX rates — directly into Excel, with a simple prompt.

What is this?

The iBanFirst MCP (Model Context Protocol) integration connects Claude AI directly to your iBanFirst account.

Once set up, you can ask Claude in plain language to pull your financial data and write it straight into your Excel spreadsheet, where you want it: no CSV exports, no reformatting columns.

The MCP server is built on top of the iBanFirst API and does not store conversation content, transcripts, or your business data.

Before starting, you must have a Super admin profile on iBanFirst Platform

Step 1: Retrieve the MCP credentials.

Connect to https://platform.ibanfirst.com/login with Administrator rights

Go to the tab “Services”

At the bottom, click on “Add a token”

Choose a name and click on “Create”

Copy Login and Password

Warning: if you loose your password, you have to revoke the user and create a new token name / password

Step 2: Add the iBanFirst MCP in Claude

With a Pro account, you can add a custom connector directly, with a “Team” offer, you have to be a Claude admin.

Later the connector will be available in the Claude marketplace

Step 3: use this Token credentials in Claude

The MCP server need to be installed once.

ð Follow the iBanFirst MCP Connector guide : 2 explanations, one for Claude.ai, one for Claude Desktop

Enter your iBanFirst API credentials when prompted.

Claude will detect the iBanFirst MCP tools automatically once the server is running.

Step 4: Install the Claude excel add-in, if not already installed

Step 5: Add a skill in Claude to better use the iBanFirst MCP

The ibanfirst-excel-sync skill tells Claude exactly how to sync your iBanFirst data into Excel. Here's how to add it:

  1. Go to claude.ai and open your project — or create a new one.

  2. Open Project Knowledge and click Add content.

  3. Copy the full skill content from the iBanFirst Excel guide.

  4. Paste the content and save.

Claude will now follow these instructions automatically every time you ask about your iBanFirst data in Excel.

Access the Documentation →

Prompt examples

Open your Excel workbook alongside Claude Desktop and type what you need in plain language. Don’t hesitate to be very specific to get a quick answer.

Remember, you can start by asking: Tell me what I can do with this MCP!

💰 Cash & liquidity overview

  • "What are my current balances across all accounts?"

  • "How much cash do we currently hold in USD?"

  • "Give me a consolidated EUR equivalent of all my accounts."

  • "Show me my EUR, GBP and USD balances with today's exchange rates."

📊 Accounts sheet refresh (Excel)

  • "Sync my iBanFirst accounts into the Accounts sheet."

  • "Update the iBanFirst accounts in the Accounts sheet with the latest balances and EUR equivalents using live exchange rates."

  • "Refresh account balances across all currencies."

  • "Which accounts have a balance below €10,000?"

🧾 Transaction import & reconciliation (Excel)

  • "Import all iBanFirst financial movements into Transactions."

  • "Import all iBanFirst transactions from the last 3 months into the Transactions sheet."

  • "Import all transactions since last Monday into the Transactions sheet."

  • "Export all EUR transactions from last month into the Transactions sheet."

  • "Reorganize the transaction data using the same columns as this accounting export (Date, Supplier, Amount, Currency and Reference)."

  • "Colour rows differently by account currency."

📅 Planned operations (Excel)

  • "Add my pending iBanFirst payments to Planned Operations."

  • "Add all pending iBanFirst payments to my weekly cash forecast."

  • "Import upcoming payments into the Cash Forecast sheet."

  • "Show all payments due in the next 30 days by currency."

  • "Add planned payments to my treasury forecast workbook."

  • "Export planned operations as an iBanFirst CSV."

🔍 Payment search & investigation

  • "Show me any blocked or rejected payments."

  • "Find the payment we made to Supplier Account 133 in March."

  • "How much have we paid Supplier Account 133 so far this year?"

  • "Find the payment we made to Supplier X in March."

  • "Show all payments sent to this beneficiary."

  • "Retrieve the details of payment ID XXXXX."

  • "Show me all rejected payments this month."

💱 FX rates & forward contracts

  • "Refresh FX rates from iBanFirst."

  • "Update the FX rates tab with the latest EUR/USD and EUR/GBP rates."

  • "List all active forward contracts."

  • "Summarize contracts maturing this month."

  • "Export all forward contracts into Excel."

  • "Show all FX trades executed this month."

  • "Summarize FX activity by currency pair."

📉 Cash flow forecasting & analysis

  • "Project my account balances in EUR 2 months from now based on monthly averages."

  • "How much should I top up my EUR account to cover the next 2 months?"

  • "What are the top 3 expense categories on my EUR account over the last 6 months?"

  • "Show all payments due in the next 30 days by currency."

📈 Charts & dashboards (Excel)

  • "Show me the EUR account balance over the last 6 months as a dashboard."

  • "Plot monthly inflows in green and outflows in magenta on the same chart."

  • "Show a volume breakdown by currency (EUR-equivalent) as a pie chart."

  • "Create a multi-currency inflow/outflow chart with a different colour per currency and solid lines for inflows, dashed for outflows."

  • "Make the chart more modern."

  • "Create a chart showing payment volumes by currency."

📋 Reporting & analysis

  • "What transactions happened in the last 7 days?"

  • "What transactions happened in the last 30 days?"

  • "Summarize all payments sent this month by currency."

  • "Generate a treasury report for May."

  • "How much did we pay in USD last quarter?"

  • "What was our largest payment last month?"

  • "Which currencies were most used in May?"

Did this answer your question?