Ledger Book

Simple Database to store Ledger Records and get reports of Money Stash. All values are in common currency unit (EuroDollar).

The Database does not involve storing multiple Accounts and is not a personal finance Tracker (purchasing Goods, paying Bills, etc.)

The main Goal is tracking the savings Account

• DB: SQLite or PostgreSQL
• PostgREST (if need HTTP Interface for PostgreSQL)
• Grafana

Table of Contents

• Database Structure
  • Account
  • Transaction
• Overview
• Pivot Tables
  • Running Balance
  • Year Income Outcome
  • Year Month Income Outcome

Database Structure

Account

• id - auto inc Value
• name - text Value
• currency - text Value

Transaction

• id - auto inc Value
• account_id - link to Account Entity
• date - ISO 8601 Date (YYYY-MM-DD), without Time
• amount - only Integer (Why count Сents?)

Overview

The main Approach is quick get main Measurements and using in big Numbers in Grafana

• Account Currency
• Total Transactions
• Last Transaction Type
• Current Balance
• Total Outcome
• Total Income
• Total Outcome Transactions
• Total Income Transactions
• Unique Transaction Dates
• First Transaction Date
• Last Transaction Date
• Days of Last Transaction

Pivot Tables

Running Balance

Shows Running Balance (Running Total/Cumulative Sum/Prefix Sum) and Delta in Percents between current and previous Running Balances

Year Income Outcome

Year Month Income Outcome