Credit Memo - Excel

Company Letterhead

{{company_name}}

{{company_address}}

Phone: {{phone}}

Email: {{email}}

Website: {{website}}

CREDIT MEMO

CREDIT MEMO NO: {{credit_memo_number}}

DATE: {{date}}

ORIGINAL INVOICE NO: {{original_invoice_number}}

ORIGINAL INVOICE DATE: {{original_invoice_date}}

BILL TO:

{{customer_name}}

{{customer_address}}

{{customer_phone}}

{{customer_email}}

REASON FOR CREDIT:

{{reason_for_credit}} (e.g., Goods Returned, Price Adjustment, Damaged Goods, Overpayment)

DETAILS OF CREDIT:

The following items/services are being credited due to the reason stated above:

| Item/Service Description | Quantity | Unit Price ({{currency}}) | Total Amount ({{currency}}) |

|---|---|---|---|

| {{item_1_description}} | {{item_1_quantity}} | {{item_1_unit_price}} | {{item_1_total_amount}} |

| {{item_2_description}} | {{item_2_quantity}} | {{item_2_unit_price}} | {{item_2_total_amount}} |

| ... | ... | ... | ... |

SUBTOTAL: {{currency}} {{subtotal_amount}}

TAX ({{tax_percentage}}%): {{currency}} {{tax_amount}}

TOTAL CREDIT AMOUNT: {{currency}} {{total_credit_amount}}

TERMS AND CONDITIONS:

This credit memo represents a reduction in the outstanding balance due from {{customer_name}}. This credit can be applied against future purchases or can be refunded upon request, subject to our company policy.

Any discrepancy or queries regarding this credit memo should be reported within {{days_to_report_discrepancy}} days of receipt.

ISSUED BY:

{{issuing_person_name}}

{{issuing_person_title}}

{{company_name}}

SIGNATURE:

_____________________________

Authorized Signature

Date: {{signature_date}}