Creating a sales receipt in Excel is a straightforward process that can help you manage your sales and finances efficiently. Whether you're running a small business or tracking personal expenses, a well-structured sales receipt can save you time and ensure accurate record-keeping. In this guide, we'll walk you through the steps to create a sales receipt in Excel, from setting up the template to adding essential details and formatting.

Import Receipts to Excel (+ other documents too!) - with Video Tutorial
Import Receipts to Excel (+ other documents too!) - with Video Tutorial

Before we dive into the process, ensure you have Microsoft Excel installed on your computer. For this guide, we'll use Excel 2016, but the steps are similar in other versions. Let's get started by creating a basic sales receipt template.

How to Create a Sales Receipt in QuickBooks Online
How to Create a Sales Receipt in QuickBooks Online

Setting Up the Sales Receipt Template

The first step in creating a sales receipt is setting up a template with the necessary columns and rows. A well-designed template will make the process of entering data quick and easy.

Best 7 Sales Receipt Templates - Excel Word Template
Best 7 Sales Receipt Templates - Excel Word Template

Open a new workbook in Excel and select the sheet where you want to create your sales receipt. In the first row (A1 to I1), enter the following headers:

  • Date (Column A)
  • Invoice Number (Column B)
  • Customer Name (Column C)
  • Item/Service (Column D)
  • Quantity (Column E)
  • Unit Price (Column F)
  • Total Price (Column G, use the formula =E2*F2 to calculate)
  • Tax Rate (Column H, you can use a percentage like 7% or 0.07)
  • Tax Amount (Column I, use the formula =G2*H2 to calculate)
Four Free Receipt Forms for Cash Payments
Four Free Receipt Forms for Cash Payments

Format the headers by filling the cells with a background color, such as light gray, and applying bold text. This will make the headers stand out and make the template easier to use.

Formatting the Sales Receipt

To make your sales receipt visually appealing and professional, apply some basic formatting. Start by adjusting the column widths to fit the content. You can do this by hovering over the line between two column headers until the double-headed arrow appears, then click and drag to resize the column.

Import Receipts to Excel (+ other documents too!) - with Video Tutorial
Import Receipts to Excel (+ other documents too!) - with Video Tutorial

Next, apply borders and shading to the cells. Select the range of cells containing the headers (A1:I1) and apply a border using the 'Borders' option in the 'Home' tab. Then, fill the cells with a light color, such as light gray, to make the headers stand out.

Adding Merge Cells and a Logo

To create a more polished look, you can add a logo and merge cells for the customer's address and other relevant information. In the row below the headers (A2), enter the customer's name and address. Then, select the cells containing this information (A2:I2) and merge them using the 'Merge & Center' option in the 'Home' tab.

Professional Customer Bill Receipt Template in Excel | Easy & Printable Format
Professional Customer Bill Receipt Template in Excel | Easy & Printable Format

To add a logo, insert a new row above the merged cells (insert a new row in A1) and click on the cell where you want the logo to appear (e.g., A1). Go to the 'Insert' tab and click on 'Pictures.' Select the logo file from your computer and click 'Insert.' Resize the logo as needed and position it in the cell.

Entering Sales Receipt Data

16+ Editable Excel Receipt Templates - Word Excel Fomats
16+ Editable Excel Receipt Templates - Word Excel Fomats
Download Free Invoice Template for Professional Receipts Today
Download Free Invoice Template for Professional Receipts Today
Invoice Template Word: Create Professional Receipts Easily | Download Free Now
Invoice Template Word: Create Professional Receipts Easily | Download Free Now
Have you ever wondered how to create a delivery tracker in Excel?
Have you ever wondered how to create a delivery tracker in Excel?
How to Create a Receipt in Excel | Techwalla
How to Create a Receipt in Excel | Techwalla
Sales Receipt Templates | Quickly Create Free Sales Receipts
Sales Receipt Templates | Quickly Create Free Sales Receipts
INVOICE RECIEPT
INVOICE RECIEPT
14 Free Receipt Templates - Download For Microsoft Word, Excel, And Google Sheets
14 Free Receipt Templates - Download For Microsoft Word, Excel, And Google Sheets
Sales Receipt Template Excel | Simple Business Receipt | Itemized Receipt Template | Small Business Invoice | Instant Download
Sales Receipt Template Excel | Simple Business Receipt | Itemized Receipt Template | Small Business Invoice | Instant Download
How to Create a Receipt in Excel | Techwalla
How to Create a Receipt in Excel | Techwalla
Sales Receipt Template | 13+ Free Word, Excel & PDF Formats, Samples, Examples, and Forms
Sales Receipt Template | 13+ Free Word, Excel & PDF Formats, Samples, Examples, and Forms
Blank Sales Receipt Template | Professional Invoice Excel | Instant Download Receipt Sheet
Blank Sales Receipt Template | Professional Invoice Excel | Instant Download Receipt Sheet
How to Create a Business Invoice in Excel - Tutorial
How to Create a Business Invoice in Excel - Tutorial
Sales Receipt Template in Word, Pages, PDF - Download | Template.net
Sales Receipt Template in Word, Pages, PDF - Download | Template.net
an invoice form for sales receipt is shown with the words sales receipt on it
an invoice form for sales receipt is shown with the words sales receipt on it
Software Sales Receipt Template | Automated Invoice Tracker | Excel & Google Sheets Billing Form
Software Sales Receipt Template | Automated Invoice Tracker | Excel & Google Sheets Billing Form
How to Make a Sales Tracker in Excel (Download Free Template)
How to Make a Sales Tracker in Excel (Download Free Template)
Free Private Car Sales Receipt Template Excel
Free Private Car Sales Receipt Template Excel
Receipt Template Excel, Printable Receipt, Google Sheets, Payment Receipt, Simple Receipt Form, Editable Invoice, Sales Receipt, Voucher - Etsy
Receipt Template Excel, Printable Receipt, Google Sheets, Payment Receipt, Simple Receipt Form, Editable Invoice, Sales Receipt, Voucher - Etsy
Sales Receipt Generator for Small Business | Sales Receipt Template with Excel Database | Automated Sales Receipt for Store and Reseller
Sales Receipt Generator for Small Business | Sales Receipt Template with Excel Database | Automated Sales Receipt for Store and Reseller

Now that you have a well-structured and formatted template, it's time to enter the sales receipt data. For each sale, enter the relevant information in the corresponding cells below the headers.

Here's an example of how the data should look:

Date Invoice Number Customer Name Item/Service Quantity Unit Price Total Price Tax Rate Tax Amount
01/15/2023 INV-001 John Doe Product A 2 $10.00 $20.00 7% $1.40
Product B 1 $15.00 $15.00
Subtotal $35.00
Tax $2.45
Total $37.45

Notice that the 'Total Price' and 'Tax Amount' columns automatically calculate the totals based on the formulas we entered earlier. After entering the data for each sale, you can add a subtotal, tax, and grand total row to summarize the receipt.

Creating a sales receipt in Excel is a simple and efficient way to manage your sales and finances. By following this guide, you can create a professional-looking sales receipt that will help you keep accurate records and streamline your business processes. Once you're comfortable with the process, you can customize the template to fit your specific needs and branding. Happy selling!