Keep freelance invoices and transfers organised

Short answer

Euro invoice tracking for freelancers means knowing, for every invoice you sent, which bank transfer paid it, how much is still open and what is overdue. The reliable way is to compare your open invoices with your bank credits using the invoice number in the transfer reference. DIGITAL EUR's free browser demo does this matching today; saved tracking is planned.

What does euro invoice tracking actually involve?

Most freelancers already have a list of invoices: a spreadsheet, an invoicing app or a folder of PDFs. The list says what was sent. Tracking means keeping a second, more important fact up to date: what was received, and from which payment.

That sounds trivial until the bank statement arrives. Freelancers paid by bank transfer meet the same small set of complications again and again:

• The client pays without the invoice number. The transfer says "web design" or "October", or only shows the client's name.
• The payer is not the client. An agency pays on behalf of its customer, or a parent company pays for its subsidiary.
• One transfer pays two invoices. Common with retainers and with clients who batch their supplier payments.
• A transfer arrives short. A deposit, an instalment, or an international payment with bank charges taken on the way.
• A transfer arrives that matches nothing. A refund, a private payment, a platform payout or a mistake.

Every one of these is easy to handle once. The problem is handling them consistently, month after month, while also doing the paid work. When status lives in a column you tick by hand, there is no record of why an invoice was marked paid, and a wrong tick means a client is chased for money they already paid, or an unpaid invoice is forgotten.

Good tracking therefore needs three things: a reference discipline that makes payments identifiable, a regular routine that compares invoices with bank credits, and evidence for every "paid".

What works today, and what is planned?

DIGITAL EUR never holds or moves money. It only compares files and records your decisions.

Is this for you?

It fits freelancers who:

• invoice in euro and are paid mainly by bank transfer (SEPA credit transfers from clients in the euro area and beyond);
• have somewhere between a handful and a few dozen incoming payments a month;
• work with retainers, deposits or milestone payments, where partial payments are normal;
• hand their records to an accountant and want to show which transfer settled which invoice.

It is not the right tool if you want an all-in-one invoicing app that creates invoices, accepts card payments and files taxes, or if almost all of your income comes through a platform that already marks invoices as paid. It also does not replace your accountant or give tax advice.

How do you track euro invoices in a 20-minute weekly routine?

The routine below works with any invoicing tool and any bank that can export transactions.

1. Number every invoice uniquely and visibly. Use a format that is hard to confuse, for example INV-2026-031. Put it on the invoice next to the words "Payment reference".
2. Make the payment details unambiguous. Show the IBAN and the account holder name exactly as your bank holds them. Since 9 October 2025, payment providers in the euro area check the payee name against the IBAN before a transfer is sent (verification of payee), so a trading name that differs from the account name can trigger a warning on your client's side.
3. Ask for the reference explicitly. One sentence in your email helps more than any tool: "Please quote INV-2026-031 as the payment reference."
4. Export open invoices as CSV. The demo expects the columns invoice_id, customer_name, currency, amount_due, reference, and optionally customer_iban. For a part-paid invoice, enter only the amount still open.
5. Export last week's bank credits. Columns: transaction_id, currency, amount, remittance, direction (CRDT for money in), plus counterparty_name and counterparty_iban if your bank provides them. Use commas as separators and a dot for decimals; convert first if your bank uses semicolons or decimal commas. Each file can be up to 2 MB and 20,000 rows.
6. Run the matching in the Reconciliation Lab. Review the suggestions from the highest score down.
7. Approve what the evidence supports. Leave anything doubtful open. An approval needs your name and is time-stamped.
8. Export and update your list. Download the approved allocations, then update your invoice list or invoicing app. Keep the export with the bank statement.
9. Act on what is left. Invoices past their due date with no matching payment are your follow-up list for the week. This is the simplest honest way to track unpaid invoices: unpaid means "no approved bank credit", not "nobody ticked it yet".

Use synthetic or anonymised data in the demo: it runs entirely in your browser, uploads nothing, and is not intended for confidential client files. Reloading the page discards the session. Our security page explains what is and is not in place.

A worked example: a freelance developer's week

The data below is synthetic. The rules are the ones the demo applies: an invoice reference found in the transfer text adds 65 points, an exact amount 20, a matching payer IBAN 10 and a matching payer name 5. A payment smaller than the open amount subtracts 15, a larger one subtracts 25. Without reference, IBAN or name evidence, no suggestion is made at all, however well the amount fits.

Open invoices:

Bank credits this week:

Result:

What the example shows: a consistent reference and a stored client IBAN do most of the work; a combined payment is handled without guessing; and a short payment is visible instead of being silently rounded to "paid".

What should a freelance invoice tracker record?

