INVOICES AND E-INVOICING
Invoice data entry automation: capture every invoice only once
The invoice arrives by email. Someone enters it into the Excel list, emails the boss for approval, records it in the accounting software and, on payment day, types the IBAN and amount into online banking. The same figures four times, and each time there is that nagging feeling that a digit got swapped somewhere. Invoice data entry automation starts with exactly these repeats.

It costs more than time. An invoice paid twice sometimes only shows up at the year end close, and a missed early payment discount usually never does. And if only one colleague knows how the list works, invoice processing stops the moment she goes on holiday.
This article shows how to automate invoice data entry without rebuilding everything: capture each invoice once, protect your Excel list against duplicates today, and import the rest instead of retyping it. It includes a worked example and a clear line for when more is worth it.
Quick answer: capture once, use many times
Invoice processing without double entry means the data from an invoice is captured in exactly one place, and every other place takes it from there. Checks happen through reconciliation, not by typing everything again. There are four steps.
- Count the touch points
Write down where the same invoice is typed today, and keep a tally for one week.
- Choose one leading place
Decide where an invoice is captured. Usually that is the accounting software or a single invoice register.
- Import instead of retyping
All other places get the data by import, export or by reading the invoice file.
- Reconcile instead of entering twice
Once a month, compare the lists by supplier and invoice number. Errors show up without anyone typing everything twice.
Where does the same invoice get typed more than once?
In many small and mid sized businesses, an incoming invoice takes this route. Every row is a place where someone copies data from the invoice.
| Place | What gets typed | Better |
|---|---|---|
| Filing | File name with supplier, date, amount | Fixed naming rule or automatic filing |
| Excel invoice register | Supplier, invoice number, amount, due date | Generate the list from the leading place |
| Approval | Email to the owner with amount and supplier | Approve directly on the captured invoice |
| Accounting | All invoice data again | Import or the software's document intake |
| Banking | IBAN, amount, payment reference | Payment file from open items |
Five places do not mean five times the full effort. But each one costs time and is a source of errors of its own: swapped digits in an amount, an invoice missing from the list, an invoice paid twice. Every place you remove takes away work and a source of errors.

