Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Music Store Invoice Template (Retail). Double-click the downloaded file to extract all files.
  2. Open the template "musicstoreretailinvoicetemplate.xlsx" or "musicstoreretailinvoicetemplate-uis.xlsx" with Microsoft Excel.
  3. Click "Design Mode" on the "Invoice" Excel ribbon tab to put it into design mode.
  4. Enter your business information and replace the default logo image to make it your own. (How?)
  5. Click "Design Mode" again to exit design mode.
  6. Create invoice (tutorial movie)!

Prefer to have a look at other samples? Try our Search tool!

Screenshots and Images

The printed version.

Music Store Invoice Template (Retail)

Music Store Invoice Template (Retail) (c5010)

This is how the template looks like when you open the freeware template in Microsoft Excel.

Music Store Invoice Template (Retail) - freeware edition

Music Store Invoice Template (Retail) - freeware edition

The following template was designed for Uniform Invoice Software version 3.

Music Store Invoice Template (Retail) - Uniform Invoice Software V3 edition

Music Store Invoice Template (Retail) - Uniform Invoice Software V3 edition

Download Music Store Invoice Template (Retail) (c5010)

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 UIS, but are looking for additional customized templates.

362 KBDownload

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

2.76 MBDownload

Detail

Music Store Invoice Template (Retail) was designed specially for music company or store. The printable form (the main invoicing form on the center of the Invoice Excel spreadsheet is same as the default sales invoice template included in Uniform Invoice Software, but there are also several special fields added for music store business.

The additional fields, which are not present in the default sales invoice template that is shipped with Uniform Invoice Software setup program, are placed outside the printable area (the area with white background color on the center of the invoicing form). This means that, the addtioanl fields will not be printed if you issue the Print command in Microsoft Excel. These addtional fields include: COMPOSER, INSTRUMENTATION, PUBLISHER, COMMENT, which are all added to the Excel invoice form as columns.

The addtional fields are implemented as custom fields.

Uniform Invoice Software support custom fields or user-defined fields, which is a unique feature that allows you to add new fields to the backend database as well as to the spreadsheet form. Music Store Invoice Template (Retail) uses custom fields to implement the features that are not available in the default template shipped with the invoicing program. With the support for custom fields in the database, Uniform Invoice Software has the ability to manipulate the newly added fields in database, includes adding them to reports. With the support for custom fields in the Excel worksheet, our invoicing app has the ability to create the relationship between fields - for example, one field should be the sum of the other fields, or the value of one field should be calculated only when another field value equals a certain value.

The support for custom fields makes it possible for even an end user who does not know programming at all, could add new features to her/his invoicing creator such as Music Store Invoice Template (Retail) without writing one line of programming code. Feel free to Search and download more samples. Sometimes our customization samples are offered in two editions here on InvoicingTemplate.com, that are one freeware edition, and another edition that works only with our invoicing software installed.

The printable form, Music Store Invoice Template (Retail), is exactly same as the default sales invoice template. So to implement this Music Store Invoice Template (Retail) based on the sales invoice template, all you need to do is to add the 4 custom fields to the Invoice Body (InvBdy) and Product database tables, and then add the 4 columns with each column mapped to a field in the database tables.

Adding a custom field to the "InvBdy" database table makes it possible to save the data on the invoice spreadsheet to database when the "Save To DB" button is clicked. For example, adding the custom field "Product Type" to the "InvBdy" database table allows save the type value on the invoicing form, such as "General" or "Labor", to database when you save an invoice by clicking the "Save To DB" button. This feature is not supported in the freeware edition of Music Store Invoice Template (Retail).

Adding a custom field to the Product table in the database makes it possible to save the field value to database along with the other data of a product. For example, adding the custom field "Product Type" to the Product database table allows you to save the type, such as "General" or "Labor", to the database when you save a product or item. If you use Uniform Invoice Software version template Music Store Invoice Template (Retail) and add the custom field to the spreadsheet, the value is retrieved whenever you pick up a product on creating an invoice.

In the original version of Uniform Invoice Software, which is named Excel Invoice Manager, adding custom fields to database tables should be done by using a standalone utility, which is called Database Designer. With Uniform Invoice Software, adding custom fields to database is much more easier. For example, to add the " Composer" field to the Product table, here are the steps to follow.

  • Open the invoice template that you want to customize, and make sure it is connecting with the database you want to add new fields to.
  • Click the Products button on the Invoice worksheet.
  • Click the "Custom Fields" button on the toolbar. This opens the "Custom Fields" dialog box. The "Database Table" dropdown list box shows the database table currently you are working with. The "Custom Fields" grid shows all the custom fields defined for this database table.
  • Click the "Add Field" button. This shows the "Add New Custom Field" dialog box. Here you speicify the name, type, caption and size etc., for the new field. In this example, we speicify the name of the new field as "composer", and the type as "text", the size as "100". This means that the text field will be able to hold up to 100 characters of text.
  • 4. Click the OK button to alter the database table to add the new field.
  • 5. Repeat the same steps 4-5 to add 3 other custom fields, INSTRUMENTATION, PUBLISHER and COMMENT.
  • Once all the custom fields have been added to the Products table, we add these fields to the "Invocie Body" database table too.

When working with Uniform Invoice Software (UIS) version of Music Store Invoice Template (Retail), how does UIS know to which cell when a field value write to when loading data from the database, and to which field a cell value must save when saving an invoice record, a customer or a product item? That is, how does UIS create the map or relationship between Excel cells on the template Music Store Invoice Template (Retail) and database fields? The answer is by using names. For example, if the field name in the Product table in a database is "ProductType", it is writing to a cell named "oknProductType_?" (where ? is the line number of the invoicing item) when you pick up a product or item on creating an invoice, and when saving an invoice, all cells with the name "oknProductType_?" are saved to the "ProductType" field in the "InvBdy" database table. By using cell names, UIS allows you to move a cell on the form without breaking the feature depending on the field / cell. You can place the "Product Type" column either inside the printable area, which is printed when you issue the Print command in Excel or click the Print command on the "Invoice" worksheet form; or place the Product Type column outside the printable area, which will be included when you print or extract an invoice or receipt.

Music Store Invoice Template (Retail) is desinged mainly for the retail business. If you are doing wholesale you may need a Discount field to appear on the invoice that you issue. See Music Store Invoice Template (Wholesale) for a free template that you can use. A PDF version of this template is also included for free.

Like other form designs here on InvoicingTemplate.com, Music Store Invoicing Form (Retail) 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#c5010
NameMusic Store Invoice Template (Retail)
CategorySales Invoice Template
Release DateFriday, September 19, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns5
Lines12
Line Height (Points)24.75
Print Area$F$3:$N$41
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left22.68
Right22.68
Top45.35
Bottom45.35

Sample Templates