InvoicingTemplate.com main content

Screenshots and Images

The printed version.

Simple Template - Moving Shipping Address

Open the template in Excel.

Simple Template - Moving Shipping Address (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.

593 KBDownload

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

5.81 MBDownload

Detail

The templates that have no shipping address section are categorized as service invoice template. This simple invoice template demonstrates how to create it by moving out shipping address fields.

This customized simple invoice template is based on the result of c5076 Simple Invoice Template - Moving Taxable Controls, which was categorized as sales invoice template because it contains the shipping address section.

Usually creating a new invoice template that works an invoicing software app sounds difficult. This is not true with Invoice Manager for Excel, which is our invoicing software that use Excel spreadsheets as the front-end.

By using Excel invoicing forms, it is possible to leverage all the powerful tools provided by Microsoft Excel to do design of invoicing forms, including create relationship between Excel cells by using formulas - for example, in c4051 Simple Invoice Template - Discount Amount Field a new field Discount Amount was added and its relationship between Subtotal and taxes are established by using Excel formulas.

One of the most powerful feature supported by Invoice Manager for Excel invoicing formats is that it allows you to move the fields around. This is the most simple yet powerful way of create new invoice layouts and designs.

To those users who want to know more about how Invoice Manager for Excel works - The reason that Invoice Manager for Excel supports moving fields is simple - it identify cells by names. So even if a cell, such as in this sample the "oknShipName", is moved to a new location (from $J$9 to $T$9), Invoice Manager for Excel is still able to find it and map it to the database field.

Sometimes it is useful on a service invoice template to have a "Service Sumarry" field. We'll add this as a custom field.

The detailed steps are described below.

  1. As always, back up the template and database file. As stated before, in this sample, we'll use the simple invoicing format built in c5076 Simple Invoice Template - Moving Taxable Controls.
  2. Open the template.
  3. Click the "Design Mode" button on the "Invoice" worksheet.
  4. Modify the text label "Ship To" (cell location $I$8) to "Service Summary".
  5. Drag your mouse to select all the fields (including labels) on the shipping address section, ranging from I9 to K14.
  6. Push your mouse key on the border of the selected area, move it to a new location outside the print area. In this sample, it is moved to T9:V14.

    Excel spreadsheets support a special name "Print_Area". If a worksheet has a name defined for a range, then when you issue the print command, only the range defined by this name will be printed. All templates available here on InvoicingTemplate.com have this name defined. If a cell / field is moved out of this area, then it will not be included on printing - we say it is not printable.

  7. Drag your mouse to select all the cells that belongs to the original shipping address fields, i.e. I9:K16.
  8. Click the "Merge and Center" command in the "Alignment" group on Excel "Home" ribbon tab. Push down "Top Align", "Align Left" and "Wrap Text" buttons.
  9. To make this section differs from other fields, you can assign it a border. In this sample, we used dashed borders.
  10. Assign this section a name, "oknSummary". To do this, enter the name "oknSummary" into the name box on the left-end of the formula bar.
  11. Unlock the "oknSummary" field. To do this, right-click the "oknSummary" range, choose Format Cells. On the Protection tab, clear the "Locked" property and then click OK. This is necessary in order to have the field manually editable / fillable when creating invoices.
  12. To create a data validation for this field, go to Excel "Data" ribbon tab. From the "Data Tools" group choose "Data Validation" and then "Data Validation" again. Choose "Text length" from the "Allow" list, enter 1 and 255 into the "Minimum" and "Maximum" field respectively. Click OK. If is an optional step - if you don't create this data validation, Invoice Manager for Excel will do this type of checks automatically on saving invoices.
  13. Exit design mode by clicking the "Design Mode" button on the "Invoice" ribbon tab again.
  14. Click the "Invoices" button on the "Invoice" ribbon tab.
  15. Click "Custom Fields" to open the Custom Field Manager.
  16. Click "Add Field" to open the "Add New Custom Field" dialog box.
  17. Fill in the field name "Summary", and fill in size "255" (This is the max field size allowed in an Access database field).
  18. Click OK to close the dialog box.
  19. If you would like to have this field visible as a column on the "Invoices" data list window, click the "Columns" button on the "Invoices" data list window, and then check the "Summary" option.
  20. Save the customized simple invoice format by clicking the "Save" button on Excel quick access toolbar.

As you can see from the creation of this simple invoice template, it is not as hard as it sounds to create a new invoice form. You can use this template directly for your service business, or as a starting point of design your own template.

Format and Specification

Template#c5077
NameSimple Template - Moving Shipping Address
CategoryService Invoice Template
Release DateWednesday, February 3, 2016
Format (XLS or XLSX).xlsx
Columns5
Lines12
Line Height (Points)18.00
Print Area$D$3:$K$47
Papaer Size / OrientationPortrait
Default Margins (Points)
Left22.68
Right22.68
Top60.48
Bottom61.20
PriceFree (0.00 USD)
SystemWindows 7 and later, and Excel 2007 and later.

Update History

April 29, 2020

  • Removed the link from the "Phone Number" line.
  • Updated the default logo image.

Samples

Screenshot for Simple Sample - Printing on Letterhead Paper

Simple Invoicing Template - Printing on Letterhead Paper

Screenshot for Simple Template with Printable Watermark

Simple Template with Printable Watermark

Screenshot for Simple Invoice for Letterhead Paper

Simple Sample for Letterhead Paper

Screenshot for Print Shop Bill Sample

Print Shop

Screenshot for Tax Invoice for Printing Shop

Printing Shop

Screenshot for Simple Sample - Changing Print Orientation

Simple Invoicing Format - Changing Print Orientation

Screenshot for Simple Sample - Building & Remodeling Invoice

Simple Sample - Building & Remodeling Service Invoice

Screenshot for Basic Service Bill Sample with Deposit

Simple Service Invoicing Template with Deposit

Screenshot for Veterinary Invoice Template

Veterinary

Screenshot for Tutoring Invoice Template

Tutoring

Screenshot for Advertising Agency Invoice Template

Advertising Agency

Screenshot for Lawn Care Invoice Template

Lawn Care