Time & Material Billing Show a discount give to Client in bill

SUGGESTED

Hi! Sorry if already answered - I could not find it. 

T&M Billing that we would like to show the Markup (10%) and then show a discount (5%) for both labor and materials, so the client realizes how we got to  the requested amount. 

I see the "Shown Markup" in 3-10-1 T&M Billing Setup, but I do not see where I can either add the discount per line OR as one line items at the bottom of the invoice (maybe during the create the bill process not in the set-up?)? I am aware of how to take the discount when the payment arrives, but that does not give me what I need on the bill. 

Any help would be greatly appreciated - even if to say that it can not be done. Thank you! 

  • 0
    SUGGESTED

    I would work this up differently...instead of all in T&M I would post the T&M invoice and then create a regular invoice that shows the 5% discount.   Don't know if you can actually show a discount in T&M so I look forward to the other responses.  

  • 0 in reply to DeboraB

    Thank you for your suggestion - I did not know that was an option. I will look at it later this week when ready for next billing and see what I get. Have a great day.

  • 0 in reply to bayviewbuilders

    Hi , if this suggested answer helped, please do mark it as verified Smile thanks!

  • 0 in reply to Erzsi_I

    I have not been able to try it yet - I will as soon as I know if it works. Thank you! 

  • 0
    SUGGESTED

    Is the discount because its a good customer and always gets it?  Or for early pay by the 10th?

    The T&M bill is not typically where you would show the discount. 

    The 3-2 invoice that is a result of posting the T&M invoice is where you can add the discount.  And if you set up the 5% discount for the client in 3-6, it may calculate it for you in the 3-2.  I can't be sure until you test it.  I don't have any T&M data to test right now

  • 0 in reply to Char DeLange

    Yes to it is a good customer and not sure always, but for this project. Not for early pay. 

    I have not had a chance to start a new invoice yet to see where it will all fall, but as soon as I do I will try this out. 

    Thank you for your help! 

  • 0

    Finally had a chance to try this today and still struggling.....here are my issues -

    I want to show 10% mark up on Materials - when I enter that in the Set-up Box - and then run a T&M Invoice - the 10% dollar figure comes out correctly , BUT The "Markup @     %" then shows 4.31 BC it is 4.31 % of entire bill (Labor and Materials), but not of the Materials.     

    So - before I can even get to the next part of 5% discount - which I do see how that can happen in the following steps - I can not get the markup to show as 10% unless I do as hidden, which is not what we wanted. 

    How can I get the Shown Markup to calculate on Materials only and show 10% as the total markup amount? Is that even possible? 

    Then I can get to the 5% Discount . 

    Thank you so much for your help! Happy New Year! 

  • 0 in reply to DeboraB

    DeboraB - I have been trying to work this out for days. Here are the issues I am having. 

    1. I can not figure out how to do what you mentioned - to post to T&M (I can do that) and then create a regular invoice.....does that mean I can bring the info over from the T&M somehow? I feel like I am missing one step in the process or something. If I simply create another invoice I would be over stating my sales. Any directive on what you were referring to would be great. 
    2. T&M Invoice: when you enter a shown mark up for materials in the set-up and then print the T&M invoice the discount shown at the bottom of the invoice does not reflect the actual discount amount. IE - my shown mark-up is 10%  in the set-up, but once calculated via Sage it come out to 4.61% bc it is saying that is the percent off Materials & Labor. IF there anyway to get it to reflect 10% at the bottom - IE Materials Markup 10%     Labor Markup 0%

    Thank you for your help! 

  • 0 in reply to bayviewbuilders

    Playing with this,  I think that you will need to modify a report.    The easiest way is to go into the T&M invoice you want to use and add a cost type#.  Click modify report.  The filter and select  type #.  This will add the ability to only show materials on your report.   With that you can see the 10% markup total.    Then run the separate report with types 2-5.   You will have to post both to your invoices but won't be a big deal.  

    Your 5% discount, I don't know how to have that automatically show up in T&M.   That is why I would go to 3-2 and calculate the amount of the discount and enter it as a negative invoice.   Say I am billing 10000 for Labor and materials.   I would have a materials invoice showing the 10% markup, another invoice showing Labor Equipment and subs, then another invoice that shows the $500 discount (-500 invoice) .  All this would show up on the statement together and if labeled appropriately should easily be discernable by the client.  

  • 0 in reply to DeboraB

    THANK YOU FOR ALL OF YOUR HELP! I think that we are simply going to use the NOTES section and then print both a Contract Invoice and the T&M Invoice (so the client can see the detail).      It seems that the way I was hoping it would work is not possible, so we will work around. 

    Thank you again!