Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your time to let others know us!

Summary

NUMBERING

When you click the "Save Invoice" or "Save To DB" button, Uniform Invoice Software generates a unique, sequential and progressive (increment) invoice / receipt number if the cell is left blank. This automatic numbering generator is based on a counter stored in the backend database. You can set the "Next Number", "Prefix" and "Numbers of Digits in ID" options on the "Database" tab of "Settings" window. Without Uniform Invoice Software, you have to use Excel macros, as detailed on Generate invoice numbers in Excel, or at Excel - A macro to perform the automatic numbering of invoices.

Excel Invoice Template With Automatic Numbering is a sub-topic of Excel Invoicing Templates . Here are our templates closely related to Excel Invoice Template With Automatic Numbering.

Receipt Sample for Seafood Restaurant

c4097
Receipt Template for Seafood Restaurant

Are you running a restaurant that is specialized in seafood? Use this receipt sample in Excel spreadsheet format as your restaurant receipt generator. This sample blank food bill template features a background watermark filled with seafood and tableware.

Service Billing Template for Germany

c4099
Service Billing Template for Germany

As detailed at Invoicing requirements for Germany, each invoice requires its own unique identifier number - i.e. invoice number. Without Uniform Invoice Software installed, you have to fill in the invoice# field manually, and you are also responsible to make sure the invoice numbers are unique.

Soccer Shop Invoice Template

cn009
Soccer Shop Invoice Template

This updated version published on InvoicingTemplate.com we're offering only one format - i.e. the UIS edition. By using this template, you can create invoices for your soccer shop without installing Uniform Invoice Software. In this case, it is able to do formatting (providing the layout of your invoices and bills), calculations etc. However without UIS, all the buttons on the worksheet will not work.

Excel Quotation Template

c9008
Excel Quotation Format with Special Discounting Model

On the bottom of the form, you'll find the usual "Subtotal", "Discount" and "Total" fields. There is also the "Last Balance" field and the "Total Due" cell. The "Last Balance" cell has its field name set to "oknAccountBalance", which is filled whenever you fill in the quotation form / estimation form with an existing client by using the on-sheet picker button, you by enter the client# into the "Customer#" cell (also located outside of the printable quotation form, at $U$2). See Invoice with Previous Balance (Sales) and Invoice with Previous Balance (Service) for more information on how to show previous balance on the form. The "Total Due" is the sum of the previous account balance and the total of the current quotation.

Excel Payment Voucher Template

c5052
Excel Payment Voucher Template

InvoicingTemplate.com also offers the Uniform Invoice Software version of this Excel Payment Voucher Template / receipt template. The Uniform Invoice Software version is also free if you have Uniform Invoice Software installed, and it has exactly the same layout as the freeware edition of the Payment Voucher Template, but with many buttons on it, such as "Clear & New", "Save To DB", "Exact / Email", "Print". Uniform Invoice Software, as the name suggests, is our invoicing software that has the ability to make any invoicing templates available here on InvoicingTemplate.com a complete invoicing program that is able to manage customers, products, invoices and payments. For example, if you click the "Clear & New" button, the payment voucher form is cleared and is ready for you to enter a new payment voucher, with several fields filled with default data - for example, the current date is filled into the "Date" field. If you click "Save To DB", the current voucher is saved to backend database and a voucher# is generated automatically. If you click "Exact / Email", a standard Excel spreadsheet is created and the current voucher is copied to the newly created Excel spreadsheet file, which you can email to your client. You can also create a PDF voucher document using Microsoft Excel.

Sample Sales Invoice Template: Using Line Number Instead of Item#

c5036
Sales Template with line Number

But there are situations where you don't need the product# or item# at all. In this Sample Sales Invoice Template: Using Line Number Instead of Item# we'll assign a line number to the product# field automatically using Excel formula. It is a good example on how the default sales invoice template could be customized in the way you like.

Sample Service Invoice Template: Using Line Number Instead of Item#

c5037
Service Template with Line Number

Sample Service Invoice Template: Using Line Number Instead of Item# is a variant of Sample Sales Invoice Template: Using Line Number Instead of Item#. It is the service edition of the original invoice template.

General Quote Template for Excel

c2035
General Quote Format in Excel Spreadsheet Format

In a business scenario, quotes and estimates are two types of closely related documents, but there are still important differences between them. Understanding the difference between a quote and an estimate can save you time and money and protect you from legal risks and business losses. A quotation is a fixed price offer that can't be changed once accepted by the customer. This holds true even if you have to carry out much more work than you expected. On the other hand, an estimate is an educated guess at what a job may cost - but it usually isn't binding. To take account of possible unforeseen developments, you could provide several estimates based on various circumstances. This will prevent your customer from being surprised by the costs.

Job Estimate Template for Excel

c4084
Job Estimate in Excel Format

