The printed version.
Proforma (2nd Sample of Customization) (c7012)
c7012 now includes the customized invoice template for the latest version of Invoice Manager for Excel. This is what you will see when you open
Proforma (2nd Sample of Customization) - 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).
This is the 2nd sample on how to create a new design for pro forma invoice template, focused on entering company information and replacing InvoicingTemplates logo image.
With the first sample on how to customize the proforma invoice template, we learnt how to unprotect the Invoice worksheet and how to modify Excel color palette to change the color theme of an existing template. This second sample of customizing the pro forma invoicing template will be focused on how to enter your company information and replace the default "InvoicingTemplates" logo image.
Most of the templates available here on InvoicingTemplate.com have the Invoice worksheet protected to avoid accidental modifications on form layout and formula. This is useful and necessary since once the design of the form is finished, you'll not change the design for a long time. However before using the invoice template, you at least need to do two things that are to enter your company information, and to replace the default logo image. Before you do, you first need to unprotect the Invoice worksheet, as detailed in the previous sample.
Once the invoice spreadsheet is unprotected, it's straightforward to enter your own company information. Simply click a text label such as "Your Company Name", and then start typing in your own text. In the sample template that you can download here, we replace the placeholder text labels with our own company name.
The next step is to replace the default "InvoicingTemplates" logo image. To do this, you need to switch the invoice form into design mode, which is done by clicking the "design mode" command on the Developer ribbon tab. If your Excel does not show the Developer ribbon tab, here is how to make it visible.
Now you can find the Design Mode button in the Controls group on the Developer ribbon tab. Click the Design Mode button once to put the template into design mode - in the design mode, Excel lets you change the properties of controls, such as the image control we used for the logo image. If you are using Invoice Manager for Excel (namely Uniform Invoice Software), our invoicing software that uses Excel templates as the front-end, the software program stops reaction to clicks on the button.
Now right-click the InvoicingTemplates logo image and choose Properties from the shortcut menu. The Properties box appears. Look for the Picture property, and click the button on that line. Excel shows you a dialog box that allows you to browse to and specify your own logo image. Depending on your Excel version, the supported image file formats may vary, but JPG, PNG and GIF formats are good choices for storing your logo image that are likely supported by your Excel.
Once you have specified your own logo image, exit design mode, and then protect the Invoice worksheet again. Save the invoice template once to make the changes persistent.
Like other form designs here on InvoicingTemplate.com, Proforma Invoicing Form 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||Proforma (2nd Sample of Customization)|
|Category||Proforma Invoice Template|
|Release Date||Wednesday, October 30, 2013|
|Format (XLS or XLSX)||.xlsx|
|Excel Version||Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016 / Excel 2019|
|Line Height (Points)||12.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
August 27, 2018
September 12, 2018
Updated the Access database "c7012.mdb" by adding the quotation tables.
October 28, 2018