YNPL25-26/0246

12 Apr 2025FKIIN36624319PO FBSWN06085957Warehouse 2140

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

Our books

From the Tally ledger and note registers

Invoice: 1,25,984.59
Credit notes: -21,639.96
Debit notes: —
Net due from customer: 1,04,344.63
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: 1,25,984.97
Debit notes: 21,640.08
Credit notes: —
Net due: 1,47,625.05
TDS deductedExpected 119.99 at 0.1% of taxable value: —
Paid in cash: 1,25,865.89
Set off against notesBook adjustment, no bank movement: —
Outstanding: 21,759.16

Difference, by cause

The parts add up to the total exactly

Invoice amount: -0.38
Notes: -43,280.04
Total position difference: -43,280.42
TDS: 119.99
UnexplainedEvery rupee of difference is attributed to a cause: 0.00

Credit and debit notes

2 notes in the order they were raised

Raised by

Type

Document number

Their reference

Date

Amount

Raised against

Recovered in

Them

Debit noteReversed

20250505-2140-RDN-FKIIN36624319_Reversed

FKIDN37326167

05 May 2025

21,640.08

FKIIN36624319

Another invoice’s payment03 Jul 2025, settling 40 other invoices

Credit note

FKIDN37326167

—

11 May 2025

-21,639.96

FKIDN37326167

Not yet recovered

Our notes total -21,639.96Their notes total 21,640.08on invoice 2526/246

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
20250505-2140-RDN-FKIIN36624319_Reversed	FKIDN37326167	05 May 2025	21,640.08	HSBCN1845618898403 Jul 2025	2425/2531, 2425/2754, 2425/2786, 2425/3218, 2526/1212, 2526/1224 and 34 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	20250412-2140-YNPL25-26/0246FKIIN36624319	12 Apr 2025	1,25,984.97	—	its own document number	Jan 2025 to July 2025row 760
Theirs	Debit noteSTANDARD	20250505-2140-RDN-FKIIN36624319_ReversedFKIDN37326167Reversed	05 May 2025	21,640.08	FKIIN36624319	the reference embedded in the document number	Jan 2025 to July 2025row 1765
Ours	InvoiceTAX INVOICE	YNPL25-26/0246	12 Apr 2025	1,25,984.59	—	its own document number	YNPL Ledgerrow 252
Ours	Credit noteCREDIT NOTE-25	FKIDN37326167	11 May 2025	-21,639.96	FKIDN37326167	our voucher number naming their note	YNPL Ledgerrow 1082

Settlement

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

Date	Payment event	Kind	Amount
12 May 2025	HSBCN13342973242HDFC BANK LTD	CashActual Payment	1,04,225.81
03 Jul 2025	HSBCN18456188984HDFC BANK LTD	CashActual Payment	21,640.08

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN37326167 → 20250505-2140-RDN-FKIIN36624319_Reversed
Matched by an exact voucher number match. Voucher number is their note FKIDN37326167
Their debit note against this invoiceCertain
20250505-2140-RDN-FKIIN36624319_Reversed → 20250412-2140-YNPL25-26/0246
Matched by the reference embedded in the document number. Document number names FKIIN36624319
Matched to our invoiceCertain
20250412-2140-YNPL25-26/0246 → YNPL25-26/0246
Matched by an exact invoice number match. FKIIN36624319 matches invoice 2526/246

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