Effortlessly Create a Bill Book Format in Excel for Financial Services

Bill book format in excel for Financial Services

assalam alaikum in this video I'll guide you through the process of creating a polished and a professional invo same as displayed on my screen we'll start by merging columns A and B up to row number three and then next three columns same as it is in the first cells insert your business logo navigate to insert and import your [Music] logo next type your business name increase the font size to 22 and make it bold and italic now incorporate a square shape adjust it same as a bold line change its color and remove the Border [Music] [Music] outline proceed to select these three columns and merge them type inv in uppercase enhance the font size to 24 and apply bold italic formatting this is where you will enter invoice 2 and customer [Music] details we'll type invoice number here and a [Music] dat [Music] now here we'll type serial number item description quantity price and the total price then merge these three cells and select heading to make font style italic to merge below cells will double click on copy forment and apply on below these cells now we'll select this whole table and insert border let's now add heading color we'll select heading choose dark gray color for heading and white color for [Music] font now we'll merge these cells change color and types sub total Tex and grand total type payment information here like account number account holder name and Bank details [Music] Etc now here we can add term and conditions you can type your business term and conditions ingly let's now extend the page size and type here thanks for your [Music] business now here we can insert a line by inserting a square shape as we did above and change its [Music] color now in the bottom we can add phone number address and email we'll insert the phone [Music] icon [Music] you can type your phone number here same as it is insert location and email icons and add details [Music] [Music] ingly [Music] finally we'll implement the necessary formulas for calculating subtotal tax and grand total to calculate subtotal simply press alt and equal and select the cells to some sub total to calculate text you can type equal select subtotal cell and multiply with 5% I have added 5% text you can adjust this tax percentage based on your country's tax rate to calculate grand total simply press alt and equal and select the cells where you have subtotal and tax amount now let's input a random data here we'll add random quantities and prices to get the total input an equal sign and multiply the quantity by the [Music] price now let's see how our invoice look like navigate to print preview it looks nice but we just need to move this part at the bottom of the page return to the sheet and insert some rows above the terms and conditions by pressing alt and plus [Music] now as you can see it looks amazing and a professional invoice so this is how you can make an invise for your business in AEL I hope you found this guide helpful see you next time Allah