Creating Invoices on Excel

Updated on February 22, 2017

How to create an Invoice on Microsoft Excel

If you run a business you understand the importance of Invoicing. Without an invoice, you’re not going to get paid. Small firms often do not have dedicated software that allows you to do all your accounting including the creation of Invoices, so often they turn to manual invoicing.

The problem with manual invoicing is that it’s very easy to make very simple mathematical mistakes that not only could result in you being underpaid, but also could result in you losing some reputation and goodwill.

Creating an invoice in Excel therefore not only ensures that the invoice is accurate, but it also ensures that your company looks professional. While it may not get you paid any quicker, at least you know that when you are paid, you will be paid the right amount.

There are a couple of ways to create invoices on Microsoft Excel; the easiest way is to use a pre-defined invoice template and simply amend it to your needs. You’ll need the relevant information about the transaction such as the purchaser, the date, the sales information and any tax information required, but once you’ve setup one invoice, you can edit it and re-use it going forward.

This article will show you how to customize a template on Microsoft Excel to create a standard invoice for your company.


Click thumbnail to view full-size
Select the category for the type of template you want to use - in this case select Invoice.Double click on the template of choice.
Select the category for the type of template you want to use - in this case select Invoice.
Select the category for the type of template you want to use - in this case select Invoice. | Source
Double click on the template of choice.
Double click on the template of choice. | Source

Finding an Invoice Template on Microsoft Excel

MIcrosoft Excel has hundreds of templates that you can customize to suit your needs. Tou use them is simple:

  • Open Microsoft Excel (the following instructions are created using Microsoft Excel 2010, but can also be used in Microsoft Excel 2007)
  • Select File New - this opens a new blank worksheet normally, but in this case I am going to select a template to use.
  • Choose the category of templates - in this case I chose Invoices and then chose Sales Invoices
  • Double click on the template you wish to use - I double clicked on the template called Template.

The final customized template - this can be used as a pro-forma for all Invoices.
The final customized template - this can be used as a pro-forma for all Invoices. | Source

Customizing the Microsoft Excel Template

I've chosen an invoice template that will calculate an amount per item base on the quantity and the cost per item. Additionally the template will calculate an overall total and add tax.

Rather than having to enter all my own details every time I want to send out an invoice, I am going to customize the template and save it as a personal template invoice that I can use at any time. The technique is very simple and doesn't require any advanced techniques - the hard work has already been done for you (The instructions below assume you have loaded the same template as I have, however, generally the method will be the same for all templates):

  • Replace 'Your Company, Inc.' with your company name.
  • Replace the Address and telephone number with your information.
  • Change the Sales Tax Rate to the appropriate rate
  • Add some generic descriptions for standard products you normally sell and enter the correct Unit Price - this will save time when you start invoicing customers; you can always remove any items you don't require at any time)
  • Amend the 'Direct all inquires' and "Make all Checks Payable' sections as appropriate
  • If required, change the Thank You message.

You can now save this as a personal template invoice. At this stage the Invoice Details, freight information etc. are irrelevant.


The final invoice edited with sales information, customer information etc. You can now send this to your customer and get paid.
The final invoice edited with sales information, customer information etc. You can now send this to your customer and get paid. | Source

Sending Out your first Invoice

Now that you've created your personal template invoice you're ready to create your first invoice. Again, this is very simple and requires you to edit a few cells on the worksheet template you previously created. To create the invoice change the template as follows:

  • Edit the 'Sold to' section and insert your customers information.
  • If different, add a Shipped To address
  • Amend the Sales Tax Rate as appropriate
  • Change the quantity, description and Unit Price as appropriate
  • Amend the Invoice Number, Invoice Date, Our/Your Order Number, Terms, Sales Rep, Shipped Via, F.O.B., Prepaid or Collect sections as appropriate.

You now have created your invoice and can save it with a suitable name.

Conclusion

Making Invoices using Microsoft Excel is very easy and can save you a lot of work and perhaps more importantly ensure that the invoice is calculated correctly and looks professional. Some of the more advanced invoice templates on Excel allow you to add your company logo and perform more complex calculations.

Questions & Answers

    Comments

      0 of 8192 characters used
      Post Comment

      • Just Ask Susan profile image

        Susan Zutautas 5 years ago from Ontario, Canada

        I used to use access all the time for invoicing but I find excel much easier to get around in.

      working

      This website uses cookies

      As a user in the EEA, your approval is needed on a few things. To provide a better website experience, hubpages.com uses cookies (and other similar technologies) and may collect, process, and share personal data. Please choose which areas of our service you consent to our doing so.

      For more information on managing or withdrawing consents and how we handle data, visit our Privacy Policy at: "https://turbofuture.com/privacy-policy#gdpr"

      Show Details
      Necessary
      HubPages Device IDThis is used to identify particular browsers or devices when the access the service, and is used for security reasons.
      LoginThis is necessary to sign in to the HubPages Service.
      Google RecaptchaThis is used to prevent bots and spam. (Privacy Policy)
      AkismetThis is used to detect comment spam. (Privacy Policy)
      HubPages Google AnalyticsThis is used to provide data on traffic to our website, all personally identifyable data is anonymized. (Privacy Policy)
      HubPages Traffic PixelThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized.
      Amazon Web ServicesThis is used to collect data on traffic to articles and other pages on our site. Unless you are signed in to a HubPages account, all personally identifiable information is anonymized. (Privacy Policy)
      CloudflareThis is used to quickly and efficiently deliver files such as javascript, cascading style sheets, images, and videos. (Privacy Policy)
      Google Hosted LibrariesJavascript software libraries such as jQuery are loaded at endpoints on the googleapis.com or gstatic.com domains, for performance and efficiency reasons. (Privacy Policy)
      Facebook LoginYou can use this to streamline signing up for, or signing in to your Hubpages account. No data is shared with Facebook unless you engage with this feature. (Privacy Policy)
      PaypalThis is used for a registered author who enrolls in the HubPages Earnings program and requests to be paid via PayPal. No data is shared with Paypal unless you engage with this feature. (Privacy Policy)
      Google AdSense Host APIThis service allows you to sign up for or associate a Google AdSense account with HubPages, so that you can earn money from ads on your articles. No data is shared unless you engage with this feature. (Privacy Policy)
      Features
      Google Custom SearchThis is feature allows you to search the site. (Privacy Policy)
      Google MapsSome articles have Google Maps embedded in them. (Privacy Policy)
      Google ChartsThis is used to display charts and graphs on articles and the author center. (Privacy Policy)
      Google YouTubeSome articles have YouTube videos embedded in them. (Privacy Policy)
      VimeoSome articles have Vimeo videos embedded in them. (Privacy Policy)
      MavenThis supports the Maven widget and search functionality. (Privacy Policy)
      Marketing
      Google AdSenseThis is an ad network. (Privacy Policy)
      Google DoubleClickGoogle provides ad serving technology and runs an ad network. (Privacy Policy)
      Index ExchangeThis is an ad network. (Privacy Policy)
      SovrnThis is an ad network. (Privacy Policy)
      Facebook AdsThis is an ad network. (Privacy Policy)
      Amazon Unified Ad MarketplaceThis is an ad network. (Privacy Policy)
      AppNexusThis is an ad network. (Privacy Policy)
      OpenxThis is an ad network. (Privacy Policy)
      Rubicon ProjectThis is an ad network. (Privacy Policy)
      TripleLiftThis is an ad network. (Privacy Policy)
      Say MediaWe partner with Say Media to deliver ad campaigns on our sites. (Privacy Policy)
      Remarketing PixelsWe may use remarketing pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to advertise the HubPages Service to people that have visited our sites.
      Conversion Tracking PixelsWe may use conversion tracking pixels from advertising networks such as Google AdWords, Bing Ads, and Facebook in order to identify when an advertisements has successfully resulted in the desired action, such as signing up for the HubPages Service or publishing an article on the HubPages Service.
      Statistics
      Author Google AnalyticsThis is used to provide traffic data and reports to the authors of articles on the HubPages Service. (Privacy Policy)
      ComscoreComScore is a media measurement and analytics company providing marketing data and analytics to enterprises, media and advertising agencies, and publishers. Non-consent will result in ComScore only processing obfuscated personal data. (Privacy Policy)
      Amazon Tracking PixelSome articles display amazon products as part of the Amazon Affiliate program, this pixel provides traffic statistics for those products (Privacy Policy)