UniformSoftware main content

Version History - Invoice Manager for Excel

15.21 - December 14, 2023

  • Updated the “Send email to customers” feature so that it works smoothly with the newer TLS protocols.

15.20 - August 31, 2023

  • It may take a relatively long time to show the list of invoices or customers if you have large amounts of data, for example, more than 10 years of data. This new release fixes the bug.

15.19 - July 7, 2023

  • The data list windows now resize columns automatically.

15.18 - December 5, 2022

  • Optimized the procedure that detects the installed Excel version. In previous versions, when Office was installed with some versions of ‘Click to Run’, it might fail to detect the installed Excel version.
  • Microsoft Store edition: The main app was migrated from Windows Forms Application to WPF.

15.12 - November 5, 2021

  • Microsoft Store edition: The main app window shows the status of the add-in installation.

15.11 - August 18, 2021

  • Microsoft Store edition: This version installs an add-in for Excel. It is no longer necessary to run the main app (the starter app) to activate the buttons inside the Excel templates.

14.11 - June 9, 2021

  • New "Compact database file" tool.
  • Microsoft Store edition: Optimized for high DPI screens.
  • Requires .NET framework 4.7.2.

12.11 - August 5, 2020

11.12 - April 20, 2020

  • Removed the "Initializing template" message that is displayed when you open a template.

11.11 - March 31, 2020

10.12 - January 28, 2020

  • Fixed a bug that caused the email settings not to be saved correctly.

10.11 - January 26, 2020

  • Optimized program performance in many aspects.

    This version requires Microsoft .Net Framework 4.5.

    We recommend all existing users upgrade to this latest version.

9.12 - December 10, 2019

9.11 - November 15, 2019

8.12 - September 29, 2019

  • In very rare cases, the installer program for v8.11 may fail silently. This release fixed the problem by adopting a new loader program.

8.11 - September 9, 2019

  • Improved program startup time by using a new add-in loader.
  • Email statement report and account aging report. See detail.
  • Removed the help file in "chm" format. All "help" buttons now link to online pages.
  • The "Hide Task Pane" button is visible only for Excel 2013 or higher.

7.13 - May 14, 2019

  • The "Delete Invoice" button is made visible by default. This changes the previous default behavior, as requested by many of our users. You can still hide the button if you want.

7.12 - January 17, 2019

  • Support for Excel and Office 2019.

7.11 - September 30, 2018

  • Renamed the program to "Invoice Manager for Excel", as this new name more clearly and accurately describes what it does.
  • All existing licenses for Uniform Invoice Software are valid for this new release. If you upgrade from Uniform Invoice Software, your existing template and database will work fine.
  • Dynamically show product images or service scenario images on your invoices, quotations, and purchase orders. See the sample at Image and Picture on Invoice, Quote, and Purchase Order.
  • Support for the purchase order.
  • The "About / Email" dialog box, which could be opened by clicking the "Contact / Email" button on the "Invoice" ribbon tab, now allows you to attach your invoice template and database file easily. If you are looking for technical assistance, don't forget to use this new feature.
  • Programmable COM add-in (Enterprise edition only) interface. Now you can call all the major features provided by Invoice Manager for Excel from your own VBA macro code. See the sample at Advanced Invoicing Format: Email Is Required Before Saving an Invoice.
  • Options for controlling how the on-sheet picker works. You can now disable or enable the on-sheet picture separately for each section of your invoice form, quote form, and purchase order form. To look into these options, click "Settings" and then go to the "Lookup and Picker" tab.
  • The search bar now allows you to perform "Search within Results" searches.
  • The "Add PayPal Button" command was moved inside the "Tools" menu on the "Invoice" ribbon.

6.12 - September 7, 2018

  • This release added back the subtotal feature of the "Sales Report".

6.11 - August 24, 2018

5.31 - August 16, 2018

  • Updated and fixed some help page links.

5.30 - July 25, 2018

  • On some platforms, the data list windows slow down when there are large datasets to load. This new release speeds up this process.

5.29 - July 12, 2018

  • With this new release, UIS takes a new approach to capturing mouse clicks inside Excel. This improves performance.

5.28 - May 16, 2018

  • If you save a template to a different folder, Excel updates all the local links automatically. This new version fixes this by verifying and updating all the local links on opening the template.

5.27 - April 12, 2018

  • This quick update added or restored support for Excel 2007. Now this latest version supports all the major Excel versions from 2007 to 2016.

5.26 -January 31, 2018

  • This version requires Microsoft Excel 2010 and higher.
  • Uniform Invoice Software is no longer relying on the helper add-in program to receive click events from templates. So "Uniform Invoice Software Helper" is no longer required.
  • All templates hosted on this web site have been updated for this new version.
  • If you need version 5.25, click this link to download: uis5.25.exe

5.25 - December 16, 2017

  • This upgrade improves the "Design Mode" button by adding a new features that checks all the named cells on the "Invoice" worksheet, and lock / unlock cells according to the content of each cell -- if a cell has a formula assigned, it will be locked, if a cell does not have a formula, it will be unlocked. This automated process is executed whenever you exist design mode, which simplifies form design, since you're no longer required to check / uncheck the "locked" cell properties manually.

5.24 - September 20, 2017

  • Removed the options "Allow incomplete lines on invoice body" and "Allow zero line totals". These two options are enabled by default.
  • The "Create New Database" feature now copies custom fields to the newly created database from the currently connected database. This applies to both Access database and MS SQL Server database.

