How to Track Days Spent in Each Country (and Why Spreadsheets Fail)

If you split your time between countries, you need to know exactly how many days you have spent in each one. Tax authorities want this information. Immigration officers want it. And if you ever apply for residency or citizenship somewhere, you will need a documented history going back years.

Most people start with a spreadsheet. It works fine for the first month or two, and then it does not.

What a spreadsheet gets wrong

A spreadsheet captures a snapshot. You enter your dates, run a formula, and get a number. The problem is that many countries use a rolling window (like the Schengen 90/180 rule, or Brazil's rolling 12-month test). A rolling window means the relevant period shifts forward every single day. The count you calculated yesterday is already wrong today because a new day entered the window and an old day may have dropped off the back.

You can build a spreadsheet that handles this. People have. It involves SUMPRODUCT formulas, date range checks, and conditional logic for each country's specific measurement period. You end up maintaining a complex formula set alongside your raw data, and one wrong cell reference means your counts are silently incorrect for weeks.

The second problem is that a spreadsheet does not warn you. It calculates on demand, when you open it and look. If you are traveling and forget to check for a week, you might cross a threshold without realizing it. There is no alert, no notification, no "hey, you're at 178 days in Spain."

What actually works

Good day tracking for multi-country travelers needs three things:

It needs to calculate automatically and in real time. The counts should update every day without you opening anything or running a formula. When you check, the numbers are current.

It needs to understand different counting rules. Calendar year, rolling 12 months, fiscal year. Each country defines its window differently, and a single tool needs to handle all of them for any country you have visited.

It needs to alert you proactively. The whole point of tracking is to avoid crossing thresholds by accident. If a tool only tells you the count when you ask, you are relying on yourself to remember to ask. An alert that fires at 170 days gives you time to adjust your plans.

What you should actually log

The minimum useful data point is a date and a country, logged every time you cross a border. That is it. From that, you can reconstruct your entire presence timeline: you were in Country A from the date of your entry until the day before you entered Country B.

Some people try to track entry and exit dates as pairs, but this creates gaps. If you fly from Germany to Thailand with a layover in Dubai, do you log Dubai? What about the travel day itself? Pair-based tracking forces you to make these judgment calls every time and to remember to close out every trip.

A simpler model: log the date you arrive somewhere. The system infers you were there until you log your next arrival elsewhere. No gaps, no ambiguity, one input per border crossing.

GPS tracking vs. manual logging

Several apps offer GPS-based tracking that logs your location automatically. This sounds appealing, but it comes with trade-offs. Battery drain is one. Privacy is another, since you are giving an app continuous access to your precise location. And GPS tracking often generates noisy data near borders. Living in a city near a border can produce phantom border crossings from GPS drift.

Manual logging, where you enter a country and date when you actually cross a border, is less convenient but more accurate. You know when you crossed. The GPS does not always.

Start now, not later

The worst time to start tracking is after a tax authority sends you a letter asking to document your physical presence for the last three years. At that point, you are reconstructing from passport stamps (which are often illegible), flight records (which show bookings, not actual travel), and hotel receipts (which you probably did not save).

If you start logging today, you will have a clean, timestamped record that grows as you travel. BorderLog stores your entries and runs all the calculations. You log a date and country at each border, and the dashboard shows you exactly how many days you have in every country across every relevant time window.