{"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

You can download your FREE copy from here.<\/strong><\/a><\/h2>\n
\"Invoice

FREE Invoice Template in Excel<\/p><\/div>\n

Highlights and Steps to configure it for yourself: <\/h2>\n

Company Logo <\/h2>\n

By clicking on the button “Change logo” [Highlight-1 in picture] you can choose your own logo.<\/p>\n

Your own company details <\/h2>\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

Invoice template – Free<\/p><\/div>\n

Customer details <\/h2>\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

Invoice template – Free<\/p><\/div>\n

Product Details<\/h2>\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.
\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>\n

Validation Rules<\/h2>\n

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

Invoice template – Free<\/p><\/div>\n

Amount in Words<\/h2>\n

Total Amount in Invoice will also get converted in text by using Excel VBA function to convert currency in word. You can change it from Rupees to Dollar or any other currency you would like to.<\/strong><\/a>
\n

\"Invoice

Invoice template – Free<\/p><\/div><\/p>\n

Print and Generate PDF command <\/h2>\n

On top of the invoice you can find two buttons “PRINT” and “PDF”. By clicking on them you can print or generate pdf of the invoice accordingly.
\nNote: Generated invoice will not have un-necessary information which you see in the excel sheet like “Instruction” box, Any of these buttons like “Print”, “PDF”, “Change Logo” etc. So do not worry about them :).<\/p>\n

Instructions <\/h2>\n

Instructions are mentioned in the Invoice sheet. You can refer it any time you want.
\n

\"invoice-instructions\"

invoice-instructions<\/p><\/div><\/p>\n

Download your FREE Invoice Template in Excel<\/a><\/h3>\n<\/span>","protected":false},"excerpt":{"rendered":"

