Skip to main content
UniformSoft.com main content
Sharing is caring

Introduction

Please visit an updated version of this template at Soccer Shop Invoice Template on our new web site InvoicingTemplate.com.

Soccer Shop Invoice Template is a sample invoice template designed for an imaginary soccer equipment and apparel shop that sells soccer shoes, jerseys, soccer balls, team uniforms, goalkeeper gear, soccer cleats, soccer boots, shin guards, etc. The invoice template has 16 columns on the printable invoice body. You may have different requirements even if you are running a soccer equipment and apparel store, but this billing format gives you a good sample on how to design such a form and can be used as a starting point of your own template.

The requirements and form layout

The most important thing is that each of the products sold by the sample soccer shop or sample soccer store has different sizes (columns). In essence they will require 9 columns for size that will total into 1 column for the total units while keeping the different sizes available. For example a jersey has 9 sizes: 'ys', 'ym', 'yl', 'yxl', 'as', 'am', 'al', 'axl'. If an invoice has 5 in each size the total would read 45. All of the sizes will have the same product code, based on the manufacturer's models.

Two levels of taxable check-boxes

The 'Taxable' checkbox near the label 'SALES TAX' makes the whole invoice taxable or non-taxable. Besides that, there is a column of 'Taxable' checkbox near the product-selection buttons, with which you can make each item taxable or non-taxable.

Branch store addresses

There are 3 boxes created at the bottom of the page. They are designed for store/shop addresses, and you can also enter your website and e-mail information here. The store needs these fields to have the ability to show branch store addresses in multiple cities. All these labels are static text, meaning that you can replace them with your own text by simply unprotecting the Invoice worksheet and then typing in your own text.

Terms and conditions

The form has the following terms and conditions listed near the bottom of the form. Be sure to modify it according your own business requirements.

  1. Terms: 50% down net cod. 1% finance charge will accrue each month to past due invoices.
  2. If you are tax exempt you must provide a sales tax exemption form before your order can be placed.
  3. 2% additional fee to all credit card purchases on account.

 

Invoice Manager notes

Auto-generation of invoice numbers

A customer said "We would like the invoice number to automatically show up when you create a new invoice, not when you save it. I do not want to be able to manually enter invoice numbers."

Invoice numbers are generated when you click the Save To DB button. This is necessary to keep the invoice numbers continuous.

The rules for generating invoice numbers are set on a per-database basis. That is, if all your computers share the same database (the same set of customers, products) on a local network, those computers will share the same rules for generating invoice number.

If those computers don't share the database, they can have their only rules. To set the rules, click the Settings button, and then go to the Database tab.

Removal of the feature for deleting invoices

The default configuration of our invoicing software shows the feature of deleting an invoice. Someone may like this to be removed, since they do not allow their employees to delete information. The employees are requested to void the invoice, note on the voided invoice why and then create a new invoice with the proper information. Therefore they do not want to be able to delete invoices.

Currently the removal of the 'delete invoice' button is implemented as a hidden feature in our invoicing software. To hide/delete the 'delete invoice' button, download the following registry file and import it into your Windows registry. Updated September 2018: Starting from version 6.11, the 'Delete Invoice' is hidden by default.

Columns on data-list windows

By 'data list window' we refer to those windows or forms that show a group of similar data in a grid format, such as the windows opened by clicking the 'Customers' button, 'Products' button or 'Invoices' button.

To set up the columns appear on the 'Select a customer' box, click the Customers button, and then right-click the data-list area, and then choose the columns. You will like to adjust the width of the columns and width/height of the window too.

PDF format

Excel Invoice Manager itself does not support PDF conversion. Since there are so many free PDF tools available, we won't implement this feature in Excel Invoice Manager. However it's a good idea to implement a feature that calls an existing PDF program to make the conversion.

The saved invoices are incomplete

If you do not enter a product style number (i.e. Product ID) for each product; when you save the invoice that product is not saved. You may notice this when you don't enter a product style number on a new invoice or while editing a saved invoice.

In the current version, Product ID, Product Description and Line Total are the 3 required fields. The program determines whether the invoice body is finished by testing these 3 columns. If Product ID or Product Description is empty, the line won't be saved. If you need to save the lines with the required fields missing, check the 'Allow incomplete line on invoice body' option on the Settings window that can be opened by clicking the Settings button on the Invoice worksheet.

Cost and profit

Outside the print area, we have created some new columns to the right of the printable invoice which contain cost and profit. It is designed in a way that the cost total found at the bottom of those columns be the cost found on the sales report for the invoice. We also make the total profit line added onto the generated report.

In-cell lookup with product description

A customer asked that, when you type a description of an item that we have already entered in past invoices, was there an auto-recall from the last invoice saved that would automatically bring onto the screen, price per, and item cost each from the last invoice or from the saved list.

Here is our answer:

The 'In-cell lookup' feature works for Invoice ID, Product ID and Customer ID only. And, reports are generated based on ID fields too. Currently our invoicing software does not support the in-cell lookup feature on item descriptions. One thing to note that is the invoicing program recalls product information only from the Product table. It cannot recall information from past invoices.

Screenshots

Tip: Enlarge an image by clicking on it.

Soccer Store Billing Format - printed document

This is how soccer shop invoice template will look like when you open it with Microsoft Excel.

Soccer Store Billing Format - Excel worksheet

The following Uniform Invoice Software version of Soccer Shop Invoice Template should be used with Uniform Invoice Software installed.

Soccer Store Billing Format - Uniform Invoice Software edition

Download Soccer Shop Invoice Template

Quick facts

  • Template#: cn-009

Download

Choose the format you like and download Soccer Shop Invoice Template for free by clicking the corresponding "Download" button.

FormatDownload
The Excel template integrated with Uniform Invoice SoftwareDownload
Soccer Shop Invoice Template (Soccer Store Billing Format) in PDF formatDownload
Soccer Shop Invoice Template and database in a self-extracting zip packageDownload
Soccer Shop Invoice Template, the Excel template (workbook) only (.xls or .xlsx)Download
The Excel template in zip packageDownload

Related Templates