A local command-line expense tracker built with Python and SQLite. It records expenses and calculates totals grouped by currency code without assuming or applying foreign-exchange rates.
Independent demonstration project · Python 3.10+ · Standard library only · MIT license
- Stores expense entries in a local SQLite database.
- Captures a date, amount, three-letter currency code, category, and optional note.
- Rejects non-positive amounts and invalid currency-code lengths.
- Calculates totals separately for each currency.
- Runs locally; it does not connect to a bank, payment processor, or FX service.
- Python 3.10 or later
- No third-party package installation required
Show available commands:
python main.py --helpAdd a sample expense to a local database:
python main.py add --db expenses.db --day 2026-10-25 --amount 12.50 --currency USD --category foodDisplay totals by currency:
python main.py --db expenses.db totalpython -m unittest discover -s tests -vThis is a minimal local record-keeping example, not accounting, tax, or financial advice. It does not verify dates against a calendar, manage budgets, reconcile transactions, or convert currencies. Keep the generated database private if it contains real financial records; use synthetic data in public demonstrations.
MIT. See LICENSE.