Reconciling e-Fatura Data with Your Client's Books Without Losing Your Mind

It's the 9th of the month. You've just closed the invoice processing for a client, and on a whim you open the e-Fatura portal to double-check. There are six invoices there that aren't in your books. Two you recognize — the client forgot to forward them. The other four you have never seen. One is from a supplier the client swore they stopped using in January.

Now you have a decision. Do you include them? Ask the client? Submit without them and correct later? It's the 9th. The SAF-T deadline is the 12th.

This is the reconciliation problem. Every Portuguese accountant deals with it, and most deal with it badly — not because they lack skill, but because the workflow around it is improvised every month. The SAF-T Portugal guide covers the submission mechanics that make this reconciliation necessary.

What e-Fatura Actually Tells You

The e-Fatura portal, operated by AT, shows two things that matter to accountants:

Invoices communicated by suppliers where your client's NIF appears as the buyer. Every Portuguese supplier with organized accounting is required to communicate the invoices they issue. If they issued an invoice to your client, AT knows about it — usually within a few days.

Invoices issued by your client (if they're on the supplier side of any transaction). Same mechanism, reversed.

What e-Fatura does not tell you:

• Whether the client actually received the invoice
• Whether the invoice is legitimate business expense or personal
• Whether it was already booked under a slightly different NIF or date
• Whether the supplier communicated it with errors

So the goal of reconciliation isn't "make my books match e-Fatura." That's naive. The goal is: for every document AT knows about, I know whether it belongs in this client's books and why.

Where the Mismatches Actually Come From

Before walking through the workflow, it helps to know what you're looking at. In our experience, reconciliation gaps fall into five buckets:

1. Client forgot to forward. The most common. The invoice exists, the client has it, they just didn't send it.
2. Supplier communicated wrong NIF. A supplier invoiced the owner personally instead of the company (or vice versa). Shows up in e-Fatura under the wrong taxpayer.
3. Timing lag. The invoice was issued late in the month, the client received it in the next month, and it's legitimately a next-period document. e-Fatura shows it now; the client's books will show it later.
4. Already booked under a different reference. Duplicates hiding in plain sight — same invoice, different filename, different date entered.
5. Not actually an expense. Personal purchases where the client typed in their NIF out of habit. These should not be booked, but they're in e-Fatura.

Each bucket needs a different response. Lumping them together is where the afternoon disappears.

The Monthly Workflow

1. Pull e-Fatura before you think you're done

Counterintuitive but important: don't reconcile at the end. Reconcile before you close the month. If you treat e-Fatura as a final audit step, you'll keep finding surprises on the 11th, which is exactly when you don't want surprises.

Our recommendation: pull e-Fatura data on the 5th-7th of the month, when the bulk of the previous month's invoices should have been issued. Anything that arrives later you chase actively rather than discovering it by accident.

You can pull the data manually by logging in and exporting the CSV, or — for clients with authorized access — you can pull it through the e-Fatura API if your tooling supports it.

2. Match by NIF + invoice number + date, not by amount

Amount matching is where most reconciliation tools go wrong. Two invoices from the same supplier for €120 on similar dates will match each other even if they're completely different documents.

Match in this order:

• NIF of issuer (exact match required)
• Invoice number (exact match; watch for prefixes like FT, FS, series codes)
• Issue date (±3 days tolerance for data entry slop)
• Amount (use as tiebreaker, not identifier)

What you want at the end of this matching pass is two lists: "in both," and "in e-Fatura only." The "in books only" list also exists but is less urgent — those are invoices the supplier hasn't communicated yet, which is their problem, not yours.

3. Triage the e-Fatura-only list

This is where the five buckets come in. For each unmatched invoice in e-Fatura:

• Recognizable recurring supplier? (EDP, Vodafone, renda, seguros, Segurança Social). Almost certainly bucket 1 (client forgot). Add to the "please forward" list for the client.
• Supplier the client doesn't recognize? Could be bucket 2 (wrong NIF) or bucket 5 (personal). Ask the client directly with a screenshot.
• Issue date within the last week of the month? Likely bucket 3 (timing). Flag for next month.
• Amount similar to something already booked? Check bucket 4 (duplicate). Look for the same supplier with a different filename or slightly different reference.

The key discipline: one round of client questions, not three. Batch everything the client needs to confirm into a single message. Three separate "can you check this?" emails will get two replies and the third will be ignored.

4. Send the client a structured confirmation, not a question

Instead of "I'm missing some invoices, can you check?", send something like:

According to e-Fatura, the following invoices were issued to [company] in March but I haven't received them yet. Can you confirm which category each falls into?

1. EDP — €87.34 — 14/03 — I assume this exists, please forward
2. [Unknown supplier] — €245 — 22/03 — Do you recognize this supplier? If personal, let me know and I'll ignore it.
3. Restaurante X — €45 — 30/03 — Business expense or personal?

A structured list gets answered. An open question doesn't.

5. Document what you ignored, and why

For every e-Fatura line you decided not to book, leave a short note. "Personal purchase — confirmed by client 08/04." "Next period — booked in April." It takes ten seconds per line and saves a future you from reopening the same question.

If AT ever comes asking, "why does your client's books not include this invoice that was communicated?", you want an answer ready. Usually they won't ask. But when they do, "I don't remember" is the worst possible answer.

6. Track the patterns

After three or four months, patterns emerge per client. This client always forgets EDP. That client has a spouse who uses the company NIF at restaurants. Another one has a supplier that consistently communicates invoices late.

Write the patterns down somewhere you'll actually read them — a note in the client file, a line in your CRM, whatever works. Next month, when you reconcile, check the known pattern first. Five minutes saved per client per month is an hour a week across a small practice.

What to Do Differently

The accountants we work with who have clean reconciliation aren't doing anything exotic. They're doing three boring things consistently:

They pull e-Fatura early, not late. Treating it as a midpoint check rather than a final audit flips the dynamic — you're asking clients to confirm five invoices when there's time to respond, not chasing ten invoices at 5pm on the 11th. This fits neatly into the broader monthly close checklist for Portuguese accountants, which maps every obligation — including the e-fatura reconciliation step — to the specific day it belongs on.

They batch client questions. One message per month with a structured list, not a drip of "one more thing." Clients respond to lists. They ignore drip messages.

They document ignore decisions. Every e-Fatura line that didn't make it into the books has a one-sentence note. Not for AT's sake primarily — for next month's sake, when the same question comes up again. Clean monthly reconciliation also makes year-end far easier: the IES and SAF-T year-end reconciliation guide explains how twelve months of tidy e-fatura data translates directly into an IES filing that doesn't generate surprises.

For the mechanical parts — matching NIFs, flagging duplicates, exporting reconciliation reports — automation helps. But automation won't fix a process that doesn't exist. Build the monthly rhythm first, then let the tools take over the boring parts.

If you're running this reconciliation for several clients each month, the time adds up. See how Faturiza handles multi-client e-Fatura cross-checking — built for accountants on /para-contabilistas. And if you want the broader context on what AT actually checks beyond e-Fatura, the SAF-T survival guide is a good companion read.

Part of our SAF-T & Compliance guide series.