Skip to main content

doppia

Personal accounting for bank and credit card accounts (PySide6 desktop GUI). Data lives in a single CSV in CountAbout export format; files are written back byte-for-byte compatible (unchanged rows are untouched, quoting matches CountAbout).

The name

doppia is named after partita doppia, Italian for double-entry bookkeeping. The method was first described in print by Luca Pacioli (c. 1447–1517), an Italian mathematician and Franciscan friar, in his Summa de arithmetica, geometria, proportioni et proportionalita (Venice, 1494), which earned him the title "father of accounting".

Install

Install doppia from PyPI as a standalone app with pipx or uv, which keep it isolated without you having to manage a virtual environment:

pipx install doppia          # or: uv tool install doppia

Python 3.10 or later is required. The clipboard import and Guess with LLM features also need Ollama with a model installed, e.g. ollama pull gemma4:12b-it-qat; everything else works without it.

Run

doppia path/to/countabout-export.csv     # reopens the last file if omitted

Development

From a clone of the repository, uv runs the app and tests with the dependencies it needs:

uv run doppia path/to/countabout-export.csv
uv run --extra test pytest

Features

  • Account list with today's balance and cleared balance. The bold Total row sums both columns over the selected accounts (all accounts when none or "All accounts" is selected). Future-dated rows shown grey.
  • Money is shown as $1,234.56: red for negative, green for positive, no minus sign (the minus is kept only in plain-text messages that can't be colored). Colors stay visible on selected rows. $ and commas are accepted when typing amounts.
  • Register per account or all accounts: running balance, uncleared-only filter, and a filter field that takes a case-insensitive regular expression (e.g. ^amazon, 3000, \$3,000) matched in the description, category, memo, ref, date, or amount. Its X button clears it; an invalid expression tints the field and is ignored. The account names over the register are cut to 30 characters, including ... (hover for the full list).
    • Ctrl/Shift-click in the account list to select several accounts; the register shows their combined transactions with a combined running balance. Reconcile and Rename account need a single account selected.
    • Click a column header to sort by it; click again to reverse. The sort column's header is highlighted, and the selection is kept when re-sorting. The register opens sorted by date, newest first. The Balance column is a date-order running balance, so it only adds up when sorted by date.
    • Click the Clr box to toggle cleared; cleared rows show a green ✔ (the CSV still stores X).
    • Double-click a row to edit it; right-click for a menu to delete it.
  • New/edit/delete (Ctrl+N / Ctrl+E / Ctrl+Del), Ctrl+K toggles cleared. Payee memory: typing a known description fills its last category and amount.
  • Search and replace (Transaction menu, Ctrl+H): find a regular expression in the Description, Category, Memo, Ref, and/or Tags fields (optionally case-sensitive, optionally only in the selected accounts). Check Replace with to preview each change (\1 inserts a matched group), untick any you don't want (Select All/None flips them all), then Replace checked. Transfer/split categories and results containing line breaks can't be replaced. Nothing is written to the file until you save.
  • Transfers use CountAbout's {Account} category; the mirror row in the other account is created/updated/deleted automatically (matched by date and negated amount).
  • Bank CSV import (Ctrl+I): column mapping saved as named profiles in ~/.config/doppia/import_profiles.json; payee/category matched from history; duplicates (same amount within 3 days) unchecked by default; imported rows marked cleared.
    • Guess with LLM asks the local model (the one chosen in clipboard import) which columns hold the date, description, amount or debit/credit, memo, and check number, and the date format. Only the header and first 8 rows are sent. Its answer is limited to the file's real column names and checked against the sample rows; Flip signs is set from the data (mostly positive amounts = card charges listed as positive), not by the model. Takes a few seconds; save the result as a profile to skip it next time.
  • Import from clipboard (File menu, Ctrl+Shift+V): copy transactions from a bank or card website or statement, and a local LLM served by Ollama turns the text into transactions for the chosen account (the active one by default). Nothing leaves your machine. The text is shown for editing; press Parse (about 15–30 s on an RTX 3060).
    • Model: any installed Ollama model, remembered between runs. Default gemma4:12b-it-qat, which read sample bank and card text correctly; smaller models got dates and signs wrong. Set OLLAMA_HOST if Ollama isn't at localhost:11434.
    • Likely duplicates of existing transactions (same amount within 3 days) are removed from the list; Show likely duplicates brings them back, unchecked. Payees and categories are matched from history, as in CSV import.
    • Review before importing: amounts the model returns that don't appear in the pasted text are unchecked and flagged, and Flip signs fixes deposits/charges read backwards.
    • Imported rows are marked cleared (optional) except ones shown as pending.
  • Reconcile (Ctrl+R) against a statement ending balance: check off uncleared transactions until the difference is $0.00.
  • Reports (Ctrl+P): totals by category, category by month, income vs. expense by month. Click a column header to sort.
    • Transfers are excluded unless Include transfers is checked. Then each transfer is reported under Transfer: <other account>. A transfer between two checked accounts appears on both sides, so it adds to both income and expense while netting to zero.
    • Accounts All/None checks or unchecks every account in the account list.
    • Categories field: a case-insensitive regular expression matched anywhere in the category name (e.g. ^(groceries|dining)$). Press Enter or Run to apply; the X button clears it and reruns. An invalid expression is reported and ignored.
    • Ctrl/Shift-click category rows, then Run, to report only those categories. The restriction persists across runs until Show all categories clears it (along with the regex). Run uses whatever rows are highlighted when pressed.
    • Total income, expense, and net rows reflect only the categories shown.
    • Save… writes the report as shown (current sort order) to CSV (plain signed numbers for spreadsheets), Markdown, plain text (aligned columns), or PDF. Markdown, text, and PDF include the report settings (dates, accounts, category filters) and show amounts with a minus sign, since they may be printed without color. Wide month-by-category reports print landscape in a smaller font.
  • View → Font… sets the font family, style (regular/italic/bold), and size for the whole app; the choice is remembered. View → Reset font returns to the system default.
  • Save (Ctrl+S) writes atomically and keeps the previous file as <file>.bak.
  • Handles a 10k+ row ledger quickly: about 0.6 s to start and 0.1 s to switch accounts.

Limitations (from the CountAbout format)

  • Split transactions: existing {SPLIT} rows are preserved, but the export carries no split detail, so new splits cannot be created and reports show splits as one lump.
  • Balances are sums of rows; there is no separate opening-balance field. New accounts get a "Beginning Balance" row.
  • Cleared is X/blank only (no separate reconciled state).

License

MIT; see LICENSE.

Metadata

Release files for doppia 0.1.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for doppia 0.1.0
File Size Uploaded Provenance Actions
doppia-0.1.0.tar.gz 45.6 kB Without provenance Details for doppia-0.1.0.tar.gz

Built distribution (wheel)

Table of built distributions (wheels) for doppia 0.1.0
File Interpreter ABI Platform Actions
doppia-0.1.0-py3-none-any.whl Python 3 none any Details for doppia-0.1.0-py3-none-any.whl

Total release size: 87.9 kB

Release files / doppia-0.1.0.tar.gz

Download URL doppia-0.1.0.tar.gz
Size 45.6 kB
Tags Source
SHA-256 checksum
How to use checksums
32fd59e681d2e6ae75f7c2cdf734e8f9d9f6972164b68f0394456cf55b716082
BLAKE2b-256 checksum
How to use checksums
75fc4346db2be42ca6491f0c383948937c54d276db0b59627796957f4d775617
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

Release files / doppia-0.1.0-py3-none-any.whl

Download URL doppia-0.1.0-py3-none-any.whl
Size 42.2 kB
Tags Python 3
SHA-256 checksum
How to use checksums
6ef56cd62d455043e8e3100d196cba0b369fb022fc63877e84c5ecca5d5aef9a
BLAKE2b-256 checksum
How to use checksums
3c88c4b5fb659f5d245d8288ef0b724887b03882d857671c78e2927617ab7a4f
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
No
Uploaded via twine/7.0.0 CPython/3.12.15

Security for doppia 0.1.0

Provenance

Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.

No provenance found

None of the files in this release were uploaded with provenance metadata.

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page