Skip to content

About

Local SQLite expense-tracking CLI with currency-separated totals and no assumed FX conversion.

Topics

Resources

Security policy

Stars

0 stars

Watchers

0 watching

Forks

Latest commit

 

History

3 Commits

Folders and files

Repository files navigation

Mini Expense Tracker

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

Features

  • 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.

Requirements

  • Python 3.10 or later
  • No third-party package installation required

Quick start

Show available commands:

python main.py --help

Add a sample expense to a local database:

python main.py add --db expenses.db --day 2026-10-25 --amount 12.50 --currency USD --category food

Display totals by currency:

python main.py --db expenses.db total

Tests

python -m unittest discover -s tests -v

Limitations and privacy

This 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.

Related Quantix projects

License

MIT. See LICENSE.

About

Local SQLite expense-tracking CLI with currency-separated totals and no assumed FX conversion.

Topics

Resources

Security policy

Stars

0 stars

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages