Skip to main content main content

How to Use

Assuming you have downloaded and installed Uniform Invoice Software:

  1. Download Pet Food Store Invoice. Double-click the downloaded file to extract all files.
  2. Open the template "pet-food-store.xlsx" or "pet-food-store-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.

Pet Food Store Invoice

Pet Food Store Invoice (c3013)

c3013 now includes the customized invoice template for the latest version of Uniform Invoice Software. This is what you will see when you open pet-food-store-uis.xlsx.

Pet Food Store Invoice (UIS Edition)

Pet Food Store Invoice - UIS edition

Download Pet Food Store Invoice (c3013)

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.


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

252 KBDownload

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

2.80 MBDownload


If you are running a pet food store or shop then this invoice template could be used for easy invoicing. The invoice format is printable on standard A5 paper size (148 mm X 210 mm, or 5.83 inch X 8.27 inch). A PDF version of the invoice template is also included and downloadable.

Here on we've already published some tutorials on customizing invoice templates regarding changing paper sizes, like Simple Invoice Template - Changing Paper Size. While many billing forms here on are suitable for printing on A4 paper (210 mm X 297 mm, or 8.27 inch X 11.69 inch) or letter (8.5 inch X 11 inch), with this Pet Food Store Invoice Template we've implemented another sample of changing paper size.

If you are running a store for selling pet (dog, cat etc.) food, or providing pet sitting service (also visit Veterinary Invoice Template), whether retail or wholesale, you can try this invoicing format. Unlike the default sales invoice template shipped with Uniform Invoice Software, with this customization, we've simplified the fields on the "Bill To" section - it now contains only two fields - Customer Name and Phone. The other fields, like customer's address, city state and zip (in U.S. format) are still there but placed outside the printable area (the area defined by the Print_Area Excel name, which is the area to print when you issue the Print command in Excel, or click the Print command in Uniform Invoice Software). If you need to move these cells back into the "Bill To" section, visit the tutorial and detailed sample at Simple Template - Moving Shipping Address.

Although we categorize this template as sales invoice template, it does not contains shipping address fields. You can add these fields back, or email us for help.

With this implementation we've removed the "taxable" options from the invoice body, assuming all items are taxable (i.e. the Excel formula for calculating the tax amount is something like "=ROUND(oknSubTotal*oknTax1Rate,2)"). Another noticeable feature of this invoicing template for pet food store is that we've added an additional "tax state name" option, which is changeable from invoice to invoice (Or, do you like a tax-rate fixed version of this template? We'll publish it soon). The "tax state name" is implemented as a drop down list before the "tax rate" field. When creating an invoice with Uniform Invoice Software installed, you first click the "Clear & New" to have the default cells values populated, like "invoice date" and "payment term" etc. And then, you fill in customer/client information (or pick an existing one using the on-sheet picker button). With this template, you have another option to choose - the tax state name. By default, the template has these state name listed: MD, VA, DE, NJ, PA, NY, CT, RI, MA, NH and VT, and their corresponding tax rate filled on the next column (see the section $O3:$P13) (visit State Tax Rates - Federation of Tax Administrators for the most recent rate list).

In the tax rate cell, we use an Excel formula "=IF(oknTaxStateName="",0,VLOOKUP(oknTaxStateName,O3:P13,2,FALSE))" to fill the correct rate value according to the state name you choose from the drop-down list. This is one of the great samples that shows the flexibility of Excel invoicing templates. While it is possible to generate professional looking invoices using templates in other formats, like Microsoft Word (doc or docx), HTML + CSS, PDF, or even Adobe Photoshop, or online invoice templates, Uniform Invoice Software combined with Microsoft Excel creates a level of flexibility that other invoicing software could hardly implement.

The "Tax State Name" on this template is implemented as a custom field.

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. Pet Food Store Invoice 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 Pet Food Store Invoice 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, that are one freeware edition, and another edition that works only with our invoicing software installed.

Adding a custom field to the "InvHdr" table in the database makes it possible to save the field value to database along with the other data of an invoice record. For example, adding the custom field Company Name to the "InvHdr" database table allows you to save the company name of a customer to the database when you save an invoice. If you use Uniform Invoice Software version template Pet Food Store Invoice and add the custom field, the value is saved from or retrieved to Pet Food Store Invoice whenever you save or reload an invoice record.

Like other form designs here on, Pet Food Shop Invoicing 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

NamePet Food Store Invoice
CategorySales Invoice Template
Release DateSunday, May 15, 2016
Format (XLS or XLSX).xlsx
Excel Version Excel 2003 / Excel 2007 / Excel 2010 / Excel 2013 / Excel 2016
Feature Gallery
Line Height (Points)15.75
Print Area$F$3:$L$31
Printable with Papaer Size / OrientationA5 (148 mm x 210 mm) - Portrait
Default Margins (Points)

Sample Templates