3 ms·

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 wo

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.

ntoni 3y ago
Also used excel previously. Then I switched to an ios app that sync with all my different bank accounts so I don't have to record stuff manually.
girishso 3y ago
I tried Excel few years back, it’s only easy when all you are tracking is income and expenses. But when you buy some stocks or MFs, the amount is debited from Bank but it’s not really an “expense”. And good luck tracking fund flows between your own accounts. 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).
- 5ol 3y ago
  You can do this in a few ways, depending on what exactly you want to do: 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.
  - girishso 3y ago
    That's terrific, thank you!
- simonmic 3y ago
  Here's a trick for reporting your transfers https://www.reddit.com/r/plaintextaccounting/comments/16d2xkg/add_monthly_mortgage_payment_to_incomestatement/ https://www.reddit.com/r/plaintextaccounting/comments/16d2xk... (alias the account names to expenses/revenues temporarily).
- freitzkriesler2 3y ago
  Whoever down voted me can suck a fat bag of d1cks. 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.
- 2Gkashmiri 3y ago
  have you tried something like gnukhata? it should work out for you i suppose

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.

ntoni 3y ago

Also used excel previously. Then I switched to an ios app that sync with all my different bank accounts so I don't have to record stuff manually.

girishso 3y ago

I tried Excel few years back, it’s only easy when all you are tracking is income and expenses. But when you buy some stocks or MFs, the amount is debited from Bank but it’s not really an “expense”. And good luck tracking fund flows between your own accounts. 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).

5ol 3y ago
You can do this in a few ways, depending on what exactly you want to do: 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.
- girishso 3y ago
  That's terrific, thank you!
simonmic 3y ago
Here's a trick for reporting your transfers https://www.reddit.com/r/plaintextaccounting/comments/16d2xkg/add_monthly_mortgage_payment_to_incomestatement/ https://www.reddit.com/r/plaintextaccounting/comments/16d2xk... (alias the account names to expenses/revenues temporarily).
freitzkriesler2 3y ago
Whoever down voted me can suck a fat bag of d1cks. 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.
2Gkashmiri 3y ago
have you tried something like gnukhata? it should work out for you i suppose