How to build cash receipt vouchers in Sheets & Excel

Overview

Cash receipt vouchers look deceptively simple: a payer, an amount, a date, and a short description. But at scale – dozens or hundreds per week across locations or reps – they turn into a fragile, error‑prone workflow.

Below we’ll walk through three levels of maturity:

1. Traditional, manual methods.
2. No‑code automation on top of Google Sheets and Excel.
3. Full AI‑agent automation where a computer agent operates your tools for you.

‍

1. Traditional / Manual Methods

‍

1.1 Paper receipt book + later spreadsheet entry

When it fits: Very small shops or early‑stage teams.

Steps:

1. Keep a numbered paper receipt book by the till.
2. For each cash payment, write: payer name, date/time, amount, purpose, and your initials. Give the customer the original and keep the stub.
3. At the end of the day or week, open a master cash receipts log in Google Sheets or Excel.
4. Manually type each receipt line into the log, matching the receipt number.
5. Save and back up the file.

Issues: Double work, high risk of missed entries, hard to search, no automatic totals.

‍

1.2 Manual Google Sheets voucher template

When it fits: Solo operators and small agencies that live in Google Workspace.

Steps:

1. In Google Sheets, create a new spreadsheet. See Google’s guide on creating spreadsheets: https://support.google.com/docs/answer/6000292
2. In the first sheet, design a voucher table with fields like: Voucher ID, Date, Payer Name, Payer Contact, Amount, Currency, Payment Method, Description, Prepared By.
3. Turn that range into a formatted table with borders, bold headers, and data validation (e.g., dropdown for Payment Method).
4. Freeze the header row so it stays visible.
5. Each time you receive cash, insert a new row and fill in all fields.
6. Use a running number for Voucher ID to keep things audit‑ready.
7. Share the sheet with only the people who should be editing or viewing it.

Issues: Still entirely manual; relies on staff discipline; errors creep in under pressure.

‍

1.3 Manual Excel voucher template

When it fits: Finance teams and bookkeepers who prefer desktop Excel or Microsoft 365.

Steps:

1. Create a new workbook in Excel. See Microsoft’s guide: https://support.microsoft.com/en-us/office/create-a-workbook-in-excel-ef29712f-f46d-4b18-b903-48621dfb5d28
2. On Sheet1, create a structured table for your vouchers with the same fields as above.
3. Use Excel tables (Ctrl+T) so formulas and formatting auto‑extend.
4. Add data validation for fields like payment method and currency.
5. Add a formula to auto‑increment Voucher ID (e.g., previous row + 1).
6. For each cash transaction, add a new row and complete every cell.
7. Save the workbook in a secure, backed‑up location. Optionally export PDF copies of filtered views for your accountant.

Issues: Manual steps, local file versions, and limited collaboration if people email the file around.

‍

1.4 Downloaded templates filled by hand

Many businesses start with a downloaded Excel or Word cash receipt template, typing values and printing PDFs one by one. This is fine for a handful of receipts, but becomes painful quickly: you duplicate files, rename them manually, and have no central log.

Key limitation: Every step – copy, rename, fill, export, email – is you clicking and typing.

‍

2. No‑Code Automation with Google Sheets and Excel

You can get a lot of leverage before you ever touch AI by introducing simple automation.

‍

2.1 Google Forms → Google Sheets cash receipt log

Scenario: Front‑desk staff or sales reps can fill a short form on any device, and your master voucher log updates automatically.

Steps:

1. In Google Forms, create a form called "Cash Receipt Voucher" with fields that match your voucher columns.
2. Link the form to a Google Sheets response spreadsheet (Forms does this automatically).
3. In the linked sheet, create a new column for Voucher ID and use a formula to auto‑number rows.
4. Add formatting, filters, and pivot tables for reporting.
5. Train your team: whenever they take cash, they open the form on their phone, submit it, and that’s it.

Pros: Easy to roll out, mobile‑friendly, structured data from day one. Cons: Still relies on human entry; no connection to your payment systems or emails.

