{"id":4616,"date":"2016-04-21T22:54:21","date_gmt":"2016-04-21T22:54:21","guid":{"rendered":"http:\/\/www.learnexcelmacro.com\/wp\/?p=4616"},"modified":"2016-04-21T22:54:21","modified_gmt":"2016-04-21T22:54:21","slug":"free-invoice-template-for-small-businesses","status":"publish","type":"post","link":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/","title":{"rendered":"Invoice Template [ FREE Download ]"},"content":{"rendered":"
Hello friends,<\/p>\n
There are many small businesses which are using Excel for their day-to-day management. Like Generating invoice, quotation, tracking data about customers, sales, employees etc. In nutshell complete management is done in excel spreadsheets.<\/p>\n
I manage my articles, tools repository and excel assignments in excel spreadsheets too. I thought of sharing with you all the invoice template which I use it for myself.<\/p>\n
FREE Invoice Template in Excel<\/p><\/div>\n
By clicking on the button “Change logo” [Highlight-1 in picture] you can choose your own logo.<\/p>\n
Go to “Your Company Details” Sheet and provide the details of your own company. From here your details will be displayed on the Invoice sheet. Every field has got characters limit.<\/p>\n
Invoice template – Free<\/p><\/div>\n
This is a drop down field from where you can select your customer name and all other details like Address, email ID, phone etc. will automatically get updated based on what you have filled in “Customer details” sheet. Here you need to list all your customer details before using it.<\/p>\n
Invoice template – Free<\/p><\/div>\n
Fill all your product details in “Product Details” sheet. All your products will appear in drop down in the invoice sheet. As soon as you select a product name from the drop down Unit price will be displayed mentioned in your Product details sheet. There is a validation rule applied to make sure that you do not forget to enter quantity of a product. If you do not provide quantity of a product Column N will be marked as “X” for that particular row as shown in the picture. This is achieved by using conditional formatting in excel.<\/strong><\/a><\/p>\n Invoice template – Free<\/p><\/div>\n
\n
\nOn selecting a duplicate product in invoice, both the records will get highlighted and strikethrough as shown in the picture. This is achieved by using conditional formatting in excel.<\/strong><\/a><\/li>\nValidation Rules<\/h2>\n
Amount in Words<\/h2>\n