Many globally mobile people default to a spreadsheet. On paper, it looks like an organised and responsible way to count days. But there’s a difference between counting days and proving them.
A spreadsheet introduces human error and compliance risk because, as Richard says, “You can’t… prove that it wasn’t faked. Prove that it was timestamped. You need that.”
And so, if authorities challenge a day count for tax residency claims, you’re suddenly having to build a casefile to support that spreadsheet.
“Putting together a record of everything you’ve done over a period of time… is enormous,” Richard says. “It’s best done in a contemporaneous way.”
Richard gives a telling example of how granular enquiries can become:
“HMRC asks for a copy of an email to prove where the email was sent… then they say, ‘No, you sent me a PDF. I need to see the actual email.'”
Whether common or not, it signals the direction of travel: when questions arise, the burden sits with the individual and their advisers to answer clearly and quickly.