GemLedger

Overview

GemLedger is a private, fully offline Android application built for gem traders to track gemstones from purchase through processing to sale. It records stage-wise costs as a stone moves through the trading pipeline, automatically calculates total cost, profit, and ROI, manages images locally, and provides dashboard summaries — all without requiring an internet connection or any external server.

Key Features

• Stage-Wise Cost Tracking: Record costs incurred at each stage of a gemstone’s journey, from purchase through processing to final sale.
• Automatic Financial Calculations: Total cost, profit, and ROI are calculated automatically as costs and sale prices are entered.
• Local Image Management: Photos of each stone are stored on-device, with no upload to any external service.
• Dashboard Summaries: At-a-glance overview of inventory and financial performance across all tracked stones.
• CSV Export: Export tracked data to CSV for reporting or use outside the app.
• Fully Offline: No internet connection or external servers involved at any point — all data stays on the device.

Tech Stack

• Language: C#, chosen for strong typing suited to accurate financial calculations.
• Framework: .NET MAUI for native Android UI and performance.
• Local Database: SQLite with Entity Framework Core, using relational tables that mirror an earlier Firestore-based data model (stones, costs, sales).
• Image Handling: Device file system, via FileSystem.AppDataDirectory.
• Ads: Google AdMob SDK for .NET.
• Target: Android only (API 33+).

Current Status

Closed-source. The app is in active private development and not yet publicly released.