Free template · Accounts & purchase

Payment Voucher Format: Free Excel Template with a Worked Example

A free payment voucher format in Excel for cash, bank, UPI and cheque payments. Get a blank format plus three filled examples: a supplier, petty cash and a job worker paid after TDS.

Download the Excel template

A payment voucher is the internal record a business makes every time money goes out. It shows who was paid, how much, why, how (cash, bank, UPI or cheque) and who approved it. A standard payment voucher format has a voucher number, date, payee, purpose and the bill it pays. It also has the amount in figures and words, payment mode and reference, and the ledger head. The approver signs it, and so does the receiver when you pay in cash. Download the free Excel on this page: a blank format plus three filled examples.

What is a payment voucher?

You make one each time you pay a supplier, a job worker, a transporter or an expense. It proves the payment was checked and approved before the money left.

It is not an invoice or a receipt. The bill says what you owe. The voucher records that you paid it. A receipt is what the payee gives back to confirm they got the money.

Types of payment voucher

  • Cash payment voucher: for cash paid from the cash box. The receiver signs it.
  • Bank payment voucher: for NEFT, RTGS, cheque or UPI, with the UTR, cheque number or UPI transaction ID.
  • Petty cash or expense voucher: for small spends like consumables or courier. Attach the cash memo.
  • GST payment voucher (reverse charge): when you, the buyer, pay the GST. It needs extra fields, covered below.

What each field in the payment voucher format means

FieldWhat to write
Voucher No.Next number in the series, e.g. PV-B/26-27/0142
DateThe day the money left
Paid To (GSTIN/PAN)Payee's name as on their bill, with GSTIN, or PAN where TDS applies
Purpose/NarrationWhat the payment is for
Bill/PO/GRN Ref.Bill number, plus PO and GRN for material
Ledger HeadThe account debited: supplier, expense or job work
Gross AmountBill amount before TDS
TDSTDS held back, if any, to deposit with the government
Net PaidGross minus TDS: what actually left your account
Amount in WordsNet paid in words, so the figures are hard to change
Mode/Account/Ref.Cash, NEFT, RTGS, cheque or UPI, with the account and the UTR, cheque or UPI number
Prepared/Approved/Received ByWho filled it, who approved it and, for cash, the payee's signature

How to fill a payment voucher, step by step

[[IMAGE {"type":"steps","title":"How to fill a payment voucher","items":["Take the next voucher number","Attach the bill, PO and GRN","Work out TDS and net paid","Write net paid in figures and words","Get approval before the money leaves"]}]]

  1. Take the next number in the series. Never skip or reuse one.
  2. Attach the bill, plus the PO and GRN for material.
  3. Write the payee's name and the purpose.
  4. Work out any TDS, then the net amount.
  5. Write net paid in figures and in words.
  6. Add the mode and its UTR, cheque number or UPI ID.
  7. Get approval before paying. For cash, the receiver signs too.

Where TranZact fills this for you

The patchwork of Tally, Excel and WhatsApp keeps the PO, GRN and bill behind a payment in different places. TranZact is manufacturing AI software used by 10,000+ manufacturers. It runs your purchase flow in one place, so those papers sit together.

What the voucher needsIn TranZactNote (checked 22 Oct 2026)
PO, GRN and bill behind each paymentPurchase flow: MRP report → indent → RFQ → PO → GRN → paymentSee purchase management
Payments due on timeDelivery & payment remindersFrom the Grow plan, see pricing
The entry in your booksAccounting stays in Tally; one-way sync, no double entryAlso Busy and Zoho Books, see integrations
Getting startedLive in 2–3 weeksOn your current workflow

TranZact doesn't file TDS or GST. Accounting stays in Tally through a one-way sync, with no double entry.

Book a demo →

Worked example: three payments at a fabrication unit (illustrative numbers)

These match the Excel's example sheet. Names and numbers are made up.

Table 1 (Example): supplier payment by NEFT against PO, GRN and bill

FieldValue
Voucher No.PV-B/26-27/0142
Date12-11-2026
Paid To (GSTIN/PAN)Shree Steel Traders (GSTIN 27AAAAA0000A1Z5)
Purpose/NarrationMS plates for job order 318
Bill/PO/GRN Ref.Bill ST/884; PO-0457; GRN-0612
Ledger HeadShree Steel Traders (creditor)
Gross Amount₹1,18,000
TDS₹0
Net Paid₹1,18,000
Amount in WordsRupees One Lakh Eighteen Thousand Only
Mode/Account/Ref.NEFT; bank current account; UTR 0012345678
Prepared/Approved/Received ByRavi (accounts) / Owner / not needed (bank)

Table 2 (Example): petty cash for consumables

