Last updated on Jan 06, 2021
New to ledger? Start here.
After you’ve accumulated transactions in your master ledger that split with
Expense accounts, you can trivially create a by-month expense report using Google Sheets.
Export an expense CSV using the
cd ~/Development/ledger-scripts bash export-expense-csv.sh > ~/Downloads/all-expenses.csv
- Open the expense report Google Sheets template
- Selecting B2 on the sheet ‘Raw Data’.
- Going to File > Import > Upload > Select a file.
- When the CSV dialog opens, make sure cell B2 is highlighted in the background and you select “Replace data at selected cell” on the dialog.
If you mess up, you can always Undo (
<Ctrl> + Z).