Screenshots and Images
The printed version.
Open the template in Excel.
You are safe to download the resources. We've added our digital signatures to the files.
Download this if you have already installed the Microsoft Store edition of Invoice Manager for Excel, and are looking for additional customized templates.
Download this if you want this design to be set as the default template by the installer program.
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 InvoicingTemplate.com 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 InvoicingTemplate.com 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 Invoice Manager for Excel, 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 Invoice Manager for Excel). 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 Invoice Manager for Excel 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, Invoice Manager for Excel 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.
Format and Specification
|Name||Pet Food Store Invoice|
|Category||Sales Invoice Template|
|Release Date||Sunday, May 15, 2016|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||15.75|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|