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

Blank Sales Billing Format (No-tax, Long Description)

Blank Sales Billing Sample (No-tax, Long Description)

As you can see from this simple example, it is easy and convenient to do formatting in Excel. By using various tools provided by Excel, it is not hard even for a beginner to create an amazing invoicing template. Here on we are publishing sample designs so that you can use as a starting point of creating your own template. With no so much effort, you can create professional invoices that are better than many expensive invoicing applications.

Invoicing Template in Euros

Invoicing Template in Euros

As a simple customized sample of VAT invoice created for Germany (See c4098 Sales Invoicing Format for Germany and Service Billing Template for Germany), we make the currency symbol shown for the appropriate cells. This customization is easy and simple. If you are interesting in the details, here is how.

Professional Freelance Bill

Professional Freelance Billing Format

As a freelancer you know it's important to get paid without delay and a professional invoice could be helpful. Being professional means your bill contains all the required information that are formatted properly.

Simple Sample - Printing on Letterhead Paper

Simple Invoicing Template - Printing on Letterhead Paper

Do you want to print your invoices on company letterhead / business letterhead papers? It is easy to do. This simple invoice template demonstrates how to customize a template so that it is suitable for letterhead papers.

Simple Sample - Discount Amount Field

Simple Invoicing Template - Adding Discount Amount Field

There are two part of work involved to add the discount amount field - customizing the invoice template, and customizing the database.

The steps required to customize the database are detailed below.

Service Invoice Form with Discount Percentage

Service Invoice Form with Discount Percentage

Besides modifying the formula, you'll also need to set the format of the discount cell to show as a percentage. To do this, first unprotect the Invoice worksheet by clicking the Unprotect Sheet command on the Review ribbon tab, and then right-click the Discount cell on the bottom of the invoice form and choose Format Cells. On the Number tab of the Format Cells dialog box, you can set the format of the discount cell to be a percentage value. Feel free to browse the other options available on the Format Cells dialog box, you may find it helps you a lot when you try to customized the invoice template to create your own style and layout.

Simple Sample - Customer Name on Product Report

Simple Invoicing Sample - Customer Name on Product Report

On the other hand, the main content of the "Product" report is retrieved from the invoice body database table, adding the fields of the invoice header table to the invoice body table will create many redundant data, as they must be repeated for each item. One exception though - the definition of invoice body items must include the invoice# (InvoiceID) field, since it is the primary key of the invoice header table that identifies each uniquely.

PayPal Payment Button Using Custom Image

Excel Invoice with PayPal Payment Button Using Custom Image

In this sample we look at how to use a custom image to replace the default PayPal payment button image inserted with our invoicing software app, which is in fact a Microsoft Excel picture object with a hyperlink set.

Service Proposal and Quote

Proposal and Quote Template

The Invoice Date field from the default sales invoice template shipped with Invoice Manager for Excel installer program is still there, but it now has new label Proposed, indicating the date of the proposal or quote.

Attorney Billing Form

Attorney Billing Form

This template is a revised version of our Attorney Invoice Template (South Africa Currency) (c5067). It now uses a new color schema, Agency FB fonts. The client# cell is also moved out of the printable form. See the PDF invoice generated by Invoice Manager for Excel to find out what will it like when you client receive your bills.

Agency Quotation

Agency Quotation

This template requires an additional column, BrokerFee, which is not printed or included in the extracted version, but saved to database. You enter "Line Total" and BrokerFee manually, and Cost, which is the money that the agency pays to the companies that the agency works for, is calculated automatically.

Five Price Percentage Levels (Sales, Custom Column)

Form with 5 Price Levels

As the name of this invoice template implies, it is a sales invoice template that has shipping information inside the printable range on the invoice form, and the prices or discounts are in percentage.