Explore the Best Proforma Invoice Format in Excel for Purchasing

Proforma invoice format in excel for Purchasing

hello and welcome to so maker pro-forma invoice template this tool mainly prepares a dynamic professional pro forma invoice for the user it is constructed by five parts these are customers products payment invoice and a simple invoice let's start with the customers enter your customer details for each section the information you will input in this section will be used dynamically in the invoice let's give an example let's say one of our customers is in Europe which is called X company a phone number the email address name of the street name of the city the name of the country the zip code and also the nearest port and Airport now if you would like to add more than 20 customers press plus sign to get additional rows we will proceed with the products part now enter your product details for each section once you enter the info for all the products they will be ready to be shown dynamically on the invoice you may also press the plus sign to get additional rows let's proceed with a payment part you enter the payment methods you or your company accepts and write down your bank or financial details which you want to be shown on the invoice once you are also done with this part you're ready to create a dynamic invoice enter your company details and logo type your invoice number you may select the continent the customer and the shipping method the options are the information you added in the previous sections once you choose the customer details will show up automatically let's say that we're making business with X company which was in also Europe X company once you choose the information below is shown automatically and as the shipping method let's say by AB once you choose it the place of delivery depends on the choice that you make in here you may input the rest of the details manually now we may carry on for this part choose the category and then the product let's say it's an RC car choose the quantity please pay attention to input only in the white cells you may manually enter the discount rate but also fright insurance taxes and other costs if you will apply any if you have any notes for explanation or an additional comment you may use this section to type in if you think the space is not enough you may press the plus sign to get additional rows choose the payment method which your customer is going to use to retrieve your financial details and now it is ready to be sent the invoice is set to print the necessary parts and finally simple invoice this is a simple version of the detailed invoice you have seen in this previous section some companies wouldn't like to show many details in their pro forma invoice and for the ones who prefer that way a simple version of the other invoice has been prepared it works in the same way like to detail the invoice put down your details an invoice number choose your continent your customer your shipping method and then choose your category your product and the quantity enter the discount rate fried insurance custom taxes and others and the invoice is going to calculate automatically write down your opinions or special notes and then choose your payment method now your invoice will be ready to be sent thanks for watching and don't forget to check our other templates at .spreadsheetrepublic.com