Streamline Your Billing with Our HVAC Invoice Template for Management

Hvac invoice template for Management

what's going on everybody it's Richard cobre here the blue CL nerd and in this video I'm going to be showing you how to set up and use commercial service agreements in service Titan so step one is to set up a service agreement template to do that we're going to come into settings and look for service agreement there we go right there under operations now for me in my example account here I already have one set up so I'm going to click edit here to open that up and show you what's inside but if you are just starting and you don't have one yet you would be clicking add up here so the first field up here is the name uh mine is named store books Cafe and bookstore because that's the location where I intend to use this although a better name might be uh deferred revenue template so I'm actually going to rename mine to that uh I say that because the main purpose of the templates is to set up the revenue recognition settings basically everything else you can set up individually per client but the template is mainly locking in Revenue recognition settings which means if you handle all of your service agreements the same way in that regard guard you you always use deferred revenue or you always use immediate Revenue recognition then you might only need one template set up but anyways there's our name we've got a tag field where we can automatically apply a tag to any location that has this service agreement template active on it so for my example I just made a tag called agreement client by the way you're able to create a new tag from this drop down so you don't have to navigate away okay and then it's time for the meat of what we're doing here which is the revenue recognition settings so we're going to get into some you know light accounting speak here if if you're totally unfamiliar with any of these terms and and you don't know anything about accounting I highly recommend working with somebody who is for this particular part of the setup so we've got two options for recognition here we've got immediate recognition that's the simpler option but less of the accounting best practice option with immediate recognition when you sell a service agreement you recognize all of that Revenue all at once that is very simple but the reason that it's not the generally accepted accounting principle is that you have a liability when you sell a service agreement you haven't done all the work yet you're agreeing to do work throughout the year so with deferred revenue recognition all of the money that you collect Upfront for the service agreement that goes into a liability general ledger account and then as you perform those services that you promising to perform that Revenue gets moved from the liability account out into a revenue account so you're recognizing it since that's the more complex option that's the one I'm choosing to select here so that I can kind of walk you through it a little bit so first we need to select the general ledger account that's going to hold the funds that we collect until we perform the work this needs to be a liability account okay the next step is choosing how we want to handle agreements that get cancelled so the recommended option is this middle option here give the option to create a charge SL refund invoice basically that means that anytime somebody in the office cancels an active service agreement they're going to be given the option to refund work that's been paid and not done or charge for work that has been done and not paid so you can give give that office person the option but not the obligation to generate that invoice every time you can choose to always generate that invoice and not give the office person the option to not do it or you can choose to never have that invoice automatically created that's the best option if you would prefer to have like an accounting person come back in and handle it later for my example I'm going to leave the middle option selected okay now we need to choose the services in our price book that are going to coincide with our deferred revenue setup if you've done deferred revenue with memberships this works the exact same way but basically we need three tasks set up in our price book that we're now going to select and map here the first task is the billing task that's the task that's going to show up when you sell the agreement and it should be tied to the liability account this is the task that Parks the money there in the liability account then you need one negative liability task and one positive income task and both of these tasks will populate when you actually go to perform the promised work so the negative liability task that's tied to that same Li liability GL account that the billing task is tied to and it's going to charge a negative number to reduce your liability take that money out of the liability account and then you have the positive income task that is adding that same amount of money that you just took away from your liability into your recognized revenue account so you charge for a service agreement you have this task that puts all of the money into a liability account so you have that amount of liability then as you go and perform the work one of these tasks will take money out of the liability account and then the other task will put money into your revenue account recognizing that revenue and reducing your liability okay this next section for default values you'll notice that that is optional it's optional because everything under here can be set up individually as you're setting up a particular service agreement for a location so anything you put in here will populate as the default values for these fields when you go to set up a service agreement but you can also choose to just leave this blank and set it up per service agreement and for my example that's what I'm going to do so I am done here I'm going to hit save and and now I have my template done so let's set up a service agreement for a location so here I am I'm on the location page for my fictional store store books I've got a section here for service agreements and I can click this create agreement button so we're going to fill in the agreement name and then we're going to select the agreement template again that's mainly selecting how we want to recognize this Revenue so I've got my deferred revenue template here and we're going to select a business unit okay and just to be clear what we're creating right now is a proposal for a service agreement that we can either not sell or hopefully sell all right so let's hit create and then that brings us onto this screen where we can set up the rest of the service agreement so we can type in an agreement summary here okay and then we choose a document Design This is the like document for our proposal that we would send to the client so there is a default one here I'm just going to select that for this example but you could also create your own to do that you would go back into settings search for the document templates you'll see that the server San default is already in there but we could click new templ template and then from here we can design our own custom PDF with a drag and drop experience or if you didn't want to start from scratch you could also come over to this Kebab menu uh and make a copy of the default and then you can make edits to that so you have more of a solid starting place I'm not going to spend too much time building one out here just because it's kind of separate from what this video is about so for my example I'm just going to stick with the service Titan default now to be clear if you already have an internal document that you like or that you just don't want to change from just because the change management is difficult you can still have your person out in the field build out their proposal the way they've always done it and then somebody in the office would basically duplicate that here in the uh service agreement setup I don't necessarily recommend doing it that way because it is duplicate entry you're doing the same work twice but I also totally understand the difficulty that can come along with getting people to change their processes plus maybe the duplicate entry could actually be a plus side for you if if you want somebody in the office to kind of have the opportunity to look over what the person out in the field Drew up up to you but my recommendation is always not to do the duplicate entry I will also point out though that as of the time of me recording this video uh this whole service agreement setup process is an office side only experience so if you do have a field person building these they would need an office side login which is free to add anyways with all that said I'm going to click continue to Next Step here here we're going to add the locations and the associated contacts that are tied to the service agreement so we can either uh create a new location or add existing ones I'm going to add my existing location here just check that off hit add to agreement and then if we hover over here we can add our individual contacts billing schedule checkin checkout so whatever contacts you've already got built onto that location will just show up here for you to check off or you can uh create new ones I'm just going to say that my pre-existing contact is the contact for all of these things and then we continue to The Next Step okay on this step we can select individual pieces of equipment at this location that uh are covered by this service agreement so I don't know maybe they've got five rooftop units but you're only covering three of them under this agreement in that case you can tie those pieces of equipment here this is an optional step though you can just hit continue to next step and it will let you move on uh since I don't have any pre-existing equipment on this location I don't have a select existing equipment button I only have an add equipment button I'll just put in a piece of equipment real quick okay so let's say I'm covering this piece of equipment and we'll go on to the next step okay now we're on our scope of work step where we set up the duration and how we want to renew this so I'm going to say that this is a one-year agreement and I'll choose to enable auto renew so that this agreement renews itself we can pick a proposed start date so it's got November 1st here pre-selected for me I think I'm good with that so I'm going to go ahead and click continue okay now we're still within the scope of work we're going to add all of the visits that are included in the service agreement so in my uh description of this agreement here I think I said that this was a quarterly filter change and inspection so that's what I'll put in here and we can choose our visit window this is basically when it's going to show up on our follow-ups page that it's time to book this I'll show you what that looks like later but I'm going to say that we can book this anytime Within the month of November and I will say apply this might be a good time to point out that service agreements do not create uh recurring services so if you've use service Titan memberships in the past and you might be familiar with the concept of recurring Services as kind of an entity in the software this doesn't use recurring services but it does set up a a different entity known as visits which go on the location and can be spent in a similar way as recurring Service events not a super important detail if if you haven't used memberships and you don't understand what I just said don't don't worry about it okay then we're going choose our job type this is going to be the job type that's pre-populated whenever we're booking one of these visits okay and next we're going to set up our cost estimates now these cost estimates are for the purposes of our profitability calculation so we have the ability to look at budgets versus actuals on the service agreements so we can enter in here our estimated labor cost and our estimated material cost that way later we can go back and see how our estimated cost compared to what actually happened and that way we can make educated decisions on if we need to adjust any pricing on this so I'm just going to throw in some totally madeup numbers here don't judge any of this I'm going to say it's 16 hours at 150 bucks an hour and our estimated material cost is uh 650 now keep in mind what you're estimating here is the cost of like predicted work not any additional repairs that you might do based on your inspection while you're out there so these are my numbers just for what I think it's going to cost to change those filters and do those inspections but not to do any repairs that might result from those inspections okay and then we can add a a task summary this is basically going to automatically be added to the job summary field when this visit gets booked into a job and then we can select any uh tide equipment that is covered in this particular visit so I'll check that off there and say save okay now that's a quarterly visit so that's one out of four that I need to make but I don't need to manually make them all I can come to this Kebab menu here and say copy and then I can select the other months where I want to perform these visits so our first visit we said is going to to be in November of 2023 so I'll say I'll do the next visit in March and then the visit after that in June and then the visit after that in September and I just click copy visit and boom all of those are made for me of course if anything's going to be different about those visits I can go in and make some edits uh you also have the option up here to add extra travel cost per visit this is also going to feed into your budget versus actuals uh I would recommend only filling this out if this is like an abnormally long drive for you that way you can account for that extra time now that I have four visits built out I've got up here my total estimated labor cost and my total estimated material cost all right so I'm going to click continue to Next Step okay and now we're on our pricing setup so we've got two things here service agreement pricing that's the pricing that we're going to set up for the service agreement itself how much we're going to charge for this agreement and then we can also tie a client specific pricing rate sheet to this agreement and that would apply to any additional repairs that we do okay so let's start with service agreement pricing here going to click add so basically we've got our labor cost that we estimated here and our material cost that we estimated and we're just going to put in how much we want to mark that up and if we want to add any surch charge on top of that which is going to calculate our price for our service agreement so we can put in some numbers there again totally madeup numbers and that gives us our total cost total markup total search charge our total agreement price that we would be charging to the customer our gross margin dollars and our gross margin as a percentage that's the only way to do it as of the time of me recording this video but there is an option coming in the near future to just straight up enter in a price if you already have a number in mind okay so I'm going to click save on that and then again this is optional but I'm also going to uh set up a client specific pricing rule so I'm going to select this rule here and click save Rule now a couple of things to understand about what we're doing here any client specific pricing rate sheet that you attach to the service agreement is going to take precedent over any client specific pricing rate sheet that might already be tied to this location also this client specific pricing rate sheet tied to this service agreement is going to to apply to any job that we do for this location whether it's for the service agreement or not so long as the service agreement is active so basically if you're trying to offer your customer special pricing for being on your service agreement then you would want to do this I have a separate video on how to set up client specific pricing and I'll leave a link to that in the description box down below all right we're going to click continue to next step and now we're on our billing schedule and payment terms page I'm going to say since this is you know quarterly filter changes I'm going to charge them quarterly for invoices per year save and continue uh any payment terms that I've already got set up I can select here so do upon receipt or you could do like net 30 netet 60 whatever it is for my example I'll just say do upon receipt then we choose the payment method that we're expecting save and continue and finally the billing address all right we're going to continue to The Next Step okay so now that is all set up as I'm recording this video you can see a message here that we're still working on the preview feature to just show you uh what you've set up here but for now you have this option to download the PDF and then here's what the PDF looks like again I used the service Titan default setting you're able to customize this to look however you want but this is basically my proposal that I would now send to the customer now as of the time of me recording this video the way to send this proposal is to download that PDF and then send the PDF in a separate email client however the team is working on a way to send the proposal directly through service Titan okay so I'm going to hit close here that brings me back to my location screen where I can see under service agreements here my new draft so from here I can change the status of this service agreement right now it's in a draft state but I could mark it as sent or I could mark it as rejected accepted and activated so let's say that they've accepted our proposal and we're good to go I'm going to say activated great so now let me take you into the follow-ups page we're going to click follow-ups in the main navigation bar up here and then we have two service agreement related tabs service agreements and service agreement visits uh service agreements is just kind of a dashboard to see all of your service agreements we've got lots of filters up here like said I only wanted want to see uh the activated ones for example and I've also got the tab service agreement visits and this is where an office person would go to actually schedule out these visits so here you can see all four of those quarterly uh filter change and inspections that I owe to that customer and we've got all of our visit Windows here so someone in the office can come in here let's say we're going to filter by date and say next month so I want to see all the agreements that we owe for next month and there I can see my first quarterly uh filter change and inspection that has the visit window of 11 1 through 11:30 it's October as I'm filming this so that's next month so then I would scroll over here to the very end uh and say actions and book a job and then book the job from here now you do have to book these visits either the way that I just showed you through the follow-up screen uh or through the page for the individual service agreement which I'll show you later but as of the time of me recording this video you cannot book these visits just from the call booking screen like normal because then the system won't know to spend the visit now as far as billing for these goes it works the same way as m memberships if you're familiar with that so on the accounting screen here we have this recurring billing button where we can create a billing run so I could say all of the things that are due between now and let's say the end of next month search and then I can see there's my store books customer who would owe me uh for that first November visit so I could say generate and charge invoice that's really for if they have a credit card on file which for a commercial service agreement is not likely so we can just come down here and say only generate invoice and then generate invoice and then we could email that invoice to our cont that's the manual way to do it I would recommend doing it manually for the first few months and then once you've got things down and you feel comfortable you could set up automatic billing rules where you could just automatically have those invoices generated on whatever you want a monthly Cadence a weekly Cadence whatever you want to do just make sure that you do check off this box down here that says apply this rule to service agreement invoices and then of course back on the accounting screen we have this invoices tab where you can see all of your invoices that you've generated and you could email them out from here okay now let me uh actually click into this service SC agement and let me show you the uh kind of dashboard for it so every service agreement if you click into that you'll get this dashboard screen on the first tab here you can see how many visits you've completed you can make some scheduling notes if you wanted to do that we've got a table of all of our remaining visits we've got an overview of our billing status how much we've build plus our billing schedule and our next billing date next we have this details tab where we can download that agreement PDF we can assign an account manager this is a handy feature because uh you can filter by this on that follow-up screen so I'll assign my guy Chris Hunter here as the account manager and then let me take you back to the follow-up screen so now I'm back on the service agreement visits and follow-ups and if I'm Chris and I only want to see uh visits that I'm responsible for scheduling and I can filter by account manager here say Chris hunter say save and that would filter everything else out now I only have the one agreement set up and it's assigned to Chris so it didn't really change anything but you get the idea for example if I selected Britney here and said save I would see nothing okay back here on the service agreement page I can see what client specific pricing I have assigned to this what business unit template tags the summary that I entered earlier which I can edit you can also set up a not to exceed limit so if if this customer has given you a certain limit let's say uh anything over $500 they want to be approved through this contact you can say that here boom there it is anything over $500 must be approved by the billing manager and by the way that not to exceed limit is going to be automatically copied into the job summary for any visit that we book for the service agreement so that the technician can see it you can also add a service level agreement so if you've promised them anything special that's outside of the norm so maybe we can say we guaranteed same day emergency calls and then we can document that information here okay then under financials over here we have our profitability tab this is where we can see our estimated cost versus our actual cost and how much uh variance we had as well as a visitby visit breakdown of expense details now something I want to point out is that this profitability tab is going to be more accurate for you if you book any additional repairs that are outside of the service agreement like expected work any anything that you find and you're like okay we need to actually fix this it's going to be more accurate on the profitability tab if you book those out as separate jobs that's because what this tab is looking at is all of the cost that were associated with the service agreement visit so if you go out on a service agreement visit and you find that something needed to be replaced and then you replace it on that same visit well then that material cost and that labor cost is going to be part of that visit and so it's going to show up as your actual expense on this tab which can muddy the waters a little bit because now this tab is showing actual costs that are outside of what you were actually estimating for which was just what's encompassed in the service agreement itself so if you book the repairs out as separate jobs you avoid that problem just something to be aware of okay next we've got a billing and invoices tab where we can see any invoices that have been generated for the service agreement then under operations we have a visits tab where we can see all of our visits and we're also able to book them from here as well we have our equipment tab where we can see all the equipment associated with the service agreement okay and we also have this materials tab so here we have this little drop down where it will expand into all of our four visits and then we can add the materials that we're expecting to use on those four visits any materials that you add here are going to autop populate when the technician actually goes out to do the job so those materials will be automatically tied to the job we're also able to pull reports on this so that we can build out purchase orders ahead of time so for example for my first visit here I could click add material just for example sake let's choose this filter and then I could edit the quantity maybe they have eight units so I'm going to say eight and there we go again now those filters are going to be automatically tied to the job when we go out they will be added as non-chargeable materials plus we can now pull a report ahead of time to see that we're going to need this and then we can put in that purchase order and there you go I mean that's the basics of it uh the only other thing I do want to show you is the reporting that we have for service agreements uh for for that I'm actually going to use a different example account because since this one only has one service agreement we're not going to get very much data in our reports okay so here we go I'm going a different sample account which as you can see has more service agreements set up inside of it so let's go into reports so there are two data sets related to service agreements there's a service agreements data set and a service agreements visits data set and you're of course able to build customized reports based on those data sets you will have a couple of preconfigured reports one of them just called server agreements and that's just going to be kind of a general overview report and then service agreement visit materials will be the other pre-built report and that's the one that you would pull to help you create POS for the things that you're going to need for your upcoming service agreement visits but in addition to that of course you could build as many reports as you want for example you can see in this account here service agreements activated last month service agreements Auto renewing this month agreements canceled last month agreements expiring this quarter so there's a lot you could do here so let going just pull a general service agreements overview report just just kind of show you what we're working with so here I'm running a report I'm filtering for anything that's activated Andor Auto renewing so basically this is now a list of all of my active service agreements and I can view related information start and end date the total agreement price the billing schedule whether Auto renew is enabled or not and of course I can come over here to edit columns and change what information I'm wanting to see and as you can see I've got a lot of data at my disposal here now something I did specifically want to show you where uh some of these service agreement aggregate profitability columns that we can add so let's actually create a new report here this is going to be a report based off of the service agreements data set this is going to be a service agreement profitability report so let's put in our estimated labor cost compared to our actual and our labor cost variance we can do the same thing with labor hours the estimated versus the actual we'll look at the material cost variance as well as the variance in our total cost and we can also throw in our gross margin percentage here and for this example I think that's good enough but of course you have all of these other data points at your disposal as well we'll call this the service agreement profitability report and then let's run one I'm filtering again for all of my activated service agreements I'm going to run the report and then there we go now I can look at all of my budgets versus actuals in aggregate which helps me quickly identify problems especially because I can filter these columns so for example let's say okay I'm looking for any service agreement that I have where my gross margin percentage is less than let's say 40% so I can just say I want to filter for gross margin percentage is less than4 so I want to express 40% as a decimal I'll say filter and there we go now I have a list of all of my service agreements specifically that have a gross margin percentage under that threshold of 40% so I can start digging in and see what's going on with my budgets versus actuals to see where we're going wrong assuming of course that we're looking for a gross margin percentage greater than 40% that is just a madeup number we can do the same thing based on any of these columns so if I wanted to filter for uh things that had a higher total cost variance let's clear this filter here and then let's just filter for a total cost variance that is greater than or equal to let's say 5,000 we'll say filter and then there we go I've got two service agreements here where the total cost variance my budget versus actual has a difference of $5,000 or more super super useful stuff anyways that's all I got for today be sure to hit like if you liked this video and found it valuable be sure to subscribe to service Titans YouTube channel if you haven't done that already hit that Bell icon so that YouTube notifies you anytime we upload a new video and leave me a comment down below and let me know what you think please remember that your engagement through likes comments and subscriber numbers are the ways in which My Success is measured appreciate it peace [Music] oh