Hello friends, 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. I manage my articles, tools repository and excel assignments in excel spreadsheets too. I thought of sharing with you all […]<\/p>\n","protected":false},"author":45,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[1246,1679,1675,1676,1682],"tags":[],"class_list":["post-4616","post","type-post","status-publish","format-standard","hentry","category-macro","category-excel-macro-beginner","category-excel-macro-for-beginners","category-excel-tips","category-popular-articles"],"yoast_head":"\nFREE Download - Automated Invoice Template in Excel<\/title>\n<meta name=\"description\" content=\"Download your free Invoice template for your company and start generating invoices automatically by clicking on a button. Best invoice template for small business.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Invoice Template [ FREE Download ]\" \/>\n<meta property=\"og:description\" content=\"Download your free Invoice template for your company and start generating invoices automatically by clicking on a button. Best invoice template for small business.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\" \/>\n<meta property=\"og:site_name\" content=\"Let's excel in Excel\" \/>\n<meta property=\"article:publisher\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:author\" content=\"http:\/\/www.facebook.com\/vmlogger\" \/>\n<meta property=\"article:published_time\" content=\"2016-04-21T22:54:21+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png\" \/>\n<meta name=\"author\" content=\"Vishwamitra Mishra\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/www.twitter.com\/learnexcelmacro\" \/>\n<meta name=\"twitter:site\" content=\"@learnexcelmacro\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vishwamitra Mishra\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\"},\"author\":{\"name\":\"Vishwamitra Mishra\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"headline\":\"Invoice Template [ FREE Download ]\",\"datePublished\":\"2016-04-21T22:54:21+00:00\",\"dateModified\":\"2016-04-21T22:54:21+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\"},\"wordCount\":513,\"commentCount\":23,\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png\",\"articleSection\":[\"Excel Macro\",\"Excel Macro Beginner\",\"Excel Macro Tutorial\",\"Excel Tips\",\"Popular Articles\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\",\"name\":\"FREE Download - Automated Invoice Template in Excel\",\"isPartOf\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png\",\"datePublished\":\"2016-04-21T22:54:21+00:00\",\"dateModified\":\"2016-04-21T22:54:21+00:00\",\"description\":\"Download your free Invoice template for your company and start generating invoices automatically by clicking on a button. Best invoice template for small business.\",\"breadcrumb\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/vmlogger.com\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Excel Macro\",\"item\":\"https:\/\/vmlogger.com\/excel\/macro\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Invoice Template [ FREE Download ]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#website\",\"url\":\"https:\/\/vmlogger.com\/excel\/\",\"name\":\"Let's excel in Excel\",\"description\":\"Let's share knowledge\",\"publisher\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/vmlogger.com\/excel\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5\",\"name\":\"Vishwamitra Mishra\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"contentUrl\":\"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png\",\"width\":528,\"height\":560,\"caption\":\"Vishwamitra Mishra\"},\"logo\":{\"@id\":\"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/\"},\"description\":\"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.\",\"sameAs\":[\"http:\/\/www.learnexcelmacro.com\",\"http:\/\/www.facebook.com\/vmlogger\",\"https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro\",\"https:\/\/www.youtube.com\/c\/VMLogger\"],\"url\":\"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"FREE Download - Automated Invoice Template in Excel","description":"Download your free Invoice template for your company and start generating invoices automatically by clicking on a button. Best invoice template for small business.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/","og_locale":"en_US","og_type":"article","og_title":"Invoice Template [ FREE Download ]","og_description":"Download your free Invoice template for your company and start generating invoices automatically by clicking on a button. Best invoice template for small business.","og_url":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/","og_site_name":"Let's excel in Excel","article_publisher":"http:\/\/www.facebook.com\/vmlogger","article_author":"http:\/\/www.facebook.com\/vmlogger","article_published_time":"2016-04-21T22:54:21+00:00","og_image":[{"url":"http:\/\/learnexcelmacro.com\/wp\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png"}],"author":"Vishwamitra Mishra","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/www.twitter.com\/learnexcelmacro","twitter_site":"@learnexcelmacro","twitter_misc":{"Written by":"Vishwamitra Mishra","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#article","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/"},"author":{"name":"Vishwamitra Mishra","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"headline":"Invoice Template [ FREE Download ]","datePublished":"2016-04-21T22:54:21+00:00","dateModified":"2016-04-21T22:54:21+00:00","mainEntityOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/"},"wordCount":513,"commentCount":23,"publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png","articleSection":["Excel Macro","Excel Macro Beginner","Excel Macro Tutorial","Excel Tips","Popular Articles"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/","url":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/","name":"FREE Download - Automated Invoice Template in Excel","isPartOf":{"@id":"https:\/\/vmlogger.com\/excel\/#website"},"primaryImageOfPage":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage"},"image":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage"},"thumbnailUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png","datePublished":"2016-04-21T22:54:21+00:00","dateModified":"2016-04-21T22:54:21+00:00","description":"Download your free Invoice template for your company and start generating invoices automatically by clicking on a button. Best invoice template for small business.","breadcrumb":{"@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#primaryimage","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2016\/04\/invoice.png"},{"@type":"BreadcrumbList","@id":"https:\/\/vmlogger.com\/excel\/2016\/04\/free-invoice-template-for-small-businesses\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/vmlogger.com\/excel\/"},{"@type":"ListItem","position":2,"name":"Excel Macro","item":"https:\/\/vmlogger.com\/excel\/macro\/"},{"@type":"ListItem","position":3,"name":"Invoice Template [ FREE Download ]"}]},{"@type":"WebSite","@id":"https:\/\/vmlogger.com\/excel\/#website","url":"https:\/\/vmlogger.com\/excel\/","name":"Let's excel in Excel","description":"Let's share knowledge","publisher":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/vmlogger.com\/excel\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/7500a107b0b2d35a8492acf0d11fc8e5","name":"Vishwamitra Mishra","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/","url":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","contentUrl":"https:\/\/vmlogger.com\/excel\/wp-content\/uploads\/sites\/11\/2022\/07\/avataaars-1.png","width":528,"height":560,"caption":"Vishwamitra Mishra"},"logo":{"@id":"https:\/\/vmlogger.com\/excel\/#\/schema\/person\/image\/"},"description":"My name is Vishwamitra Mishra. Friends Call me Vishwa. I hold a Bachelor\u2019s Degree in Computer Science from D.A.V.V. Indore & currently working as a Technical Lead having over 7 years of experience.","sameAs":["http:\/\/www.learnexcelmacro.com","http:\/\/www.facebook.com\/vmlogger","https:\/\/x.com\/https:\/\/www.twitter.com\/learnexcelmacro","https:\/\/www.youtube.com\/c\/VMLogger"],"url":"https:\/\/vmlogger.com\/excel\/author\/vishwamitra\/"}]}},"_links":{"self":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4616"}],"collection":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/users\/45"}],"replies":[{"embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/comments?post=4616"}],"version-history":[{"count":0,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/posts\/4616\/revisions"}],"wp:attachment":[{"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/media?parent=4616"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/categories?post=4616"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/vmlogger.com\/excel\/wp-json\/wp\/v2\/tags?post=4616"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}