[GNC] Need to Print A List of Expense Accounts

David T. sunfish62 at yahoo.com
Tue Dec 30 01:30:16 EST 2025


I would try the Account Summary report. If you want the results in a 
spreadsheet,  Ctrl-A, Ctrl-C, switch to spreadsheet, Ctrl-V 
  
  
  
  
  
  
  
  
  On 12/29/25 15:38, Jerry Criswell (JC) wrote: 
  
  I would export the CSV, and run it through something to extract the  
  
  account names. On Linux that would probably be: 
  
  
  
  
  awk -F, '$1=="EXPENSE" { print $2 }' accounts.csv 
  
  
  
  
  I don't have a Windows computer to test this, but in PowerShell you  
  
  could try: 
  
  
  
  
  Import-Csv accounts.csv | 
  
     Where-Object { $_.Type -eq "EXPENSE" } | 
  
     Select-Object -ExpandProperty "Account Name" 
  
  
  
  
  
  
  
  
  
  
  _______________________________________________ 
  
  gnucash-user mailing list 
  
  gnucash-user at gnucash.org 
  
  To update your subscription preferences or to unsubscribe: 
  
  https://lists.gnucash.org/mailman/listinfo/gnucash-user 
  
   
  
  Please remember to CC this list on all your replies. 
  
  You can do this by using Reply-To-List or Reply-All.


More information about the gnucash-user mailing list