NF-e Reader

Python application for reading Electronic Invoices (NF-e) from XML files, generating Excel reports, and featuring a modern and minimalist graphical interface.

It allows extracting and analyzing information from multiple XML files simultaneously, with date and value filters, as well as automatic error logging.

About the Project

NF-e Reader was developed to automate the reading of Electronic Invoices (models 55 and 65) in XML format, quickly and easily generating detailed reports in Excel spreadsheets.

The application has a simple and intuitive interface built with CustomTkinter, allowing folder selection, filter application, and formatted report generation with just a few clicks.

Main Features:

Automatic reading of XML files from NF-e and NFC-e.
Modern and minimalist graphical interface.
Date and minimum value filters before report generation.
Excel report creation with summary and product details tabs.
Enhanced formatting: bold headers, alternating colors, and auto-adjusted columns.
Progress bar during XML processing.
Error and inconsistency logging in logs.txt.

Technologies Used

Python pandas openpyxl lxml customtkinter

How to Use

Download or clone the project repository.
Install dependencies using:
```
pip install -r requirements.txt
```
Run the main program:
```
python main.py
```
In the interface, select the folder containing the NF-e XML files.
Optionally set date and value filters if needed.
Click Generate Report to create the Excel file.
The report will be automatically saved in the relatorio_output folder.

Report Structure

The generated report contains two main tabs:

Summary: shows invoices with key, issuer, recipient, date, total value, and number of items.
Details: lists all products from each invoice, including description, quantity, unit price, and total item value.

Screenshots

Application Interface

Excel report with summary and details tabs

Date and value filters before report generation