Whatever tool you use, these fields make the weekly routine fast and leave evidence behind. The right-hand column explains why each one earns its place.

Common mistakes in freelance invoice spreadsheets, and how to avoid them:

• Ticking "paid" when the client says they have paid. Wait for the bank credit; a payment announced is not a payment received.
• Overwriting the amount on a partial payment. Record the payment as a separate line, so the original invoice total remains visible.
• Spelling a client's name three ways. Use the legal name from the contract or the first bank credit, consistently.
• Re-using invoice numbers across years or projects. A reference that appears twice cannot prove anything.
• Matching by amount alone. Two clients can pay €900 in the same week. The demo deliberately refuses to suggest a match on amount alone for this reason.
• Doing it only at year end. Reconciling twelve months of transfers at once turns small questions into lost evidence. Weekly is easier than yearly.

Spreadsheet, invoicing app or reconciliation step?

You do not need to replace your invoicing tool. Matching is a separate step that makes whatever tool you use more accurate.

What can you do when a client pays late?

Tracking tells you who has not paid; it does not collect the money. For business-to-business invoices in the EU, the Late Payment Directive (2011/7/EU) sets the baseline: payment terms between businesses should generally not exceed 60 days unless expressly agreed and not grossly unfair to the creditor; statutory late-payment interest is at least eight percentage points above the ECB reference rate; and the creditor is entitled to a fixed minimum of €40 for recovery costs. National rules implement the directive and a revision has been proposed, so check your country's current rules or ask an adviser before relying on them. This is general information, not legal advice.

A calm follow-up sequence usually works better than anything legal: a friendly reminder shortly after the due date, a firmer one with the invoice attached, then a call. Planned reminder drafting is described on the collections page, and a reminder text generator is part of our tools section.

What changes when you are getting paid in euros from a client abroad?

Clients elsewhere in the euro area usually pay by SEPA credit transfer, which carries up to 140 characters of reference text, enough for an invoice number. Clients in SEPA countries outside the euro area, or outside SEPA altogether, may pay via an international route where charges or currency conversion change the amount you receive. The demo only pairs an invoice and a payment in the same currency. The cross-border payments page covers this in more detail, including what to put on the invoice.

What are the honest limitations?

• Demo, not a service. No accounts, no saved history, nothing to subscribe to yet.
• Exact name matching. "Northwind Holding GmbH" does not match "Northwind GmbH"; record the client's IBAN instead.
• Strict reference matching. The full reference must appear as a token; INV-12 never matches INV-123, and references shorter than four letters or digits are ignored.
• One currency per pair. No foreign-exchange matching.
• No write-offs. Short payments stay partly open; the accounting decision is yours.
• No tax or VAT logic. The demo does not know about VAT, reverse charge or income tax.

What will it cost?

Nothing can be bought yet. The pricing page shows illustrative pre-launch plans; the Solo plan at €19 a month (up to 100 matched transactions) is the one designed for a freelancer, and prices may change before launch.

Frequently asked questions

Do I need invoicing software to track euro invoices?

No. A clean list of open invoices with unique numbers is enough. What matters is comparing it with your bank credits regularly and keeping evidence of each match.

What should I write as the payment reference?

Your invoice number in a distinctive format, such as INV-2026-031, labelled "Payment reference" on the invoice. A structured creditor reference (RF reference, ISO 11649) is also recommended by the European Payments Council if your bank can generate one.

How do I track a partially paid invoice?

Record each payment against the invoice and keep the remainder open. In the demo, an approval can never allocate more than the invoice's open amount, so the balance stays visible.

Can I use a spreadsheet as a freelance invoice tracker?

Yes, at low volume. Add a column for the bank transaction that paid each invoice, not just a "paid" tick, so that every status has evidence behind it.

Does DIGITAL EUR connect to my bank account?

No. You export a CSV from your bank and load it in the browser. Bank connections would need a licensed partner and are not offered.

Is my client data uploaded?

No. The demo reads files in your browser tab and stores nothing. Still, use synthetic or anonymised data, because it is a demonstration.

Can my accountant use the results?

Yes. The export lists each approved invoice–payment allocation with the approver and time. See the page for accountants.

Sources

• European Central Bank, Instant Payments Regulation — verification of payee from 9 October 2025 in the euro area (accessed 5 November 2026)
• European Payments Council, SEPA Credit Transfer Rulebook 2025 v1.0 — 140-character remittance information; ISO 11649 creditor reference recommendation (accessed 5 November 2026)
• EUR-Lex, Directive 2011/7/EU on combating late payment in commercial transactions (accessed 5 November 2026)
• EUR-Lex, Summary: combating late payment in business dealings (accessed 5 November 2026)
• European Commission, Late payment — revision proposal context (accessed 5 November 2026)