✦Template Printable Ideas Insights

Mastering Excel: Step-by-Step Guide to Create Receipt Vouchers

By

Ever found yourself in a position where you needed to generate receipt vouchers but couldn't afford the time or resources to design them from scratch? Excel offers a simple yet powerful solution to this common dilemma. With a few clicks and drags, you can create professional-looking receipt vouchers that meet your unique business needs. Let's explore a step-by-step guide on how to make receipt vouchers in Excel.

Before you dive in, ensure you have the latest version of Excel installed on your computer. This guide uses Excel 2019 as a reference, but the steps remain largely similar across versions. Now, let's get started!

Creating a New Workbook and Setting Up the Layout

To begin, open a new Excel workbook. You'll want to start with a clean slate to ensure your receipt vouchers look their best. Right-click on the desired sheet tab and select "Move or Copy" to duplicate it, giving you a fresh canvas for your receipt voucher design.

Petty Cash Template | Free Word Templates
Petty Cash Template | Free Word Templates
Free Voucher Templates - Excel Word Template
Free Voucher Templates - Excel Word Template
Salary Receipt Voucher | Templates at allbusinesstemplates.com
Salary Receipt Voucher | Templates at allbusinesstemplates.com

Next, set up the basic layout. In the 'Page Layout' tab, configure the margins as needed, ensuring your voucher fits onto a standard A4 or Letter-sized paper. Choose a suitable font and font size for your voucher details, considering readability and aesthetics.

Defining the Voucher Sections

Your receipt voucher should include essential sections such as header, client details, product/services list, totals, and a footer. Use Excel tables or ranges for each section to keep your data organized and make edits a breeze.

Download Free Payment Voucher Template in Word for Accurate Transactions
Download Free Payment Voucher Template in Word for Accurate Transactions
Payment Voucher Template | 11+ Free Word, Excel & PDF Formats, Samples, Examples, Designs
Payment Voucher Template | 11+ Free Word, Excel & PDF Formats, Samples, Examples, Designs
Free Payment Voucher Template - Free Report Templates
Free Payment Voucher Template - Free Report Templates

Create a table for the header, including your company's logo, name, and contact information. For the client details, create another table that can accommodate varying client names, addresses, and other relevant information. Add tables for the product/services list, subtotals, taxes, and final totals. Don't forget to include a footer with additional information like payment terms or disclaimers.

Designing the Receipt Voucher

Now comes the fun part – designing your receipt voucher! Use Excel's extensive formatting tools to make your voucher visually appealing and informative. Here are some design tips:

financières

How to Create Payment Voucher Request for Bill in Microsoft Word
How to Create Payment Voucher Request for Bill in Microsoft Word
Payment Voucher Template - Excel Word Template
Payment Voucher Template - Excel Word Template
Company Voucher Templates - Excel Word Template
Company Voucher Templates - Excel Word Template
Import Receipts to Excel (+ other documents too!) - with Video Tutorial
Import Receipts to Excel (+ other documents too!) - with Video Tutorial
Free Petty Cash Voucher Template in Word Doc & Excel
Free Petty Cash Voucher Template in Word Doc & Excel
Free Payment Voucher Template for Hotel Invoices – Download Now
Free Payment Voucher Template for Hotel Invoices – Download Now
  • Use conditional formatting to add color and shading to cells based on their values. For example, highlight negative amounts in red or use different colors for percentages.
  • Customize number formats for better readability. For instance, display currency with symbols and a specified number of decimals.
  • Add merge cells to create headers and subtitles. Combine them with border styles to define sections and make your voucher visually appealing.
  • Make use of Excel's image insertion feature to add logos, charts, or other relevant visuals. However, ensure they don't clutter your voucher or make it difficult to read.

Automating Voucher Generation

Once you've created your receipt voucher template, it's time to make life easier by automating the process. Excel's Formulas and Data Validation features can help create dynamic receipt vouchers that update automatically based on the input data.

Use SUMIFS, AVERAGEIFS, and other aggregate functions to calculate subtotals, taxes, and final totals. Employ Data Validation to limit the user's input to specific values or ranges, ensuring your voucher remains error-free.

Populating Data and Generating Vouchers

With your receipt voucher template complete and automated, it's time to populate the data and generate vouchers. Create another sheet or use data connections to pull client and product/service data from an external source such as your CRM or inventory management system.

two receipt vouchers sitting on top of each other in front of a gray background
two receipt vouchers sitting on top of each other in front of a gray background
Free Receipt Template for Effortless Invoicing | Download Now
Free Receipt Template for Effortless Invoicing | Download Now
an invoice form for payment with the name and number of each item on it
an invoice form for payment with the name and number of each item on it

Use Excel's GETPIVOTDATA function to retrieve dynamic information from pivot tables, or employ INDEX MATCH or XLOOKUP functions to extract data from different sources. Automatically update your voucher data by refreshing the connections or running VBA macros.

Printing and Saving Receipt Vouchers

Before printing, review your receipt vouchers to ensure all data is accurate and up-to-date. Excel offers various print options, including printing multiple vouchers on a single page for efficient use of resources. To print, select the range containing your voucher data, go to the 'File' tab, and click 'Print.'

Additionally, save your receipt voucher template for future use. Create a dedicated folder for your templates and update them periodically to maintain consistency and accuracy.

And there you have it – a comprehensive guide on creating receipt vouchers in Excel. By following these steps and continually refining your templates, you'll streamline your business processes and generate professional receipt vouchers with ease. Happy vouchering!