Rental P&L

[Hao Wu]

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?

[Dritan Muneka]

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.

--
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+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/36cb1836-e8a2-42be-ae4e-c2017855c440n%40googlegroups.com.

Dritan

[Jake Drum]

The fund accounting proposal in the docs would be a good solution for this, is that going to be implemented in v3?

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAJ3t8vi6J0eeHah60mqyps%3D%2BGAuv-HUVw_0yLiV%3DBJNvn5Cfzw%40mail.gmail.com.

[Martin Blais]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAM_xKk3JBcjSFBEh400eRad41SgcdTSY%2B01ABB8MXhajHE4VCw%40mail.gmail.com.

[Hao Wu]

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.

[Martin Blais]

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.

To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/448da77c-52ca-44bd-84af-ab1827248832n%40googlegroups.com.

[Hao Wu]

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!