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.
This free printable Excel sheet offers a receipt template and invoice template for pet boarding and grooming, for businesses like cattery and dog daycare etc. It is able to show pet photo / image when the pet name is filled in.
For generic pet sitting service receipt, visit c5135 Pet Sitting Invoice Sample. The template c5135 was released on Sunday, January 21, 2018, at that time our Invoice Manager still didn't support showing image dynamically. Starting from version 7.11, a new Excel formula was introduced by Invoice Manager, which was "DisplayImage".
As explained at c4126 Image and Picture on Invoice, Quote and Purchase Order, the "DisplayImage" formula requires two argument -- the file name of the image, and the target range address where you want to show the image. The image file is loaded from Windows file system, but not the backend database system. This design makes it easy for you to store and organize photos and images.
The sample template shows the pet photo next to the "Bill To" section. The formula looks like this:
The $A$20 cell calculates full folder path of the current invoice. The "CONCATENATE" formula combines this path, the subfolder name "\dogs\", the customer ID, a hyphen, the I21 cell (which is the pet name, and the file extension ".jpg", to construct the full path name of the photo image file. So for example, if the receipt template is stored in the "c:\MyInvoices" folder, the customer ID is "c1001", and the dog name is "Apple", then the image that will be shown is "c:\MyInvoices\dogs\c1001-apple.jpg. See the screenshot to find out how it looks when the pet photo is displayed.
You can use the Excel template for free. However our invoicing program (i.e. "Invoice Manager for Excel") is not a freeware. The invoicing program is an Excel COM add-in program that runs inside Excel, connects the front-end Excel sheet with backend database (could be Access or SQL Server). It offers advanced features like automatic numbering, reporting etc. Feel free to download and try the fully functional trial version to find out how it is easy to create receipts with the help from our program.
The downloadable template includes 3 dog photos. Once you installed the IMFE edition of the downloadable package, try to enter one of the names "apple", "orange" or "banana" to see how the photo changes according to the pet name.
Format and Specification
|Name||Printable Receipt Template for Pet Boarding|
|Release Date||Tuesday, November 20, 2018|
|Format (XLS or XLSX)||.xlsx|
|Line Height (Points)||86.25|
|Papaer Size / Orientation||Portrait|
|Default Margins (Points)|
|Price||Free (0.00 USD)|
|System||Windows 7 and later, and Excel 2007 and later.|