[GNC] Real Estate property-segregated costs tracking

Adrien Monteleone adrien.monteleone at lusfiber.net
Mon Dec 27 23:21:27 EST 2021


This question applies to various business models where you need to track 
revenue and expenses by 'entity' or 'project'.

GnuCash does not have an analogy to 'classes' as an extra dimension for 
reporting or tracking purposes.

There are various alternatives:

1. Use a spreadsheet or alternative software for this level of 
reporting. You can either export the data from GnuCash, or import it 
from the external app to GnuCash so you aren't entering anything twice.

2. Develop a system of 'tags' in GnuCash using one or more fields such as:
	a. Description
	b. Notes (you need to turn on Double Line mode to see them)
	c. Memos (Not visible in Basic Mode)
	d. Action/NUM (not the best idea, but perhaps doable)

You then run the needed reports filtering or using Regex to only show 
data for transactions matching those tags. (which presumably would be a 
tag for each property in your case)

Unfortunately, the best report here, Profit & Loss/Income Statement 
doesn't offer the needed filters in its Options. But the Transaction 
Report does. So you can use that, then export the result to a 
spreadsheet to get a pretty report designed the way you like.

(of course, you could craft a new report, or patch the P&L code to do 
what you want too, the above are suggestions shy of getting dirty with 
Scheme)

Note, the Business Features have something called 'Jobs' but this will 
not work the way you think with respect to this use case.

Regards,
Adrien

On 12/27/21 9:26 PM, Juan F. Saa wrote:
> Does anyone use GnuCash to keep track of wholesaling/flipping of Real
> Estate properties?
> 
> In Quickbooks this is done by entering each property as a 'class', as
> described here
> <https://resources.hemlane.com/quickbooks-for-real-estate-investors/>. I
> have been struggling trying to find a way to accomplish something similar
> in GnuCash for months.



More information about the gnucash-user mailing list