The printed version.
Simple Sample - Separate City State ZIP (c4081)
c4081 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Simple Sample - Separate City State ZIP - IMFE edition
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you want this design to be set as the default template by the installer program.
Without database file. How to download and use
Download this if you have already installed IMFE, and are looking for additional customized templates; or if you want a template for Invoice Manager (Lite).
The default invoice template stores "City, State and ZIP" in two separate fields. This customization sample of our simple invoice templates demonstrate how to store it in 3 separate fields using custom fields.
In c4072 Simple Sample - Splitting City State ZIP, we demonstrates how to use Excel formulas to split a field value of user-entered "City, State ZIP" into 3 fields, and then store them in 3 database fields. The drawback of that solution is that it relies on the format of the user-entered values - for example, a United States style format like "La Jolla, California 92092-0100". A more stable solution is to let the end-user enter these 3 values, "City", "State" and "Zip" into 3 different cells, so that it will no longer rely on Excel formulas to do the separation.
To make the text shown on the printed invoice matches exactly the specification - that is, the "City" name followed by a comma, the "State" name followed by a space, we'll put the editable "city", "state" and "zip" fields outside the printable invoicing form, and use an Excel formula to concatenate what the user entered.
We'll take the sample invoice template crated in c4072 Simple Sample - Splitting City State ZIP as the base template, and then implement separate fields for "City", "State" and "Zip".
With this template design, we also replace the usual logo implementation, which is an image control, with a Word Art illustration. So if you don't have your own logo image, you can simply type in your own business name to replace the default placeholder text "InvoicingTemplate.com" to create your own logo. It is nice to have your own logo on your invoices and bills, but if you don't have one for your business yet - as many small businesses, using a Word Art logo might be an acceptable solution. Invoice Manager for Excel (namely Uniform Invoice Software) fully supports these types of logo images too, and it will also be included in your pdf invoices too!
Like other form designs here on InvoicingTemplate.com, Simple Invoice Template - Separate City State ZIP 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, 2016 or 2019.
|Name||Simple Sample - Separate City State ZIP|
|Category||Sales Invoice Template|
|Release Date||Tuesday, July 26, 2016|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||18.00|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|