Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Advance Payment Invoicing Format. Double-click the downloaded file to extract all files.
  2. Open the template "advancepayment.xlsx" or "advancepayment-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Advance Payment Invoicing Format

Advance Payment Invoicing Format (c6023)

c6023 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open advancepayment-uis.xlsx.

Advance Payment Invoicing Format (UIS Edition)

Advance Payment Invoicing Format - UIS edition

Download Advance Payment Invoicing Format (c6023)

License: Private Use (not for distribution or resale). See our Terms of Use.

You are safe to download the resources. We've added our digital signatures to the files.


Download this if you have already installed UIS, but are looking for additional customized templates.

281 KBDownload

Download this if you want this design to be set as the default template by the installer program.

2.79 MBDownload


If your business requires a percentage of the cost has been paid before the service or product delivery, then this Advance Payment Invoicing Format might be your choice. This form is printable on standard A4 paper.

Advance Payment Billing Format is created based on c6010 Sales Invoice Template with Discount Amount Column. Another customized template that supports discount percentage is also available here on, at C6011 Sales Invoice Template with Discount Percentage Column. For a list of all sales invoice template online here, see the template category listing at Sales Invoicing Templates.

This template, Advance Payment Invoicing Format, differs from the original design in that it adds two new cells, "Advance Payment %" and "Advance Payment Amount" to the bottom of the invoice spreadsheet. The first cell "Advance Payment %" is a manually editable cell (that is, it is unlocked), where you enter the percentage of the advance payment. The second cell, "Advance Payment Amount" is calculated automatically based on the total payable and advance payment percentage. The advance payment amount is then deducted from the invoice balance due.

Both "Advance Payment %" and "Advance Payment Amount" are implemented as custom fields.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Advance Payment Invoicing Format uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Advance Payment Invoicing Format without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on, that are one freeware edition, and another edition that works only with our invoicing software installed.

Note that custom fields is a powerful feature introduced by previous version of Uniform Invoice Software (UIS), i.e. Excel Invoice Manager. The support for custom fields in Excel Invoice Manager requires a database definition file ("FDINFO10.rst") to be present in the folder where the database file was installed. With UIS, using custom fields is much simpler than in Excel Invoice Manager, and the database definition file is no longer required.

Advance Payment sometimes are also referred as security deposit. For a sample template with detailed steps on creating the definition of "Deposit" and "Deposit Payment Method" fields, visit c5078 Basic Service Invoice Sample with Deposit. Hence it can be stated that an invoice / receipt / bill is a small statement and agreement of goods and services that is provided by a business to another entity, such as car rental / house rental / freelance design work / website development job etc. Every organization has its own requirements, meaning you need to really customizable template to make your invoices differ from others. While Microsoft Word, or even Adobe Acrobat PDF, Photoshop, or and some other online accounting / billing tools could get the job done too, one of the big advantages of Microsoft Excel is that it is very easy to customize the form. This, combined with the back end database, makes Uniform Invoice Software the ideal invoice creator for small businesses.

The design of Advance Payment Billing Format also takes advantages of Excel formulas. By using Excel formulas, we are able to create the relationship between Excel cells that are mapped to database fields in Uniform Invoice Software. This gives Uniform Invoice Software unusual flexibility that supports not only simple and regular invoicing and billing forms, but also complex layouts and formats that are required in many business practices. With the Excel-formatted spreadsheet forms, we are able to design invoices that are beautiful and professional. With the database connected via Uniform Invoice Software, your invoicing system will be able to manage customers, products, invoices and payments easily.

For example, the invoice template at Sample Sales Invoice Template: Fixed Items locks the first item on the detail section of the printable invoicing form. Which means that, the first line (the description) will not be changed from invoice to invoice. In fact, all template here on are created based on the default sales invoice template shipped with Uniform Invoice Software. Please refer to the "Customizing Invoice Template" chapter of Uniform Invoice Software help file for more information on how to customize our invoice templates.

Like other form designs here on, Advance Payment Billing Format is free (offered to you at a price of 0.00USD). It works on Windows XP and all newer versions of Windows, and Excel 2007, 2010, 2013 or 2016.

Format and Specification

NameAdvance Payment Invoicing Format
CategorySales Invoice Template
Release DateSunday, October 18, 2015
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Line Height (Points)15.75
Print Area$D$3:$M$54
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)

Sample Templates