JEV-T: Journal Entry Verification Tool

A high-performance journal entry verification tool optimized for SAP ERP exports. JEV-T is available as an open-source Community Edition (AGPLv3) and as a commercial product licensed by IA Solutions. Originally developed by Jupyo Seo.

Features

• SAP ERP Optimized: Native support for S/H debit/credit identifiers
• Automatic Detection: Automated delimiter and negative sign detection
• High Performance: Direct CSV (including gzip-compressed) parsing for large files (100M+ records), without prior decompression or database import
• Interactive TUI: Modern terminal user interface with Textual
• Flexible Mapping: Map any CSV/TSV column to required fields

Installation

From PyPI (when published)

pip install jevt

From GitHub Release

Pre-built Python package artifacts are available from the GitHub Releases page.

pip install jevt-<version>-py3-none-any.whl

Usage

Command Line

# Run the interactive TUI
jevt

# Run with a specific file
jevt --file data.csv

# Enable debug tracing
jevt --debug

As a Python Module

python -m jevt

Supported File Formats

• CSV (.csv)
• Tab-separated (.txt, .tsv)
• Gzip compressed (.gz)

Field Mapping

Mandatory Fields

Field	Description
Document No A	Header document number
Account Code	GL account code
Amount	Transaction amount
Debit/Credit ID	S/H indicator
Memo A	Primary memo field

Optional Fields

Field	Description
Document No B	Line item number
Account Name	GL account name
Memo B	Secondary memo field
Negative Posting	Reversal indicator (X)

SAP Debit/Credit Identifiers

The tool recognizes these standard SAP identifiers:

• Debit: S
• Credit: H

Debugging

When the application freezes or produces unexpected results:

1. Check jevt_trace.log for step-by-step execution trace
2. Check jevt_debug.log for detailed calculation diagnostics Note: Debug logs are created in the current working directory by default.

Project Structure

jevt/
├── src/jevt/
│   ├── __init__.py
│   ├── cli.py              # Command-line interface
│   ├── core/
│   │   ├── __init__.py
│   │   ├── constants.py    # Field definitions, SAP identifiers
│   │   ├── engine.py       # DuckDB data engine
│   │   └── queries.py      # SQL query builders
│   ├── ui/
│   │   ├── __init__.py
│   │   ├── app.py          # Main Textual application
│   │   ├── screens.py      # UI screens
│   │   └── styles.py       # CSS styles
│   └── utils/
│       ├── __init__.py
│       ├── logger.py       # Step logger for debugging
│       └── debug.py        # Debug trace generator
├── tests/
├── pyproject.toml
└── README.md

License

Community Edition (Open Source)

This project is developed and maintained by IA Solutions.

The Community Edition of JEV-T is licensed under the GNU Affero General Public License v3 (AGPLv3). You may use, modify, and redistribute this software in accordance with the terms of that license.

A copy of the AGPLv3 license is provided in the LICENSE file.

Commercial License

JEV-T is also available under a commercial, proprietary license for use in commercial consulting, enterprise environments, and other use cases where the AGPLv3 is not suitable.

Commercial licenses are offered by IA Solutions and may include:

• Binary-only distribution
• Client-specific customization
• Commercial support and updates

For commercial licensing inquiries, please contact IA Solutions.

---

Copyright © 2026 IA Solutions