Continue to WhatsApp?

The chat opens in WhatsApp, in the app or in a new tab. You leave our website, and data such as your IP address is sent to WhatsApp (Meta).

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.

Office worker at two screens showing an email inbox and messages, where incoming invoices arrive
Photo: Patrick Amoy on Unsplash

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.

  1. Count the touch points

    Write down where the same invoice is typed today, and keep a tally for one week.

  2. Choose one leading place

    Decide where an invoice is captured. Usually that is the accounting software or a single invoice register.

  3. Import instead of retyping

    All other places get the data by import, export or by reading the invoice file.

  4. 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.

Typical double entry touch points
PlaceWhat gets typedBetter
FilingFile name with supplier, date, amountFixed naming rule or automatic filing
Excel invoice registerSupplier, invoice number, amount, due dateGenerate the list from the leading place
ApprovalEmail to the owner with amount and supplierApprove directly on the captured invoice
AccountingAll invoice data againImport or the software's document intake
BankingIBAN, amount, payment referencePayment 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.

Office worker at two screens showing an email inbox and messages, where incoming invoices arrive
Photo: Patrick Amoy on Unsplash

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:

Columns of a lean invoice register
ColumnPurpose
Date receivedShows how long an invoice has been waiting
SupplierPart of the duplicate key, spelled consistently, ideally from a drop down list
Invoice numberPart of the duplicate key, stored as text so leading zeros stay
Gross amountFor payment and for reconciling with open items
Due date and discount dateSo that no deadline is missed
StatusRecorded, approved, paid, query open
FileLink 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

Effort per invoice before and after (assumed values)
PlaceBeforeAfter
Excel list1.5 minutes0, generated
Approval email1 minute0.5 minutes, click on the invoice
Accounting2 minutes1 minute, check the suggestion
Banking1 minute0, payment file
Total per invoice5.5 minutes1.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.

Untidy stack of invoices and receipts still waiting to be recorded
Photo: Camilo Rueda López on Unsplash

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

FAQ

Quick answers.

How do I automate invoice data entry?

Start with one shared address for all invoices and a single place where invoices are captured. Then replace every further entry with an import, an export or by reading the invoice file. A monthly reconciliation replaces typing everything twice. Checks and approvals stay as fixed steps with your team, so nothing is paid without a person signing off.

Do I need a separate invoice register in Excel?

No, neither German nor Austrian law requires a separate Excel list. Invoices must, however, be fully recorded in your accounts. An Excel list can help you keep track of open invoices. If you keep one, generate it from your accounting software rather than typing it in parallel. Check the details with your tax adviser.

How do I find duplicate invoices in Excel?

The most reliable way is COUNTIFS on supplier and invoice number. A result greater than 1 means the combination appears more than once. As a data validation rule, the formula blocks duplicates when typing. It does not catch pasted values, so add a helper column with conditional formatting as well.

What should I do if I receive the same invoice twice?

Compare supplier, invoice number, date and amount. If everything matches, it is a copy, for example one by post and one by email: record and pay only one, and claim the input VAT only once. If the second invoice has a different number but the same content, ask the supplier before paying.

Should I print e-invoices?

No, and in Germany a printout is not enough. There, at least the structured part of an e-invoice must be kept unaltered in its original format for eight years. In Austria, records generally have to be kept for seven years. To read an e-invoice, use a viewer or your accounting software.

LET'S TALK ABOUT YOUR WORKFLOW

Write to us. We reply personally.

A question, an idea or a task that costs time every week? A few sentences are enough. You get an honest answer from the people who also build your office helper.

Ivan, Lukas & JanReply within 1–2 working days

  • Personal reply
  • No obligation
  • Based in Vienna, GDPR aware
Photo of Ivan
Rather talk directly?Ivan, your contact person+43 676 59 40 027office@pebblebyte.comMon to Fri 08:00–18:00
Have a specific task? Get your free workflow check

Your message

Please do not enter passwords or confidential customer data. We only use your details to handle your request. No newsletter, no sharing for advertising. Details in our privacy notice.