I need to put more thoughts into it, my ultimate goal is to implement similar to quickbook and produce a nice income/cashflow monthly statement (fwiw in pdf) for all investors in my LLC, which aggregates all the investing activities.
Now I have subaccounts as you suggested, and manually have them in google sheet, which works for now but I'd like to do it in a correct and productive way. I can have tags or links to categorize activity, and generate the report as I see fit, this sounds like what you suggest doing. Thanks all for the inputs! On Tuesday, January 12, 2021 at 2:07:42 PM UTC-8 [email protected] wrote: > 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/e5042797-fa42-4cfe-9de5-31ceb755b753n%40googlegroups.com.
