Stax Digital Garden

QTM-1010 - Liberating Proprietary Finance Silos Deconstructing Quicken and YNAB Exports

2 min read

Living Document Notice
Published 2026-09-17. The evolving architecture, revisions, and connected notes for this dispatch live in the Stax Digital Garden.

Liberating Proprietary Finance Silos Deconstructing Quicken and YNAB Exports

Liberating Proprietary Finance Silos Deconstructing Quicken and YNAB Exports: Dual-trace Phosphor P1 high-persistence green and P4 paper white vector CRT macro showing proprietary database liberation funnels, SQLite schema extraction graphs, and plain-text output streams

Decades of personal financial history are frequently trapped in proprietary formats such as Intuit Quicken QIF/QFX databases or YNAB JSON exports. When subscription models shift or legacy software stops running on modern operating systems, financial records risk being lost. Quartermaster includes deterministic liberation parsers that transform proprietary records into clean double-entry text.

QIF Syntax Normalization

The Quartermaster converter parses legacy QIF records, maps single-entry transactions into balanced double-entry postings, and reconstructs account hierarchies:

def parse_qif_stream(qif_lines):
    transactions = []
    current = {}
    for line in qif_lines:
        line = line.strip()
        if not line:
            continue
        code, value = line[0], line[1:]
        if code == 'D':
            current['date'] = normalize_qif_date(value)
        elif code == 'T':
            current['amount'] = float(value.replace(',', ''))
        elif code == 'P':
            current['payee'] = value
        elif code == '^':
            transactions.append(current)
            current = {}
    return transactions

The script verifies that reconstructed historical postings balance to zero before writing to disk.

Ten-Year Data Sovereignty

Transforming proprietary exports into standard plain text guarantees:

  • Universal Tooling: Files can be queried with grep, awk, DuckDB, or custom scripts without license keys.
  • Permanent Availability: Personal financial records remain accessible forty years into the future on any computer capable of reading ASCII text.
  • Directus Target: quartermaster
  • Garden Source Reference: MOC - Personal Finance, Ledgers & Tax Manifests, MOC - Bosun PKM Tools
  • Garden Source Reference: [QTM-1010 - Liberating Proprietary Finance Silos Deconstructing Quicken and YNAB Exports](QTM-1010 - Liberating Proprietary Finance Silos Deconstructing Quicken and YNAB Exports)

Graph View