Building a Privacy-First Expense Sorter with Open-Source AI for Freelancers

Description and use

LedgerShield is a local-first tool that automatically extracts and categorizes receipt data, preserving privacy and saving time for freelancers.

Problem

Freelancers need automated bookkeeping without exposing sensitive financial records to third‑party cloud services.

Outcome

In a test with 18 mixed receipts, LedgerShield parsed line totals and vendor details in under three minutes, eliminating manual spreadsheet entry and earning positive user feedback for potential paid usage.

Workflow

• 1. User drags and drops mixed receipts into LedgerShield’s web dashboard.
• 2. The local Python backend loads an open‑weight vision‑language model to process each image on the user’s device.
• 3. The model extracts vendor name, date, total amount, taxes, and category.
• 4. Extracted data is stored in a lightweight SQLite database and exported as CSV or JSON.
• 5. Users review and optionally export the structured data for bookkeeping.

Evidence

LedgerShield extracts key metadata (vendor name, date, total amount, taxes, and category) and exports them into structured CSV or JSON formats.

Source

The extraction parsed line totals and vendor details in under three minutes, eliminating manual spreadsheet entry.

Source

Open-weight models run locally on the user's laptop, ensuring sensitive financial documents, client names, and tax identifiers never leave their hardware or get used to train closed corporate systems.

Source