About

Reporting

hledger bal {query}
hledger reg {query}

Query

Queries

Queries are used on all commands (bal, reg, etc). (docs)

Assets           # An account (regex)
acct:Assets      # same
^Assets          # Starting with Assets (eg, not 'Expenses:Assets')

acctonly:A       # no subaccounts

amt:2000         # amount (in absolute value)
amt:<200         # amount comparison (in absolute value)
amt:<+200        # amount comparison
                 # also: <=, >, >=

desc:REGEX      # description
code:REGEX      # transaction code (check number?)
tag:REGEX
cur:'\$'

real:            # real posts
real:0           # virtual posts

depth:N          # --depth 2
not:...          # eg, not:status:!

Filter by status/type

real:1           # -R, --real, no virtuals
status:!         #     --pending
status:*         # -C, --cleared
status:          #     --uncleared

Periods

For dates and intervals (see above).

date:2015/01/01
date:2015/01/01-    # -b, --begin
date:-2015/01/01    # -e, --end
date2:PERIODEXPR
-p, --period=...
  -p "2009/01/01"
  -p "2009/01/01 to 2009/12/31"
  -p "2009/01/01to2009/12/31"      # spaces optional
  -p "1/1 to 12/31"
  -p "to 2009"
  -p "weekly"                      # -W, --weekly
  -p "weekly 2009/01/01 to 2009/12/31"

Intervals

Used on all commands (bal, reg, etc). Displays in multi-column mode. In ledger-cli, only reg is supported. Can also specified via -p (period).

-D, --daily
-W, --weekly
-M, --monthly
-Q, --quarterly
-Y, --yearly

Smart dates

Used for --period, --begin and --end (-p -b -e).

-p 2015/01/01
-p 2015/01
-p 2015
-p january
-p jan
-p 05/25
-b today
-b yesterday
-e tomorrow
-p this week
-p last month
-p this year

Display formats

    --tree          # only in bal
    --flat

    --depth 2       # collapse those under this depth
    --drop 1        # drop top-level accounts
-B, --cost          # convert to default currency
-E, --empty         # don't strip out $0 accounts
    --date2         # use date2 when available

Multi-column mode

When used with intervals (like --weekly):

-T, --row-total
-N, --no-total

Also: (only in bal)

    --cumulative    # show ending balance per period
-I, --historical    # like --cumulative but only for --begin
-A, --average

Accounts

hledger accounts [--tree]

Other commands

hledger balancesheet       # bs
hledger incomestatement    # is
hledger cashflow           # cf
hledger print
hledger activity
hledger stats

Examples

# Current balance
  hledger bal Assets
  hledger balancesheet

  hledger balancesheet Assets [--cleared --cost --empty -e tomorrow]
  # ...discard future stuff; convert foreign currencies

# Monthly changes in assets
  hledger bal Assets Liabilities --monthly --tree --historical [--cleared --cost --empty -e tomorrow]

# Weekly expenses
  hledger bal Expenses --weekly --average --tree -b 'last month' [--cleared --cost --empty -e tomorrow]

See also

0 Comments for this cheatsheet. Write yours!