TOOLS CLUB TEMPLATE

Credit Note / Refund Template

When you need to refund a client or correct an invoice after the fact, an informal adjustment over email creates confusion and a messy paper trail. This template issues a formal credit note referencing the original invoice, with the adjusted balance calculated automatically.

Join the Tools Club — $7/mo Already a Member? Log In

Included in the $7/mo Tools Club · Works in Excel or Google Sheets · Includes a built-in AI prompt

Who this is for

Businesses issuing partial or full refunds to clients
Anyone correcting a billing error on a previously sent invoice
Businesses handling returns that require a credit against a future invoice
Bookkeepers needing a clean paper trail for credit adjustments

What's included

Reference field linking back to the original invoice number
Line items for what’s being credited and why
Automatic adjusted balance calculation
Built-in AI prompt to review whether your credit note documentation is clear and complete

Why use a template instead of starting from scratch?

A refund or correction handled only through an email thread is easy to lose track of, both for you and the client — and it leaves nothing formal in your books. A proper credit note creates a clear, referenceable record tied directly to the original invoice.

How to Use This Template

Download and open in Excel or Google Sheets

Requires a Tools Club membership — log in first to access the file.

Reference the original invoice number

This ties the credit directly back to what’s being adjusted.

List what’s being credited and the reason

Being specific here prevents confusion later, for both you and the client.

Review the automatic adjusted balance

This shows the new amount owed (or refunded) after the credit is applied.

Send it to the client and update your books

Record the credit against the original invoice in your accounts receivable records.

Built-in AI prompt

Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on whether your credit note documentation is clear enough to stand on its own if questioned later, and what’s commonly missing, no accounting background required.

Common Mistakes to Avoid

Not referencing the original invoice number

A credit note that doesn’t clearly tie back to a specific invoice is hard to reconcile later — always include the reference.

Being vague about the reason for the credit

A specific reason protects both you and the client if there’s ever a question about the adjustment later.

Handling refunds informally instead of documenting them

Even a quick verbal or email-only refund should still be followed up with a formal credit note for your records.

Forgetting to update accounts receivable after issuing the credit

The credit note itself doesn’t automatically update your books — make sure the adjustment is reflected in your AR ledger.

Frequently Asked Questions

What is a credit note?

It’s a formal document reducing the amount a customer owes, typically issued to correct a billing error, process a return, or apply a partial refund — it references the original invoice and shows the adjusted balance.

When should I issue a credit note instead of just refunding directly?

A credit note creates a clear paper trail and is standard practice for any billing correction — even if you’re also processing an actual cash refund, the credit note documents why.

Can a credit note be applied to a future invoice instead of refunded in cash?

Yes — this is common for ongoing client relationships, where the credit reduces what’s owed on a future invoice rather than being paid out directly.

Is this included in the free plan?

No, this is a Tools Club template. iLuvAccounting also has a free Invoice Template for the original invoices this template references.

Does issuing a credit note have tax implications?

It can, depending on your jurisdiction and whether sales tax was charged on the original invoice — check with your accountant on how to handle tax adjustments correctly.

How should I number credit notes?

A separate sequential numbering system (distinct from your invoice numbers) is common practice, making it easy to distinguish credits from invoices in your records.

What if the credit is for more than the client currently owes?

This typically results in a cash refund or a credit balance carried forward to the client’s next invoice — decide and communicate clearly which approach you’re using.

Related Templates

Related Resources

Want the Full Template Library?

70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.

Join the Tools Club