Created by
jrz1977
RSS Feed View All Collections by jrz1977
Building a Budget Tracker with Double-Entry Bookkeeping

3 books • PUBLIC

Build a fully functional budget tracking system in SQL, from scratch. Each article adds to a working schema based on double-entry bookkeeping, the same system that has powered financial record-keeping since the 1400s. You'll design accounts, record balanced transactions, enforce integrity with triggers, and generate real financial reports. No toy examples. Every table, constraint, and query is something you could use in production.

Open Access
Collection Books:
  1. 1-Building a Budget Tracker-Double-Entry Bookkeeping
    The 500-year-old accounting system behind every financial application on earth. What it is, where it came from, and why we're building one in SQL.
  2. 2-Building a Budget Tracker-The Chart of Accounts
    Design a chart of accounts in SQL. Account types, hierarchical categories, and the constraints that keep your financial data clean.
  3. 3-Building a Budget Tracker-Querying the Chart of Accounts
    Explore a chart of accounts with JOINs, self-joins, NOT EXISTS, aggregations, and data validation queries that catch integrity problems before they spread.