LedgerShield: Reconcile Confidently. Keep Financial Data Local.

A developer built LedgerShield, an open-source, privacy-first transaction reconciliation assistant that runs entirely on a bookkeeper's local machine using an embedded SQLite database and the open-weight Google Gemma 2 model. The tool uses a two-stage pipeline — deterministic vendor-rule normalization followed by local AI classification — with strict Chart of Accounts schema enforcement to prevent hallucinated account codes, and exports audit-compliant CSVs for QuickBooks Online, Xero, or Sage. It targets solo bookkeepers and freelance fractional CFOs at $39–$49/month, claiming to cut monthly transaction triage time by more than 50%.

This is a submission for the Hacktoberfest Open-Source AI Challenge Week 2: Side Hustle https://dev.to/challenges/hacktoberfest-week2-2026-10-12 What I Built LedgerShield is an autonomous, privacy-first transaction reconciliation assistant designed for independent bookkeepers, solo accounting professionals, and freelance fractional CFOs. The Real Problem for Real People Independent bookkeepers manage 10 to 30 small business clients. Every single month, they face the exact same grueling bottleneck: ingesting raw bank feeds where transactions arrive truncated, coded, or ambiguous: - AMZN MKTP US 2K39F - SQ MIKE'S CAFE 12 - CHECKCARD 09/12 CHEVRON 0092144 - ACH DEPOSIT NORTHSTAR INV 1042 Today, solo bookkeepers are caught in an impossible trade-off: 1. Manual Spreadsheet Grunt Work: Bookkeepers spend 15 to 25 hours per client every month manually reviewing hundreds of rows, hunting through past statements, and emailing clients to ask what specific card charges were for. 2. Cloud AI Accounting Add-ons: Sending client bank feeds to third-party cloud AI APIs like OpenAI or Anthropic violates non-disclosure agreements, exposes confidential cash-flow records to external server retention, and routinely hallucinates non-existent general ledger accounts. What LedgerShield Does LedgerShield brings open-weight AI directly to the bookkeeper's laptop: - 100% Local Processing: Financial records, Chart of Accounts, and reconciliation tables live exclusively in an embedded local SQLite database. Zero confidential financial packets ever leave the computer. - Two-Stage Intelligent Pipeline: Microsecond deterministic normalization handles verified vendor rules and historical patterns first. Unresolved items are then classified by local open-weight AI Google Gemma 2 . - Zero Hallucination Guarantee: Strict Chart of Accounts schema enforcement prevents the model from ever inventing account codes. If an item cannot be mapped with high confidence, it is flagged for human review. - Client Inquiry Builder: Automatically transforms ambiguous marketplace and wire charges into structured, multiple-choice questionnaires that can be copied into Slack or email with one click. - Clean General Ledger Export: Exports clean, audit-compliant CSVs ready for immediate import into QuickBooks Online, Xero, or Sage. Who Would Pay For It? Solo bookkeepers and freelance QuickBooks ProAdvisors whose revenue is capped by manual hours. Reconciling messy transactions is their lowest-margin, highest-friction activity. At a price of $39–$49/month , LedgerShield pays for itself in a single afternoon by cutting monthly transaction triage time by more than 50%. Demo - 🎥 Video Walkthrough YouTube : https://youtu.be/ L-JsBISRNo https://youtu.be/ L-JsBISRNo Full HD 1080p demo with professional neural voice narration - 🌐 Live Cloud Deployment Render : https://ledgershield-dcqj.onrender.com https://ledgershield-dcqj.onrender.com - 📦 GitHub Repository: https://github.com/Shreyansh00987/LedgerShield https://github.com/Shreyansh00987/LedgerShield - 🧊 Interactive 3D Spatial Vault: Real-time mouse-reactive 3D perspective cube SpatialVault.tsx demonstrating the 3 local architectural layers: Zero-Cloud Privacy, Gemma 2 AI, and SQLite Deterministic Rules. - 🧪 Three Ready-to-Test Real-World Scenarios: 1. Apex Creative Studio example1 apex creative studio.csv : Freelance design agency with Stripe payouts, Figma/Adobe/AWS SaaS subscriptions, and ambiguous meeting expenses. 2. Summit Plumbing & Heating example2 summit plumbing.csv : Plumbing trade contractor with wholesale supplier rules Ferguson, Grainger , United Rentals, fuel cards, and personal debit card swipes. 3. Metro Cafe & Bakery example3 metro cafe.csv : Neighborhood cafe with daily Square and Toast POS settlements, Sysco bakery supplies, and commercial utility invoices. - ⚡ One-Click Synthetic Demo Dataset: Pre-loaded with "Northstar Electrical Services" 57 realistic contractor transactions + active trade Chart of Accounts . Step-by-Step Flow: 1. Click "3D Spatial Vault" in the top bar to inspect the interactive 3D local privacy architecture. 2. Load or upload any bank statement CSV. 3. Click "Run Reconciliation" : exact rules match instantly, ambiguous transactions are categorized by local Gemma 2 AI, and tricky items are flagged as Needs Clarification . 4. Inspect any line in the Audit Inspector Drawer and click "Remember Rule" to persist learned vendor patterns into local SQLite for all future statements. 5. Switch to Client Inquiry Builder : preview the interactive multiple-choice questionnaire generated for the client. 6. Click Export & Audit : run pre-flight checks and download the clean reconciled General Ledger CSV. Code 🛡️ LedgerShield Reconcile Confidently. Keep Financial Data Local. 🌐 Live Cloud Demo on Render: 🎥 Watch 76s Walkthrough Demo Video with Neural AI Voice : LedgerShield Demo Walkthrough.mp4 https://github.com/Shreyansh00987/LedgerShield/LedgerShield Demo Walkthrough.mp4 Full 3D interactive React UI, deterministic reconciliation, client inquiry generator, and benchmark evaluator hosted live on Render. LedgerShield is a privacy-first transaction reconciliation assistant designed for independent bookkeepers, solo accounting professionals, freelance fractional CFOs, and small accounting practices. It streamlines the monthly reconciliation of messy, ambiguous bank transaction feeds by uniting deterministic pattern matching , local open-weight AI Gemma , Chart of Accounts schema enforcement , human-in-the-loop review , client inquiry generation , and clean general ledger exports —with the non-negotiable architectural guarantee that confidential financial records never leave the user's device. The Problem Independent bookkeepers spend 15–25 hours per client every month manually deciphering truncated, messy bank transaction descriptions e.g. AMZN MKTP US 2K39 , SQ MIKE'S CAFE , PURCHASE 09/12 CHEVRON … The complete codebase is organized cleanly into modular, production-grade services: - Repository: https://github.com/Shreyansh00987/LedgerShield https://github.com/Shreyansh00987/LedgerShield - Frontend Architecture: React 19, TypeScript, Vite, Tailwind CSS v4, Lucide React icons. Implements the Impeccable "Operate" standard for mission-critical financial applications. - Backend Architecture: Python 3.11/3.14, FastAPI, Pydantic v2, SQLite 3 in WAL mode, Uvicorn. - Key Modules: - backend/services/csv parser.py : Safe CSV ingestion with formula injection protection = , + , - , @ sanitization . - backend/services/matching engine.py : Merchant normalization, prefix stripping SQ , TST , CHECKCARD , and historical pattern matcher. - backend/services/ai reconciler.py : Gemma 2 / Ollama open-weight adapter with strict Pydantic output schema validation and honest heuristic fallback. - backend/services/chart of accounts.py : Strict Chart of Accounts validator preventing code hallucination. - backend/services/client inquiry.py : Client inquiry questionnaire generator. - backend/services/export service.py : Pre-flight reconciliation validator and CSV export service. - backend/services/evaluator.py : Live empirical benchmark harness. - frontend/src/components/SpatialVault.tsx : Interactive 3D spatial security vault with real-time perspective tilt and layer inspection. - Dockerfile & render.yaml : Multi-stage containerization and Blueprint deployment on Render. - scripts/deep system test.py : Comprehensive 17-stage automated security, privacy, and integrity verification suite. How I Built It LedgerShield is built around a local open-weight AI architecture designed to run on a bookkeeper's standard laptop: 1. Model Core: Configured for Google Gemma 2 2B Instruction gemma2:2b via Ollama and compatible open-weight models. 2. Inference Strategy: - The application connects via localhost HTTP loopback http://localhost:11434 to the local Ollama daemon. - Ambiguous transaction strings are paired with the active Chart of Accounts in a structured system prompt. - Pydantic enforces an exact JSON response contract suggested account id , confidence , explanation , evidence , requires review , missing information . - If Ollama is offline or uninstalled, LedgerShield transparently falls back to an embedded deterministic domain heuristic engine with honest UI labeling heuristic fallback . 3. Data Integrity & Security: - SQLite 3 with PRAGMA journal mode=WAL ensures high-throughput, non-blocking reads and writes. - All cell values are sanitized against spreadsheet formula injection attacks. - Internal audit logs record administrative counts while strictly redacting sensitive financial dollar amounts and raw payee names. 4. Cloud Production Deployment: - Multi-stage Dockerfile Node 20 Alpine for Vite compile + Python 3.11-slim for Uvicorn . - Deployed on Render via Infrastructure-as-Code Blueprint render.yaml with continuous deployment from GitHub and live health monitoring at /api/health . Why Does Open Innovation Matter? Open-weight AI is not merely an optional feature for LedgerShield— it is the architectural foundation that makes this commercial product viable: 1. Absolute Confidentiality Zero Third-Party AI Packets Bookkeepers sign binding non-disclosure agreements with their small business clients. Uploading banking records, invoice amounts, vendor names, and personal owner draws to remote cloud AI APIs introduces severe legal liability and data harvesting risks. Open-weight models running on local hardware ensure client financial records never leave the bookkeeper's laptop. 2. Predictable Economics $0.00 Marginal Inference Cost Closed proprietary APIs charge continuous per-token inference fees. For a freelance bookkeeper reconciling 5,000 transactions across 15 clients every month, cloud API bills accumulate and erode profit margins. With open-weight models like Gemma running locally, the marginal inference cost per transaction is $0.00 . 3. Stability & Control Closed AI endpoints can alter weights, change behavior, or deprecate model versions overnight, breaking accounting reconciliation rules. Open-weight models give the developer and the end-user an unchanging, auditable, and reproducible inference pipeline. 4. Zero Hallucination Authority By sandwiching local open-weight AI between deterministic rules and strict Chart of Accounts validation, LedgerShield achieves a 0.0% account code hallucination rate . Measured Benchmark Proof Using LedgerShield's built-in evaluation harness backend/services/evaluator.py across a representative 28-transaction business dataset: - Deterministic Rules Alone: 60.7% accuracy, 42.9% review rate. - Combined Rules + Local AI : 82.1% accuracy +21.4% gain , review rate reduced to 17.9% a 58.3% reduction in human review workload , running at 0.387 ms per transaction . My Agent Session Agent pairing and autonomous development trajectory: The end-to-end implementation of LedgerShield—from architecture planning, safe CSV parsing, deterministic matching, Gemma model adapter, and Impeccable design system to automated test suites and Render deployment—was executed autonomously in pair-programming collaboration with the Antigravity agentic coding assistant. All design anti-patterns were audited with the official Impeccable CLI detector, achieving zero defects. My First User - Target Persona: Solo QuickBooks ProAdvisor specializing in trade contractors electricians, plumbers, HVAC . - Synthetic Validation: The complete user journey was validated end-to-end using synthetic transactions from "Northstar Electrical Services" 57 realistic transactions spanning supplier parts, fleet fuel, equipment rentals, dining, and ambiguous Amazon/wire transfers . - Multi-Scenario Validation: Tested across 3 diverse industry profiles Apex Creative Studio, Summit Plumbing, Metro Cafe . - Validation Protocol: A complete 15-minute evaluation script, interview guide, and outreach template are documented in USER VALIDATION.md for ongoing beta user testing. Prize Categories Featured Categories: - Best Use of Gemma $200 : LedgerShield uses Google Gemma 2 gemma2:2b / gemma2:9b as its core semantic classification engine. Gemma runs locally on the user's laptop via the Ollama adapter, processing confidential banking descriptions into structured, validated accounting categories with zero cloud data transmission and zero marginal token cost. - Best Use of Render $200 : LedgerShield is deployed and hosted live on Render at https://ledgershield-dcqj.onrender.com https://ledgershield-dcqj.onrender.com . It leverages Render's Infrastructure-as-Code Blueprint render.yaml and an optimized multi-stage Dockerfile Node 20 + Python 3.11 . Render unifies the interactive 3D React frontend and the FastAPI REST backend into a single performant container with automatic health checks /api/health , zero CORS issues, instant HTTPS, and automated CI/CD continuous deployment connected directly to the GitHub repository.