For US citizens abroad who fell behind on tracking their days and need to rebuild the record before they file.

1. The Problem

I filed my 2020 taxes without claiming FEIE. I didn't know it existed. A friend mentioned it that December. By the time I'd worked out that I qualified, I was DIY-amending the return in March 2022. To figure out my qualifying days I built a spreadsheet. I tracked the basics: country, city, dates, full days, costs, receipts, and any note that might save me later. I reconstructed around ten flights from Gmail boarding passes, Airbnb receipts, and cash-only stays where my own note said "paper receipt."

The column structure of my original spreadsheet (illustrative rows). The Confidence column I add in §3 Step 4 isn't here yet — that's the column I didn't have.

I told myself I'd update the spreadsheet monthly going forward. I didn't. Work crunches. A trip back to the U.S. for the holidays. A longer stay in one city. The file would sit unopened for weeks. Whenever my routine broke, the tracking broke with it. By the next tax season I was reconstructing again.

The 2020 FEIE limit was $107,600. I qualified for a partial exclusion: 113 days out of 366, starting September 10, which let me exclude $33,229 of foreign earned income from U.S. federal tax. Once I ran the numbers, the calendar mattered in a way it never had before. I kept a five-day buffer at year-end and turned down trips home when the count was tight.

The mistake isn't falling behind on tracking. That happens. The bigger mistake is assuming the record is lost once the spreadsheet stops being current. Work, family, and long stays in one place are exactly the kinds of disruptions that create FEIE risk. You need a way to rebuild the record after the routine breaks.

By the end of this guide you'll have a method to produce three things from whatever you're starting with, whether that's a full Gmail inbox, a phone, or just a vague memory of a trip to Mexico in May:

  • A travel ledger with confidence levels per row

  • An evidence folder organized for the CPA handoff

  • Your best 12-month window with foreign and US day counts

This guide doesn't decide your FEIE eligibility. That's something to review with your CPA or tax advisor. FEIE also depends on having a foreign tax home and foreign earned income. The goal here is to make sure your advisor isn't starting from a mess.

2. The Rule (Not the Whole Tax Code)

This guide only helps with one specific thing: rebuilding your physical-presence record. The full FEIE rule is broader than that. What follows is the short version of the rule your record has to satisfy. Whether you qualify is a separate decision. Your CPA makes that call. Or you do, if you're filing yourself.

The Physical Presence Test requires 330 full days in a foreign country or countries during any 12 consecutive months. The 330 don't have to be in the same calendar year. They don't have to be consecutive. You can pick the 12-month window that works best for the year you're filing.

A "full day" is midnight-to-midnight in a foreign country. The day you fly out of the U.S. doesn't count. Neither does the day you fly back in. And if a single trip between two foreign countries leaves you over international waters for 24 hours or more, those days don't count as foreign either, since you weren't in any country. In practice that's mostly a boat or long sea-crossing issue, not a normal flight or a layover on the ground.

Out of 12 months, 330 days must be abroad, which leaves about 35 days of slack. That 35 isn't a US-only allowance: US days, travel days, and any full day spent over international waters all draw from it. Family visits, weddings, business onsites, and the flights between them eat the same budget.

Even tax professionals confuse the Physical Presence Test with the Bona Fide Residence Test. The Physical Presence Test does not require the country you were in to have a U.S. tax treaty. Only the Bona Fide Residence Test does. If a generalist accountant tells you that you don't qualify because of a tax treaty issue, read IRS Publication 54 yourself. I had this exact conversation with an accountant who insisted Serbia disqualified me. It didn't.

FEIE also requires a foreign tax home and foreign earned income. Foreign earned income means compensation for personal services performed abroad. That's salary, contracting income, freelance fees. Investment gains, Social Security, and pension income don't count.

