[GNC] Job Expenses? Job Profit Reports?

Adrien Monteleone adrien.monteleone at lusfiber.net
Tue Dec 28 19:16:36 EST 2021


The short answer is, "you can't." 'Jobs' aren't quite what the name 
implies. Rather, think 'Purchase Order'.

There are various use cases the 'Jobs' feature does not work for:

Multiple Customers (and even split with stock orders) for the same Job. 
Yeah, I know this sounds weird, but if a Job is really just a PO, it is 
not un-common to place a single PO with a Vendor that covers not only 
items for multiple customers, but also for stock inventory.

The Job assigned to a Vendor and the Job assigned to a Customer are 
*not* the same 'job' despite them both having the same 'job name'.

The intended use case is extremely limited.

There are several other threads about job/project/property reporting. 
Other than using outside software entirely, you have perhaps 4 options:

1. Create special expense/income accounts for each job/project/property 
and only include those in the relevant reports. The drawback is 
cluttering your CoA, especially if such special accounts aren't 
on-going. (easier for rental properties, less so for one-offs)

2. Use your own 'tags' in various fields to identify what 
job/project/property the expense/revenue applies to. Then use the 
Transaction Report, exporting to a spreadsheet if needed to make it 
pretty the way you want.

3. Modify the P&L/Income Statement to use the report Option to filter 
based on various fields like the Transaction Report can. (the included 
P&L doesn't have this option)

4. Craft your own entirely custom report that uses these 'tags'.

-----
I say 'tags' because GnuCash doesn't have that as an established 
feature. You'd simply include text with an identifier like '@' '#' et 
cetera before the tag text and put that tag in one of the 'Description' 
'Notes' 'Memos' or 'Action' fields as you find useful.

Regards,
Adrien

On 9/21/21 1:26 AM, Christian Peritore wrote:
> Looking everywhere for this function but can't seem to find it.
> 
> How to connect a given Job to any Expense? Then how to Report a Job's net profit (and connected total Expenses and total Income)?
> 
> Entering Expenses doesn't seem to offer a Job to spend against. I presume I need to bring the Expense into an Invoice manually? Ok...
> 
> But then how to view the total of Expenses for a given Job, thus it's net profit?



More information about the gnucash-user mailing list