Sap Journal Auditor

# SAP Journal Auditor

Audit SAP FI/CO journal entry exports for anomalies, duplicate postings, unusual cost center assignments, period-end outliers, and approval bypass patterns.

## Triggers

- audit journal
- check journal entries  
- SAP audit
- review postings
- flag anomalies
- prüfe buchungen
- journal analyse

## Description

This skill analyzes SAP FI/CO journal exports (CSV or Excel) and identifies potential audit issues:

- **Duplicate Postings** - Same amount, account, reference posted multiple times
- **Round Amount Anomalies** - Large round numbers that may indicate estimates or accruals
- **Cost Center Mismatches** - Expenses booked to unusual cost centers
- **Approval Bypass** - Missing references, manual journal entries
- **Intercompany Issues** - IC postings without proper clearing references
- **User Patterns** - Unusual posting activity by specific users

Supports SAP exports from:
- FB03 (Document Display)
- FAGLL03 (G/L Account Line Items)
- KSB1 (Cost Center Line Items)
- ACDOCA (S/4HANA Universal Journal)

## Inputs

| Parameter | Type | Required | Description |
|-----------|------|----------|-------------|
| `file` | file | Yes | CSV or Excel export from SAP FI/CO |
| `language` | string | No | Output language: `en` (English) or `de` (German). Default: `en` |
| `period` | string | No | Fiscal period to focus on, e.g., `2025-03` or `Q1-2025` |

## Outputs

- Structured audit memo with findings categorized by severity (CRITICAL, HIGH, MEDIUM, LOW)
- CSV export of flagged entries for further review
- Summary statistics and risk assessment

## Example

```
Audit the attached journal_march_2025.csv for anomalies
```

```
Prüfe die angehängte Buchungsdatei auf Auffälligkeiten
```

## Author

**Daryoosh Dehestani**  
RadarRoster | [https://radarroster.com](https://radarroster.com)

## License

CC-BY-4.0

# SAP Journal Auditor

<p align="center">
  <strong>Enterprise-grade SAP FI/CO journal audit automation for controllers, auditors, and finance teams.</strong>
</p>

<p align="center">
  <a href="https://github.com/dda-oo/sap-journal-auditor/actions"><img src="https://github.com/dda-oo/sap-journal-auditor/actions/workflows/test.yml/badge.svg" alt="Tests"></a>
  <a href="LICENSE"><img src="https://img.shields.io/badge/license-CC%20BY%204.0-blue" alt="License"></a>
  <a href="https://github.com/dda-oo/sap-journal-auditor"><img src="https://img.shields.io/badge/open%20source-SAP%20Finance-brightgreen" alt="Open Source"></a>
  <a href="https://radarroster.com"><img src="https://img.shields.io/badge/by-RadarRoster-0f172a" alt="RadarRoster"></a>
</p>

<p align="center">
  <a href="#quick-start">Quick Start</a> •
  <a href="#features">Features</a> •
  <a href="#usage">Usage</a> •
  <a href="#audit-checks">Audit Checks</a> •
  <a href="#contributing">Contributing</a> •
  <a href="https://radarroster.com/#contact">Free Strategy Call</a>
</p>

---

**Author:** Daryoosh Dehestani (GitHub: [`dda-oo`](https://github.com/dda-oo))  
**Business:** [RadarRoster](https://radarroster.com) — AI & Data Intelligence Consulting

---

## Overview

SAP Journal Auditor is an open-source audit automation tool that analyzes SAP FI/CO journal entry exports and automatically flags anomalies, duplicates, approval bypass indicators, and period-end irregularities.

Built with deep knowledge of SAP FI/CO, S/4HANA Universal Journal (ACDOCA), and hands-on controlling experience across DACH enterprise environments.

### Why This Tool?

- **Save hours of manual review** — Automated detection of common audit red flags
- **Enterprise-ready** — Handles German/English SAP exports, European/US number formats
- **Zero-dependency option** — Works without npm install for air-gapped environments
- **Professional output** — Structured audit memo ready for management review
- **Open source** — Extend, customize, an...