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

BlankWhat to giveExample
sheet urlThe Google Sheet with your foreign-currency invoiceshttps://docs.google.com/spreadsheets/d/1FxInvoices
rate sourceThe official rate source that your accountant usesEuropean Central Bank reference rates
base currencyYour book currencyEUR

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

DateAmountRateRate dateEUR
1 Oct1,200.00 USD1.09421 Oct1,096.69
3 Oct860.00 GBP0.85712 Oct (3 Oct is a Saturday)1,003.38
14 Oct25,000.00 SEK11.412014 Oct2,190.68

... 9 more

Total: 18,442.71 EUR

Source: ecb.europa.eu, euro foreign exchange reference rates

Run it in Cuiar

  1. 01

    Open it

    Click Use in Cuiar on this page. The side panel opens with the task in the composer.

  2. 02

    Fill in 3 blanks

    Type sheet url, rate source and base currency. Tab moves to the next blank.

  3. 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/mcp

2. 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."
  }
}
All finance templates
  • Finance

    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
    • Amazon 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