home

ynab

Custom SQL query

Tables

accounts

id, name, type, balance, closed, deleted

45 rows

admin_category_mappings

id, vendor_pattern, category_name, category_id, notes, created_at, updated_at, pattern_type

152 rows

admin_transaction_overrides

id, transaction_id, override_category, override_payee, override_amount, notes, created_at, updated_at

0 rows

admin_vendor_aliases

id, raw_name, normalized_name, vendor_category, notes, created_at, updated_at

0 rows

categories

id, month, name, group_name, budgeted, activity, balance, hidden

1,192 rows

months

month, budgeted, activity, income, to_be_budgeted, synced_at

12 rows

skip_projection_categories

category_name, added_date

5 rows

sqlite_sequence

name, seq

2 rows

sync_meta

key, value

2 rows

transactions

id, date, amount, payee_name, category_name, category_id, account_name, memo, approved, deleted, cleared

11,424 rows

Powered by Datasette · Queries took 35.732ms