E-Invoice - Online Invoicing

Client Description

The National Tax and Customs Administration (NAV) is a governmental organization in Hungary responsible for the collection of taxes and customs duties, as well as enforcing tax-related regulations. Its duties include tax audits, providing guidance to taxpayers, overseeing customs procedures, and detecting financial fraud. The organization aims to improve the efficiency of the tax system and ensure fair contribution to public finances.

Project General Description

The purpose of the Online Invoice System is to whitewash the economy and reduce tax evasion, enabling the National Tax and Customs Administration (NAV) to monitor invoice traffic in real time. The data received through the system improves risk analysis and error detection, contributing to an increase in the state's VAT revenue. Information about issued invoices is accessible not only to the NAV but also to invoice recipients and issuers, creating clearer market conditions for compliant taxpayers. The automation of data reporting reduces administrative burdens, while the IT system supports the receipt and verification of invoice data. The Online Invoice System enhances the transparency of economic processes and expands the circle of compliant taxpayers.

Let's talk!
Government Sector
​ / ​
Data Warehouse
​ / ​
Risk Management
​ / ​
Internal Reporting Service
​ / ​
Tax Audit Area

Challenge

The National Tax and Customs Administration (NAV) has made electronic invoice data reporting mandatory. This step has significantly increased data traffic and processing requirements. The new system applies to all invoices, amendments, and invalidating documents subject to the invoicing rules of the VAT law.

The NAV data warehouse had to contend with a sudden increase in data volume. With the implementation of the e-Invoice system, millions of new records are received daily, which must be stored and processed efficiently. The main challenge is to maintain high performance and fast response times despite the large data volume.

One of the fundamental requirements for the NAV data warehouse was fast and efficient data processing. The goal was to ensure that data loads were completed within 2 hours, while reports would generate responses within 2 minutes. To achieve this, complex optimization strategies were implemented.

How we helped?

  • Preparation
  • Familiarization with the NAV IT infrastructure and the regulatory background.
  • Data Structure Design
  • A well-structured data model was created in the reception area and the data warehouse to support efficient data processing and storage.
  • Data Cleaning
  • Ensuring data quality by filtering out duplicates and errors through automated processes.
  • Data Normalization
  • Standardizing data with different formats into a unified structure for effective analysis.
  • Data Warehouse Loaders Implementation
  • Designing and creating data warehouse loaders for every logically related data unit. The development of ETL (Extract, Transform, Load) processes ensures efficient and reliable loading of data into the warehouse. Daily data refresh mechanisms were implemented to guarantee up-to-date information.
  • Complete Data Mart and Reporting
  • Designing and developing a data mart based on requirements. The data was presented through Oracle BI reports.
  • Managing Data Growth
  • Since the introduction of the e-invoice system, the volume of managed data has significantly increased (with billions of records in fact tables). This continuous data growth poses a serious challenge to the infrastructure and data processing processes. Solutions were implemented to ensure that system performance and response times remain unaffected by the increasing data volume.
  • ITAR Pilot Project
  • The NAV ITAR (Integrated Data Warehouse System) project is a comprehensive initiative to unify data management and analysis. The e-invoice data set served as the pilot project for this multi-system development.
  • Oracle BI
  • Oracle Database