Скачать или смотреть Free Invoice Template - How to Create Sales Invoices using Excel Template?

Download this Free Sales Invoice Template and create invoices easily in Excel for your small business selling products.
https://indzara.com/2016/07/free-exce...

You can create unlimited invoices and manage them all in one file. You can save time by storing your products and customers once and re-using them for invoices whenever needed.

FEATURES:
Create professional sales invoices for your small business instantly
Customize it to your need
Customize customer data that appears on the invoice
Change columns (2 columns are flexible) in invoice
Discounts can be set as amounts or %
Logo and other formats like colors or fonts can be changed as preferred
Currency can be set easily to suit your business need
Automatically calculate totals and subtotals
Handles tax rates at order level
Accommodates products that are not taxable
Handles discounts at product and order levels
Save time by storing customer and product data

For more Small Business Excel Templates, please visit https://indzara.com/small-business-ex...


Requirements:
Microsoft Excel for Windows (2010 and above)
Microsoft Excel for Mac (2011 and above)

If you are running a small business where you are selling products to our customers, most likely you would have the need to create invoices and send them to your customers about the orders that you receive and fulfilled your customers. So, use this free excel template to create professional-looking invoices and you can use this one template to create any number of invoices and then store and manage them very very easily.

In this video we are going to see the different features of this template andalso how you can easily create sales invoices for your small business veryvery quickly.
This is the settings sheet in our excel template where we have some instructions on how to initially setthis up for our small business and also how we can create invoices in an ongoing basis now the business information is where we begin by entering the details about our business and this will be used to populate the invoice later.
Now in the product sheet we will enter the lists of our products have already entered about 10 products here. Basic information such as product ID or number and then the name of the product, description, price of the product and then unit of measurement and whether the product is taxable or not. If it is not taxable just say no if it is taxable just leave it blank.

Then we go to the customer sheet where we have the list of our customers specifically the customer ID and then the key here isthe customer name which would be unique and then the shipping address billingaddress contact information and similarly you can add more columns orIranian the custom field to store information about your customers.

The invoice sheet is where we will be customizing how the invoice would look so that it matches ourspecific small business brand.
So first we will do is to use the change picture option to change the logo image to choose a logo for your small business.

We can see whether the customer data here that is displayed is the way you would want to invoice to look.
If i choose my customer here you will see that the shipping address comes at the top and the billing address and all these contact information and you get all these fields are customizable so that you can decide which order you want them to appear or if you don't want something to appear just hit delete.

If you like this template please share and if you have any questions about how this template works are whether you have any suggestions to improve the featuresplease leave them in the comments. I look forward to your feedback. Please subscribe to the channel if you find these templates helpful. Thank you very much for watching this video.


Simple and Effective Excel Templates: http://indzara.com/
Free Excel Templates: http://indzara.com/free-excel-templates/
Premium Excel Templates: http://indzara.com/shop/
Small Business Management Templates: http://indzara.com/small-business-exc...
Project Management Templates: http://indzara.com/project-management...
HR Templates: http://indzara.com/hr-excel-templates/
Free Excel Course: http://indzara.com/useful-excel-for-b...

Social:
Subscribe to YouTube: http://www.youtube.com/user/theindzar...
Facebook:   / theindzara  
YouTube:    / theindzara  
LinkedIn:   / indzara  
Twitter:    / theindzara  

~-~~-~~~-~~-~
Please watch my latest video: "Highlight events, weekends and holidays on calendar in Excel"    • Highlight events, weekends and holidays on...  
~-~~-~~~-~~-~