FieldValue
Voucher No.PV-C/26-27/0087
Date13-11-2026
Paid To (GSTIN/PAN)Ganesh Hardware (unregistered)
Purpose/NarrationWelding rods and grinding discs
Bill/PO/GRN Ref.Cash memo 2231
Ledger HeadConsumables
Gross Amount₹2,450
TDS₹0
Net Paid₹2,450
Amount in WordsRupees Two Thousand Four Hundred Fifty Only
Mode/Account/Ref.Cash; petty cash
Prepared/Approved/Received BySunil (stores) / Plant manager / signed by shop owner

Table 3 (Example): job worker payment with TDS

FieldValue
Voucher No.PV-B/26-27/0143
Date14-11-2026
Paid To (GSTIN/PAN)Mahesh Powder Coating, proprietor (PAN AAAPA0000A)
Purpose/NarrationPowder coating of 400 brackets
Bill/PO/GRN Ref.Bill MPC/112; job work challan JW-0098
Ledger HeadJob work charges
Gross Amount₹48,000
TDS₹480 (1%)
Net Paid₹47,520
Amount in WordsRupees Forty-Seven Thousand Five Hundred Twenty Only
Mode/Account/Ref.NEFT; bank current account; UTR 0012345690
Prepared/Approved/Received ByRavi (accounts) / Owner / not needed (bank)

Can you record TDS in a payment voucher? Yes. Show gross, TDS and net paid as separate fields.

Contractor TDS under the Income-tax Act, 2025 is 1% for an individual or HUF and 2% for others. It applies when one payment is above ₹30,000, or the year's total is above ₹1,00,000. Here the job worker is an individual, so 1% applies. Check with your accountant whether any other TDS applies.

GST payment voucher under reverse charge

Under reverse charge, the buyer pays the GST, not the supplier. Section 31(3)(g) of the CGST Act says the buyer must issue a payment voucher when paying. Rule 52 lists what it must show:

  • Supplier's name, address and GSTIN, if registered
  • A serial number of up to 16 characters (letters, numbers, "-" or "/"), unique for the financial year
  • Date of issue
  • Your name, address and GSTIN
  • Description of the goods or services
  • Amount paid
  • Rate of tax: CGST, SGST, IGST, UTGST or cess
  • Amount of tax payable
  • For an inter-State supply: place of supply, with the state name and code
  • Signature or digital signature of the supplier or authorised representative

Add these as extra columns for a reverse-charge voucher. Take each GST rate from your accountant.

Common payment voucher mistakes

  1. No papers attached. Without the bill, PO and GRN, nobody can check a supplier payment later.
  2. A broken number series. Skipped or repeated numbers raise questions in an audit.
  3. Cash above ₹10,000 to one person in a day. That expense is not deductible (₹35,000 for hiring goods carriages), so pay by bank. Receiving ₹2 lakh or more in cash from one person in a day is also barred.
  4. TDS missing. Writing only the gross hides the TDS you must deposit.
  5. Words don't match figures. Then nobody can tell which amount is right. Write the words from Net Paid.
  6. No approval or receiver signature. An unsigned voucher doesn't show that anyone checked it.

Payment voucher format in Excel: what's in the download

The free .xlsx file has two sheets. Sheet 1 is the blank 12-column format, which doubles as your monthly payment register. Sheet 2 has the three filled examples above.

How do I make a payment voucher format in Excel?

Type the 12 field names as headers in row 1. Fill one row per payment, in voucher-number order. Set Net Paid as a formula: Gross Amount minus TDS.

For a new month, copy the blank sheet and name it, e.g. Nov-2026. Carry voucher numbers on, and restart the series only in a new financial year.

To print, use landscape and Fit All Columns on One Page. For one voucher, print the header row and that voucher's row.

Need other formats? See our invoice and bill format guide and the free bill of materials format.

Don't be the bottleneck. Become the AI-Run Factory.

Bring one month of supplier payments to a demo. We'll show you the PO, GRN and payment together in TranZact, and the sync to Tally.

Book a demo →

Frequently asked questions

Do I need a separate payment voucher for every payment?

Yes. One voucher per payment, each with its own number, makes every rupee traceable to a bill and an approval. The blank sheet works as your monthly register, with one row per voucher.

Should cash and bank vouchers use separate number series?

Many businesses keep one series per type, for example PV-C and PV-B. Either works, as long as numbers run in order without gaps and are unique within the financial year.

What should I attach to a payment voucher for a supplier?

The supplier's bill, and for material purchases the PO and GRN. Then anyone can see what was ordered, what came in and what was paid.

Can I use this Excel with Tally?

Yes. The voucher keeps the same details you enter in Tally's payment entry: date, party, ledger, amount and narration. If your operations run in TranZact, accounting stays in Tally through a one-way sync with no double entry.

Is the template free and editable?

Yes. It's a free .xlsx file with a blank format and a filled example sheet, and no sign-up. Add your logo and change any column.

Don’t be the bottleneck.
Become the AI-Run Factory.

Book a demo

Born in India. Building for the world.