BoostExcel main content
Freelance Invoice Template
c6018
Freelance Billing 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 InvoicingTemplate.com help you spend less time creating invoices and more time doing the things you love.

Print Shop Bill Sample
c4006
Print Shop Bill Sample

Some cells, such as "Date Requested" and "Date needed", are not defined in the default template. These are additional fields called custom fields in Invoice Manager for Excel.

Professional Freelance Bill
c4047
Professional Freelance Bill

The template has no tax set by default (the tax cells are hidden and not printable). With Invoice Manager for Excel 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
c3012
Freelance Writer Billing Template

When creating an invoice, be sure to include your contact information. Put your name, address, phone number, email address, and even your website at the top of the invoice. If you are USA-based charge over $600 over the course of the year, you'll probably need to give your client your business's Federal Tax ID number (so they can send you a 1099-MISC, see Form 1099-MISC, Miscellaneous Income - IRS.gov, or Form 1099-MISC - Wikipedia).

Software Development Invoice Sample
c4122
Software Development Invoice Sample

Designed for computer programming freelancers, development teams and small businesses, this software development invoice template in Excel spreadsheet format helps you create invoices and bills that are not only professional, but also cool.

Invoicing Sample for Cosmetics Shops
c4095
Invoicing Sample for Cosmetics Shops

Download this free Excel bill sample for vendors, stores, retailers and wholesalers that are specialized in cosmetics and makeup. The template (".xlsx" file) features auto calculation and a cosmetics background picture.

Clothing Shop Receipt
c6001
Clothing Store Invoice Template

The most noticeable difference between this free Clothing Shop Receipt and the default sales invoice template shipped with Invoice Manager for Excel is that the clothing shop receipt template has a "Size" column on the printable invoice form. That is, there are now 6 columns on the printable form - product#, description, size, quantity, unit price, line total. The other column, Taxable, which allows you to indicate whether each item is table or not, is located outside the printable form.

Psychologist Invoice Template
c6024
Psychologist Invoice Template

Except the "Current Balance" column, which is in fact the "Line total" column in the default invoice template shipped with Invoice Manager for Excel, all the other columns are manually fillable when you create an invoice. The calculation of "Current Balance" is done by "Charge - Payments - Insurance Payments" using Excel formulas. As you can see, we completely redefined the calculation method of the "Current Balance" or "Line total" cells, without breaking or modifying Invoice Manager for Excel, which is our invoicing software that processes tasks like saving invoices, auto-generation of invoice numbers, tracking customers etc. Even in complex accounting / invoicing systems on the market, this level of flexibility could hardly be found. Invoice Manager for Excel archived this easily because it uses Excel spreadsheets as its front end.

Advanced Sample - Email Is Required Before Saving Invoice
c5103
Advanced Format - Email Is Required Before Saving Invoice

"UISClickProc" is a procedure provided by "UniformInvoiceSoftwareHelper" that is referenced to by using the "References - VBA Project" dialog box. In your macro code you call this procedure, and provide the button name as the argument to ask Invoice Manager for Excel to perform the specified action.

Basic Sales Invoice with Blue-violet Gradient Background
c3018
Basic Sales Invoice with Blue-violet Gradient Background

The itemized detail section features 3 columns, "#", "Description" and "Amount". This "#" column is a line number column, but not the "Item#" or "Product ID" column as found in many other templates here on InvoicingTemplate.com. The value of the "#" column is filled automatically using an Excel formula like this:

Photography Receipt Template (Detail)
c8005
Photography Receipt Template (Detail)

The most fascinating side of photography lies in the move from photography using film to photography using media storage. Nowadays even "traditional" photographers have begun to use digital SLR cameras in order to obtain the most brilliant and clear pictures possible. This template, Photography Receipt Template (Detail) or Photography Receipt Format (Detail), includes fields for digital image processing, such as the "CD" field. Including the CD field, there are totally 8 columns on this template - "ROLL", "DIMENSIONS", "GLOSSY / MATTE", "COLOR / B&W", "# in ROLL", "DOUBLES?", "CD?" and "LINE TOTAL". The "DIMENSIONS" field is actually the "Product Name" field in the original Sales Invoicing Template shipped with Invoice Manager for Excel. The "Product ID", "Quantity" and "Price" fields, which are found in many templates available here on InvoicingTemplate.com, were moved out of the printable area of the sheet. Beside "DIMENSIONS" and "LINE TOTAL", all the other 6 columns are custom fields that are not defined in the default database (and template) shipped with Invoice Manager for Excel.

Bill Format for Painting Service
c4087
Bill Format for Painting Service

While the title of the current template is set to "INVOICE", you can easily modify it to be a work order by moving out cells like "Total Due" and "Paid" to the area out of the printable invoicing form.

Service Invoice with Payment Advice
c2004
Service Invoice with Payment Advice

Although this is a very different format or layout than the default invoice template shipped with Invoice Manager for Excel, the fact is that it is not so hard to customize default invoice form to create this one. The most important operation during the customization is the moving of cells and fields. Let's say you want to move the shipping section in the default sales invoice template out of the printable area, for example, here are the steps.

Sales Invoice Template with Discount Amount Column
c6010
Sales Template with Discount Amount Column

What if you need to show discounts in a more detailed manner? For example, show discounts applied to each item on invoice body separately? This requires an additional column on the invoice body, as compared to the 5 columns on the default sales invoice template that shipped with the setup program of Invoice Manager for Excel. So in this customized sample invoice template - Sales Invoice Template with Discount Amount Column, we have 6 columns on the invoice body within the printable invoice body: Product ID, Description, Quantity, Unit Price, Discount, and Line Total. The "Discount" here is an amount value. We'll publish the percentage version of this sample invoice template here on InvoicingTemplate.com in the near future.

Blank Service Invoice Template with Image Border
c3019
Blank Service Bill Format with Image Border

The image border was added to the template as a background image or watermark. It occupy respectable space of the printable invoicing form so we need to reduce the number of visible rows from 12 (as implemented in the original template) to 8. We also set al the paper margins to leave space for the image border. To make space for quotation mark on the top-left corner, we move the logo image, which you should replace with your own business logo before you create your own invoices, to the bottom part.

Sales Invoice Form with Discount Amount
c5032
Sales Invoice Template - Discount Amount

By moving the shipping fields back into the printable area on the Excel Invoice form, the original service invoice template now becomes a sales invoice template that supports per customer discount amount.