Pro Forma Invoice Template Excel for Marketing Made Easy

Pro forma invoice template excel for Marketing

this is my simple invoice template for freelancers at the top here you see you can put your business name or just your name if you're operating under your name on the left hand side here we've got the invoice date we can put your telephone number in here your email address and your address here on the right hand side we've got the details of the appeals in your invoicing or company and then just some details about the project title project description and and the invoice number this second bit down here is for each job description so you may well have done one or two jobs or just the single job itself either way you can add several different uh lines in here so for example a job one example job one here which was done in may was 30 hours and the hourly rate was 50 pounds an hour so this automatically totals the cost at the end and this example job here it was just a retainer so it was just a one-off rate so we just put one hour in and the total hourly rate if that is the case the total cost here will automatically calculate at the bottom so we can see a total cost at the bottom here we also have the thank you for your business uh it's been a pleasure working with you on this project you're sincerely your name and then just your payment details and how the invoice is actually paid at the bottom here so when you go to print it if i just go ctrl and p to print you can see it all fits onto one single page perfectly fine and so there's no need to kind of do any readjusting or such like that even if we go back on here and let's say we add another line in so we've just insert if you do insert another line all you'll need to do is just click on the cell above under the cost column click this little green box we can see here and just drag it down so it copies the formula in here so it'll still calculate the formula at the bottom here will automatically adjust itself to uh incorporate that line insert there now even if we were to copy in uh let's insert a handful of lines insert copied cells as you can see here this is quite a lot bigger now if we go ctrl p see we still got a good amount of space at the bottom there to add quite a few jobs if you do have a long list of jobs you may well need to do your invoice over two pages um but that's a lot of jobs so well done and lastly if you're looking to email this as a document and you don't email it as a spreadsheet as this would be able to be edited by the the receiver if you go onto file and export you should be able to export it as a pdf i hope this spreadsheet's what you're looking for and thank you very much for listening