Skip to main content
InvoicingTemplate.com main content
Sharing Is Caring! We do appreciate your efforts to let others know us!

Screenshots and Images

The printed version.

Simple Sample - Using Currency Symbol

Simple Sample - Using Currency Symbol (c4050)

c4050 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open simple-invoice-template-currency-symbol-uis.xlsx.

Simple Sample - Using Currency Symbol (UIS Edition)

Simple Sample - Using Currency Symbol - UIS edition

Download - Simple Sample - Using Currency Symbol

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

Without database file. How to download and use

80 KBDownload

Download this if you have already installed UIS, but are looking for additional customized templates.

295 KBDownload

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

2.80 MBDownload

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 Uniform Invoice Software 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 Uniform Invoice Software is installed and running. In design mode, Uniform Invoice Software 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.

Like other form designs here on InvoicingTemplate.com, Simple Billing Format - Using Currency Symbol 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 or 2016.

Format and Specification

Template#c4050
NameSimple Sample - Using Currency Symbol
CategorySales Invoice Template
Release DateMonday, January 25, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Columns4
Lines12
Line Height (Points)18.00
Print Area$D$2:$K$46
Printable with Papaer Size / OrientationSimple Sample - Using Currency Symbol - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35