Skip to main content main content
sharing is caring! we do appreciate your time to let others know us!



What is a purchase invoice? According to, "A commercial document or bill presented to a buyer by a seller or service provider for payment within a stated time frame that indicates what has been purchased, in what amount and for what price. A purchase invoice can be used to prove that something was bought and how much was paid for it."

How to prepare a purchase invoice? It is easy to do with Invoice Manager for Excel (namely Uniform Invoice Software). Once you have done customization by following the Before Using document, for example add your own business information, replace the logo image etc., a purchase invoice could be easily created:

  1. Click the "Select a customer" button to pick a customer if it already exists. Or fill in new client information.
  2. Fill in product / service information, usually a description, quantity, unit price. The line total usually will be auto-calculated.
  3. Click "Save To DB" or "Save Invoice". A new invoice number will be generated automatically.

Feel free to watch our movie tutorial.

Things to remember while making purchase invoice - the invoice number and invoice date are always required. However with Invoice Manager for Excel (namely Uniform Invoice Software) installed they will be filled automatically if left blank.

Whether you are creating purchase invoices for organizations / companies, for home, the basic procedure are the same.

Coming here by searching for Buy Excel Invoice Template? You can download our templates for free without paying a cent.

Here are our templates closely related to Free Purchase Invoice Templates - 20 Results Found.

General Purchase Invoice Template (Sales, One Tax)

General Purchase Billing Template (Sales, One Tax)

Sometimes an invoice is also referred as purchase invoice from the view of the buyer. This general-purpose Excel-formatted purchase invoice sample includes two editable/fillable columns, Description and Amount, and a Taxable checkbox column.

General Purchase Invoice Template (Service, One Tax)

General Purchase Billing Template (Service, One Tax)

To move out the address section, we first need to put the template into design mode. To do this, simply push down the "Design Mode" button on the "Invoice" ribbon tab. This commands unprotect the sheet and then push down the "Design" button on the "Developer" ribbon tab.

General Purchase Invoice Template (Consulting, One Tax)

General Purchase Billing Template (Consulting, One Tax)

If you items are always taxable or not taxable, you may find the additional taxable column redundant. If this is the case you can move all the taxable check boxes out of the printable invoice form. To do this, first switch to design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab, and then select one tax box, or select all taxable boxes by push CTRL key on your keyboard and click each box. And then, you can drag the boxes out of the printable area.

Freelance Invoice Template

Freelance Invoice Template

As a freelancer, creating invoices might not what you best at but it is necessary. Further more your invoice should be prim and proper, so that you can get paid by your clients efficiently. While invoicing is not a fun task, it's a necessary one: by keeping clients informed of your expectations, you will get paid punctually and reinforce your professionalism. Using a template is the most easy and quick way to get the job done. Our templates online here on help you spend less time creating invoices and more time doing the things you love.

Professional Freelance Bill

Professional Freelance Billing Format

The template has no tax set by default (the tax cells are hidden and not printable). With Invoice Manager for Excel (namely Uniform Invoice Software) installed, you can easily change it to one tax or two taxes, depending on your particular needs. Simply click the Settings button on the ribbon tab, and then go to the Taxes tab, choose your tax type (no tax, one tax, two taxes), enter the tax name such as VAT, and the rate, click Apply and you are done! With this flexibility, we can say this template is not only suitable for freelancer, limited company and also sole trader, whether they are VAT-registered or not.

Freelance Writer Invoice

Freelance Writer Invoice

We've already published an invoice format for freelancers, at Freelance Invoice Template; and for a list of invoicing forms that could be used by freelancers like designers, developers etc., visit Freelance Invoice Template For Service Business, Graphic Design Freelance Invoice Template, Freelance Web Design Invoice Template, etc. Unlike Freelance Invoice Template, where the calculation of line totals are done by multiply "Hours * Hourly Rate", in this billing template sample Freelance Writer Invoice Template, the amount of each line is manually fillable - this means that it is more suitable for project or contract - based billing. You can find more invoice samples for hourly-rate based invoicing under the Service Invoice Template and Consulting Invoice Template.

Recipient Created Tax Invoices Form

Recipient Created Tax Invoices Form

This invoice template for purchaser created tax invoices mimics the fields defined in the Australian Taxation Office pdf sample (NAT 73657), with only one field addition - the "Invoice#", placed above the "Invoice Date" field, as we believe it is a useful field / information for both parties (the seller and the buyer) involved in the transaction. If you have Invoice Manager for Excel (namely Uniform Invoice Software) installed, the automatic invoice numbering feature is able to generate invoice numbers for you. The invoice generator works when you click the "Save Invoice" command and leave the "Invoice#" field empty. The sequential numbering generator provides several options that you can use to control how it works, including the next start number, the prefix text added to each invoice#, the number of digits in each invoice# (for example, "INV003" has 3 digits in the invoice#). See simple invoice templates for more samples.

Image and Picture on Invoice, Quote and Purchase Order

Product Image and Picture on Invoice, Quote and Purchase Order Template

The second part of the above sample is simply an Excel cell address. Once the image is successfully loaded, it will be displayed in the target cell with an Excel "Picture" object.