‍

2.2 Email to spreadsheet using automation tools

Scenario: You receive proof of cash payments by email (confirmations, scanned slips). You want those to become structured rows in Sheets or Excel.

**Steps (conceptual):

1. Use a no‑code tool like Zapier, Make, or Power Automate.
2. Trigger on new emails matching specific subjects or addresses.
3. Extract key fields (payer name, amount, date, reference) from the email body.
4. Append a row to your Google Sheets or Excel Online voucher log.
5. Optionally, send a confirmation email to the customer.

Pros: Eliminates copying from email into spreadsheets. Cons: Template‑sensitive; when email formats change, your parsing breaks.

‍

2.3 Excel with Power Query or Power Automate

Scenario: You already have a POS or banking export in CSV; you want vouchers to update from that file.

Steps:

1. Save your daily POS or bank CSV export to a fixed folder.
2. In Excel, use Power Query to import that folder and combine files into a single table.
3. Map columns from the CSV (date, amount, customer) into your voucher log table.
4. Refresh the query whenever you add a new CSV.
5. Use Power Automate (optional) to trigger a refresh on a schedule and send summaries by email.

Pros: Good for recurring, structured exports. Cons: Setup takes time, and changes in CSV format require maintenance.

‍

3. Scaling with AI Agents Operating Sheets and Excel

Manual steps and simple automations eventually hit a ceiling. When you have multiple locations, many team members, and messy inputs (photos of receipts, unstructured emails, chat messages), you want something that can operate like a human assistant across apps.

An AI computer agent platform like Simular Pro is built for exactly this: it can see your screen, click, type, and navigate inside Google Chrome, Google Sheets, Excel, email, and shared drives, following a workflow you define.

‍

3.1 AI agent that prepares daily vouchers in Google Sheets

Story: Imagine closing your café at 9 pm. Instead of staying an extra hour reconciling cash, you trigger your AI agent.

Workflow:

1. The agent opens your POS dashboard, downloads the day’s cash sales report.
2. It launches Google Sheets and opens your master voucher log.
3. For each transaction in the report, it inserts a new row, fills payer info (if available), amount, date, and description, and assigns the next Voucher ID.
4. It checks for duplicates (same time, amount, and reference) and flags anomalies on a separate "Review" sheet.
5. Finally, it emails you a summary: total cash, number of vouchers created, and any exceptions.

Pros: Handles messy multi‑step work; every action is visible and auditable. Cons: Initial setup effort; you should supervise the first runs.

‍

3.2 AI agent generating Excel vouchers and PDFs for clients

Story: You run an agency collecting small cash retainers at events. After each event, your AI agent does the boring work.

Workflow:

1. The agent opens your event folder and reads a simple CSV or Google Sheet exported from your event app.
2. It opens your Excel voucher template workbook.
3. For each row, it duplicates a template sheet or fills a template table with the client name, amount, and purpose.
4. It exports each filled voucher as a PDF, names it consistently (e.g., CRV-2025-03-001-ClientName.pdf), and moves it into a "Vouchers" subfolder.
5. Optionally, it opens Outlook or Gmail and emails each PDF to the corresponding client.

Pros: Produces professional vouchers and PDFs with zero manual copy‑paste. Cons: Requires a clean template and some initial instructions.

‍

3.3 Hybrid: AI agent plus your existing no‑code flows

You don’t have to abandon existing automations. A powerful pattern is:

1. Let your no‑code tools push structured data (transactions) into Google Sheets or Excel.
2. Have the AI agent pick up from there: cleaning data, resolving edge cases, generating vouchers, exporting PDFs, and filing.
3. When it finds anomalies (missing payer name, mismatched totals), it writes them to a "Needs Review" sheet instead of guessing.

Pros: Human‑like flexibility on top of your existing automations. Cons: Requires a bit of process design – but once it’s set, you’ve effectively hired a tireless, precise digital bookkeeper.