Credit Note Format: Free Sample Excel Download

A credit note format is a document issued by a seller to a buyer to reduce the invoice value or confirm an adjustment in favour of the buyer. It is commonly issued for sales returns, price reductions, post sale discounts, wrong billing, or service overcharging. A credit note keeps records clean, avoids disputes, and helps both parties settle adjustments faster. Using a credit note format in Excel is one of the easiest ways to create, number, and store credit notes in order.

download Credit Note Format

Download Credit Note Format in Excel

Download the free credit note format in Excel. Customise it as per your requirements at no cost.

What is a credit note format, and when is it used?

A credit note is usually issued by the seller to the buyer. It clearly communicates, “I am reducing your payable amount because an adjustment is required.”

Common situations include customer returns, rate reductions after billing, discounts applied after the invoice is raised, excess quantities billed, wrong items billed, and service overbilling. It works as written proof for the adjustment, so there is no confusion during payment follow-up.

Credit note template: fields you should include

A good credit note template should be short but complete.

• Credit note number
• Date
• Seller name and address
• Buyer name and address
• Original invoice number and invoice date reference
• Reason for credit note
• Item details (quantity, rate, amount)
• Tax details if applicable
• Total credit note value
• Authorised signature and stamp

Optional but useful:

• Return receipt or delivery reference for returned goods
• Transport details for returned goods
• Remarks section
• Supporting proof reference (photos, email approval, service report)

Quick checklist before you issue a credit note

• Mention the correct buyer name and linked invoice number with date.
• Write a clear reason with specifics (return, rate reduction, discount, wrong billing, service adjustment).
• Match item details and quantities with the invoice and return or delivery record.
• Calculate amounts correctly and keep tax treatment consistent with the original invoice terms.
• Use a running credit note number series (CN 001, CN 002).
• Share the credit note with the buyer quickly and adjust it in the next settlement to avoid disputes.