For 2025 (what you're filing in 2026), the maximum exclusion is $130,000 per qualifying person. For 2026, it's $132,900. If you qualify for only part of a year, the limit is prorated by qualifying days.

3. The Recovery Workflow

You can rebuild a year of travel from almost nothing. I've had to do it more than once, and the method is the same every time: start from the dates you can prove, work outward to the dates you can reason about, then convert the whole thing into the only unit the Physical Presence Test counts, full days. Five steps, in the order I'd run them again.

Step 1 — Anchor the timeline

Start with flights. A boarding pass is a date nobody can argue with, and it pins you to a country on a specific day. Search your email for the airlines you flew, plus the words "boarding pass," "itinerary," and "check-in." Forwarded confirmations and your calendar fill in the rest. I pulled around ten flights out of Gmail this way, including two I'd completely forgotten I took.

Each flight gives you two fixed points: the day you left one country and the day you entered another. Drop every one of them onto a calendar. Those are your anchors. Everything else fills in between them, and the gaps between two known flights are much smaller problems than a blank year.

Step 2 — Fill the gaps

Between two flights, you were somewhere, and usually you were paying to be there. Airbnb sends a receipt with check-in and check-out dates. Hotel confirmations do the same. Card statements place you by where the charges cluster: a month of grocery and coffee transactions in one city is a month of residency you can defend. Your phone helps too. The photo library is timestamped, and most photos are geotagged, so a camera roll quietly logs which country you woke up in.

The hard rows are the cash ones. I paid cash for a few stays and had nothing but a paper receipt and a note to myself. One line in my own spreadsheet just read "$1,300, paper receipt." If that's all you've got, write down what you do know, the approximate dates and the city, and flag it. We deal with the weak rows in step four. Don't skip them, and don't inflate them.

Step 3 — Convert to tax days

Now turn each row into a number: the full days in a foreign country it represents. Most rows are simple, a straight count of midnight-to-midnight days abroad. The edges are where people get it wrong.

The day you fly out of the U.S. doesn't count. The day you fly back in doesn't either, and it spends one of the roughly 35 non-foreign days you get across the window. I landed back in the States near midnight once and that whole day was still a U.S. day. This is why my notes carried flight times, especially the US arrivals and departures, so I could call those edge days right.

Count as you build the spreadsheet or all at once when you file, it doesn't matter. What matters is that the dates and flight times underneath are right. Get those wrong and the number is worthless.

Step 4 — Add the column I didn't have

Next to each row, rate how well you can prove it. I use three levels. High is anything with a date a stranger could verify: a boarding pass, an Airbnb receipt, a cluster of card charges. Medium is one weak source, or a date you're reasoning toward rather than reading off a document. Low is memory only.

This isn't busywork. The confidence column is what turns a pile of dates into something a CPA, or an auditor, can actually trust. It shows you exactly where the record is thin while you still have time to fix it, by digging up one more email or pulling one more statement. A ledger that's honest about its weak rows is worth more than one that looks clean and falls apart the moment someone asks for backup.

Step 5 — Find your best 12-month window

You don't have to use the calendar year. The Physical Presence Test lets you pick any 12 consecutive months, so the last move is sliding that window to capture your strongest 330 days.

Lay your full-day counts across a calendar and look for the densest foreign stretch. In my case the clock didn't start until I actually left, on September 10. My first qualifying window ran from that date forward, not from January 1, and it crossed into the following year: September 2020 through September 2021. That rolling window is the whole reason I could go back and amend a return I'd already filed wrong. 113 of those qualifying days landed in 2020, which prorated the exclusion for that year down to $33,229.

Try a few different start dates. Move the window by a week and the count shifts. You're hunting for the 12-month span where your U.S. days stay under 35 and your foreign days clear 330 with a little room left over.

What you have now

Three things: a travel ledger with a confidence level on every row, the supporting files gathered in one place, and the specific 12-month window you intend to claim. Later sections cover handing that off cleanly, and doing it without exposing more of your life than you need to.

One habit worth stealing from the painful version of this. I keep a five-day buffer at the end of every count. Not because the rule demands it, but because I've never once regretted the days I didn't spend cutting it close.

4. Tool Comparison

Before you go looking for an app to do this for you, it helps to know what the tools actually do. They split into two camps: ones that track your days going forward, and ones that rebuild a record you already lost. Almost all of them are the first kind. This guide is the second.

Forward trackers. Apps like Nationly (iOS) run GPS in the background, log which country you're in, and can pre-fill Form 2555 at year-end (for the physical presence test or bona fide residence). Start today and stay disciplined and you may never need a guide like this again. Some, Nationly included, will also backfill past gaps from your geotagged camera roll, which helps when your photos happen to cover the missing stretch. What none of them do is the full forensic rebuild, from boarding passes, receipts, card statements, and passport stamps, for the months your photos can't. That part is still on you.

Email parsers. Some tools, like DayProof, read your inbox for boarding passes and flight confirmations and build a timeline. Useful, with one catch worth checking: some of them count toward the 183-day general tax-residency threshold, not the 330-day FEIE physical presence test. Different rule, different math. Before you trust any tool's number, confirm it's counting full foreign days against 330, not residency days against 183.

Day-count calculators. FEIE Calc and similar do the math once you hand them your trips. They count correctly. They just don't find the trips for you, which is the actual hard part of reconstruction.

The spreadsheet. What this guide teaches. It's the only one of these that takes a messy, multi-year history from scattered sources, boarding passes, receipts, card statements, photos, and turns it into a defensible ledger plus an evidence folder. No app rebuilds the past from nothing the way a person working backward through their own records can.

I'm not affiliated with any of these, and I don't have a favorite. The honest split is simple. If you're trying to stay clean going forward, pick a tracker and move on. If you're rebuilding a record you already let slip, which is probably why you're here, the spreadsheet plus the method in this guide is still the answer. Don't over-tool a job you'll do once. Reconstruction is a one-time push, not a subscription.

(One note: tools change fast. This reflects what each did as of 2026, and none of it is an endorsement. Confirm current features yourself before you rely on one.)

5. The CPA Handoff Packet

A reconstruction isn't finished when the spreadsheet balances. It's finished when it's in a form someone can file from, whether that someone is your CPA or you. That package is four things.

The ledger. One row per stay: country, city, dates, the full-day count, and the confidence level. This is the workflow's output, cleaned up. It's the spine of everything else.

The window summary. One line at the top: the exact 12-month window you're claiming, your total foreign full days, your total US and travel days, and confirmation that the foreign number clears 330. Whoever files should be able to read your conclusion in a few seconds, then check your work underneath it.

The evidence folder. The supporting documents, named so they map to the ledger rows. Boarding passes, Airbnb and hotel receipts, the card statements that placed a fuzzy month, the photos that timestamped a gap. Back your low-confidence rows the hardest. Those are the ones that get questioned, so those are the ones that need a document attached.

A short cover note. A paragraph: what you did, which window you chose and why, and where the record is genuinely thin. Don't hide the weak rows. Flagging them yourself is what makes the strong ones believable.

Hand this to a CPA and the packet keeps the bill down: a CPA charges for judgment, not for sorting your shoebox, so you pay only for the part that needs a professional. File it yourself and it's what you work Form 2555 from, line by line.

Either way, keep the whole folder after you file. I kept mine, not because anyone asked, but because the one time the IRS comes back with a question, it lands years later, long after the details have left your head. The packet is the version of your memory that doesn't fade. That's the real reason the confidence column and the evidence exist. Not to file. To still be able to answer.

6. Privacy: Doing This Without Oversharing

The packet you just built is a concentrated map of where you've been and what you spent. That's useful for proving your days. It's also more of your life in one folder than you'd hand most people. A few rules keep it from leaking.

Share the conclusion and the backup, not your whole life. Whoever files needs your ledger, your window, and the documents that support the days. They do not need every line of every bank statement. Pull the transactions that place you in a city and leave the rest out.

Redact before you send. A card statement proves location with a merchant name and a date. It doesn't need your full account number or the unrelated purchases around it. Black those out. Same with boarding passes: the route and date do the work, not your frequent-flyer or passport numbers.

Know what the tools keep. A GPS tracker logs your location around the clock. An email parser reads your inbox. A photo backfill scans your whole camera roll. That's a real trade of privacy for convenience. If it's worth it to you, fine, but make it a choice, not an accident, and check where that data lives.

The IRS needs the count, not the dossier. Form 2555 asks for travel dates and a tax home. Keep the full evidence folder for yourself, as your answer if a question ever comes. You don't volunteer the rest.

Then store the folder like what it is: a sensitive record of your movements and money. Keep it somewhere private, and share copies on purpose, not by reflex.

7. What I'd Do Differently + the 20-Minute Monthly Routine

The reconstruction worked. I'd still rather have never needed it. Three things I'd change.

Track from day one. The spreadsheet was never the problem. Letting it go quiet was. The pain in this whole guide comes from the months I didn't log, not from the logging. A record kept current is twenty minutes a month. A record rebuilt from scratch is a weekend with your old boarding passes. Same data, very different cost.

Pick the right tier of help, once. Before I filed, I went through three people. A specialist who got the rules exactly right and was priced for someone with a far more complicated situation than mine. A generalist who was competent and quoted around five hundred dollars. And someone cheap and close to me who got a key rule wrong and nearly talked me out of qualifying at all. The trap is that middle option: an accountant who hasn't specialized in expat tax will either hesitate or be confident and wrong. If your situation is simple, a W-2, no business, few investments, the DIY path works as long as you read Publication 54 yourself. If it's genuinely complex, pay the specialist. What doesn't work is splitting the difference.

Give people less. I handed all three of them my full financials before I ever filed. They didn't need most of it, and by the time I'd shopped around, my whole picture was sitting in three different inboxes. Now I'd send the ledger and the documents that support the days, and nothing else.

Then, the routine that ends all of this. Once a month, twenty minutes:

  • Open the ledger and log the month while it's fresh. Dates in and out, cities.

  • Drop the month's boarding passes and receipts into the folder.

  • Update the confidence column. Anything you can't back yet, fix it while you still remember.

  • Glance at your rolling twelve-month count and your buffer.

That's the whole thing. The expensive version is this guide: a weekend rebuilding a year from boarding passes and receipts. The cheap version is twenty minutes a month you won't even notice. Same $33,229 on the line either way. Only the weekend was optional.

8. What to Do Next (+ the Fine Print)

You now have the whole method: a travel ledger with a confidence level on every row, an evidence folder organized for handoff, and the specific twelve-month window you're going to claim. That's the hard part done.

One thing before you go. I'm collecting the messy edge cases people hit with this: the layover you can't place, the cash month with no paper trail, the window that won't quite clear 330. The ones that come up most are what I write about next. If you want those, subscribe and tell me the trickiest part of your own reconstruction. I read every one.

The fine print, because it matters here. I'm not a CPA, an accountant, or a lawyer, and none of this is tax, legal, or financial advice. It's the method one person used to rebuild a record and file. Whether you actually qualify for the FEIE depends on your own facts: your tax home, your foreign earned income, the days you can defend. Confirm it with a qualified professional, or by reading IRS Publication 54 yourself, before you file anything. The dollar limits, the forms, and the tools in here all change year to year. Check the current numbers against the IRS before you rely on them.

That's it. Go rebuild your year.

Keep Reading