Background
Joseph Sprei is the founder of Ask the Ledger. Over a twenty-five year software development career — working primarily in Delphi with SQL Server, PostgreSQL, and MS Access, with more recent work in Lazarus, Free Pascal, Python/Flask, and modern web stacks — Joseph has designed and shipped over forty production applications for clients across healthcare, long-term care, secure communications, network infrastructure, auto services, buying groups, and community organizations.
That span — from early database tools to modern cross-platform mobile apps — is the foundation for Ask the Ledger. The pattern across every project has been the same: sit with the operator, learn the actual workflow, build the smallest thing that replaces the manual process, then refine it based on how people really use it. Ask the Ledger is the application of twenty-five years of that pattern to the hardest workflow in wholesale distribution: running a business on tight margins with perishable or time-sensitive inventory, complex customer pricing, and daily operational pressure.
Systems I've built
What follows is a representative sample of custom business software delivered for clients over the years. Client names are omitted out of professional discretion, but the industries and system types are accurate.
Healthcare and long-term care
- Asset tracking system — Delphi desktop application for a long-term care facility to track equipment across hundreds of rooms and departments. Check-in / check-out, location history, condition notes, searchable history.
- Employee PTO and accrual system — Custom accrual calculator and reporting application for a nursing home back office, replacing a stack of spreadsheets. Access-backed database, Delphi UI, printable reports.
- Patient discharge records system — Multi-tier client/server application to capture and store discharge records with full audit history for a skilled nursing facility.
- Biometric time clock — Delphi-based employee time-and-attendance system with fingerprint and facial recognition hardware integration, including an Android companion app.
- Digital new-hire orientation board — Touch-screen orientation kiosk with weather, directory, and safety content. Both Windows (Delphi) and Linux (Lazarus) builds deployed side-by-side.
- Internal staff messaging / chat system — Custom client/server instant-messaging application with bubble-style UI, used internally by a healthcare organization for HIPAA-conscious staff communication.
- Internal ticketing / help-desk application — Issue-tracking system with a desktop client and a mobile (Android / FireMonkey) companion for on-the-go status updates.
Secure communications and compliance
- HIPAA-compliant secure email — A send-secure Outlook add-in (Microsoft Outlook 2003, 2007, and XE2 variants) that encrypts outbound email and integrates with a standalone SSL mail server so protected health information can be exchanged with outside parties without a third-party service.
- Web-based secure email portal — A Delphi web server and service that lets external recipients read encrypted messages through a browser with token-based authentication.
- Standalone SSL server — A lightweight SSL/TLS server used as the secure transport layer in front of the secure-email stack.
Network infrastructure and security
- DNS content filtering server — Delphi-based DNS server implementing policy-driven filtering for managed-services clients. Logs requests, blocks categories, serves allow-listed domains.
- Syslog monitoring service — A receiver and parser for SonicWall firewall syslog streams, with alerting on unusual patterns.
- Screen and content filter — An endpoint screen-content filter for environments requiring controlled browsing.
- File-system watch utilities — Directory-change notification tools in Delphi and Free Pascal used in backup, sync, and audit workflows.
- Auto-update framework — An in-house auto-update system deployed across several shipping apps, pushing new versions to customer PCs without manual reinstall.
Accounting, purchasing, and operations
- Accounts-receivable and customer management module — Delphi/Paradox-era AR customer maintenance system, later repackaged and modernized.
- Data pump and migration utilities — Several GUI and command-line data-movement tools built for migrating legacy data into new systems, handling type conversions and referential integrity.
- Multi-tier buyers' group purchasing system — Client/server application used by a buying group: client workstations, central server, DataSnap/FireDAC backend, Excel integration.
- Auto-service shop management — Work-order tracking, parts, and labor billing for an automotive service shop.
- Import/export transaction processor — Transaction import/export utility for an educational institution.
- Upload generator — Tool that generates structured upload files from operational data for a client's accounting system.
Community, education, and religious software
- Hebrew text reference tool (Chumash) — Searchable Torah text application with HTML rendering for cross-referencing verses and notes.
- Talmud commentary generator — Multi-version application for building annotated commentary overlays on classical texts, now in its sixth revision.
- Classical text rewriter and translation tools — Applications for rewriting and restructuring translated religious texts in Hebrew and Aramaic.
- Prayer-times (Zmanim) calculator — Cross-platform application built in Lazarus / Free Pascal, combining astronomical time calculations with local weather.
- Community membership database — Paradox-based membership, campaign, and communication system with multiple branch/sub-group variants.
- Religious community event management — Server + client application for managing scheduled community events, calendars, and Hebrew-date-aware reminders.
Experimental and recent AI work
- AI-orchestrated CLI tooling — Delphi applications that orchestrate large-language-model calls for task automation and code generation.
- GPT-assisted behavior coaching app — Multi-iteration desktop experiment that combines CBT (cognitive behavioral therapy) prompts with LLM completions for a structured coaching workflow.
- Embedded web browsers — Microsoft Edge-based and legacy IE-based embedded browser controls for in-app content display.
Now: Ask the Ledger
Ask the Ledger is the synthesis of this work, focused on a single industry that needs all of it at once: wholesale distribution. Fast order entry (from the POS work), inventory and pricing (from the AR / buyers' group work), route delivery and time-sensitive operations (from the healthcare and home-health work), secure on-premise data handling (from the HIPAA and infrastructure work), cross-platform reach (Windows desktop, web B2B portal, Android companion), and AI reporting (from the recent LLM work). It is the product I would have wanted twenty-five years ago when I was first building each of these pieces separately for different clients.
What I write about
My writing on this blog covers ERP selection and evaluation, implementation planning, on-premise deployment, route delivery and DSD operations, inventory management, AR collections, warehouse workflows, and the financial fundamentals of running a healthy distribution business. The goal is practical content that helps distributors make better decisions, whether they end up choosing Ask the Ledger or not.
I try to be honest when another product is a better fit. The comparison pages describe the scenarios where Ask the Ledger is the right choice and the scenarios where another ERP would serve a distributor better. Over the years I have learned that honesty serves customers better than aggressive positioning, and it produces better long-term relationships.
Why distribution
Distribution is one of the most operationally complex businesses to run well. Tight margins, perishable or time-sensitive inventory, complex customer relationships, route logistics, recurring billing, and constant pressure on working capital all combine to make distribution a demanding field. Distributors deserve software built for their reality, not generic ERP adapted to fit. That conviction is what drives both the product work and the editorial work.
Connect
You can find me on LinkedIn, on GitHub (open-source projects from the Ask the Ledger toolchain — including the QuickBooks Desktop → JSON extractor), or via our contact form. I read every message and especially appreciate hearing from readers who work in distribution every day.
Browse the blog