Hi all, I am quite new to beancount (and in accounting in general) and are testing a few minor things at the moment with version 3.
At the moment I am planing to use it for two topics. One is for travelling and another one is for calculating tax relevant gains from investing (with interarctive brokers), which needs to be converted to EUR currency gain. For my understanding that is possible with beancount, but I missed up to now a good example case for it. Maybe someone can point me to one? This would be great! As mentioned, in addition to these investing tasks, I would like to track my business trips and also count days abroad or days in a hotel. For my understanding I am having different options to track this. I saws this: https://groups.google.com/g/beancount/c/NGt2BRHR6LE and understand, that I can use tags, meta or links for additional information. It seems that meta is a good option. Maybe I could even use a special NIGHT-currency also for tracking it. But I am not sure yet, what the best way is to get e.g. the number of nights which I stayed in a hotel in a certain time frame and what I paid for this. E.g. I could state a stay of 3 night in these two ways: ``` 2025-03-11 * "Hotel in Berlin (3 nights)" date: "2025-03-08" ; Booking date nights: 3 ; Number of nights purpose: "Conference" Expenses:Travel:Accommodation:Hotel 300.00 EUR Assets:Bank:Checking -300.00 EUR 2025-03-08 * "Hotel in Berlin (3 nights)" firstNightDate: "2025-03-11" ; date of 1st night nights: 3 ; Number of nights purpose: "Conference" Expenses:Travel:Accommodation:Hotel 300.00 EUR Assets:Bank:Checking -300.00 EUR ``` With this query: ``` bean-query uow_test3.beancount " SELECT SUM(position), entry.meta['nights'] as nights WHERE account ~ '^Expenses:Travel' GROUP BY nights " ``` I get something like this: ``` SUM(positi n ---------- - 600.00 EUR 3 ``` I.e. I am summing the cost for all stays with 3 nights, but the number of nights. Do you have an advice how I can adjust my query for this? Thank you in advance! Best Regards Fab -- 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 beancount+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/beancount/fb28e70a-7ee3-4d56-9dcc-081de1ecc923n%40googlegroups.com.
