SANOCEA™
INSIGHTSREQUEST A MEETING
SNC-WF-022 · Free Tier · Payments & Audit

Extract Payment Gateway Notifications into a Clean Reconciliation Ledger

SNC-WF-022 · Payment-Email Inbound Rail & Receipt Audit Ledger (Free Tier)

A free, local Python tool that turns messy payment confirmation emails into a structured financial ledger. It extracts transaction IDs, customer details, gross amounts, MDR processing fees, and net payouts from email exports (.eml or text dumps)—creating a unified reconciliation CSV ready for your accounting team.

PRODUCT SUMMARY AT A GLANCESNC-WF-022
Primary OutcomeParses payment gateway notification emails (Razorpay, Stripe, Cashfree, PayPal) into a structured CSV ledger with transaction IDs and fees.
How It RunsSelf-Hosted Python 3.8+ (Runs on your own computer or server)
Setup ExpectationsFree to self-host on your own hardware. Free workflows never run on Sanocea infrastructure. Optional assisted setup: ₹500 one-time.
Verification StatusCode & Logic Tested: Tested with synthetic Indian payment gateway email fixtures and raw EML files
The 3-Step Process in Simple English
1. Input

Directory of payment confirmation emails (.eml or text exports).

2. Transformation

Local Python script applies regex patterns for Razorpay, Stripe, and PayPal to extract financial tokens.

3. Output

payment_audit_ledger.csv and unparsed_email_exceptions.csv.

Free to self-host. Want Sanocea to set it up? ₹500 one-time.

Setup scope covers installation on customer-controlled infrastructure, configuration of authorised integrations, functional testing and handover.

Hosting, third-party charges and ongoing support are excluded unless separately agreed. Free workflows must never run on Sanocea-hosted infrastructure.

Direct Download or Assisted Setup: Download the free toolkit below, or contact engineering on WhatsApp for ₹500 assisted setup on your machine.
Visual Demonstration · 18 Seconds

Watch the Inbound Payment Audit Engine in Action

See how inbound payment confirmation emails are automatically audited, checked for duplicates, and reconciled into a structured SQLite ledger and CSV—with zero cloud uploads and zero inbox passwords.

STAGE 1

Input: Payment Notification Email

Inbound payment confirmation emails (Razorpay, Stripe, PayU, Cashfree) are placed in your local input folder. The tool operates 100% offline—no Gmail passwords or cloud APIs needed.

STAGE 2

Processing: Automatic Audit & Extraction

The system automatically extracts and checks 4 key fields: payment reference ID, captured amount, payment gateway, and payment status, verifying SHA-256 idempotency to prevent duplicate charges.

STAGE 3

Output: Reconciled Ledger & CSV

Receive a clean, verified reconciled_transactions.csv export and an ACID SQLite ledger. Duplicates and reversals are flagged and isolated without manual spreadsheet cross-referencing.

01 · The Everyday Problem

What Goes Wrong in an Ordinary Working Day

Reconciling customer payments across different gateways (Razorpay, Stripe, PayPal) requires digging through dozens of email notifications and disparate PDF attachments.

02 · Why It Matters

The Impact on Your Business & Customers

Missing payment receipts and unrecorded processing fees lead to balance sheet discrepancies during month-end bookkeeping and tax audits.

03 · The Solution

What This Tool Does & What Changes for You

Reads your exported payment notification emails, extracts financial tokens (transaction ID, fees, net payout, customer email) using smart pattern matching, and outputs a consolidated ledger.

What Changes in Practice:

Your accounting team gets a structured, unified transaction ledger in seconds without manual copy-pasting from email inboxes.

Real-World Transformation

Concrete Before & After Example (Actual Code Output)

Shows how an unformatted payment email is extracted into a structured ledger row.

INPUT: Raw Payment Notification Email BodyInput File
Subject: Payment Successful for Order #8921
Amount Paid: INR 3,499.00
Payment ID: pay_N92kL10928
Fee: INR 69.98 (GST: INR 12.60)
Customer: rajesh.k@example.com
OUTPUT: payment_audit_ledger.csvnormalized_inventory.csv
order_id,payment_id,gateway,gross_amount,fee,net_payout,currency,customer
8921,pay_N92kL10928,Razorpay,3499.00,82.58,3416.42,INR,rajesh.k@example.com

Structured financial record ready for Tally, QuickBooks, or Excel reconciliation.

What Changed vs. What Remained Unchanged

✓ What Changed (Normalized):
  • Extracted transaction ID, gross revenue, gateway fee, and net payout
  • Standardized diverse gateway email templates into one consistent format
  • Built searchable accounting audit ledger from unstructured emails
ℹ What Remained Unchanged:
  • Original email files remain untouched
  • Zero cloud API keys required—runs 100% offline
04 · Prerequisites

What You Need Before Getting Started

  • Exported .eml files or JSON email dumps from your payment notification inbox.
  • Python 3.8+ on your computer or server.

Technical Setup Guidance: Zero cloud tracking. Message contents are parsed strictly in memory and stored locally in SQLite.

05 · Setup Effort

Setup Difficulty & Expected Time

Takes 5 minutes. Download the free tool, point it at your email directory, and view the audit summary.

Step-by-Step Run Instructions (Zero-Code Terminal Run)

  1. Download and unzip snc-wf-022-payment-auditor.zip.
  2. Export your payment notification emails to a folder (data/emails/).
  3. Run: python3 payment_auditor.py --emails-dir data/emails/
  4. Open payment_audit_ledger.csv to view all extracted financial transactions.
  5. Import the clean ledger into your accounting software.
06 · Package Contents

What You Receive in the Download Archive

Every deliverable is clean, self-contained, and ready for immediate deployment. You receive the complete files, configuration templates, setup guides, and automated tests.

