How to create simple invoices in Excel

Invoicing in Excel is not difficult. Follow the instructions below to create an invoice and be ready to send it to the receiving customer.

Whether you are a freelancer working for many companies or a business that plans to extend credit limits to customers, you will need an invoice. Invoicing in Excel is not difficult. Follow the instructions below to create an invoice and be ready to send it to the receiving customer.

  1. Summary of expensive shortcuts in Microsoft Excel
  2. These are the most basic functions in Excel that you need to understand
  3. 10 ways to recover corrupted Excel files

Use invoice templates in Excel

Creating an invoice in Excel is relatively simple. You just need to create a few tables, set up some rules, add information and that's it. In addition, there are many websites online that provide free invoice forms created by accountants. You can use these forms or even based on that form and create your own invoice form.

Excel also provides a bill template library for users to use. To access these templates, open Excel and click the File tab.

How to create simple invoices in Excel Picture 1How to create simple invoices in Excel Picture 1

Here select New and type Invoice in the search bar.

How to create simple invoices in Excel Picture 2How to create simple invoices in Excel Picture 2

Press Enter and you will see invoice forms.

How to create simple invoices in Excel Picture 3How to create simple invoices in Excel Picture 3

Find the invoice form you like.

Create simple invoices in Excel

To create a simple invoice in Excel, you first need to know some of the required information in the invoice. For simplicity, we will only use the information we need to receive payment. Here is the basic information:

  1. Seller information:
    1. Name
    2. Address
    3. phone number
  2. Buyer information
    1. Company name
    2. Address
  3. Date of invoice
  4. Some bills
  5. Description of goods (service or product sold)
  6. Commodity price (of each product or service)
  7. total payment amount
  8. Payment methods

First, open an empty Excel sheet. Remove the grid lines to create an empty Excel sheet. To remove gridlines, go to the View tab and uncheck Gridlines in the Show section.

How to create simple invoices in Excel Picture 4How to create simple invoices in Excel Picture 4

Now adjust the column and row sizes to add space for long information like description of goods. To change the row or column size, click on the drag.

How to create simple invoices in Excel Picture 5How to create simple invoices in Excel Picture 5

By default, the rows are set to a height of 20 pixels and a width of 64 pixels. Here is an example of the width and height you can refer to.

Items:

  1. Row 1: 45 pixels

Columns:

  1. Column A: 385 pixels
  2. Column B: 175 pixels
  3. Column C: 125 pixels

Row 1 will have your name and from Invoice . In order for the recipient to see this information immediately, you should increase the font size for this information.

Column A contains most of the important information in the invoice, including information on buyers, sellers, description of goods, payment methods. Column B contains the specific date of the listed goods, the date of the invoice, the price of each item and the total value. This information is not long, so it does not require much space.

After adjusting the column and row sizes, we will fill in the invoice information. In column A, row 1, enter your name. You should leave the font a bit bigger (18pt) and bold to highlight it.

How to create simple invoices in Excel Picture 6How to create simple invoices in Excel Picture 6

In column B, row 1, type Invoice so that viewers can see clearly what this document is. You should set the font size to about 38pt and capitalize, for lighter colors if desired.

How to create simple invoices in Excel Picture 7How to create simple invoices in Excel Picture 7

In column A, rows 4, 5 and 6, enter your address and phone number.

How to create simple invoices in Excel Picture 8How to create simple invoices in Excel Picture 8

In column B, rows 4 and 5, type DATE and INVOICE , highlight and align right. Columns C 4 and 5 are used to enter the date and invoice number.

How to create simple invoices in Excel Picture 9How to create simple invoices in Excel Picture 9

Finally, enter the Bill to (the super buyer) in column A, row 8. Below the row 9, 10, 11 is the buyer information.

How to create simple invoices in Excel Picture 10How to create simple invoices in Excel Picture 10

Now we need to set up a table to list the goods sold, fulfillment date (the date begins when the goods are entered into the warehouse until the buyer receives the product), the amount of each item.

First, merge columns A and B in row 14 as the title for the listed items (column A, row 15-30) and fulfillment date (column B, row 15-30). After you have merged columns A and B in row 14, create a frame for the column by going to the Font section of the Home tab, selecting the outline icon and choosing the desired border type. Here we will use All Borders .

How to create simple invoices in Excel Picture 11How to create simple invoices in Excel Picture 11

Do the same for cell C14. You can color the cells if you want by selecting the cells you want to color, select the arrow next to the Fill Color icon in the Font section of the Home tab and select the color from the drop-down menu.

How to create simple invoices in Excel Picture 12How to create simple invoices in Excel Picture 12

In the first colored cell, enter DESCRIPTION (Description of goods) and center it, highlight. For cell C14, type AMOUNT and make the center, bold.

How to create simple invoices in Excel Picture 13How to create simple invoices in Excel Picture 13

You need to make sure the table has enough space to list the goods sold. In this example we will use 16 rows. Then, go to the bottom of the table and draw the bottom border for the first two boxes in the row.

How to create simple invoices in Excel Picture 14How to create simple invoices in Excel Picture 14

Now highlight the boxes C15-29 and the left and right borders for these cells.

How to create simple invoices in Excel Picture 15How to create simple invoices in Excel Picture 15

Now, select cell C30 and the contour left, right and bottom. Finally, we will add Total Sum to the table. Highlight cell C31 and draw the border around the entire cell. You can apply color if you want and remember to put TOTAL in the box next to it.

How to create simple invoices in Excel Picture 16How to create simple invoices in Excel Picture 16

We basically completed the goods description, now add some rules and formulas to calculate.

As we have set above, column B row 15-30 is the fulfillment date. Select these boxes, click Format Number in the Number section of the Home tab.

How to create simple invoices in Excel Picture 17How to create simple invoices in Excel Picture 17

After selecting, a drop-down menu will appear, select the Short Date option. Now if you enter the example number 12/26 in these cells, it will automatically reformat.

How to create simple invoices in Excel Picture 18How to create simple invoices in Excel Picture 18

Similarly, if you highlight cells C15-30, these are cells into money, select the Currency option and enter the amount in these boxes, it will be formatted in currency.

How to create simple invoices in Excel Picture 19How to create simple invoices in Excel Picture 19

To automatically calculate the total amount, select the sum cell (in this example, C31) and enter the following formula:

 = SUM (C15: C30) 

How to create simple invoices in Excel Picture 20How to create simple invoices in Excel Picture 20

Now if you enter (or delete) any number in the cells into separate amounts, it will automatically fill in the totals cell.

  1. How to use the SUM function to calculate totals in Excel

How to create simple invoices in Excel Picture 21How to create simple invoices in Excel Picture 21

Continue, enter the Method of Payment in A34.

How to create simple invoices in Excel Picture 22How to create simple invoices in Excel Picture 22

This information should be placed between buyers and sellers. The usual payment methods are cash, check and bank transfer. Now complete the invoice, do not forget to thank your customers.

How to create simple invoices in Excel Picture 23How to create simple invoices in Excel Picture 23

So we have completed a simple bill. I wish you all success!

5 ★ | 1 Vote