Is there a way in which to show a report or summary of actual profitability where logged expenses and non-billable items actually decrease the total amount billed? All expenses except for any markups along with any non-billable items should be counted against the billed totals. If I look at the included summary Client + Project Profitability it actually adds expenses and non-billable items to the total inflating the totals improperly.
Date
Votes
5 comments
-
Oranged Support If you select Summaries Menu > New Custom summary, you can create a summary of all/billable/non-billab/etc by selecting the type popup in the summaries window.
Separately, if you want to show the actual profit (which is the total billable minus any costs), you can change the displayed fields by clicking on "show fields" and removing "amount" and adding "profit".
-
Greg Guarnaccia Thanks for the reply. There are still two fundamental issues that make this not work correctly and were throwing me for a loop.
1) When creating the Debit/Credit item you must use the Calculate Total function for the amount to be not included in the profit calculation. If you just enter an amount it gets added to the total profit. This should be corrected so the basis is whether it's a Reimbursable Expense or Non-Billable item and not effected by how you choose to enter the amount.
2) Non-Billable items are not treated correctly. They are treated the same as reimbursables rather than being subtracted from the profit total. So while these amounts are not totaled as profit they are also not counted against the billings as they should be which makes this summary of no use to determine actual profit.
-
Oranged Support Hello Greg,
You might want to check out this page regarding profit of billable and non billable items on a project:
https://oranged.zendesk.com/entries/25858807-Project-EstimatesIf an item has a cost rate or cost amount, it will count against the cost of the project. If you want to add items to a project that reduce the total billed amount, you might be looking for discounts, or you may want to create a new debt/credit type that reduces the amount billed on the project. If you have an item that you do not want to enter a cost for, but want to have it reduce both the amount bill and the profit, that would be best served by adding a new type.
1. Go to the preferences window
2. Go to Categories & Rates
3. Under Debt/Credit types in the bottom left, click the plus button
4. Select the "Credit/Discount" type. Name it and press OKNow, you can add an item of this type to your project, and when you do it will reduce the profit of the project and the billable amount of the project.
-
Greg Guarnaccia Thank you again for the response! I looked at the reference you provided, thank you. I use manual estimates to note what my project contract total is but this doesn't affect the Profit question.
I can't use discounts because I do not want to reduce the amount billed. Here is an example of what I am trying to achieve.
If I bill $1,000 on a project and have a non-billable expense of $200 then I need to see that my actual profit on the project is $800 even though my billings are $1,000. My client is still getting a bill for $1,000. I just had an expense that can not be billed for and therefore it reduces my profit. Is there a was in which to achieve this?
-
Greg Guarnaccia Okay, I see what you are saying regarding using a discount. If I create a "Non-Billable" Discount item it effectively does not reduce the billing total and still counts against the profit. I think what's confusing is the terminology since I'm not really giving the client a discount. None the less, this I believe will work.
Thank you for the help.
Please sign in to leave a comment.