BoostExcel main content

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.

Description Size Download

Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.

560 KB Download

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

6.29 MB Download

Screenshots and Images

The printed version.

Simple Sample - Using Currency Symbol

Open the template in Excel.

Simple Sample - Using Currency Symbol (IMFE Edition)

Detail

This simple invoice template details the steps required to show a specific currency symbol on all the currency-related fields, for example "Unit Price", "Line Total", "Subtotal", "Total", "Paid" and "Total Due".

The default template and database file shipped with Invoice Manager for Excel is currency-neutral. This means it assumes the template and database uses on currency, but it does not have a specific currency set. It also means that with the default implementation, our invoicing software program does not do any currency conversation or similar jobs.

While not displaying a currency symbol is acceptable for many businesses or companies, there are cases that it is helpful to show a specific currency symbol on the invoices or bills. This tutorial details the steps required to set a currency symbol for all the money fields on the invoice layout. The result of this customization is a simple invoice template that could be downloaded for free, like all the other templates available here on InvoicingTemplate.com

  1. First of all, we recommend you to back up your invoice template before doing any modification and design on it. By doing so you'll save a lot time when some steps in the customization work go wrong. To make the backup, simply copy the invoice template in Windows File Explorer.
  2. Now open the template. In this sample, our customization of template is based on c4049 Simple Invoice Template - Moving Item# Column as the original template.
  3. Click the Design Mode button by clicking the "Design Mode" button on the "Invoice" ribbon tab. The "Invoice" ribbon tab is shown only when Invoice Manager for Excel is installed and running. In design mode, Invoice Manager for Excel stops responses to the clicks on the worksheet buttons, so that you can move or resize them. The design mode command also unprotect the sheet, so that you can modify the layout, format and formula of the template.
  4. Click to select the cells that you want to set a currency symbol for. In this sample, we set currency symbol for the following cells: all "Unit Price" cells, all "Line Total" cells, Subtotal, Total, Tax1, Tax2, Shipping Cost, Total, Paid, and Total Due. To select multiple cells, push the CTRL key on your keyboard, click each cell one after another.
  5. Once you have select all the cells, release the CTRL key.
  6. Right-click one of the select cells, choose Format Cells.
  7. On the Format Cells dialog box, choose the Number tab.
  8. Choose either "Currency" or "Accounting" category. Both categories have pre-defined formats that show a currency symbol before a number. For more information about currency formatting, visit Format numbers as currency. In this sample, the cells are formatted using United Kingdom currency symbol ("£").
  9. Once done, click the "Design Mode" button again to exit design mode.
  10. Save the template by clicking the "Save" button on Excel quick access toolbar.

Format and Specification

Template# c4050
Name Simple Sample - Using Currency Symbol
Category Sales Invoice Template
Release Date Monday, January 25, 2016
Format (XLS or XLSX) .xlsx
Columns 4
Lines 12
Line Height (Points) 18.00
Print Area $D$2:$K$46
Papaer Size / Orientation Portrait
Default Margins (Points)
Left 22.68
Right 22.68
Top 45.35
Bottom 45.35
Price Free (0.00 USD)
System Windows 7 and later, and Excel 2007 and later.

Related

Thumbnail for Simple Sample - Total Quantity on Sales Report
Thumbnail for Simple Sample - Moving Balance and Payment Cells
Thumbnail for Simple Sample - Moving Item# Column
Thumbnail for Simple Sample - Discount Amount Field
Thumbnail for Simple Sample - Moving Taxable Controls
Thumbnail for Simple Sample - Changing Paper Size
Thumbnail for Simple Sample - Changing Print Orientation