InvoicingTemplate.com main content

Screenshots and Images

The printed version.

Simple Sample - Separate City State ZIP

Open the template in Excel.

Simple Sample - Separate City State ZIP (IMFE Edition)

Download

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 the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

542 KBDownload

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

5.81 MBDownload

Detail

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".

  1. Backup the template before modifying it.
  2. Open it.
  3. Go to the "Invoice" ribbon tab and click the "Design Mode" button.
  4. Drag your mouse to select 3 custom fields, "oknCustomerCity" (cell address O8), "oknCustomerState" (cell address O9) and "oknCustomerZip" (cell address O10).
  5. Hit DEL key on keyboard to delete the formulas of these 3 cells.
  6. With the 3 cells / fields still selected, right-click on of the selected cell and choose "Format Cells" from the shortcut menu. This opens the "Format Cells" dialog box.
  7. Go to the "Protection" tab. Clear the "Locked" checkbox option.
  8. Click OK to close the "Format Cells" dialog box. This makes the 3 cells editable when the worksheet is protected.
  9. Now click and select the "City, State ZIP" cell in the "Bill To" section (cell address $F$11).
  10. Enter this formula for the cell: = CONCATENATE( TRIM ( oknCustomerCity ) , ", ", TRIM( oknCustomerState ), " ", TRIM ( oknCustomerZIP )). This formula combines the 3 user entered values into one readable and formal "City, State ZIP" value.
  11. Right-click selected cell ($F$11) and choose "Format Cells" from the shortcut menu.
  12. Go to the "Protection" tab.
  13. Check the "Locked" option box.
  14. Click OK to close the "Format Cells" dialog box. This make the cell not editable when the "Invoice" worksheet is protected.
  15. Exit design mode by clicking the "Design Mode" button again on Microsoft Excel ribbon tab.
  16. Save the template by clicking the Save button on Excel quick access toolbar.

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 fully supports these types of logo images too, and it will also be included in your pdf invoices too!

Format and Specification

Template#c4081
NameSimple Sample - Separate City State ZIP
CategorySales Invoice Template
Release DateTuesday, July 26, 2016
Format (XLS or XLSX).xlsx
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$47
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Samples

Screenshot for Simple Sample - Splitting City State ZIP

Simple Sample - Splitting City State ZIP

Screenshot for Simple Sample - Using Segoe Print Font

Simple Invoice Sample - Using Segoe Print Font

Screenshot for Invoice Sample with Partial Payment and Payment History

Partial Payment and Payment History

Screenshot for PDF Invoice with PayPal Button

PayPal Button

Screenshot for Invoice and Packing List on Separate Worksheet

Invoice and Packing Slip on Separate Worksheet

Screenshot for Spin Button to Add or Subtract One

Sample Invoice Template with Spin Button

Screenshot for Excel Shipping Invoice with Printable Truck Background Image

Printable Truck Background Image

Screenshot for Invoice and Packing List on Same Form

Invoice and Packing Slip on Same Form

Screenshot for Recipient Created Tax Invoices Form

Recipient Created

Screenshot for ABN Tax Invoice

ABN Tax

Screenshot for Invoicing Template with Logo

With Logo Image

Screenshot for Standard Invoice with Double Border

Double Border