How To Create A Sales Record In Excel

Keeping proper records of daily sales is important for every business, whether you run a small shop, sell products online or manage a growing company.

Writing sales information in a notebook can work when transactions are few. However, as the business grows, finding particular records, calculating sales and checking previous transactions can become difficult.

Microsoft Excel makes this process easier. With a simple spreadsheet, you can record the quantity of goods sold, customer names, addresses, dates and amounts paid. You can also calculate totals automatically as you enter new transactions.

If you are new to Excel, don’t worry. You do not need advanced computer knowledge to create a simple sales record. Follow the steps below.

What You Need

Before you begin, make sure you have:

A laptop or desktop computer.
Microsoft Excel installed on your computer.
Basic knowledge of how to use a mouse and keyboard.

Step 1: Open Microsoft Excel

Switch on your computer and open Microsoft Excel.

If you cannot find the application on your desktop, click the Windows Start button and type Excel in the search box. Select Microsoft Excel from the search results.

When Excel opens, select Blank Workbook to create a new spreadsheet.

Step 2: Understand the Excel Worksheet

A new Excel workbook contains a worksheet made up of small boxes called cells.

The cells are arranged in rows and columns. Columns are identified by letters such as A, B, C and D, while rows are identified by numbers such as 1, 2, 3 and 4.

Each cell has an address. For example, A1 refers to the cell in column A and row 1.

You will enter the headings for your sales record in the first row.

Step 3: Enter Your Sales Record Headings

For this tutorial, we will create a simple sales record containing the following information:

Click cell A1 and type Quantity.

Move to B1 and type Customer Name. Continue entering the remaining headings until you reach F1.

Your first row should now contain all six headings.

These headings will help you identify the information to enter for every transaction.

How To Create A Folder On Your Laptop: A Beginner’s Guide

Step 4: Enter Your Sales Information

After entering the headings, start recording your sales from row 2.

For example, your worksheet may look like this:

The figures above are only examples. You should enter the actual details of your transactions.

Click the appropriate cell and type the information. Press the Tab key to move to the next column, or use the arrow keys on your keyboard.

When you finish entering one transaction, move to the next row to record another sale.

Step 5: Make Your Headings Easy to Read

Your spreadsheet will look more organised if you format the headings.

To make the headings bold:

Select cells A1 to F1.
Go to the Home tab at the top of Excel.
Click the B icon for Bold.
You can also increase the font size or apply a background colour.

You may also need to adjust the column widths so that long headings such as Customer Address can be seen properly.

To do this, move your mouse to the line separating two column letters, such as A and B. When the cursor changes, drag the line to increase the width.

You can also double-click that line to automatically adjust the column width to fit its contents.

Step 6: Save Your Sales Record

Do not wait until you have entered many transactions before saving your work.

Press Ctrl + S on your keyboard.

If you are saving the workbook for the first time, Excel will ask you to choose a location and enter a file name.

You can name the file Daily Sales Record and save it in your Documents folder.

Excel will save the workbook as an Excel file, usually with the “.xlsx” extension.

Whenever you add new information, press Ctrl + S again to save your changes.

Why Use Excel for Sales Records?

Excel helps you keep business information organised in one place. It also makes it easier to review transactions, search for customer details and calculate sales figures.

As you become more familiar with the application, you can learn how to calculate total quantities, add up sales amounts, sort customer names and create simple reports.

These features can save time and reduce mistakes when handling business records.

Practise What You Have Learned

Open Excel on your computer and create a workbook called My First Sales Record.

Enter the six headings used in this tutorial:

Quantity
Customer Name
Customer Address
Sold By
Date
Amount

Next, enter at least five sample transactions. Save the workbook when you finish.

You have now created your first basic sales record in Microsoft Excel.

In the next lesson, we will explain how to calculate the total quantity and total amount in Excel automatically, so you do not have to add the figures manually every time.

Submit a Press Release | Advertise With Fresh News | Contact Us