YNPL26-27/0476

07 May 2026FKIIN49792418PO FBSWN08108646Warehouse 0600155

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

Our books

From the Tally ledger and note registers

Invoice: 8,42,210.52
Credit notes: -64,149.44
Debit notes: —
Net due from customer: 7,78,061.08
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: 8,42,214.53
Debit notes: -43,496.90
Credit notes: —
Net due: 7,98,717.63
TDS deductedExpected 802.11 at 0.1% of taxable value: 802.11
Paid in cash: 7,97,915.52
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: -4.01
Notes: -20,652.54
Total position difference: -20,656.55
TDS: —
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

20260521-0600155-RDN-FKIIN49792418

FKIDN50132068

21 May 2026

-64,149.98

FKIIN49792418

This invoice’s payment, 25 May 2026 (with 67 other invoices)

Them

Debit noteReversed

20260521-0600155-RDN-FKIIN49792418_Reversed

FKIDN50132068

21 May 2026

20,653.08

FKIIN49792418

Another invoice’s payment01 Jul 2026, settling 161 other invoices

Credit note

26-27/July/24/26

—

24 Jul 2026

-64,149.44

2627/476

Not yet recovered

Our notes total -64,149.44Their notes total -43,496.90on invoice 2627/476

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
20260521-0600155-RDN-FKIIN49792418_Reversed	FKIDN50132068	21 May 2026	20,653.08	30000042986413301 Jul 2026	2627/1023, 2627/1068, 2627/1070, 2627/1071, 2627/1072, 2627/1073 and 155 more

Raised against another invoice, but recovered from a payment that settled this one

Note	Their reference	Date	Amount	Payment event	Raised against invoice
20260518-0600155-RDN-FKIIN49997221	FKIDN50034062	18 May 2026	-9,000.00	30000038819442325 May 2026	YNPL26-27/0577

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	20260507-0600155-YNPL26-27/0476FKIIN49792418	07 May 2026	8,42,214.53TDS -802.11	—	its own document number	Aug 2025 to till daterow 4879
Theirs	Debit noteCREDIT	20260521-0600155-RDN-FKIIN49792418FKIDN50132068	21 May 2026	-64,149.98	FKIIN49792418	the reference embedded in the document number	Aug 2025 to till daterow 4625
Theirs	Debit noteSTANDARD	20260521-0600155-RDN-FKIIN49792418_ReversedFKIDN50132068Reversed	21 May 2026	20,653.08	FKIIN49792418	the reference embedded in the document number	Aug 2025 to till daterow 6685
Ours	InvoiceTAX INVOICE	YNPL26-27/0476	07 May 2026	8,42,210.52	—	its own document number	YNPL Ledgerrow 6892
Ours	Credit noteCredit Note New	26-27/July/24/26	24 Jul 2026	-64,149.44	2627/476	the reference column in the register	YNPL Ledgerrow 9488

Settlement

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

Date	Payment event	Kind	Amount
25 May 2026	300000388194423HSBC-071050702001-FKI	CashPaid	-64,149.98
25 May 2026	300000388194423HSBC-071050702001-FKI	CashPaid	8,41,412.42
01 Jul 2026	300000429864133HSBC-071050702001-FKI	CashPaid	20,653.08

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
26-27/July/24/26 → YNPL26-27/0476
Matched by the reference column in the register. Raised against our invoice 2627/476
Their debit note against this invoiceCertain
20260521-0600155-RDN-FKIIN49792418 → 20260507-0600155-YNPL26-27/0476
Matched by the reference embedded in the document number. Document number names FKIIN49792418
Their debit note against this invoiceCertain
20260521-0600155-RDN-FKIIN49792418_Reversed → 20260507-0600155-YNPL26-27/0476
Matched by the reference embedded in the document number. Document number names FKIIN49792418
Matched to our invoiceCertain
20260507-0600155-YNPL26-27/0476 → YNPL26-27/0476
Matched by an exact invoice number match. FKIIN49792418 matches invoice 2627/476
Reversal of an earlier noteNeeds review
20260521-0600155-RDN-FKIIN49792418_Reversed → 20260521-0600155-RDN-FKIIN49792418
Matched by a shared base reference. Shares base reference RDN-FKIIN49792418 but the amounts do not offset

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