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, Invoice Manager for Excel (namely 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 Invoice Manager for Excel (namely 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

This free service invoicing form in Microsoft Excel spreadsheet and PDF format for German is a variant of c4098 sales invoicing template for Germany. This sample differs from the original version in that it has all the shipping fields moved out of the printable form.

Soccer Shop Invoice Template

cn009
Soccer Shop Invoice Template

By installing Invoice Manager for Excel (namely Uniform Invoice Software), the simple pure Excel template becomes a powerful invoicing program. For example, when you finish filling the soccer shop invoice form, click the "Save To DB" button on the "Invoice" worksheet, or click the "Save Invoice" button on the task pane, an invoice number is generated automatically (See automated invoice numbering for more information).

Bricklayer Invoice Template

c4115
Bricklayer Invoice Template

If you are in the constructionc or masonry industry, your services may not limited to building houses. You may also help to beautify client's yard and landscape, etc. This billing form is suitable for all these situations.

Simple Sample - Default Value

c2038
Simple Sample - Editable Default Value

A default value is the value assigned to a field or cell. The value of the cell must be changeable / editable, but if it is not changed or edited, the default value appears on invoice and save to database.

Translation Service Receipt

c5126
Translation Service Receipt

Whether you're a freelance translator or interpreter, or you're running a small business offering translating service, it is import to receive payment timely. A professionally designed receipt (invoice) helps. You don't need an expensive accounting or book keeping software program for that. A free and simple spreadsheet sheet template like this one produces elegant results too.

Boutique Bill Sample

c6032
Boutique Bill Sample

If you are a manufacturer instead of a shop, you may like to take a look at cm003 Clothing Store (Manufacturer) Invoice with Size Breakdown and cm005 Clothing Store (Manufacturer) Invoice Template with Discount Percentage. Another example here on InvoicingTemplate.com includes item pick-up buttons, which could be found at cm004 Clothing Store (Manufacturer) Invoice Template with Item Pickup Buttons.

Five Price Levels (Service, Amount)

c4013
Form with 5 Price Levels

After unprotect the sheet, the second step is to switch to design mode, which is done by clicking the Design Mode button on the Developer ribbon tab in Excel 2007, Excel 2010 and Excel 2013, or in Excel 2003 by clicking the Design Mode command button on the Controls toolbar.

Sample Invoice Template

c4128
Sample Billing Form

Although it has only 3 lines on the detail section, each line is able to holds up to 3 lines of text. This is especially useful for those who has long item descriptions. You can more samples at c4020 Invoice Template with Long Product Description.

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
Payment Voucher Template

This Excel payment voucher template contains 4 fields on the bottom of the voucher form, there are Discount, Total, Advance, and Balance. Both "Discount" and "Advance" are manually editable fields. "Total" is calculated from the sum of all the line totals subtracted by discount; "Balance" is calculated from Total subtracted by "Advance". If you prefer a voucher template that does not have the advance field, take a look at Cash Payment Voucher Template.

Work Invoice in Excel

c4125
Work Billing Template in Excel

This sample template also adds the line of "United States Federal Tax I.D." to the bottom of worker information. We also formatted several fields to show the US Dollar currency symbol, such as "Subtotal", "Tax" and "Total".

Commercial Invoice for Export in Excel

c7015
Commercial Invoice in Excel

Note: This free Commercial Invoicing Template was original published on our company site, UniformSoft.com, with the ID number c7011.

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

c5036
Sales Template with line Number

This sample invoice template was originally published as a customization sample on office-kit.com at Sample Invoice Template: Using Line# as Product IDs, where you can also find detailed steps on how to create the sample invoice template based on the default sales invoice template shipped with Invoice Manager for Excel (namely Uniform Invoice Software).

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

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

Like what we do to all the customized invoice templates here on InvoicingTemplate.com, we start by unprotecting the Invoice worksheet, and then display gridlines and row/column headers, and then drag the shipping fields, including the related labels, out of the printable invoice form.

General Quote Template for Excel

c2035
General Quote Format in Excel Spreadsheet Format

Due to this difference, it is important to clearly identify the document type on the header - whether it is a quote or an estimate. It is also useful, at least in some business areas, to include an expiry date on the document, if your prices are subject to change on the time. In this sample, we added it as a custom field "ExpiryDate". This field is defined as "text (100)" in the backend Access database, and the corresponding cell is named "oknExpiryDate" on the top quote form.

Building Construction Bill Format

c4130
Construction Bill Format in Excel

Designed for general contractors and operative builders in the construction industry, this free building construction bill format in Excel is suitable for small businesses like family owned and operated contractor.

Bill Sample with Sports Theme

c4094
Bill Sample with Sports Theme

All templates here could be downloaded for free. You can use the templates without installing Invoice Manager for Excel (namely Uniform Invoice Software). For example, you can just download this "Billing Sample with Sports Theme" template, fill in your business / organization name, and then create new invoices just like filling a blank paper. The result could be either printed, or you can generate electronical PDF invoice for your sports store using Office / Excel's built feature, and then send it PDF invoice to your clients. Even the template is completely free of charge, the result is good enough that even some commercial / paid invoicing software app couldn't procedure.

Construction Invoice Template

c4046
How to Make a Construction Invoice

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.