While in the Estimate Templates gallery we've already published several templates that could be used for estimating and quoting purpose, like the General Estimate Template and Telecom Consultant Estimation Template, this template differs from other in the number of columns and the layout of the form itself.

Donation Receipt Template for Excel

c1004
Donation Receipt Format for Excel

According to IRS Publication 1771, Charitable Contributions Substantiation and Disclosure, charitable donations are tax-deductible for the donor and reportable by the nonprofit organization. A donation receipt must include specific information about the value of the donation and what the donor received in return.

Labor Invoicing Sample

c4070
Labor Billing Format for Excel

This Excel labor invoice template calculates line totals from hours and hourly rates. There are many other samples here on InvoicingTemplate.com that could be used for invoicing parts, labors and services. For example, Invoice Template Labor Excel Spreadsheet, Contract Labor Invoice Template and Excel Job Invoice Template collect the top 10 invoice templates in our database that are closely related to labor invoicing; for specific implementations, there are samples like Handyman Invoice Template, Engineering Service Invoice Template, Welding and Fabrication Service Invoice Template, Freelance Invoice Template, etc. Still not find your desired invoice template? We've developed a search box for you to find and download invoice template with template# or name.

Bill Sample with Sports Theme

c4094
Bill Sample with Sports Theme

Designed for sports shops and stores that sell sports goods, accessories and equipment, or for sports training and education organizations. Download this free billing and invoicing sample in Excel or PDF format that features a translucent sportsman background.

Simple Invoice for Construction Business

c4046
Simple Billing Format for Contractor

Although this template is named with the word "construction" and "contractor", it could also been seen as a general service invoice template. For example, consultants, service providers, and other small businesses could use this invoicing form too. We have other layouts here on InvoicingTemplate.com too. If you charge based on hourly rates, visit Invoice Template Hourly Rate. A Handyman Invoice Template is also ready here for you.

Hotel Bill Format with Online Payment Button

c7030
Hotel Bill Format with PayPal Payment Button

Note due to the internal hyperlink handling / caching mechanism of Microsoft Excel, the payment button does not work directly on the Excel spreadsheet template. Furthermore, the link on the Excel spreadsheet is just a template, which includes variables such as "oknBalanceDue" and "oknInvoiceID". However when generating the PDF invoice, Uniform Invoice Software will update the link to replace the variables with transaction details reflected on the current invoice - for example, the invoice# will be inserted to item description, the invoice balance will be the amount to pay.

Simple Sales Invoice Template without Item Description

c8002
Simple Sales Invoice Format without Item Description

All free invoice templates designed by us at InvoicingTemplate.com are based on the default sales invoice template shipped with Uniform Invoice Software. Usually if a new invoice format does not required a field to be included in the printable invoice form, we simply move the field out of the printable area - i.e. the area with white background on the center of the Invoice worksheet. And, if a new field is required that is not defined by the default sales invoice template shipped with Uniform Invoice Software, we define a custom field. The definition of the custom fields makes sure that the newly added field will work with Uniform Invoice Software, our invoicing software that connects an Excel invoice template with a back end database.

Customization of Standard Fields

c4108
Customization of Standard Database Fields

The database fields defined by the default invoice template (or standard invoice template) are useful for common situations. In most cases you don't have to change them. However if it is needed according to your business requirements, here are the steps to follow.

Proforma Invoice with Printable Earth Map Background

c7029
Pro-Forma Invoice with Printable Earth Map Background

This sample, Proforma Invoice with Printable Earth Map Background, is based on c7014 Proforma Invoice Template (4th Sample, Landscape Page Orientation). This new version differs from the original one in that we've released all unnecessary button from the invoice form, replaced all ActiveX "Taxable" checkboxes with form controls, etc. However the most noticeable change is that we've add an earth map background image to the printable form (it will also be included in the auto-generated PDF proforma invoices too). Again, each of our template on InvoicingTemplate.com includes a PDF invoice template. Feel free to visit our PDF invoice templates to find out more invoice samples.

Photography Receipt Template (Detail)

c8005
Photography Receipt Format (Detail)

If you run a photography studio focusing on producing images you might find Photography Receipt Template (Detail) / Photography Receipt Format (Detail) interesting. Compared to Photography Invoicing Template (General), the layout of Photography Receipt Template (Detail) offers more fields for the images purchased.

Photography Invoicing Template (General)

c4043
Photography Invoicing Template (General)

Creating an invoice using Photography Invoicing Template is as easy as fill in a paper form. Our templates are offered in Microsoft Excel spreadsheet format. A PDF version, which is generated using Microsoft Excel, is also included. The template is provided free of charge, yet it produce beautiful and professional results that could be found only with some expensive invoicing software programs. However if you need more from your invoicing system, such as management of your clients / customers, reporting on sales, customers and products, simply install Uniform Invoice Software, which is our invoicing app that support all the templates you can download here on InvoicingTemplate.com.