Create Billing Statement Template Excel for it with Ease

Billing statement template excel for IT

okay in this next section of the video I'm going to show how we can fill out the invoice with the way it's currently set up in Microsoft Excel so this is the generic step template that we created and I'm going to put in a statement number for customer let's say we call this statement 1 0 01 the date date's already set up with equals date um equals today open parentheses close parenthesis using this formula today's date will show up uh customer ID we can modify that so we can put we have customer [Music] number 4570 I mean whatever kind of numbering convention you might have for your customers you know you can or if you don't have one already I would recommend creating one that way your customers have some kind of repres representation to them and you can use this to to track their orders and their overall history with you build to this would be your customer uh your customer's name company name if applicable their address address line two City s and zip code I'm going to leave those blank I mean those are rather self-explanatory but coming down here the way this template is set up you can put in the date of a service for example let's say that service was provided on 418 2012 and let's just say that this is some kind of pressure watching service we can put type residential invoice number and this could be like some other sub invoice number that you might have for a customer we can put pressure wash roof the amount that we build the customer 1,600 so far customer's given us a $300 down payment and so that leaves them with a remaining balance of $1,300 and if we scroll down in the template with the way Microsoft Excel has already set this up customer ID is already linked the customer's name from up here see if we modify this put a name up here it's actually not link but here we we could link it if we want let me show you how to do that hit the equal sign and then just click the field that it's automatically set up the customer ID is already linked up the statement number is linked up equals C8 it's up here the date's already linked up to the date you have up here and the amount due is getting this field right here 1300 now this 1300 is calculated adding up these totals this up total is calculated by getting the amount minus the payment so subtracting the 1600 minus 300 and we get 1300 now what I did want to explain is that this field right here that says equals today personally I would change this because this is always going to show today's day which currently is April the 21st you can modify this to a fixed date such as manually typing in it April 21st 2012 because when you reopen this file let's just say 5 days from now it won't say April 21st on this field anymore it's going to say the date that's 5 days from now now then again you could leave it as equals today because in this field down here you have the data as to when the services were rendered and this field again is equal to C9 which is this field up here so it's it would be up to you personally I would type in April 21st manually rather than having the formula as equals today now I'm going to show you briefly that if you wanted to add more data to this all you have to do is highlight row 15 right click your mouse and hit insert you now have a new line it actually probably would have been better for you to highlight row 16 and then insert that way you can type in another another line so let's say that we type in same date and again this would be for the same customer residential but they this customer now has another invoice pressure wash driveway and for this there was a $500 charge from that portion customer paid 100 so now we see that they still customer still owes a ground total of $1,700 now that concludes this portion of the video what I will be showing next in the next video is how we can modify this section this entire section so that instead of a payment amount being entered here it will be a quantity amount and a gr total will be calculated over here Now One Last Thing Before I Do close out this video you don't want to do file save because you'll override your current building statement template so make sure you go to menu save as and then here you what I would recommend doing is maybe putting in the invoice number for the customer so we'll do invoice one 01 there's three zos one Dash and then customer ID 4570 or vice versa you know customer ID 4570 invoice one 00001 however you want to set up the naming Convention of your files but save it that way you don't overwrite your template that has the generic information thank you for watching this video