Convert transactions to one currency
“show every bank transaction, convert euro, pounds, and cad to usd by the day’s fx rate, and add a Status that says "Agrees" when the usd amount lines up, else a short note on what to check”
show every Bank transactions, convert euro, pounds, and cad to usd by the day’s fx rate from Daily FX rates, and add a Status that says "Agrees" when the usd amount lines up, else a short note on what to check
What the agent built
2 steps, each one an ordinary Mammoth step you can open and change.
- FileBank transactionsCSV export · 24 rows
- FileDaily FX ratesCSV export · 32 rows
- JoinAdd FX rate17 of 24 paired
- StepConvert to USDStep 2
- ResultBank USD conversions24 rows · 2 flagged
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 24 rows came out, and the join paired 17 of 24 rows.
- Download Bank transactions sample (24 rows)Bank: Transactions > Export CSV
- Download Daily FX rates sample (32 rows)Bank: Treasury > FX rates > Export daily rates CSV
What you get back
The result of that run, the rows to look at first.
| Transaction ID | Txn date | Posted date | Description | Account name | Txn currency | Txn amount | Balance | USD amount | Status |
|---|---|---|---|---|---|---|---|---|---|
| txn_1017 | 2026-10-14 | 2026-10-14 | Paris invoice payment | sales_revenue | EUR | 1,765.40 | 71,890.55 | · | Check FX rate |
| txn_1023 | 2026-10-28 | 2026-10-28 | Tokyo vendor payment | vendor_payables | JPY | -92,000 | -18,266.95 | · | Check FX rate |
| txn_1002 | 2026-09-03 | 2026-09-03 | AWS invoice payment | software_subscriptions | EUR | 1,240 | 57,180.15 | 1,345.40 | Agrees |
| txn_1003 | 2026-09-08 | 2026-09-08 | Client refund for order 4831 | sales_revenue | GBP | -185.50 | 56,994.65 | -237.25 | Agrees |
| txn_1004 | 2026-09-08 | 2026-09-08 | Courier payment | travel_expense | CAD | -312.40 | 56,682.25 | -229.61 | Agrees |
| txn_1005 | 2026-09-12 | 2026-09-12 | Upwork contractor payout | payroll_clearing | EUR | -960 | 55,722.25 | -1,048.32 | Agrees |
| txn_1007 | 2026-09-18 | 2026-09-18 | Google Ads invoice | marketing_spend | GBP | -780 | 61,455.05 | -1,005.42 | Agrees |
| txn_1008 | 2026-09-18 | 2026-09-18 | SEPA customer deposit | sales_revenue | EUR | 2,145.60 | 63,600.65 | 2,351.58 | Agrees |
| txn_1009 | 2026-09-24 | 2026-09-24 | Hardware supplier payment | vendor_payables | CAD | -1,450.75 | 62,149.90 | -1,075.01 | Agrees |
| txn_1011 | 2026-09-30 | 2026-09-30 | Office rent | admin_expense | GBP | -2,400 | 63,949.90 | -3,115.20 | Agrees |
| txn_1012 | 2026-09-30 | 2026-09-30 | Wire fee reversal | bank_fees | CAD | 85 | 64,034.90 | 63.11 | Agrees |
| txn_1013 | 2026-10-03 | 2026-10-03 | Canadian customer payment | sales_revenue | CAD | 3,180.25 | 67,215.15 | 2,366.11 | Agrees |
How do you convert transactions to one currency?
Export your bank transactions and your daily fx rate table as files, then upload them to the workflow. It adds the fx rate for each date, converts euro, pounds, and cad to usd, and sets a Status so you can see which rows agree and which need a check.
How it works
How to use the Bank USD conversions workflow
- 1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
- 2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
- 3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.
Bank USD conversions: questions
Which export should you use?
What happens to rows that do not match?
How do you change the rules?
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Remove duplicate rows, catch invoices paid twice, match messy names to a master list, standardise spellings and turn wide tables long.
- Compare two listsCompare two exported spreadsheet lists by email, see matches, and label rows where name and email agree or differ.See the workflow Built by the agent
- Split full names into first and lastSplit full names into first and last name, keep useful name parts, and flag rows that need a check in your exported spreadsheet file.See the workflow Built by the agent
- Remove duplicatesOne row of each, with a Copies column saying how many there wereSee the workflow Template
- Match names to a master listEach record with its master name (and ID), and how it matchedSee the workflow Template
- Duplicate invoice checkPairs of bills that look paid twice: same supplier, same amount, close dates or the same numberSee the workflow Template
- Standardise namesA Standard name for every row, so spellings of the same name group togetherSee the workflow Template