Working in pounds and closing the books monthly handles income in more than one currency: list every receipt, note the pounds that reached your bank, and total that column. Do not try to convert at the end of the year from memory. A monthly close takes ten minutes and is the difference between knowing your income and estimating it.
Step 1: set up the columns once
A translator who works for agencies abroad might have one sheet with these headers: date received, client, invoice number, currency, amount invoiced, pounds received, and status. Nothing more is needed to start. Resist adding columns for rates or fees until you actually need them, because a sheet you stop updating is worse than a short one.
Step 2: record each receipt on the day it lands
Take the pounds figure from your bank, not from a converter website. The converter tells you what the money might have been worth; the bank tells you what you got. Say an agency pays you $1,200 and £948 arrives. Your row reads: USD, 1,200 invoiced, £948 received.
Say a second client, paying in euros, settles €850 and £727.50 arrives. The pounds received for the month so far is 948 + 727.50 = £1,675.50. The hypothetical rates here are 948 / 1,200 = 0.79 pounds per dollar and 727.50 / 850 = 0.8559 pounds per euro, rounded. Neither is a market quote, just the arithmetic of one imagined month.
Step 3: what does the monthly close look like?
- Sort the sheet by date received and filter to the month.
- Add up the pounds received column. In a sheet with dates in column A and pounds in column F, the formula is =SUMIFS($F$2:$F$500, $A$2:$A$500, ">="&DATE(2026,10,1), $A$2:$A$500, "<="&DATE(2026,10,31)).
- Compare the result with the foreign receipts on your bank statement for the same month. They should match to the penny.
- Note anything unpaid. A simple filter on the status column does it.
- Save a copy of the month, or at least note the closing total, so later edits do not quietly change history.
Should I record the rate or just the pounds?
Both are useful, but only the pounds figure is essential. Recording the implied rate, pounds received divided by amount invoiced, helps you spot an unusually poor conversion. If one payment came through at 0.74 when the previous five were near 0.79, something changed: a different intermediary, a different method of paying you, or a charge taken before the money reached you. Ask your bank or payment provider for the breakdown rather than guessing which.
| Invoice | Currency | Invoiced | Pounds received | Implied rate |
|---|---|---|---|---|
| T-014 | USD | 1,200.00 | £948.00 | 0.790 |
| T-015 | EUR | 850.00 | £727.50 | 0.856 |
| T-016 | USD | 400.00 | £300.00 | 0.750 |
In this imagined sheet the third row stands out, 300 / 400 = 0.75, and it is the one to investigate. October total: 948 + 727.50 + 300 = £1,975.50.
What if a client pays late or changes currency?
Keep the original invoice row and update only the status and the pounds received. If a client who normally pays in dollars switches to euros, add a new row with the new currency rather than altering the old one. A clean history lets you see, for example, that three of your five clients now pay in a currency you never planned for, which may matter when you choose how to receive money.
When is a spreadsheet no longer enough?
When your outgoings join your income in the same record, such as software, equipment and travel in a mix of currencies, you may want one tool for both. SpendixAI can record each expense in its own currency and total them in a base currency using the rate stored with each transaction. It is designed for India and INR, so treat it as something to evaluate rather than assume. Until then, the sheet above is perfectly sound.
Useful ideas start with a clearer picture of your own spending.
Explore your reports

