"[email protected]" <[email protected]> writes:
> 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 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:
>
> 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
>
but I need to keep track of how much milk I take to calculate how much I
pay, problem is after paying in cash I still hold milk as a commodity.
see my example
> 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.
>
Will try this. Thanks
> * 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.
>
This is not my experience. take into account the following example:
option "operating_currency" "USD"
1970-01-01 open Liabilities:BestBank:Mortgage:Loan
USD
1970-01-01 open Equity:Opening-Balances
1970-01-01 open Income:Salary:AcmeCo
1970-01-01 open Expenses:Food:Grocery
1970-01-01 open Expenses:Home:Monthly:Loan-Interest
1970-01-01 open Assets:House
1970-01-01 open Assets:BestBank:Checking USD
2008-01-01 * "Home" "Buy"
Assets:House 1 HOME {150000 USD}
Liabilities:BestBank:Mortgage:Loan -150000 USD
Equity:Opening-Balances
2008-02-10 * "ACME" "Salary paid from employer"
Assets:BestBank:Checking 2000.00 USD
Income:Salary:AcmeCo
2008-02-11 * "Groceries"
Expenses:Food:Grocery 300 USD
Assets:BestBank:Checking
2008-02-12 * "MORTGAGE PAYMENT"
Assets:BestBank:Checking -450 USD
Liabilities:BestBank:Mortgage:Loan 150 USD
Expenses:Home:Monthly:Loan-Interest
This gives a net profit af 1400 USD but balance in account is 1250
--
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/877bw0hnfv.fsf%40posteo.org.
