YNPL25-26/1281

06 Jun 2025FKIIN38573077PO FNNWN06346091Warehouse A274

DEBIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by -Rs 23,123.94A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice: 2,97,359.62
Credit notes: -34,801.32
Debit notes: —
Net due from customer: 2,62,558.30
Receipts allocatedNeeds the invoice-wise outstanding report: —
OutstandingNeeds the invoice-wise outstanding report: —

Their register

Signed the same way as ours, so the two columns subtract

Invoice: 2,97,361.64
Debit notes: -11,677.38
Credit notes: —
Net due: 2,85,684.26
TDS deductedExpected 283.20 at 0.1% of taxable value: 282.46
Paid in cash: 2,85,401.80
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: -2.02
Notes: -23,123.94
Total position difference: -23,125.96
TDS: 0.74
UnexplainedEvery rupee of difference is attributed to a cause: 0.00

Credit and debit notes

3 notes in the order they were raised

Raised by

Type

Document number

Their reference

Date

Amount

Raised against

Recovered in

Them

Debit note

20250620-A274-RDN-FKIIN38573077

FKIDN38966901

20 Jun 2025

-34,801.88

FKIIN38573077

This invoice’s payment, 26 Jun 2025 (with 55 other invoices)

Them

Debit noteReversed

20250620-A274-RDN-FKIIN38573077_Reversed

FKIDN38966901

20 Jun 2025

23,124.50

FKIIN38573077

Another invoice’s payment14 Jul 2025, settling 19 other invoices

Credit note

FKIDN38966901

—

30 Jun 2025

-34,801.32

FKIDN38966901

Not yet recovered

Our notes total -34,801.32Their notes total -11,677.38on invoice 2526/1281

Notes settled against a different invoice

Their remittances net notes off whichever invoices share the payment, so the money can move between invoices

Raised against this invoice, but recovered from a payment for other invoices

Note	Their reference	Date	Amount	Payment event	Payment settled invoices
20250620-A274-RDN-FKIIN38573077_Reversed	FKIDN38966901	20 Jun 2025	23,124.50	HSBCN1955877580514 Jul 2025	2526/1419, 2526/1606, 2526/1609, 2526/1610, 2526/1611, 2526/1612 and 13 more

Source documents

Every row that contributed, with the file and Excel row it came from

Side	Type	Document	Date	Amount	Raised against	Matched by	Source
Theirs	InvoiceSTANDARD	20250606-A274-YNPL25-26/1281FKIIN38573077	06 Jun 2025	2,97,361.64	—	its own document number	Jan 2025 to July 2025row 1644
Theirs	TDS memoCREDIT	20250606-A274-YNPL25-26/1281-TDS-CM-20304974	06 Jun 2025	-282.46	—	the reference embedded in the document number	Jan 2025 to July 2025row 1709
Theirs	Debit noteCREDIT	20250620-A274-RDN-FKIIN38573077FKIDN38966901	20 Jun 2025	-34,801.88	FKIIN38573077	the reference embedded in the document number	Jan 2025 to July 2025row 1715
Theirs	Debit noteSTANDARD	20250620-A274-RDN-FKIIN38573077_ReversedFKIDN38966901Reversed	20 Jun 2025	23,124.50	FKIIN38573077	the reference embedded in the document number	Jan 2025 to July 2025row 1925
Ours	InvoiceTAX INVOICE	YNPL25-26/1281	06 Jun 2025	2,97,359.62	—	its own document number	YNPL Ledgerrow 1713
Ours	Credit noteCREDIT NOTE-25	FKIDN38966901	30 Jun 2025	-34,801.32	FKIDN38966901	our voucher number naming their note	YNPL Ledgerrow 2310

Settlement

4 row(s) across 2 payment event(s)

Date	Payment event	Kind	Amount
26 Jun 2025	HSBCN17753262764HDFC BANK LTD	CashActual Payment	2,97,361.64
26 Jun 2025	HSBCN17753262764HDFC BANK LTD	CashActual Payment	-282.46
26 Jun 2025	HSBCN17753262764HDFC BANK LTD	CashActual Payment	-34,801.88
14 Jul 2025	HSBCN19558775805HDFC BANK LTD	CashActual Payment	23,124.50

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN38966901 → 20250620-A274-RDN-FKIIN38573077
Matched by an exact voucher number match. Voucher number is their note FKIDN38966901
Their debit note against this invoiceCertain
20250620-A274-RDN-FKIIN38573077 → 20250606-A274-YNPL25-26/1281
Matched by the reference embedded in the document number. Document number names FKIIN38573077
Their debit note against this invoiceCertain
20250620-A274-RDN-FKIIN38573077_Reversed → 20250606-A274-YNPL25-26/1281
Matched by the reference embedded in the document number. Document number names FKIIN38573077
Matched to our invoiceCertain
20250606-A274-YNPL25-26/1281 → YNPL25-26/1281
Matched by an exact invoice number match. FKIIN38573077 matches invoice 2526/1281
Reversal of an earlier noteNeeds review
20250620-A274-RDN-FKIIN38573077_Reversed → 20250620-A274-RDN-FKIIN38573077
Matched by a shared base reference. Shares base reference RDN-FKIIN38573077 but the amounts do not offset
TDS memo against this invoiceCertain
20250606-A274-YNPL25-26/1281-TDS-CM-20304974 → 20250606-A274-YNPL25-26/1281
Matched by the reference embedded in the document number. TDS memo for invoice 2526/1281

Run 721876af-4fea-45ef-8ef8-5412d9b1931d