Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    sm
    @simonmic:matrix.org
    [m]
    that's my motto
    my PTA survival tip :)
    slifty
    @slifty:matrix.org
    [m]
    Nuts, wish Fava could let me visualize by payee -- that's one big downside to not using vendor sub-accounts (e.g. being able to have my TreeMap show me which vendor is being paid the most, rather than one big Wages block)
    slifty
    @slifty:matrix.org
    [m]
    Update: oh yay beancount/fava#756
    slifty
    @slifty:matrix.org
    [m]
    I see fava has "fava.plugins.link_documents" as a listed plugin, but the documentation doesn't make it too clear if this is enabled by default or if I have to do something to make it work... Anybody here know how I can have documents appear as linked to my transactions?
    slifty
    @slifty:matrix.org
    [m]
    Looks like I just have to type plugin "fava.plugins.link_documents" in my ledger (btw what is the "noun" for a beancount document? is it ledger? recordset?)
    sm
    @simonmic:matrix.org
    [m]
    journal I usually call it, from https://en.wikipedia.org/wiki/General_journal
    Rudde
    @Rudde
    Are there no offical fava docker?
    Vlad Rafeev
    @dandaka
    Hey everyone! Is it possible to get an account statement? I am looking for a basic report, that will include
    — opening balance
    — closing balance
    — all transactions between
    3 replies
    one-validr
    @one-validr
    Hello, how to bind fava to https?
    I think I shall put fava under a reverse proxy.
    Other suggestion?
    yusf
    @yusf:gottsnack.net
    [m]
    @one-validr: there are various implementations on Docker Hub 🙂
    one-validr
    @one-validr
    Ok, i'll check ;)
    simonmic:matrix.org @simonmic:matrix.org would try caddy
    sm
    @simonmic:matrix.org
    [m]
    how would you convert to cost or value with Beancount, like Ledger's -B or -V/-X ?
    Alan Hawrylyshen
    @muonzoo
    Inventories are held at cost. You can write a query that uses your price data to show value.
    I'm pretty sure there's and example query in the docs and if not check the pta wiki?
    If not I can dig up an example of you ping the thread again and I'm on my laptop
    sm
    @simonmic:matrix.org
    [m]
    muonzoo (Alan Hawrylyshen) or anyone - a sample command line would be most welcome. There are a ton of docs
    saharshtapi
    @saharshtapi
    Hey Admin,
    Can you please look into the GitHub issue beancount/fava#1427
    Alan Hawrylyshen
    @muonzoo
    @sm if you have a sample file that works with hledger I can whip up the corresponding beancount example(s)
    putzwasser
    @putzwasser
    Is there an ETA for beancount3 ?
    sm
    @simonmic:matrix.org
    [m]
    @muonzoo: here's an example, I'm wondering how to show cost and market value like this:
    P 2022-01-01 A 3C
    
    2022-01-01
        (a)        1A @ 2B
    
    comment
    
    $ hledger bal -N
                      1A  a
    $ hledger bal -N -B
                      2B  a
    $ hledger bal -N -V
                      3C  a
    no, @putzwasser
    Alan Hawrylyshen
    @muonzoo
    Sorry - not familiar with ledger syntax sufficiently to work that one out. I can see that you price A at 3C, but I just don’t have enough time / context to process the transaction. I’m a bean count user and rather like the more rigorous syntax. :-)
    I suggest you read the bean count docs on inventories
    sm
    @simonmic:matrix.org
    [m]
    Thanks. If anyone can answer directly that will be ideal and appreciated
    That doc is nice muonzoo (Alan Hawrylyshen) but assumes more beancount expertise than I have
    those entries are incomplete, right ? "..."
    and the commands are not shown
    to recap: I'm looking for the beancount syntax and commands to report balances at cost and at market value
    sm
    @simonmic:matrix.org
    [m]
    I don't know if that involves @ or {}, or if it has to involve lots/inventories as in that doc - I'm interested in simple non-investment transactions like a currency exchange
    sm
    @simonmic:matrix.org
    [m]
    cost and value are very familiar reports in h/ledger but maybe beancount is more different than I think. Or I just haven't found the right docs.
    Alan Hawrylyshen
    @muonzoo
    I think you might want the holdings report
    This shows you all assets by account and broken out into lots with cost and market value.
    example: https://gist.github.com/muonzoo/7170a6c1e39b01a2bdf77ec7f86e7349
    bean-report beanfile.beancount holdings if not there are other bean-reports that might work for you.
    Alan Hawrylyshen
    @muonzoo
    I’ll also point out that this is the fave chat - and that the fava UI has support for showing everything at cost, market value or specific currencies in use.
    sm
    @simonmic:matrix.org
    [m]
    thanks
    this is combined fava & beancount, am I right ?
    or really more for fava ?
    sm
    @simonmic:matrix.org
    [m]
    2022-01-01 price AAA  3 CCC
    
    2022-01-01 open Assets:Aaa
    2022-01-01 open Equity:Eee
    
    2022-01-01 * ""
        Assets:Aaa        1 AAA {2 BBB}
        Equity:Eee
    
    ; Report cost:
    ;
    ; $ bean-report a.beancount bal -c
    ; Assets:Aaa    2 BBB
    ; Equity:Eee   -2 BBB
    ; Expenses    
    ; Income      
    ; Liabilities 
    ;
    ; Report value:
    ;
    ; $ bean-report a.beancount holdings
    ; Account     Units  Currency  Cost Currency  Average Cost  Price  Book Value  Market Value
    ; ----------  -----  --------  -------------  ------------  -----  ----------  ------------
    ; Assets:Aaa   1.00       AAA            BBB          2.00               2.00              
    ; ----------  -----  --------  -------------  ------------  -----  ----------  ------------
    thanks for the command hints, that helped. bal -c shows cost and holdings shows value. Though, why is it not showing value above ?
    Alan Hawrylyshen
    @muonzoo
    Likely because your price data is from the same day ? Double checking
    There is also a useful plugin called ‘auto’ that will skip you needing to declare and open all accounts / commodities - I don’t recommend it for your real ledger but it is useful for testing / examples.
    The examples we are working on now are just beancount - no fava.
    sm
    @simonmic:matrix.org
    [m]
    right, I meant is this channel for beancount and fava both ? I have assumed that from the name
    Alan Hawrylyshen
    @muonzoo
    It might be :-) but I assumed that it was named after the respository (beancount/fava vs beancount/beancount) I think you are more likely to be correct. :-)

    Looking more closely I see that you are doing something ‘unusual’ perhaps this is your point but you are purchasing ‘AAA’ using currency BBB but you’ve priced it in ‘CCC’.

    If you use implicit prices (which is another plugin) bean count will auto generate a price from the purchase transaction that makes things work as you might expect.

    plugin "beancount.plugins.auto"
    
    2022-01-01 price AAA  3 CCC
    ;2022-01-01 open Assets:Aaa AAA
    ;2022-01-01 open Equity:Eee ; no comoddity - can hold anything
    2022-01-01 * ""
        Assets:Aaa        1 AAA {2 BBB}
        Equity:Eee
    bean-report /tmp/t2.bean holdings
    Account     Units  Currency  Cost Currency  Average Cost  Price  Book Value  Market Value
    ----------  -----  --------  -------------  ------------  -----  ----------  ------------
    Assets:Aaa   1.00       AAA            BBB          2.00   2.00        2.00          2.00
    ----------  -----  --------  -------------  ------------  -----  ----------  ------------