The result of the formula will show "Loaded" if the image is successfully displayed, or an error message if failed.

Advanced Sample - Macro-Enabled Invoicing Template

Advanced Sample - Macro-Enabled Invoicing Template

While most templates here on are ".xlsx" and ".xls" formats, Invoice Manager for Excel (namely Uniform Invoice Software) does work with macro-enabled invoice templates. This sample introduces the steps to use ".xlsm" workbooks and templates.

Invoicing Format for HVAC Service

A C invoice template

The "Invoice" ribbon is created by Invoice Manager for Excel (namely Uniform Invoice Software) (UIS) - i.e. you have to install UIS in order to have Excel show the ribbon tab. This ribbon tab provides global commands, that are available to all the worksheets in the Excel spreadsheet template, such as "Customers", "Products", "Invoices", "Reports", "Settings" and "Help"; there are also shortcut to commands that affect the working mode the invoicing form, such as "Hide Task Pane", "Disable On-sheet Picker", "Design Mode", "Replace Logo Image", "Add / Update PayPal Button", etc.

Proforma Invoice Template (4th Sample, Landscape Page Orientation)

Proforma (4th Sample)

To address this issue one way is to wrap the text so that they can span several raw Excel rows. Another way described in this sample is to expand the form horizontally so that it can would be printable with landscape paper orientation. Both methods require decreasing the number of lines on the form.

VAT Invoice Template with VAT Rate Column

VAT Billing Template with VAT Rate Column
  • the unit price or rate, excluding VAT
  • the quantity of goods or the extent of the services
  • the rate of VAT that applies to what's being sold
  • the total amount payable, excluding VAT

Template with Summary on Top

Template with Summary on Top

For a variant of this template please also visit Customer Invoice Template.

Moving cells and fields is also as easy as dragging and dropping. If you prefer to place a cell on a new location, firstly unprotect the Invoice worksheet, and then click to select the cell/cells, and then drag the border of the selected cell to move it to a new location you like. Invoice Manager for Excel (namely Uniform Invoice Software) supports all these tools provided by Excel, which makes sure that you can have the invoice form you like. And, one of the great features of Invoice Manager for Excel (namely Uniform Invoice Software) is that, you can connect the invoice template in Excel spreadsheet format to a backend database, which gives you the ability to manage large amount of data, such as customers, products, invoices and payments, in an organized manner. Simply put, Invoice Manager for Excel (namely Uniform Invoice Software) combines the power of Excel and backend relational database, turning a simple Excel invoice template into a powerful invoicing system. Feel free to download and try the fully functional trial version.

Limousine Service Invoice

Limousine Service Bill

While we've already published billing templates for shipping service, such as shipping invoice template, this one is built specially for limo services.

Sales Invoicing Format for Germany

Sales Invoicing Example for Germany

If you are not charging VAT (MwSt), you can hide the fields / cells completely by using this "Settings" box. In this case, you'll also need to add a declaration to the invoicing form,

Australian GST Invoice Template

Australian GST Billing Form

Note: a revised version of this template could be found at ABN Tax Invoice Template.

This customized invoice template is suitable for companies whose goods or services include GST. As Australian Taxation Office and the law required, the billing form should include information as detailed below.

Commercial Template Sample - Using Payment Method Checkboxes

Commercial Template Format - Using Payment Method Checkboxes

If you have visited Commercial Invoice - FedEx Style and Commercial Invoice - FedEx Style (Landscape), you may notice that the two templates use check boxes on the bottom of the form. Many other invoicing forms here on use checkboxes too. If you have installed Invoice Manager for Excel (namely Uniform Invoice Software), you may noticed that the "taxable" column is a checkbox column which controls whether each item on the invoice detail section is taxable - if an item is taxable, the Excel formula set for the template calculates tax or VAT for the current item.

Invoicing Template in Euros

Invoicing Format in Euros

This template has one single tax named "VAT" set by default. To change the tax name or rate using Invoice Manager for Excel (namely Uniform Invoice Software), which is our invoicing software program that enhances any Excel invoicing template here on InvoicingTemplate to be a complete invoicing system, first click the "Settings" button on the "Invoice" ribbon tab, go to the "Taxes" tab and then choose the number of taxes applied to this form, the names of the taxes, and the rates of the taxes. You can also enable options like "Tax invoice total including shipping cost" etc. Make sure you click the "Apply" button after modifying the taxing options, otherwise the template layout won't be changed according to the options you choose. If you accept the changes after verifying the form, click the "Save" button on Excel quick access tool bar to make the changes persistent. For more customization samples on VAT, visit VAT invoicing templates. Also refer to VAT invoicing rules on EU Taxation and customs union / European Commission.

Hotel Bill Format with Online Payment Button

Hotel Bill Format with PayPal Payment Button

Looking for hotel billing software in Excel? This is the one you need. In the hotel / motel businesses customers usually pay at the front office. For those clients who are under long term contracts, or for the rental of meeting room etc., it is useful to add a PayPal button to invoices / receipts so that the clients are able to pay online.

4-Column without Tax

4-Column without Tax

This is a variant of the invoice template with 4 columns. The template is set with no tax and shipping address.