Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Invoice with Previous Balance (Sales). Double-click the downloaded file to extract all files.
  2. Open the template "invoice-previous-balance-sales.xlsx" or "invoice-previous-balance-sales-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.

Invoice with Previous Balance (Sales)

Invoice with Previous Balance (Sales) (c5007)

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

Invoice with Previous Balance (Sales) (UIS Edition)

Invoice with Previous Balance (Sales) - UIS edition

Download Invoice with Previous Balance (Sales) (c5007)

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.

DescriptionSizeDownload

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

362 KBDownload

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

2.82 MBDownload

Detail

This invoice template has fields for forwarding previous outstanding balance, making it easy for your client to see past due amount on the new invoice.

Sometimes it's helpful and necessary to add past due balance to the current new invoice. Although this feature is not directly implemented in the default invoice template shipped with Uniform Invoice Software installer program, it is easy to implement such a feature so that whenever you pick up a customer, the past balance is shown automatically on the currently invoice, and added to the total due. If you decide not to use Uniform Invoice Software, the previous balance should be retrieved and added manually.

With Uniform Invoice Software installed, the invoice template is no longer a simple invoice creator, but becomes a fully featured invoicing system with the ability to manager customers, products, invoices and payments. The data is stored in a database, which is a better way than a pure-Excel way for manipulating large amount of data. So how does Uniform Invoice Software create the link between the Excel invoice form and the backend database? Specifically, when you retrieve a customer from the backend database, how does Uniform Invoice Software know where to place the value of each field? The secret lies in field names and cell names. Uniform Invoice Software adheres to a simple rule to create the relationship between the database and the Excel invoice form. For example, when you load the data of a customer from database, the value stored in the "AccountBalance" field is filled into the cell named "oknAccountBalance". However exceptions exist, as some cell names and field names don't adhere to this rule. A detailed list on the exceptions can be found in the Cell Name Reference document included in Uniform Invoice Software, which you can download and try for free.

So to create this Invoice with Previous Balance, all you need to do is to name a cell "oknAccountBalance". To do this, first unprotect the Invoice worksheet, and then select the cell you want to assign the name, and then enter the name in the name box on the formula bar. One additional step might be required, that is to unlock the named cell - If a cell is locked and the sheet is protected, Uniform Invoice Software will not be able to write to it. To unlock a cell, first unprotect the Invoice worksheet and then right-click the cell and choose Format Cells. Go to the last tab, uncheck the Lock box. After naming the cell, you can move it without breaking the functionality of the template. Moving cell to a new location could be done by dragging and dropping - more detailed sample and instructions can be found on Proforma (1st Sample of Customization) and Proforma (2nd Sample of Customization).

Note that in order to save the previous outstanding balance to the current invoice, a custom field named "AccountBalance" should be added to the invoice header database table too.

You may also like to add the "Total Due" cell, like what we did to the template here on InvoicingTemplate.com, and then use an Excel formula to add up previous balance and current invoice balance. Please download the template for free to see the details.

This invoice template with previous balance includes shipping section, if you running a service business, see Invoice with Previous Balance (Service) for a version customized for service business.

Like other form designs here on InvoicingTemplate.com, Invoice Forwarding Outstanding Balance 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

Template#c5007
NameInvoice with Previous Balance (Sales)
CategorySales Invoice Template
Release DateFriday, November 8, 2013
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)19.50
Print Area$F$3:$N$47
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Update History

March 30, 2017

  • All "Taxable" ActiveX checkbox controls were replaced Excel form controls.
  • Removed "Invoicing Form" logo.
  • "Green" color theme.

Sample Templates