Supplier credit and debit notes in SQL Accounting
Which document, and how to tie them to the invoice: a supplier’s credit note lowers what you owe and goes into Purchase Returned; a debit note raises it and goes into Purchase Debit Note. On a bill keyed as a Supplier Invoice, use Supplier Credit Note or Supplier Debit Note instead. To tie every note to the invoice it changes, note that invoice’s number, transfer from it where you can, and knock the credit off against it.
Last checked against eStream’s SQL Accounting documentation (the Purchase and Supplier usage guides) and wiki, and LHDN’s e-Invoice FAQ of 4 September 2026.
Which way the money moves
| The note | What it says | What it does to what you owe | Key it into |
|---|---|---|---|
| Credit note | The supplier charged too much, or took goods back | Lowers it | Purchase Returned; Supplier Credit Note for a Supplier Invoice bill |
| Debit note | The supplier charged too little, or adds a charge | Raises it | Purchase Debit Note; Supplier Debit Note for a Supplier Invoice bill |
The names are the supplier’s view. A credit note credits your account with them, so you owe less. A debit note debits it, so you owe more.
Credit notes: Purchase Returned
The Purchase menu lists this document as Purchase Returned, and the window it opens is titled Purchase Return. eStream’s guide describes it as the document “created when you return purchased goods to a supplier”. You do not have to key it from nothing: open a new one, right-click the Purchase Return title and choose the Purchase Invoice (or Cash Purchase) it comes from, so the return starts from that invoice instead of a blank page.
When the note is for a bill you keyed as a Supplier Invoice, such as a service, use Supplier Credit Note in the Supplier menu. eStream says credit notes there are used “to reduce and offset outstanding invoices or debit notes”.
Debit notes: Purchase Debit Note
eStream’s guide says a Purchase Debit Note “is used to increase an expense amount or the amount owed to a supplier”. Key it like an invoice: the supplier, then the item lines the note adds.
For an extra charge on a Supplier Invoice bill, use Supplier Debit Note, which eStream describes as for general debit notes received from suppliers.
Tie every note to its invoice
A note on its own says “you owe less” or “you owe more”. Tied to its invoice, it says which bill and why. Three habits keep that link.
- Quote the invoice it changes. A supplier’s note should print the number of the invoice it adjusts. If it does not, ask the supplier before you key it, and put that number in the note’s description.
- Transfer, do not retype. In Purchase Returned, start from the invoice: right-click the title, then pick the source document.
- Knock the credit off. A credit note reduces a particular bill only once it is matched to that bill. eStream’s wiki says a credit note made in the Purchase module is offset against the outstanding invoices in Supplier Credit Note: tick the box beside the Pay column for the invoice it settles, or type the amount. Until then, SQL Accounting shows the note’s amount as unapplied.
A credit note that is never knocked off leaves the invoice outstanding in full, with the credit sitting beside it unapplied. Look for unapplied credit notes before you pay a supplier, so the invoice is not paid in full by mistake.
When the note is an e-invoice
LHDN asks a supplier who issues a credit note or debit note as an e-invoice to put the original e-invoice’s Unique Identifier Number in its “Original e-Invoice Reference Number” field (e-Invoice FAQ, questions 50 and 51). That number tells you which invoice the note changes.
Before you key a note, check it like an invoice: the supplier, the number, the sums. The guide to which document each paper goes into has every other supplier paper.