Billable Time that is unable to be billed because maximum billing has been reached

What is the best way to report on Billable Time that I am unable to bill because maximum billing has been reached?  I have been using the Markup feature so that the charges are not billed, but wish to be able to show how much Billable Time is not being charged (and paid).  Should I be changing the slips to NO CHARGE instead of using the Markup?  I thought there was a reason I shouldn't be doing that.  Please advise. 

  • 0

    I'm not 100% certain I am following what you want to do but it sounds like you are referring to a Maximum flat fee arrangement. 

    That arrangement will charge all of your slips until the bill reaches that Maximum value, and then all additional time will be treated as though the slips were entered with a DO NOT BILL status.  The time will be recorded and visible as billable time on reports, but the client will not see that billing.

  • 0 in reply to RogerS
    Thank you for the reply. The client project is billed at a hourly rate. However, some clients have a cap on how many hours we can bill for the project (even though it may take us longer). I am able to bill up to the maximum hours, however, I would like to be able to show management that of the "real" billable hours, we billed the cap hours. For example, a project may take 70 hours, but we can only bill 50 hours. I want management to see the total of 70 hours as billable time (because they are), but 50 hours as "Billed Time".
  • 0 in reply to billingmgr
    What is a little unusual here is the use of Hours and not Dollars, as most users of Timeslips have various employees that might bill at different rates, so 10 hours of paralegal time is billed out at substantially less than 10 hours of a Senior Partner's time. Thus Hours would be an odd way to manage the fee. Can you provide confirmation that Hours is really how you wish to handle it?

    A lot of this depends on what you want your reporting to reflect. I agree with you that all the hours are billable, just at a capped price. For every additional hour recorded, your price per hour decreases. Otherwise, only the first hours are billable and folks who happen to get assigned the work on the end of the project end up with unbillable hours.
  • 0 in reply to Nancy Duhon
    Yes, Hours is what I am looking for. The projects are not billed at individual user rates. They are billed at "client project" rates; it doesn't matter who is doing the work, it is still billed at the same rate.
  • 0 in reply to billingmgr
    Okay, thanks for the additional information. If you wanted to, you could make use of the Maximum Flat Fee billing arrangement as Roger suggested above. You will find this under Client Info, Arrangement tab, under Fees. The program defaults to Slips (Hourly billing), but you can pull that menu down and choose other things. (Make sure and choose JOB as the Duration, and do not leave it at the default, which is Perpetual.)

    IF you go with the Maximum Flat Fee, you just key all of your slips as billable at the Client Project rate. You don't worry about anything at a slip level.

    Then you set up the Maximum fee on the client level to be the maximum dollar amount calculated as the Maximum Hours (MH) times the Client Project Rate (CPR). You just need to do the one time calculation of MH x CPR at the beginning of the project, and put that in as the Maximum Fee (MF). So, to recap: MF = MH x CPR.

    Timeslips will keep track of the slips entered and at billing time, will compare it against the MF. If the Actual Hours Recorded x CPR is less than the MF, it will bill the lower amount, and accrue that progress to history. When the history + (Actual Hours Recorded x CPR) exceeds the MF, it will cap the fee at the MF.

    Whether you want to show the slip details to the client is up to you via the layout, but I'll have to disagree with Roger above. The slips entered beyond the Maximum are not treated as DO NOT BILL. They WILL show up on the bill if you are showing slip details (as Billable slips always should), they just won't charge the client anything more because the Maximum will prevent it.

    You will then be able to run an accurate Flat Fee Analysis report (found on the client tab) to show management whether they made a profit or loss on that type of fee arrangement.

    Again, the key here is that all slips are billable, all hours are billable, but their individual values go down as more hours are entered.

    You can test this in your Explore database if you would like, and you should. To make sure that everything gets reported as you would like it to.
  • 0 in reply to Nancy Duhon

    Thanks for correcting me, Nancy. Yes, they will be billable, but essentially acting as No Charge slips since their value will have exceeded the maximum value in the billing arrangement.

    To clarify for anyone coming into this thread later on, literal 'Do Not Bill' status slips would not appear at all on the bill and would not be charged, per se, to the client, and 'No Charge' slips would appear on the bill with a zero dollar value.  While this isn't what would be set on these slips under this scenario, the arrangement will have the same net effect.