>From a high level - and I don't have time to dig too deep into the details right now - it's a matter of handling accounts differently depending on the scenario you desire to implement. For instance, you could have completely separate ledgers for each of the entities, but if you want joint reporting, some accounts would need to be renamed before reporting. It should be pretty straightforward to write scripts that join the various sets of transactions to a tempfile, mapping account names along the way, and then run Beancount on the result.
I'd be curious to see you detail in much detail the specific outputs you'd like to get. Going back to your original question: "Right now, it looks like Expense and Income are the top tree node, what should I do to make it a leaf node so their parent can be a rental property?" You cannot, but you can easily create subaccounts under those. Remember that at the end of the day, the final output from Beancount is a single giant table of postings, which you will project, filter and aggregate in various ways. This is by far the most integrated, simple way to think about the system. On Tue, Jan 12, 2021 at 2:52 PM Hao Wu <[email protected]> wrote: > Thanks for the reference, I looked at them quickly. > > Separate bean files sound like a good alternative, however many of rentals > share the same transactions, which would be tedious to manually separate > them. I can automate to some extent, but spreading the source of truth into > many locations made me wonder how I would reconcile / audit at a later > point. > > I am not able to find what the core really defines, but it sounds like if > it supports expense/income can be a leaf node and there is a way to plug in > and compute and produce the statement, that would work for me, with some > work to write something on my own. > > Ideally, I'd like to track expense/income *per activity*, it can be > either a rental property, or a project, or some of investment activity. > also there can be expenses/income for all/part of activities. And the final > statement can aggregate them all together. > > On Tuesday, January 12, 2021 at 6:46:46 AM UTC-8 [email protected] wrote: > >> IIRC that's something that can be built on top of Beancount, that can >> probably be build with some juggling of accounts. >> Here's the doc: >> >> https://docs.google.com/document/d/1nf_yCiLuewVCEjkXq9Kd9SqbZGWqcs0v0pT5xQnkyzs/edit >> Probably doesn't have to be part of the core. >> >> >> >> On Tue, Jan 12, 2021 at 9:35 AM Jake Drum <[email protected]> wrote: >> >>> The fund accounting proposal in the docs would be a good solution for >>> this, is that going to be implemented in v3? >>> >>> On Mon, Jan 11, 2021 at 11:50 PM Dritan Muneka <[email protected]> >>> wrote: >>> >>>> Hi, >>>> >>>> There's probably a way to do this with bean-query, but the easiest >>>> solution I can think of is to have each rental property in its own >>>> beancount file and call them both with an include statement. This was you >>>> can comment out the one you don't want to see. >>>> >>>> >>>> On Sun, Jan 10, 2021, 14:56 Hao Wu <[email protected]> wrote: >>>> >>>>> Hi list, >>>>> >>>>> What is the best way to track expenses and income per rental property? >>>>> >>>>> If I have two property, Rental-A and Rental-B, I need to track their >>>>> expenses and income separately, Expenses:Rental-A/B and Income:Rental-A/B, >>>>> and they are shown nicely in the income statement, however, what I'd like >>>>> to also have, is in the income statement, I can see P&L per rental >>>>> property. >>>>> >>>>> Right now, it looks like Expense and Income are the top tree node, >>>>> what should I do to make it a leaf node so their parent can be a rental >>>>> property? >>>>> >>>>> -- >>>>> 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 on the web visit >>>>> https://groups.google.com/d/msgid/beancount/36cb1836-e8a2-42be-ae4e-c2017855c440n%40googlegroups.com >>>>> <https://groups.google.com/d/msgid/beancount/36cb1836-e8a2-42be-ae4e-c2017855c440n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>> . >>>>> >>>> Dritan >>>> >>>> -- >>>> 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 on the web visit >>>> https://groups.google.com/d/msgid/beancount/CAJ3t8vi6J0eeHah60mqyps%3D%2BGAuv-HUVw_0yLiV%3DBJNvn5Cfzw%40mail.gmail.com >>>> <https://groups.google.com/d/msgid/beancount/CAJ3t8vi6J0eeHah60mqyps%3D%2BGAuv-HUVw_0yLiV%3DBJNvn5Cfzw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>>> . >>>> >>> -- >>> 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 on the web visit >>> https://groups.google.com/d/msgid/beancount/CAM_xKk3JBcjSFBEh400eRad41SgcdTSY%2B01ABB8MXhajHE4VCw%40mail.gmail.com >>> <https://groups.google.com/d/msgid/beancount/CAM_xKk3JBcjSFBEh400eRad41SgcdTSY%2B01ABB8MXhajHE4VCw%40mail.gmail.com?utm_medium=email&utm_source=footer> >>> . >>> >> -- > 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 on the web visit > https://groups.google.com/d/msgid/beancount/448da77c-52ca-44bd-84af-ab1827248832n%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/448da77c-52ca-44bd-84af-ab1827248832n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhOq5ZappDmK%3DO7Rhh24%2BmKq4%3DZG-XGxJgqTLs8r%2BjZ_Tw%40mail.gmail.com.
