We recommend you to send a PDF version of your invoice instead of excel file. For recording more products on your list, you can simply insert rows in between, as per your requirement. Once you become more familiar with the template you can simply protect these columns from unnecessary changes using Excel's Protect Sheet option. Just remember not to delete formulas that column Line Total contains as well as formula from sub-column Sub Total, Sales Tax, Sub Total that contain currency symbols. What is Subtotal and Purchase Order Sub Total? Subtotal is the sum of Total Product costs and PO Sub Total is calculated by subtracting the Discount from subtotal and adding the Shipping and handling charges along with any other associated costs.
#MICROSOFT OFFICE PURCHASE ORDER SOFTWARE#
This means that you can have as many vendors on your vendors list as necessary and create price list which is specific only to the particular vendor, so that when you create your purchase order, you only need to pick the vendor from the list and the software automatically selects the price list that corresponds to a vendor you have picked. View ScreenshotĪnother modification, which lets user to use purchase order with more than just one vendor as well as create and assign price lists for specific vendor. This version lets you enter the products just by selecting them from the drop-down list in the "Product Name/Description" section and also populate corresponding cells with product number and unit price. Slight modification of the original purchase order with addition of a price list, which can contain all items that you purchase most frequently to ease creation of the purchase orders and save time. Contains Fields for Logo & Company infoīonus Downloads Bonus #1 Purchase Order with Price List.Unlocked - so that you can customize it just a little more.If you have some instructions for the Vendor for any particular Purchase Order then you record that in "Notes and Instructions" area.
In case you have agreed on some discounts with your vendor then you can simply add discounts at the end of product specification along with Shipping and Handling Cost and Sub Total amount is computed automatically. Also specify the details of vendor, whom you want to send this Purchase Order and shipping information like shipping mode, method, terms and delivery date.Īfter this record the information of the products along with required details like code, quantity and price. Once the settings are specified, go to the second sheet named "Purchase Order" and customise it by inserting your logo on the top. And if this is not enough you can also use Excel's Themes or colours that can be found in the Page Layout ribbon available in Excel 2007 and above.
It also has a inbuilt design picker, where you can choose a colour that is most appropriate for your company. Here you can set the relevant tax type and sale tax rate. This template provides a provision to select the default currency by selecting a country currency symbol from the drop down menu under the country specific settings. Begin by downloading the template and setting up your company by providing basic details like Company Name, Company Slogan, Company Address.
0 kommentar(er)