File NameDeliverable Description
auditor.pyStandalone Python 3.8+ payment email parser and SQLite ledger CLI
fixtures/synthetic_payment_emails.jsonSynthetic multi-provider payment email fixtures
README.mdComplete documentation, CLI options, and email schema details
SETUP.mdQuickstart instructions for running local payment audits
COSTS.mdOperating cost disclosure (₹0 ongoing fees)
LICENSING.mdSanocea Open Workflow License (MIT Compatible)
tests/test_email_auditor.pyAutomated test suite verifying multi-gateway parsing and deduplication
07 · Technical Details & Verification

Architecture Diagram & Tested Capabilities

For technical teams or developers assisting your business, below is the visual execution architecture and automated verification breakdown:

Extract Payment Gateway Notifications into a Clean Reconciliation Ledger Architecture Pipeline Diagram
⚡Deterministic execution flow: runs on your own compute without telemetry tracking.

Verification Disclosure

Extracts transaction IDs, amounts, currencies, and status with strict SHA-256 metadata hashing and duplicate message suppression. Zero email content leaves your local machine.

Multi-Gateway Extraction

Supports Razorpay, PayU, and Cashfree payment confirmation structures.

Fully Tested

Strict Idempotency

Suppresses duplicate message processing using message ID and SHA-256 metadata hashing.

Fully Tested

Manual Review Flagging

Isolates ambiguous amounts or missing transaction references for human inspection.

Fully Tested
08 · Operational Disclosures

Documented Limitations & Third-Party Costs

We believe in complete transparency. Review the documented technical boundaries and external service fee breakdown below prior to obtaining the package:

⚠️Documented Boundaries & Considerations

  • Local Email Parser: Parses downloaded .eml or text files; does not log into your email server or payment gateway directly.
  • Standard Gateway Formats: Supports standard transaction emails from major gateways; custom proprietary templates may require regex mapping.
ComponentEstimated CostDetails & Free Tier Allowances
Payment Email Auditor Tool₹0 (Free to self-host)Download full source code and run locally
Optional Assisted Setup₹500 one-timeAssisted installation, mail directory configuration, and handover
Recurring Fees₹0 ForeverZero third-party APIs or subscription fees
System Compatibility

Platform Compatibility & Technical Specifications

Operating System
Linux, macOS, Windows
Runtime / Python
Python 3.8+ Standard Library
Supported Platforms
Razorpay, Bank NEFT/RTGS alerts, Generic gateway emails
Required Inputs
  • Downloaded .eml payment notification files or email body dump
Generated Outputs
  • Parsed transaction records (amount, payment ID, timestamp)
  • Local SQLite receipt audit ledger
  • Structured CSV export for financial matching
Free Self-Hosted SoftwareInstant Download · Optional ₹500 Setup

Download or Set Up SNC-WF-022

Receive the complete distributable archive containing auditor.py, step-by-step setup guides, mock fixtures, and automated test suites.

Free to self-host. Want Sanocea to set it up? ₹500 one-time.

Setup scope covers installation on customer-controlled infrastructure, configuration of authorised integrations, functional testing and handover.

Hosting, third-party charges and ongoing support are excluded unless separately agreed. Free workflows must never run on Sanocea-hosted infrastructure.

Download Free Package (.zip)Chat on WhatsAppWe reply within 2 business days (Monday to Saturday, 9:00 AM to 9:00 PM IST)
Questions & Answers

Frequently Asked Questions

Why parse emails instead of using API webhooks?

When API access is restricted, gateway credentials are held by third parties, or for secondary independent ledger audits, parsing email confirmations provides an immutable secondary record.

Are our banking details shared with external servers?

No. The parser runs 100% offline using standard library email parsing tools. Zero data leaves your computer.

Can it extract payment IDs and amounts accurately?

Yes. It uses strict regex and text extraction tuned to standard Razorpay and Indian bank confirmation templates.

Operational Field Guide & Research

Payment Notification Email Parsing: Building Offline SQLite Audit Ledgers from Transaction Receipts

How fragmented gateway notification emails obscure financial audits, why unparsed transaction receipts slip through accounting checks, and how offline parsers extract clean ledgers.

Read Field Guide on Sanocea Insights →
Related Automations

Explore Related Self-Hosted Tools

C02Managed Service

See Where Every Order's Money Went & Recover Lost Marketplace Revenue

E-Commerce Settlement & Fee Matcher

An enterprise marketplace reconciliation engine that automatically audits bank payout sheets from Amazon, Flipkart, and Myntra against your original order records. It isolates commission overcharges, unexpected weight penalties, uncredited customer returns, and missing remittances—generating ready-to-file dispute spreadsheets that recover thousands of rupees in lost margin every month.

See Details →
SNC-WF-090Self-Hosted Python 3.8+

Validate Indian GST Numbers Offline Before Invoicing Customers

Offline Customer GSTIN Checksum & Format Validator (Free Tier)

A free, local Python tool that protects your B2B invoicing and GST tax compliance. It validates 15-character Indian GSTIN tax IDs completely offline using the official GST Council Modulo-36 checksum algorithm, state code tables, and entity PAN regex—quarantining invalid tax IDs before you generate invoices or submit GSTR-1 returns.

See Details →
SNC-WF-100Self-Hosted Python 3.8+

Reconcile Cash on Delivery (COD) Courier Remittances and Hidden Fee Deductions

Courier COD Remittance & Fee Deduction Reconciler (Free Tier)

A free, local Python reconciliation tool that stops courier revenue leaks on Cash on Delivery orders. It compares your courier remittance payout files against delivered store orders, identifying unpaid orders, volumetric weight disputes, and unauthorized return fees so you can claim missing cash from shipping partners.

See Details →