Convert foreign-currency invoices at the official rate
The official rate for each invoice date and the amount in your currency, ready for your books.
- You start it: When you start it
What it does
The task
Read the invoices in the Google Sheet sheet url: the date, the amount and the currency. For each date, find the reference rate from rate source for that day. When there is no rate for that day, use the last rate before it. Add three columns: the rate, the rate date and the amount in base currency, rounded to 2 decimals. Put the link to the rate page at the top of the sheet.
- It works in Google Sheets and any website, in the workspace you pick, and signs in with passwords from your Cuiar vault.
- It runs once, when you start it.
What you give it
| Blank | What to give | Example |
|---|---|---|
| sheet url | The Google Sheet with your foreign-currency invoices | https://docs.google.com/spreadsheets/d/1FxInvoices |
| rate source | The official rate source that your accountant uses | European Central Bank reference rates |
| base currency | Your book currency | EUR |
What you get back
An example run with the example values above. Your run uses your own data.
12 invoices converted to EUR at ECB reference rates
| Date | Amount | Rate | Rate date | EUR |
|---|---|---|---|---|
| 1 Oct | 1,200.00 USD | 1.0942 | 1 Oct | 1,096.69 |
| 3 Oct | 860.00 GBP | 0.8571 | 2 Oct (3 Oct is a Saturday) | 1,003.38 |
| 14 Oct | 25,000.00 SEK | 11.4120 | 14 Oct | 2,190.68 |
... 9 more
Total: 18,442.71 EUR
Source: ecb.europa.eu, euro foreign exchange reference rates
Run it in Cuiar
- 01
Open it
Click Use in Cuiar on this page. The side panel opens with the task in the composer.
- 02
Fill in 3 blanks
Type sheet url, rate source and base currency. Tab moves to the next blank.
- 03
Run it
Run sends it to the agent. Follow each step in the panel, and stop it at any time.
From the terminal
cuiar exec "Read the invoices in the Google Sheet https://docs.google.com/spreadsheets/d/1FxInvoices: the date, the amount and the currency. For each date, find the reference rate from European Central Bank reference rates for that day. When there is no rate for that day, use the last rate before it. Add three columns: the rate, the rate date and the amount in EUR, rounded to 2 decimals. Put the link to the rate page at the top of the sheet."Run it from your AI agent
Claude Code, Codex, Cursor and other MCP clients reach Cuiar at https://mcp.cuiar.com/mcp. Add the server one time, then ask for the task in plain words, or call run_task yourself.
1. Add Cuiar to Claude Code
claude mcp add --transport http cuiar https://mcp.cuiar.com/mcp2. Ask your agent
Use the Cuiar tool run_task to run my "Convert foreign-currency invoices at the official rate" template with sheet url = https://docs.google.com/spreadsheets/d/1FxInvoices; rate source = European Central Bank reference rates; base currency = EUR.Setup for other agents: AI agents.
The tool call
{
"name": "run_task",
"arguments": {
"task": "Read the invoices in the Google Sheet https://docs.google.com/spreadsheets/d/1FxInvoices: the date, the amount and the currency. For each date, find the reference rate from European Central Bank reference rates for that day. When there is no rate for that day, use the last rate before it. Add three columns: the rate, the rate date and the amount in EUR, rounded to 2 decimals. Put the link to the rate page at the top of the sheet."
}
}Related templates
All finance templatesFinance
Find card payments that have no receipt
Each card payment matched to a receipt from your inbox or folder, with the missing ones listed first.
You start it: When you start it- Any bank site
- Gmail
- Google Drive
- +1 more: Google Sheets
Finance
Match Stripe payouts to your bank deposits
Each payout matched to a deposit, with fees and refunds, and the payouts that did not arrive.
You start it: When you start it- Stripe
- Any bank site
- Google Sheets
Finance
Prepare the figures for your VAT return
Sales and input VAT by rate for the period, checked against your sales platforms, with the box values.
You start it: When you start it- Xero
- Shopify
- Stripe
- +1 more: Google Sheets
Finance
Build a 13-week cash flow forecast
Weekly cash in and out from your bank, open invoices and bills, with the weeks below your minimum marked.
You start it: When you start it- Any bank site
- Xero
- Google Sheets
Finance
Break down the fees in your marketplace payouts
Sales, fees, ads and refunds for each product on each marketplace, with your net after fees.
You start it: When you start it- AAmazon Seller Central
- Etsy
- eBay
- +1 more: Google Sheets
Finance
Build a mileage log from your calendar
Each business trip with its date, purpose, route and distance, and the total claim at your rate.
You start it: When you start it- Google Calendar
- Google Maps
- Google Sheets