Today’s your day David! I just had a quick look and we’re at 1.1530 ish. It’s looking a little like a happy new year for now.
We can’t use the microfoncier reporting system, we have to use form 2044 and report according to the “réel” method. At some point in the online form there’s a link to a “détail”
section where they want details of each repair.
Yes, I remember that now, I also use the 2044 and I think I just don’t press the detail button ?? I seem to remember I just typed single figures directly into each box - there’s about 4 to do I recall.
Yes, I remember now, naughty boy! Mind you, I have a colleague who also forgets to go to the “détail” section, so far with no nasty consequences. I should probably take a leaf out of your book.
1 Like
We do keep some money in the UK, although not a lot. We tend to transfer money only a couple of times a year so for money still in the UK, we just take an average of the rate we received when we did all our transfers.
Edit: The only UK derived income we have is pension income and a UK benefit for OH, so not complex like having property.
1 Like
Not that desparate, will need to go much higher than that before I move my millions. 
Supplementary question for @George1 . In previous years I have done more or less what you did and checked it against the mean figure published by various other people like Connexion, for example.
However, last year I thought I’d check the differences between using the mean rate and using the spot rate for the day on which our pensions were paid in the UK. (I know that’s a bit barking but actually, in some years, a mate of mine got a more advantageous result doing that than using the mean, but it obviously depends on the way the pound moves during the year.)
What I’m getting to in a roundabout way is that the BdF publishes a downloadable list of all the rates for the past year or more in CSV form and this is what I used last year. The problem is that the delimiter on the csv is a comma BUT decimals in France use a comma instead of a full stop which makes it impossible to import directly into eg a spreadsheet. I clearly found a way of doing that last year but can I remember it? Obviously not!
Any suggestions?
Couldn’t you format the column as EUR currency and it then works it out appropriately?
Once it’s in a spreadsheet, it’s fine but when the BdE csv file is delimited by commas AND the amounts have embedded commas, import facilities can’t discriminate and BdE doesn’t give any options at all on the download.
Random example line…
2026-01-05,1,7492,6,347,1,6087,0,9289,8,1478,24,195,7,4695,0,8676,9,822,384,55,19524,95,3,685,105,316,147,4
Oh. That’s a bit silly
I’m looking at the BdE 's website to see if there’s any way round that problem. - will report back in case anyone else is daft enough to do what I want to do 
I’ve been tracking my income each month and using the daily rate as appropriate, so I’m interested.
Got it! If you make sure the language setting on the BdE website is set to English (I normally do everythingin French) and go to page Exchange rates (daily parities) - 2026-01-07 | Banque de France
the amounts miraculously appear with a full stop. Then if you download the lot where it has a “click here” to give it all in TXT format, it still downloads as a csv file, not txt, but this one will import to a spreadsheet because it preserves the full stops.
1 Like
At first glance, it looks like Google Sheets can parse the French CSV just fine.
Interesting. You are clearly a modern young person… 
1 Like
An alternative is to ask AI for the official month end closing £/€ ECB exchange rates (copied by the BdF) - or indeed whatever date your pension is usually gets paid (see example below). It even offered me a downloadable spreadsheet….
1 Like
You’re obviously a moderner, younger person
Thank you @George1 . I am allergic to AI but it is very useful to know that BdF copies its data from he ECB, which has an interesting interface. I shall have a play!
Our pensions arrive at all sorts of dates, so it’s easier for me just to have a list throughout the year, which is what I got before. Ah well - that was a year ago 
I believe there’s an option when .csv files are created as to what character is used as a delimiter.
1 Like
Indeed but I think the problem is that the delimiter is a comma and the “decimal point” is also a comma.
1 Like