Ledger

Common [[https://www.ledger-cli.org/]\[Ledger]] CLI Commands ([[https://gist.githubusercontent.com/agarrharr/03450c1be7f6b3d2b883c6b5e317d2aa/raw/4c5bfa57be1cd98a232e3f4bda0fcc2a51ba0862/index.md]\[Source]])

Income vs expenses this month?

ledger balance income expenses --period "this month"

What did my budget look like at a certain date?

ledger balance budget --end 2018-01-02

This is how it looked at the end of the day on Jan 1, 2018.

How much is in the checking account right now?

ledger balance checking

What is our net worth?

ledger balance ^assets ^liabilities --real

How much money have we made?

ledger balance income

How much money have we made from our salaries?

ledger balance income:salary

How much do we spend each month on x?

ledger register -M expenses:groceries:food

Group transactions by payee

ledger register --by-payee

Only show uncleared transactions

ledger register --uncleared

Do I have enough budgeted to pay off my credit cards?

ledger balance creditcard

It should be $\mathrm{0.00.}Ifi{t}^{\prime }snot$0.00, run this with different dates to find the problem:

ledger balance creditcard --end 2018-02-01

Import

Change Chase checking from:

#+BEGIN_EXAMPLE
Details,Posting Date,Description,Amount,Type,Balance,Check or Slip #
#+END_EXAMPLE

to:

#+BEGIN_EXAMPLE
,Date,Payee,Amount,,,Code
#+END_EXAMPLE

Change Chase Credit Card from:

#+BEGIN_EXAMPLE
Type,Trans Date,Post Date,Description,Amount
#+END_EXAMPLE

to:

#+BEGIN_EXAMPLE
,Date,Posted,Payee,Amount
#+END_EXAMPLE

ledger convert ~/Downloads/checking.CSV --input-date-format "%m/%d/%Y" --invert --account Assets:Checking --rich-data -f budget.ledger --auto-match --pager less

Expenses each month (sorted)

ledger -M --period-sort "(amount)" reg ^expenses

This will show all expenses, grouped by month and sorted by the amount.

How much do we spend on credit cards each month?

ledger -M -r --display 'account=~/creditcard/' reg ^expenses