Hi, I don’t use forecasting myself, and there are probably plugins and scripts other uses, but here are some quick answers outside that.
In GNUCash, I could set up recurring transactions using a mortgage formula that automatically calculated principal + interest. When you Here’s the trivial script <https://gist.github.com/redstreet/3bf5b9da37329835297b851e933a1b05> I use. When importing from your bank, manually replace your mortgage transaction with the output of this script. Or automate it if you have fancy importers setup. - Buy milk from farmer. Simplified: 2025-03-03 txn "Pay Milk January/February" Assets:Csah -50 EUR Expenses:Groceries:Milk Or if expense spreading matters, I use my plugin <https://github.com/redstreet/beancount_reds_plugins/tree/main/beancount_reds_plugins/effective_date#readme> : 2025-03-03 txn "Pay Milk January/February" Assets:Csah -50 EUR Expenses:Groceries:Milk 25 EUR effective_date: 2025-01-01 Expenses:Groceries:Milk 25 EUR effective_date: 2025-02-01 I have a car that can use LPG or Gasoline (95 or 98). Rigth now I do: Use metadata: 2024-06-01 * "Gasoline" odometer: 66,324 gallons: 11.567 Liabilities:Credit-Cards:Credit-Card -50 USD Expenses:Car:Koeninsegg:Fuel You can then write a simple plugin to compute fuel efficiency and such. I use it for oil changes as well. - Net Profit Liabilities and Expenses I have a mortgage on my main house (it’s my only one and not an investment). As far as I can tell, net profit is calculated without accounting for principal payments on the mortgage because those are treated as Liabilities, not Expenses. This doesn’t make much sense for personal finance tracking. How can I adjust this? Or, alternatively, how can I calculate what money I really have available (Income - Expenses - Payments on Liabilities)? Payments are typically booked as such: 2025-10-12 * "Mortgage Payment" Assets:Banks: -1000 USD Expenses:House:Mortgage:Interest 800 USD Liabilities:Mortgage 200 USD So money flows from Assets:Bank to Liabilities:Mortgage and Expenses:Interest. There’s nothing you should have to do: your net profit and net worth should all compute correctly as expected. -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion visit https://groups.google.com/d/msgid/beancount/8148fe72-fb46-492c-afd5-62e4b6daefa0n%40googlegroups.com.