5.23 - March 7, 2017

  • Fixed a bug that caused the "Invoices" data list window not to be able to restore default search bar options in certain situations.

5.22 - February 9, 2017

  • Remember the state of the "Disable (Enable) on-sheet picker" button state.
  • Remember the visibility state of the task pane (works for Excel 2010 and higher versions only).
  • Remember the folder used for storing customer statement reports.
  • Support for Microsoft Access ".accdb" database format.
  • New option to hide the "Invoice" ribbon tab on the "Forms" tab of the Settings window.

5.12 - October 10, 2016

  • This minor upgrade from 5.11 to 5.12 simplifies the macro assignment of on-sheet buttons. Now all the buttons on an Excel invoice template could be assigned with the same macro name "UISClickProc", without passing in the command name. The macro procedure (i.e., "UISClickProc") will detect the command name based on the button name.

    For a detailed tutorial on how to create a command button from scratch, see Standard Invoice Template and Shortcut Keys.

5.11 - September 21, 2016

  • This major upgrade of Uniform Invoice Software changed the way the buttons on the template are implemented. In previous versions, all the buttons were ActiveX controls. With this upgrade, the buttons are changed to text boxes with macros assigned.

    The default template (standard template) shipped with Uniform Invoice Software now contains on-sheet buttons too, in addition to those commands provided by task pane and ribbon tab.

    If you open a template created for previous versions, Uniform Invoice Software is able to convert it automatically, which means your existing template and database will work with this new version without problems.

  • All major commands available on the template now have a shortcut key assigned, which means you can execute commands by pressing key combinations in addition to clicking on command buttons.

4.17 - August 9, 2016

  • Support for PayPal payment button on PDF invoices.

4.16 - May 10, 2016

  • Support for remote SQL Server database connections. This enables you to put your database on the Internet, sharing it across different locations.

4.15 - November 25, 2015

  • Support for Excel 2016.

4.14 - October 31, 2015

  • In addition to PDF invoice and Excel invoice, Uniform Invoice Software now also supports image invoice (set this option on the Extract/Email tab of the Settings) window.
  • Minor UI improvements.

4.12 - July 12, 2015

  • Support for Windows 10.
  • The new "Replace Logo Image" button on the "Invoice" ribbon tab provides a quick way for new users to replace the default logo image on the Invoice worksheet.
  • Advanced database fields customization: with this utility, the end-user is able to modify the size (or precision and scale of decimal fields) of database fields and to change the text alignment (left, center, or right) for those fields shown on the data list windows (for example, the "Customers" window that shows all the customers). Please refer to "Advanced Database Field Customization" in the help document for more information.
  • The new "Include time with invoice date" option, located on the "Template" tab of the "Settings" window, allows you to store time information along with the invoice date.

4.11 - April 3, 2015

  • The main user interface is now integrated with the Microsoft Excel ribbon. With this release, the commands available on the Invoice ribbon tab are: Customers, Products, Invoices, Reports, Settings, Help, About, Hide Task Pane, Disable On-sheet Picker, and Design Mode.

    Commands that are sheet-specific are now available on the task panes. For example, when Invoice is the active worksheet, the task pane shows commands: Clear & New, Save Invoice, Extract / Email, etc.

    This design makes it possible to remove almost all ActiveX controls from the spreadsheet.

  • To make it easy to select customer, shipping address, products, shipping methods, and sales representative names, a new tool called "On-sheet Picker" was introduced. If you click a cell that supports the on-sheet picker, for example, a cell inside the "Bill To" section, a small button appears below the active cell. Click the button to choose a customer from the list.
  • The main forms, Customers, Products, and Invoices are now modeless, which means you can execute other commands without closing these windows, for example, creating invoices with the "Products" window opening for reference.
  • Integrated email sender, with the ability to generate PDF and Excel format invoices.

3.15 - April 2, 2014

  • The addition of the Custom Field Manager, which can be opened from the Customers, Products, and Invoices data list windows, makes it easier to work with user-defined fields.
  • All main forms, including Customer Edit, Product Edit, Invoice Edit, Payment Edit, and Shipping Address Edit, are now resizable.
  • A new option "Set default quantity to 1" was added to the Templates tab on the Settings window, which instructs Uniform Invoice Software to fill quantity with "1" when a product is picked up on creating invoices.

3.14 - February 15, 2014

  • Added a "Colors" command to the Customers, Products, and Invoices data list windows, which allows you to set the status colors of customers (active, inactive, and terminated), products (active and inactive), and invoices (pending, paid, void).

3.13 - September 29, 2013

  • Added a "Save & New" button to the Customer Edit, Product Edit, and the Misc. Data Edit windows.

3.12 - August 27, 2013

  • Fixed a bug that occurs when the template connects to an Access database and the decimal symbol in the "Region and language" setting in the Windows control panel is not "." (dot), but a different symbol such as "," (comma). For example, it could happen when your Windows uses "Russian" or "Finnish" languages. The bug may cause a "Data type mismatch in criteria expression" error message on saving an invoice.
  • Added a new feature that allows you to print multiple invoices with a single click of the mouse. To do this, select the invoices to print on the Invoices data list window, and then click Print on the toolbar.

3.11 - August 4, 2013

  • This is a completely redesigned version. Excel Invoice Manager is now renamed to Uniform Invoice Software, and it runs with Windows 8 and Excel/Office 2013 (both 32-bit and 64-bit).

Before August 4, 2013, Uniform Invoice Software was named Excel Invoice Manager.