✦Template Printable Ideas Insights

Create Payment Receipt in Excel: Step-by-Step Guide

By

Keeping track of finances can be a daunting task, and for many, the Manual record keeping process can be erroneous and time-consuming. Fortunately, with Microsoft Excel, you can streamline the process of creating receipts of payments, reducing errors and saving you time. By following this comprehensive guide, you'll be able to create receipts of payments in Excel with ease.

Before we get started, ensure that you're familiar with basic Excel operations such as opening a new workbook, navigating cells, and entering data. Let's delve into the steps to create a receipt of payment in Excel, making the process as straightforward as possible.

The Basic Setup: Header and Layout

Excel receipts, much like paper receipts, need a clean, organized appearance. Let's start by setting up the basic layout and header for your receipt.

receipts to excel with the text receipt in green and white on top of it, next to an image of a calculator
receipts to excel with the text receipt in green and white on top of it, next to an image of a calculator
Four Free Receipt Forms for Cash Payments
Four Free Receipt Forms for Cash Payments
how to keep track of customer payments in excel
how to keep track of customer payments in excel

1. **Fetch Receipt Header**: Insert a new row at the top (Row 1) and make it the header. Add the following details: Receipt ID, Date, Paid To, Paid By, and Payment Method. Use AutoFilter to sort and filter your receipts.

Formatting Your Header

Your receipt header should stand out. To format it, select the header row, and use the Font (B, I, U), Fill, and Border options in the Home tab. For a professional touch, apply shading and bold text.

Payment Receipt Excel Template - Model 3
Payment Receipt Excel Template - Model 3
Import Receipts to Excel (+ other documents too!) - with Video Tutorial
Import Receipts to Excel (+ other documents too!) - with Video Tutorial
Payment Receipt Template in Google Sheets, Pages, Excel, Apple Numbers, Word, PDF, Google Docs - Download | Template.net
Payment Receipt Template in Google Sheets, Pages, Excel, Apple Numbers, Word, PDF, Google Docs - Download | Template.net

For a simple and clean appearance, use Light Gray (Lightest Shading) for the fill color and Black (Automatic) for the border. Adjust the font size and style to your liking. Remember, readability is key!

Freezing the Header

To make the header always visible, even as you scroll through your receipts, click anywhere in the header row and go to View > Freeze Panes. Select Freeze Panes and click on the line where you want the freezing to start.

This ensures that your header remains in place, making navigation and reference more convenient.

5 Free Receipt Of Payment Templates in Word Excel PDF formats
5 Free Receipt Of Payment Templates in Word Excel PDF formats
Editable Receipt Template - Excel & Google Sheets - Small Business, Printable PDF, Instant Download
Editable Receipt Template - Excel & Google Sheets - Small Business, Printable PDF, Instant Download
an invoice form with the words receipt written on it, and a black and white background
an invoice form with the words receipt written on it, and a black and white background
Receipt Template MS Excel | Receipt Template Google Sheets | Business Form Bundle | Blank Invoice
Receipt Template MS Excel | Receipt Template Google Sheets | Business Form Bundle | Blank Invoice
the receipt form is shown in black and white
the receipt form is shown in black and white
a receipt form with the words cash - aknowglement receipt written on it
a receipt form with the words cash - aknowglement receipt written on it

Entering Receipt Data

Now that your layout is set up, it's time to enter your receipt data. Your receipts are essentially a list, with each receipt occupying a row. The data could include the following: Item Description, Quantity (if applicable), Price, Tax, Discount, and Subtotal.

1. **Data Entry**: Enter your receipt data directly into the appropriate columns (B5 onwards). Excel will automatically adjust the formatting based on the data type (Number or Text).

Adding a New Receipt

Excel allows you to add new receipts effortlessly. Simply scroll down to the last row, and start entering your new receipt data. Remember to keep the data organized and consistent.

Yellow and Black Modern Payment Receipt A4
Yellow and Black Modern Payment Receipt A4
FREE Receipt Template Printables | Word, Excel or Editable PDF
FREE Receipt Template Printables | Word, Excel or Editable PDF
Professional Customer Bill Receipt Template in Excel | Easy & Printable Format
Professional Customer Bill Receipt Template in Excel | Easy & Printable Format
Fillable Form Receipt | Edit, Sign & Download in PDF | PDFRun
Fillable Form Receipt | Edit, Sign & Download in PDF | PDFRun

Pro tip: Use AutoFill (little squares in the bottom right-hand corner of a cell) to populate data. For instance, if you enter a date in one cell, you can use AutoFill to quickly fill the dates for the following days.

Sorting and Filters

To keep your receipts organized, use the Sort & Filter feature. Click on the filter icon in the header, and sort your receipts by date, amount, or any other category that suits your needs.

For more advanced sorting, select the data you want to sort, click on Sort in the Home tab, and choose your sorting options.

Calculating Totals and Grand Total

With Excel's built-in functions, calculating subtotals and grand totals is a breeze. This helps in understanding the overall expenditure and comparison between receipts.

1. **Subtotal**: Use the SUM function at the bottom of the Price, Tax, Discount, and Subtotal columns to add up the receipt totals. Excel 365 users can use the SUM function with dynamic arrays to fill in all subtotals automatically.

2. **Grand Total**: Use SUM or a similar function to calculate the total of all subtotals, giving you the overall expenditure.

Formatting Your Receipts

Make your receipts easy on the eye by adding some visual separation. Use the Merge & Center and Merge Dn functions to merge cells and create section titles. Experiment with different colors, fonts, and borders to suit your style.

Remember, your receipts should be clear, concise, and easy to understand. Too much clutter can make them overwhelming.

Reviewing and Protecting Your Work

Once you're satisfied with your receipts, it's time to finalize and protect your work. Click on the File > Info tab, and apply a watermark or add a protection password to prevent unauthorized changes.

Pro tip: Save your work regularly. Excel autosaves changes periodically, but better safe than sorry!

And there you have it - a comprehensive guide on creating receipts of payments in Excel. With practice, creating receipts in Excel becomes second nature. Happy tracking!