Handling twenty clients' expense data well comes down to separating each client completely while working them all the same way. You want one sign-in on your side, a sealed space for each client and a standard process that copes with items in more than one currency, which is common when clients trade across borders.
Figures below are in euros, invented for illustration. The piece covers method only, not local rules.
Why do cross-border clients make this harder?
Take a client who sells to two neighbouring countries and buys software in dollars. Their bank statement shows the euro amount actually charged, while the invoice shows another currency. If you record only one of them, reconciliation later becomes a guessing game. Record the amount in the original currency, the euro amount that left the account and the date, and keep the two together on one row.
A currency-aware row layout
| Date | Supplier | Original amount | Euro charged | Note |
|---|---|---|---|---|
| 03 Mar | Cloud host | US$ 118.00 | € 109.65 | Card statement amount |
| 09 Mar | Print shop | € 46.20 | € 46.20 | Same currency |
| 14 Mar | Design licence | £ 59.00 | € 69.80 | Charged in pounds, converted by bank |
Notice that the third column holds what the invoice says and the fourth holds what the bank took. The difference between them is the true cost of converting. Over a year this is worth seeing in aggregate, which you can do with a simple sum of Euro charged by currency.
Keep clients sealed from one another
- One workspace, folder or file set per client, never a shared workbook
- Client codes in file names so a misdirected attachment is obvious
- No client data in your own personal spending records
- Access given in the client's name, with a date noted when it was granted
A person using a tool that lets one account belong to several workspaces gets the convenience of one sign-in without mixing the data. Whatever you choose, test it by opening two clients side by side and confirm you cannot see one inside the other.
What does a good monthly pull look like?
- Request the statement for every account, as a file, by a fixed date
- Import or paste into the client's own sheet
- Match each line to a receipt or invoice where one exists
- Flag foreign-currency lines for a second look
- Total by category and compare with the previous month
Allow about 45 minutes for a straightforward client and double that for one with several currencies. For 20 clients with, say, 14 simple and 6 mixed, that is 14 times 45 plus 6 times 90 minutes, so 630 plus 540, or 1,170 minutes, which is 19.5 hours.
How do you wind down a client?
Export the full set of records, store it in the client's closed folder, note the date and tell the client where the copy lives. Then remove your own access to anything that was shared. SpendixAI offers base currency choice and per-expense currencies for personal records and is built around India and INR, so check whether any product you consider supports your clients' country before relying on it.
A short checklist for Monday
- Template per client in place
- Currency columns added where needed
- Deadline email scheduled
- Access list reviewed
If you only have an hour, spend it on the two clients with the most foreign-currency lines. Add the original-amount column, backfill the last quarter from their statements and see how many rows fail to reconcile. That small experiment tells you whether the layout works before you roll it out to the other eighteen.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


