Automated Invoice Processing & Price Comparison for Trade Businesses

The trade business Lodger works with a variety of different suppliers. Incoming PDF invoices contain structured XML data, but this has so far been checked and transferred manually.

Manual invoice checking and comparing material prices between different suppliers were time-consuming and prone to errors. Additionally, individual special price agreements had to be taken into account.

The aim was the development of a automated Excel tools for invoice processing and price checking, which saves time, creates transparency and makes price deviations immediately visible.

We developed a powerful, practice-oriented Excel Automation Tool for Procurement and Invoice Verification in Craft Businesses:

• Automatic XML Extraction from embedded PDF invoices

• Intelligent parsing and structured storage in a central Excel database

• Cross-supplier price comparison for materials and services

• Managing individual special price lists

• Automatic identification of price deviations

• Audit-proof logging of all processing steps

• User-friendly interface with Custom Excel Ribbon

• Complete reduction of manual data entry

Nagengast now has fully digitised invoice processing. Price deviations are detected immediately, supplier prices are transparently comparable, and special conditions are automatically taken into account.

Administrative overhead in procurement has been significantly reduced – with higher process security and cost control at the same time.