I honestly just use excel but that's because I use it as a book of record for receipts as well. Since you're looking for open source alternatives, OpenOffice would fill that need.
I’ve finally settled on hledger for now. There’s some issues, mainly the reports are generated by calendar year, there’s no support for Financial Year reports (Apr-1 till Mar-31 in India).
1. Using period reporting feature (`-p`):
hledger bse -p "yearly from 2019-04" --depth=2 --layout=bare -e 2022-04-01 -X₹
2. Separating journals into April 1 – March 31 financial years.3. Using `-b` and `-e` to demarcate begin and end dates when generating reports.
The trick with making excel work is treating your finances like a company with assets and liabilities. Build out your balance sheets, list it out, and compute it.