Free Excel download • Edit online • Save & share with Drive • Export to PDF
A Credit Memo is a formal accounting document a seller issues to reduce or fully cancel the balance on a previously sent invoice. It references the original invoice by number, lists the specific line items being adjusted with quantities and unit prices, reverses the applicable tax, and states the net credit amount — giving both parties a clear, auditable record of the adjustment. Unlike voiding an invoice, a credit memo preserves both the original billing record and the correction in each party's accounting system.
Without a credit memo, adjusting an invoice balance creates reconciliation problems on both sides of the transaction. Buyers cannot post an undocumented credit against their open payables, and sellers are left with an inaccurate AR ledger that inflates revenue until year-end. A vague email promising a discount or return credit is not an accounting document — it cannot be matched, audited, or used to support a tax filing. This Excel template gives you a structured, professional credit memo in five minutes: enter the original invoice reference, adjust the line items, and the net credit calculates automatically. Both parties walk away with a document that satisfies their bookkeeping, tax records, and audit trail requirements.
| If your situation is… | Use this template |
|---|---|
| Fully cancelling an invoice that was issued in error | Credit Memo (Full Cancellation) |
| Reducing an invoice by a negotiated discount after delivery | Credit Memo (Partial Adjustment) |
| Processing a product return with restocking details | Return Merchandise Authorization (RMA) |
| Issuing a refund confirmation after payment was already received | Refund Receipt |
| Sending the original invoice you need to offset | Invoice Template |
| Recording a customer overpayment to apply to a future invoice | Credit Note |
| Adjusting a proforma invoice before delivery has occurred | Proforma Invoice |
Why it matters: Without the original invoice number, the buyer's AP team cannot match the credit to the correct payable — it may sit in a suspense account or be rejected entirely.
Fix: Always include the original invoice number, date, and total amount in a dedicated reference block near the top of the credit memo.
Why it matters: A single line reading '$300 credit' gives the buyer no basis to verify the amount or match specific invoice rows — disputes and delays follow.
Fix: Mirror the original invoice's line-item format: list each adjusted item with quantity, unit price, and line total so both records align row by row.
Why it matters: Crediting the pre-tax amount without reversing the associated sales tax or VAT leaves the buyer overpaying tax and creates mismatches in both parties' tax filings.
Fix: Apply the same tax rate used on the original invoice to the credit subtotal and show the tax reversal as a separate line in the totals block.
Why it matters: Buyers often assume a cash refund while sellers intend an offset against a future invoice — this mismatch causes payment disputes and strained relationships.
Fix: Add a clear application instruction line stating whether the credit is being offset, refunded, or held on account, with an expected date.
Add your business name, address, phone, email, and tax ID to the seller block — use the exact same details that appear on the original invoice being adjusted.
💡 Save a pre-filled version with your details as a master file so each new credit memo only requires updating the client and invoice-specific fields.
Enter the customer's legal entity name, billing address, and AP contact — pulled directly from the original invoice to ensure the records match.
💡 Confirm the AP email address before sending — credit memos routed to the project contact often sit unprocessed past the expected application date.
Use a separate sequential numbering system for credit memos (e.g., CM-2026-0001) and enter today's date. Keep this series distinct from your invoice numbers.
💡 A CM-YYYY-NNNN format keeps credit memos sortable by year and prevents confusion with invoice records during month-end close.
Enter the original invoice number, its issue date, and its total amount in the reference block. This is the single most important linking field in the document.
💡 Double-check the invoice number against your AR ledger before issuing — a mismatched reference can cause the credit to be posted against the wrong account.
Write a one-to-two sentence explanation — returned goods, billing error, negotiated discount, or partial non-delivery. Be specific enough that the buyer's AP team can approve it without a follow-up call.
💡 If the credit stems from a written agreement (email, return authorization), reference that document's date in the reason field.
List each item being credited with quantity, unit price, and line total. The template calculates the subtotal, tax reversal, and net credit automatically.
💡 Use the same product descriptions and SKUs as the original invoice — exact matches speed up approval and reduce dispute risk.
State clearly whether the credit offsets a future invoice, reduces a current open balance, or will be refunded as cash — and include the expected timeline.
💡 If applying to a specific future invoice, name that invoice number in the application instructions so both parties track it the same way.
A credit memo is a document a seller issues to reduce the amount a buyer owes on a previously sent invoice. It is used for product returns, billing errors, post-invoice discounts, or partial non-delivery. Rather than voiding the original invoice, a credit memo adjusts the balance while preserving both records for accounting and audit purposes.
A credit memo reduces the buyer's outstanding balance — it is an accounting adjustment that can be offset against a current or future invoice. A refund is a cash payment returned to the buyer. A credit memo is often the first step; if no open invoices exist to apply it against, the seller then issues a cash refund. Both events should be documented.
Issue a credit memo when the original invoice has already been sent, recorded in the buyer's AP system, or partially paid. Voiding an invoice is appropriate only when it was created in error before being sent or recorded. Once the invoice is in a buyer's system, a credit memo is the correct adjustment — voiding creates reconciliation problems for both parties.
Yes. The original invoice number, date, and total are required fields on any credit memo. Without them, the buyer's AP department cannot match the credit to the correct payable, and your own AR ledger will have an unmatched open item. A missing reference is the single most common cause of credit memo processing delays.
Yes, in most cases. If you charged sales tax, VAT, or GST on the original invoice, the credit memo should reverse the tax proportional to the items being credited. Issuing a credit for only the pre-tax amount overstates the buyer's tax liability and creates discrepancies in both parties' tax records. Confirm the applicable rate with your accountant if you are unsure.
Yes. A credit memo balance can be held on the customer's account and offset against a future invoice rather than refunded as cash. Specify this in the application instructions on the credit memo itself — note whether it will be applied to a specific upcoming invoice or held as a general credit. Both parties should record the credit and its intended application in their accounting systems.
Use a separate sequential numbering series from your invoices — for example, CM-2026-0001 through CM-2026-9999. Mixing credit memo and invoice numbers in the same sequence creates confusion during AR reconciliation, audits, and month-end close. A distinct prefix makes every document type immediately identifiable.
The two terms are used interchangeably in most contexts. In some regions — particularly the UK and Australia — "credit note" is the standard term, while "credit memo" is more common in North America. Both documents serve the same function: formally reducing a buyer's outstanding invoice balance. The content and required fields are identical regardless of the label used.
An invoice is a payment request issued after goods or services are delivered. A credit memo is its mirror image — issued to reduce or cancel an invoice balance. Every credit memo must reference the invoice it is adjusting. You need the invoice first; the credit memo corrects it.
Credit memo and credit note refer to the same document — the former is common in North America, the latter in the UK and Australia. Both reduce a buyer's outstanding invoice balance with identical required fields. Use whichever term matches your region and your customer's expectations.
A credit memo is an accounting adjustment that reduces an invoice balance — no cash changes hands until the credit is applied or refunded. A refund receipt confirms that cash was actually returned to the buyer. A credit memo often precedes the refund; the receipt documents that the cash transaction occurred.
A proforma invoice is issued before delivery as a preliminary quote or deposit request — it does not create a receivable. A credit memo adjusts a real, posted invoice after delivery. The two documents operate at opposite ends of the transaction timeline and are never interchangeable.
High-volume product returns require SKU-level line items, restocking fee deductions, and tax reversals at the state or country level.
Bulk-order adjustments often involve partial shipment credits, volume-discount recalculations, and references to purchase order numbers.
Credits typically offset hours not delivered, scope reductions agreed mid-project, or billing rate corrections on time-and-materials invoices.
Campaign cancellations, media buy reversals, and third-party expense credits require line-item detail matching the original production invoice.
| Path | Best for | Cost | Time |
|---|---|---|---|
| Use the template | Small businesses, freelancers, and any seller needing to adjust a standard B2B or B2C invoice | Free | 5 minutes per credit memo |
| Template + professional review | Businesses handling high-volume returns, multi-currency credits, or complex tax reversals across multiple jurisdictions | $0–$75 (accountant or bookkeeper check) | 30–60 minutes |
| Custom drafted | Enterprise AR workflows with ERP integration, regulated industries, or automated credit memo generation from order management systems | $200–$1,500+ (accountant or developer setup) | 1–5 days |
This document is one of 3,000+ business & legal templates included in Business in a Box.
Access over 3,000+ business and legal templates for any business task, project or initiative.
Customize your ready-made business document template and save it in the cloud.
Share your files and folders with your team. Create a space of seamless collaboration.
"Fantastic value! I'm not sure how I'd do without it. It's worth its weight in gold and paid back for itself many times."
"I have been using Business in a Box for years. It has been the most useful source of templates I have encountered. I recommend it to anyone."
"It has been a life saver so many times I have lost count. Business in a Box has saved me so much time and as you know, time is money."
Stop downloading documents. Start operating with clarity. Business in a Box gives you the Business Operating System used by over 250,000 companies worldwide to structure, run, and grow their business.
Start free · No credit card required
