The point is not that it is clever. The point is that it is right, and tells you when it is not sure.
Your structure, not ours
Year, then supplier, inside the folder you chose. The summary columns are the ones you asked for — change them and the loop follows.
Amounts that add up
A dollar invoice from March converts at March’s ECB rate, and the row records which day’s rate was used. The converted column sums.
It asks rather than guesses
No readable total, no date, no exchange rate for that day — it holds the document for you and says why. Nothing is invented to fill a cell.
Never files the same thing twice
Every document is recognised by its own contents, so a loop that runs again over the same mailbox quietly skips whatever it has already filed.
You can see what it did
Every run keeps a transcript. “What happened at 4am” has an answer you can read, not a log line.
Not only invoices
A loop is a schedule, an instruction and an assistant. Chase overdue quotes on Tuesday with the same machinery.