Skip to main content
InvoicingTemplate.com main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Print Shop Bill Sample. Double-click the downloaded file to extract all files.
  2. Open the template "printshopinvoicetemplate.xlsx" or "printshopinvoicetemplate-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.

Print Shop Bill Sample

Print Shop Bill Sample (c4006)

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

Print Shop Bill Sample - freeware edition

Print Shop Bill Sample - freeware edition

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

Print Shop Bill Sample - Uniform Invoice Software V3 edition

Print Shop Bill Sample - Uniform Invoice Software V3 edition

Download Print Shop Bill Sample (c4006)

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.

281 KBDownload

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

2.77 MBDownload

Detail

Print Shop Invoice Template could be used by a print shop or mail room for a school district. Compared to the default sales invoicing sample shipped with Uniform Invoice Software, in the Bill To section the "Name" changed to "Department", "Company" changed to "Contact Name", "Address" changed to "Department Code", etc.

As a service bill format, this template for Print Shop does not contains the Shipping To section. This section is moved out of the printable invoice form, i.e. the section identified by the Print_Area name.

The printable area, or print area, is the area with white background on the center of the Print Shop Bill Sample spreadsheet. By default Microsoft Excel prints the entire worksheet when you issue the print command, but if the worksheet has a print area defined, such as what we do for Print Shop Bill Sample, only the print area will print. You can add cells to expand the print area as needed, and you can clear the print area to print the entire worksheet again. If you need to recreate the print area definition, here are what to do: On the "Invoice" worksheet of the Print Shop Bill Sample, select the cells that you want to define as the print area; On the Page Layout tab, in the Page Setup group, click Print Area, and then click Set Print Area.

This bill template for printing shop is set with no tax, but the tax cells and fields defined in the default template are still there.

Print Shop Bill Sample, like the default template, has two tax items on the bottom of the worksheet, which are applied to all the items, and a column of Taxable checkboxes to the left of the form body, which are corresponding to each invoicing item. You can change the tax names and rates on the bottom of the form by typing in whatever meet your requirements. These are the supported features implemented in both the freeware version and the Uniform Invoice Software version.

If you use the Uniform Invoice Software version of Print Shop Bill Sample, there are additional taxing options on the Taxes tab of the Settings window. The first is the option for choosing the number of tax items; you have 3 choices - no tax, one tax and two taxes. Secondly, you can set the names and rates in percentage for each tax, such as VAT, GST or PST, or simply Sales Tax. Thirdly, there are a group of checkbox options on the dialog box, including: "Tax invoice total including shipping cost", which adds the shipping cost to the taxable amount when checked; "Tax 2 is applied to tax 1", which adds the amount of "tax 1" to the taxable amount if checked; and "tax rate can be zero", which allows you to set any of the tax rates to be the value of zero. If you modify the options on this dialog box, the spreadsheet will be changed accordingly if needed.

Some cells, such as "Date Requested" and "Date needed", are not defined in the default template. These are additional fields called custom fields in Uniform Invoice Software.

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. Print Shop Bill Sample 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 Print Shop Bill Sample 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.

When working with Uniform Invoice Software (UIS) version of Print Shop Bill Sample, 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 Print Shop Bill Sample 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.

Note that the Invoice worksheet is protected by default. Before you can use the spreadsheet for the first time, you need to unprotect the Invoice worksheet and then type in your business details.

The protection of the "Invoice" worksheet in Print Shop Bill Sample prevents accidental modifications to layouts and formulas. If you have Uniform Invoice Software installed, it could even display a warning message when you close a template without protecting the worksheet. However for the purpose of this sample, we should firstly unprotect the worksheet in Print Shop Bill Sample.

While the free version of Print Shop Bill Sample is simple, the result created by using this template is as beautiful and professional as many commercial invoicing software program, or even better. It is an ideal tool for small businesses and freelances who offer services and don't need a shipping section on their invoicing form. It is a good service bill creator, but if you need more features, like management of customers, products / service items, invoices and payments, just install Uniform Invoice Software to make all the buttons on Print Shop Bill Sample work for you.

Please also refer to another billing sample for print shop that created for you by InvoicingTemplate.com, at Tax Invoice for Printing Shop.

Like other form designs here on InvoicingTemplate.com, Print Shop Billing Format 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#c4006
NamePrint Shop Bill Sample
CategoryService Invoice Template
Release DateFriday, May 30, 2014
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Columns4
Lines12
Line Height (Points)19.50
Print Area$G$1:$P$44
Printable with Papaer Size / OrientationA4 (210 mm x 297 mm) - Portrait
Default Margins (Points)
Left36.00
Right36.00
Top72.00
Bottom72.00

Sample Templates