Beverage Stocktake
To run a business that involves sale of a products such as beverage requires significant amount of knowledge and good understanding of the processes involved in generating profit from sales. The Beverage Stocktake template, offered on this page was created with consideration of entire process that begins with opening inventory count and ends with a final stock count at the end of a given period of time, which is determined by the requirements of your business. This spreadsheet offers comfort and familiar interface of Microsoft Excel that is pretty easy to use and does not require download of any additional software.
Cash Receipt templates is designed for a general use, which you can customize to meet your personal or business requirements.
All of our receipt templates have more than one on a page, so that you can print the receipt out, cut them and group them together as a receipt book.
We have designed both cash and rent receipts from scratch, which lets to use it with almost every major spreadsheet software with ability to open or import excel files. This spreadsheet is great for intended purpose, but if you need a different type of receipt, we have also created a sales receipt, which is a simple alternative to an invoice and sometimes can be used instead of one.
Printable Receipt Forms
If you do not wish to use the excel version, you may also download a PDF printable receipt form that is designed in the way that can repeat values, which means that a value entered in one of the receipts will automatically update others on the page. One disadvantage of this version is that it can't be customized.
If you do not have Microsoft Excel or any similar software installed on your computer, than you may want to try this printable sales receipt worksheets PDF to help when you need to provide your customers with a simple hand-written receipt. Unfortunately this version isn't customizable and it won't perform automatic calculations like the above one, but you could still use it as a simple receipt pad.
If you do not have Microsoft Excel or any similar software installed on your computer, than you may want to try this printable sales receipt worksheets PDF to help when you need to provide your customers with a simple hand-written receipt. Unfortunately this version isn't customizable and it won't perform automatic calculations like the above one, but you could still use it as a simple receipt pad.
Free Sales Invoice
for Excel®, OpenOffice & Google Docs
Sales Invoice Template for Excel is designed in four different colours, which can be changed by selecting an appropriate colour from the drop down menu and also in two different formats on the separate worksheets, which makes customization pretty easy when creating a custom invoice form for your business.
Download the template and customize it with your business name, business address and contact details then save your invoice as a template file (.xlt) in any folder of your choice on your computer.
Preparing new invoice for customers is really easy:
- open your saved template and update it with new customer details
- assign the invoice number
- save your file with the number of your invoice instead of name (eg. 000151.xls), this should make things easier when you need to look for it again.
Sending this invoice to a customer: ready invoice can be printed on the standard printer to be mailed or faxed to the customer or can also be printed as PDF with help of a PDF conversion software such as Adobe® Acrobat or similar, which if you have one of course, usually will show up as a printer in a Devices and Printers panel of your computer and then e-mailed to your customers.
by Alex Bejanishvili of Spreadsheet123.com
SI 1.01 (Trial)
Requirements
Microsoft Excel® 2002(XP) or Higher
License
User License Agreement
Help & Questions?
Contact Us
Support
Visit Support Page
Sales Invoice Pro
Professional Version SI1.21
Three Professional Sales Invoice templates, each of which can be customized to meet requirements of your business.
Content of the purchase:
Professional Invoice - unlocked version of our free sales invoice.
Invoice with Remittance - contains simple Remittance Slip, that is used as a reference.
Invoice with Products List - is exactly identical to Professional Invoice template except that it also contains a Products List. Products List can include a product code, short description and unit price.
All of Spreadsheet123 trademarks, logos, links and copyright notices are not included within any printing areas of the template and will not be shown when printed.
Specifications of the Commercial Version
- Unlocked
- Contains Fields for: Logo & Company info
- Ability to add more rows
- Technical Support (for 90 days)
- 3 Bonus Spreadsheet Included
SI 1.21
File Type
zip
File Size
~1.20 MB
Requirements
Microsoft Excel® 2002(XP) or Higher
(PC & Mac)
License
Company Use EULA
Bonus #1: Sales Invoice with Remittance
A modified version of the sales invoice that includes a remittance slip, which also performs all calculations automatically with inclusion of an outstanding balance, if payments are made partly.
See screenshot
Bonus #2: Invoice with Products List
Yet another modification that contains a Products List on the separate worksheet and can contain large quantity of products. This modification saves time on typing in your product description, product code and unit prices, instead it lets you select products in products/description column directly from the drop down menu and automatically updates cells with code and price.
See screenshot
Bonus #3: Sales Quote
Almost identical to the sales invoice, with few minor modifications that changed it in to a Sales Quote Template, which is suitable to use with our sales invoices.
See screenshot
Buy unlocked version of this Packing Slip Template risk free with 90 day full money-back guaranty!
Configure your browser to allow pop-ups before proceeding to payments screen.
If for any reason you are not able to download this template after making a payment through PayPal, use our Contact Us form to contact us with your Paypal Transaction ID.
Disclaimer - The pro forma invoice and information on this page is intended for educational an illustrative purposes only. Use information at your own risk. It is strongly advised to consult the appropriate authorities or seek for help of professionals prior to applying this template to you practise.
How to use this Sales Invoice?
Customizing template to your business.
Update all necessary fields with your company information.
1. Change all values in the square brackets [...] - values applicable to your company need to be replaced with your company information.
2. Company Logo - insert your company logo by going to your menu Insert > Picture > From File... (only available in unlocked version).
3. Company Name - Change it to the name of your company, this will also automatically change "Make all cheques payable to [Your Company Name]" field below.
4. Salesperson - Change it to the name of the person responsible (Eg. Sales Manager), this will also change the name of the contact person.
5. Tax Rate - Change the tax rate to the required rate.
6. Bank Account, Tax and Company Registration Details - In some countries it is a required by law to provide your company registration and tax and bank account details to the customer on every issued invoice. Unless it is required you can delete the entire section by selecting it with your mouse and hitting a delete button on you keyboard.
7. Cheque Payments - this field is automated and will therefore change automatically once you change the name of the company at the top of the invoice. If cheques required to be payable to any other than your company name, you can manually override the formula in this field. (only available in unlocked version).
8. Contact Information - Change your contact information (eg. Phone, Fax, e-mail, postal address).
9. Saving Template - Save the updated document as invoice_template.xlt file any preferred folder on your computer (Eg. My Documents > Invoices).
Preparing the Invoice for your customers.
Update all necessary fields with new customer information.
Date - the date will change to today's date automatically each time you open your document, but you can manually override the formula in this field to display the date of issue.
Invoice Number - assign the number to your invoice that must be unique for each new invoice, you can start by using 00001 for the first customer. You must save the invoice with the same name as the invoice number (eg. if invoice # is 00001 than the saved file name must be 00001.xls), this will help you to keep track of your invoices and makes searching for it way easier.
Customer ID - This cell is for unique customer number which will help to identify the customer and may contain full information about your customer (Eg. address, contact phone and fax number, e-mail).
Purchase Order Number -If your customers use a purchase order form to order and purchase your products, then you may want to specify the purchase order number on the invoice..
Bill To - Your customers name and address where the goods will be delivered and will also be used to issue the invoice.
Ship To - Name and address of alternative delivery location if different from Bill To address
Shipping Method - Here you can specify your courier service (Eg. DHL, UPS or other).
Shipping Terms - Here you can explain the terms of the shipping, it can be a discounted shipment term for goods over certain amount or similar.
Payment Terms and Due Date - here you should explain to your customer the terms of payment (eg. immediate payment or within 30 days of issue) and also the date when payment is due.
Description, Quantity and Unit Price - Provide a short description of the Product (Eg. Printing Paper), assign unit price (per one unit) and quantity ordered.
Printing and sending your Invoice.
You can print your saved invoices on the standard printer on an A4 format page in portrait or landscape depending on the format that you choose to use, then send it by standard mail service, but the much quicker way is to print it as PDF with help of a PDF conversion software like Adobe® Acrobat or similar, which if you have one of course, usually will be shown up as a separate printer in a Devices and Printers panel of your computer, and then emailed to a customer.
Invoice Related Frequently Asked Questions
Most of general question related to sales invoice can be found at Wikipedia.com, but I have also selected few questions asked by visitors answer to which is covered in my invoicing article, in fact I would recommend to read it through since I have shared few ideas that can help using this invoice, which you may also find useful.
- How to keep track or make log for my Invoices?
- What PDF Software can you recommend to convert my saved Invoices?
- How to find my Invoice Template .xlt file that I have created and saved?
- How can I add more rows in this template?
- How can I change the currency symbol in the cells?
If you don't see the question that bothers you in this list, you can just contact us.
Other Free Invoice Templates
- Basic Invoice Template by Spreadsheet123.
- Invoice Templates - on Microsoft Office Online.
- Service Invoice Template by Spreadsheet123.
- Pro Forma Invoice by Spreadsheet123.
More Related Templates by Spreadsheet123
Share Our Sales Invoice Template
If you did find this sales invoice useful and would like to share it with others on your blog, website, Facebook or Twitter, please use the HTML code below.