Invoice data entry automation: from five entries to one
1. Keep a tally for one week
Put a sheet next to the keyboard listing the places from the table, and add a mark for every entry. Note the minutes roughly. After a week you know where most of the time goes. It is often not where everyone expects, and you have a solid number instead of a gut feeling.
2. Decide on the leading place
Many businesses keep an Excel list because the books are kept by the tax adviser, or because open invoices are not visible otherwise. That is understandable. Still, decide which place holds the truth. If your accounting software has an open items list, the Excel list can be generated from it instead of being maintained in parallel. Then there are no longer two versions to argue about.
3. How do I find duplicate invoices in Excel?
As long as the list stays, protect it. Turn the range into a table with Ctrl+T. Say the supplier is in column B and the invoice number in column C: select the invoice numbers starting at cell C2, open Data > Data Validation, choose Custom under Allow and enter this formula:
=COUNTIFS($B$2:$B$2000,$B2,$C$2:$C$2000,$C2)=1
COUNTIFS counts rows where several conditions are met at the same time. If the same supplier and invoice number already exist, Excel rejects the entry. So always enter the supplier before the invoice number, and extend the range beyond row 2000 once your list grows. Important: the check only works when typing. When a value is pasted, Excel shows no message. So add a helper column with =COUNTIFS($B$2:$B$2000,B2,$C$2:$C$2000,C2) and highlight values greater than 1 via Home > Conditional Formatting > Highlight Cells Rules > Greater Than. In German Excel the function is called ZÄHLENWENNS and uses semicolons.
Keep the list lean as well. Every column nobody uses is one entry too many. These columns are enough for most businesses:
| Column | Purpose |
|---|---|
| Date received | Shows how long an invoice has been waiting |
| Supplier | Part of the duplicate key, spelled consistently, ideally from a drop down list |
| Invoice number | Part of the duplicate key, stored as text so leading zeros stay |
| Gross amount | For payment and for reconciling with open items |
| Due date and discount date | So that no deadline is missed |
| Status | Recorded, approved, paid, query open |
| File | Link or path to the invoice file, instead of copying its data again |
4. Import instead of retyping
For every place, check whether there is a way without typing. Many accounting programs have a document intake that accepts invoices by email and suggests the data. Many also create a SEPA payment file for online banking from open items, so IBAN and amount no longer need to be copied. Whether your program can do this, be it DATEV in Germany or BMD in Austria, is quickest to clarify with your tax adviser or the vendor. How data moves between programs in general is covered in transferring data between systems.
5. Reconcile once a month
Export the open items from your accounting software, filter your invoice register to unpaid invoices and compare the two in the free Excel comparison tool. Choose the invoice number as the column to match rows by. If two suppliers use the same number, add a helper column combining supplier and invoice number in both files, for example =B2&"|"&C2, and use that as the key. You see at once which invoices are only in one list or have different amounts. The files stay in your browser.
Example: 120 invoices, typed four times
| Place | Before | After |
|---|---|---|
| Excel list | 1.5 minutes | 0, generated |
| Approval email | 1 minute | 0.5 minutes, click on the invoice |
| Accounting | 2 minutes | 1 minute, check the suggestion |
| Banking | 1 minute | 0, payment file |
| Total per invoice | 5.5 minutes | 1.5 minutes |
With 120 invoices that is 660 minutes, or 11 hours a month, before and 180 minutes, or 3 hours, after. At an assumed €38 per hour including employer costs, those 8 hours are worth around €300 a month or around €3,650 a year. The saving is an estimate based on cautious assumptions. Often the hours are not the main gain: the assistant no longer has to double check every IBAN on payment day, and a stand in can follow the process. Run your own numbers in the office work cost calculator.
Common mistakes that lead to duplicate payments
- Maintaining two lists in parallel: The Excel list and accounting drift apart. One place leads, the other is generated.
- Invoices in personal inboxes: An invoice sitting in a colleague's inbox is missing from every list. Use a shared address.
- Looking for duplicates by amount only: Equal amounts are normal. Check supplier and invoice number.
- A copy by post and the original by email: The same invoice arrives twice. Record only one, note the copy and claim the input VAT only once.
- Recording a payment reminder as a new invoice: A reminder refers to an existing invoice. First check whether that invoice is already recorded or paid.
- Losing track of early payment discounts: If the list is only updated at month end, deadlines have often passed. Record invoices on the day they arrive.
If an invoice has been paid twice anyway, it is annoying but fixable: ask the supplier for a refund or to offset it against the next invoice. The monthly reconciliation means you notice within weeks, not at the year end close.
Limits: what does e-invoicing change for incoming invoices?
With 20 or 30 invoices a month, a protected Excel list and the document intake of your accounting software are usually enough. A custom automation rarely pays off then. Approval always stays with a person, and so does the question of whether the work was actually done.
E-invoices remove typing, because the data is already structured in the file. In Germany, all domestic businesses have had to be able to receive them since 1 January 2025, and an email inbox is enough. Printing is not enough: at least the structured part must be kept unaltered in its original format for eight years. The Fourth Bureaucracy Relief Act (Bürokratieentlastungsgesetz IV) cut this period from ten to eight years (section 14b of the German VAT Act, section 147 of the Fiscal Code). If an XRechnung arrives as a bare XML file nobody can read, open it in the free e-invoice viewer: it shows amount, due date, IBAN and line items like a paper invoice, recalculates the totals and checks the IBAN check digits. The file stays in your browser.
As of November 2026, Austria has no general obligation to use structured e-invoices between businesses. Invoices there mostly arrive as PDFs by email: according to a March 2025 survey by WKÖ, the Austrian Economic Chamber, and AUSTRIAPRO, 80.1% of respondents usually send electronic invoices by email, and 58.3% prefer PDF. In Austria, books and records generally have to be kept for seven years (section 132 of the Federal Fiscal Code, BAO). Details for both countries are in automating invoice processing: steps and limits.

When is an office helper worth it for invoice data entry?
It gets harder when invoices arrive in many formats, the books are kept by your tax adviser and you still need an up to date invoice register, or when invoices must be checked against purchase orders. Then a gap remains that no standard feature closes, and usually a person fills it by retyping.
An office helper collects invoices from the agreed mailbox, extracts the data, checks for duplicates and mandatory fields, and writes everything in one go to your invoice register and to an import file for accounting. Your software stays, unclear invoices are flagged for your team, and approval and payment remain with you. Read more on capturing incoming invoices automatically.
Work out what your repeated entries cost today in the office work cost calculator. With that figure, the free workflow check is quick to fill in: describe where your invoices arrive and everywhere they get typed today. Within 1–2 working days you get a personal, free assessment. At 20 or 30 invoices a month, the steps in this article are usually enough. For larger volumes you get a fixed price from €1,990 excl. VAT, and small projects are in place 3–7 days after the use case is agreed.
Sources and further reading
- Microsoft Support: ZÄHLENWENNS (Funktion)
- Microsoft Support: Anwenden von Datenüberprüfung auf Zellen
- Microsoft Support: Weitere Informationen zur Datenüberprüfung
- BMF: Fragen und Antworten zur Einführung der obligatorischen E-Rechnung
- BMF-Schreiben vom 15. Oktober 2025: Einführung der obligatorischen elektronischen Rechnung
