How to Track Days Across Countries for Tax Residency (And Why Most Methods Fail)
If you split time between countries, you need an accurate day count for every jurisdiction where you spend time. Tax authorities determine residency based on physical presence. The IRS uses a weighted 3-year formula. HMRC uses a ties-and-days matrix. The Schengen Area uses a rolling 180-day window. Get the count wrong and you trigger tax obligations you didn't expect.
Most people track days on a spreadsheet, in their head, or with a GPS app. All three methods fail in predictable ways.
Quick summary: Spreadsheets can't handle rolling window calculations reliably. GPS tracking apps miss days when battery is low, cellular data is off, or background permissions are revoked. Mental math breaks down after a few months. The method that works is manual entry with a system that applies the correct rules for each country. Whatever you use, keep records that match what tax authorities will check: passport stamps, boarding passes, and a daily location log.
Why do spreadsheets fail for day tracking?
Spreadsheets are the most common tracking method. They are also the most dangerous.
A basic spreadsheet can count days between two dates. But residency rules are not basic. The Schengen 90/180 rule uses a rolling window that looks backwards 180 days from every single day of your stay. The US Substantial Presence Test applies a weighted formula across 3 calendar years. The UK SRT cross-references days with ties and adjusts thresholds based on your prior 3 years of residency history.
Building a formula that correctly calculates a rolling 180-day window in Excel or Google Sheets is possible. Trusting that formula after 6 months of edits, copied rows, and shifted date ranges is a different question.
The failure mode is silent. A broken formula does not flash a warning. It just gives you the wrong number. You plan your travel around that number. Six months later, you discover the count was off because a cell reference shifted when you inserted a row in March.
I tracked my days on a spreadsheet for two years. It was wrong for six months before I noticed. By the time I found the error, the damage was done. I couldn't un-spend those days.
Why do GPS tracking apps miss days?
GPS-based day trackers promise "set it and forget it." Install the app, grant location permissions, and it logs where you are automatically. In theory, this solves the problem of forgetting to record a trip.
In practice, GPS tracking has documented failure modes:
Battery and permissions. GPS apps need background location access, cellular data, and sufficient battery to function. When any of these fail, the app stops logging. It does not tell you it stopped. One Flamingo user reported that the app logged only 18 days over 8 months despite granting all background permissions.
Accuracy errors. Another Flamingo user tracking days between Florida and Minnesota found the app recorded 7 nights in their home state when the actual number was 29. The core count was wrong by a factor of four.
Border accuracy. Cell tower-based location can place you in the wrong state or country, particularly near borders. The CPA Journal documented that New York State auditors using cell phone records found tower pings that inaccurately placed people in neighboring states.
Pricing confusion. Some GPS apps use tiered pricing that locks features behind higher subscriptions. Users have reported that features available during a free trial disappeared after they paid for a lower tier.
The fundamental problem with GPS tracking is that when it fails, it fails silently. You don't know your count is wrong until you check it against your passport stamps, and by then the records you needed are months out of date.
What tracking method actually works?
Manual entry with rule-aware software.
You enter your trips: country, arrival date, departure date. The software applies the correct rules for each jurisdiction. Schengen rolling window. US SPT weighted formula. UK SRT ties matrix. UAE 183-day cumulative count.
Manual entry means every trip exists because you recorded it. There is no gap where the GPS lost signal. There is no silent failure where the app stopped logging. Your data is as accurate as what you entered.
The trade-off is obvious: you have to remember to log your trips. That is a real limitation. But forgetting to log a trip is a problem you notice. A GPS tracker that silently missed 5 months of data is a problem you don't notice until it's too late.
What records do tax authorities actually check in an audit?
This matters more than most people realize. Your day count is only as good as the evidence behind it.
HMRC (UK) is the most explicit about what they expect. According to the RDR3 guidance, you should keep a daily diary of where you are, noting specifically whether you were in the UK at midnight. They also want travel documents, records of hours worked in the UK, and evidence of accommodation arrangements.
The IRS (US) is surprisingly vague. Publication 519 does not list specific documentation for proving daily presence. But the obligation to prove your count exists. In practice, auditors accept passport stamps, flight records, boarding passes, and credit card statements showing location-based transactions.
New York State is the most aggressive. According to the CPA Journal, NYS auditors routinely subpoena cell phone carrier records. They separate voice and data transmissions chronologically to establish your location on every day of the year. They also request credit card statements, E-ZPass toll records, appointment calendars, and social media activity.
The standard across all jurisdictions: contemporaneous records. A log written at the time carries more weight than a reconstruction from memory months later. Passport stamps plus a daily location diary plus credit card records is the combination that holds up.
Keep records for at least 7 years. Tax authorities can audit several years back, and you need evidence for the full lookback period.
What should I look for in a day tracking tool?
Based on how residency rules actually work and what auditors accept, a useful tracker needs these things:
Multiple rule engines. You probably track days against more than one rule. Schengen 90/180 and UAE 183-day. Or UK SRT and US SPT. A tool that only counts total days per country is not enough. It needs to know that Schengen uses a rolling window, the US uses a weighted formula, and the UK uses midnight presence.
Manual entry. You enter the trip. You verify the data. No GPS dependency means no silent failures.
Historical tracking. The US SPT looks back 3 years. The UK SRT checks your prior 3 years of residence history. The Schengen window rolls back 180 days. Your tool needs your full travel history, not just the current year.
Export capability. When your tax advisor or accountant asks for your day counts, you need a clean export. CSV for spreadsheet analysis. PDF for audit documentation. If the export is messy, your advisor won't use it.
Privacy. Your travel history is sensitive data. Where you spend your days, how long you stay, which countries you visit. A tool that stores this on a remote server creates a data exposure you don't need. Local storage means your data stays on your device.
I built Jetseen with all of these in mind. 12 built-in rule engines. Manual-first entry. Full travel history. CSV and PDF exports your advisor can use directly. Local-only storage with no GPS and no cloud.
FAQ
What is the best way to track residency days across countries? Manual entry into a tool that understands the specific rules for each country. Spreadsheets break with complex rules like rolling windows. GPS apps miss days silently. A purpose-built tracker with country-specific rule engines gives you the most reliable count.
Do tax authorities accept app data as proof of residency days? No source confirms that app location data has been accepted as primary evidence in an audit. Tax authorities rely on passport stamps, flight records, boarding passes, credit card statements, and daily location logs. Your tracker helps you maintain an accurate count, but your proof should include official records.
How long should I keep my travel records? At least 7 years. Tax authorities can audit multiple years back, and the US SPT uses a 3-year lookback. The longer you keep records, the better protected you are.
Can I use passport stamps to prove my day count? Passport stamps are accepted evidence, but they are not always reliable. Not every border crossing produces a stamp (especially within the Schengen Area or when using automated e-gates). Supplement stamps with flight records and boarding passes.
Why can't I just use a spreadsheet? You can, but the risk is high. Spreadsheets can't reliably calculate rolling windows (like the Schengen 90/180 rule) without complex nested formulas. One shifted cell reference corrupts months of data silently. If your tax situation depends on an accurate count, a spreadsheet is the weakest link.
Sources
- IRS Publication 519 (2025) — U.S. Tax Guide for Aliens
https://www.irs.gov/publications/p519 Official IRS guidance on residency status. Notably sparse on specific documentation requirements for proving daily presence.
- HMRC RDR3 — Statutory Residence Test Guidance
https://www.gov.uk/government/publications/rdr3-statutory-residence-test-srt/guidance-note-for-statutory-residence-test-srt-rdr3 HMRC's explicit recommendations on record-keeping: daily diary, travel documents, work hour records.
- CPA Journal — Cell Phone Records for Statutory Residence (2017)
https://www.cpajournal.com/2017/03/20/slt-proper-utilization-cellphone-records-determine-statutory-residence/ Documents how NYS auditors subpoena and use cell phone carrier records in residency audits.
- HBK CPA — State Residency Audits: How to Prepare
https://hbkcpa.com/insights/state-residency-audits-how-to-best-prepare-yourself-for-the-audit-process/ Guidance on documentation and preparation for state residency audits.
- Anchin CPA — Proving Residency to State Auditors
https://www.anchin.com/news-press/proving-residency-in-a-low-tax-state-to-state-auditors/ Why 183 days in a new state is often not enough, and what totality of evidence auditors examine.
- Monaeo Blog — Cell Phone Records in Tax Audits
https://blog.monaeo.com/when-the-tax-auditor-subpoenas-your-cell-phone-records How cell tower data is used in audits and its accuracy limitations near state borders.
- EU Commission — Short-Stay Calculator
https://home-affairs.ec.europa.eu/policies/schengen/border-crossing/short-stay-calculator_en Official EU tool for checking Schengen 90/180-day compliance.