Where communities thrive


  • Join over 1.5M+ people
  • Join over 100K+ communities
  • Free without limits
  • Create your own community
People
Repo info
Activity
    gary
    @garyp:matrix.org
    [m]
    slifty: for question 1, I would probably add the project as metadata on the individual posting rather than sub-accounts for each project. I think you should then be able to write a beancount query using the metadata in order to get a balance for just a specific project even across multiple bank accounts. And you can put the metadata on your Accounts Payable/Receivable postings too.
    slifty: for question 2, why do you need the separate sub-account for each vendor? I would just put them all in one account and do a report by payee to see each vendor's balance.
    1 reply
    slifty
    @slifty:matrix.org
    [m]

    @gary I am storing invoices alongside my ledger; do you know if it's possible to maintain a document structure that doesn't mirror accounts directly (e.g. if I track vendor using the Payee model)? With sub-accounts I had each invoice in a ./Liabilities/AccountsPayable/VendorNameHere which aligned with the account. Fava seemed opinionated about that file structure, but I'm wondering if maybe I'm not so locked in.

    (or, alternatively maybe I keep the AP sub-accounts but ditch the expense sub-accounts. food for thought.)

    I know I'm saying thanks a lot but why stop now: thank you so much for the advice

    simonmic:matrix.org @simonmic:matrix.org would stick with accounts for such an important subdivision that needs to be reliable
    sm
    @simonmic:matrix.org
    [m]
    but, YMMV! whatever works
    slifty
    @slifty:matrix.org
    [m]

    sm: ah! Are you talking about for vendors or the project concept (or both)?

    Now that you mention that, I do think the reason I was worried about relying on Payee was the potential for typos -- whereas with accounts I'd get an error if I screw it up

    sm
    @simonmic:matrix.org
    [m]
    right. I was responding to "why do you need the separate sub-account for each vendor"
    slifty
    @slifty:matrix.org
    [m]
    sm: Got it -- point well taken; and to that end where I might wind up is "sub accounts for AP" (which addresses my document problem too), but NO sub-accounts for the expense.
    Once this is all done maybe I'll write a blog post to share what I've learned in case it helps others in future...
    sm
    @simonmic:matrix.org
    [m]
    when you find you need to report things separately, that's the time to add separate accounts for them, usually
    until then, less is more!
    slifty
    @slifty:matrix.org
    [m]
    sm: I like that rule of thumb
    sm
    @simonmic:matrix.org
    [m]
    the fewer moving parts, the better. Finances get complex enough already
    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.