YNPL25-26/1706

03 Jul 2025FKIIN41475384PO FGB3G06405528Warehouse 0901497

DEBIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by -Rs 54,771.44TDS short deducted by Rs 1.69A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice: 4,57,394.31
Credit notes: -98,342.04
Debit notes: —
Net due from customer: 3,59,052.27
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: 4,57,396.27
Debit notes: -43,570.60
Credit notes: —
Net due: 4,13,825.67
TDS deductedExpected 435.62 at 0.1% of taxable value: 433.93
Paid in cash: 4,13,391.74
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: -1.96
Notes: -54,771.44
Total position difference: -54,773.40
TDS: 1.69
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

20250906-0901497-RDN-FKIIN41475384

FKIDN41659058

06 Sept 2025

-98,341.54

FKIIN41475384

This invoice’s payment, 11 Sept 2025 (with 33 other invoices)

Them

Debit noteReversed

20250906-0901497-RDN-FKIIN41475384_Reversed

FKIDN41659058

06 Sept 2025

54,770.94

FKIIN41475384

Another invoice’s payment23 Oct 2025, settling 37 other invoices

Credit note

26-27/June/08/06

—

08 Jun 2026

-98,342.04

2526/1706

Not yet recovered

Our notes total -98,342.04Their notes total -43,570.60on invoice 2526/1706

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
20250906-0901497-RDN-FKIIN41475384_Reversed	FKIDN41659058	06 Sept 2025	54,770.94	30000019655581023 Oct 2025	2526/2608, 2526/2848, 2526/2855, 2526/2946, 2526/2976, 2526/2982 and 31 more

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

Note	Their reference	Date	Amount	Payment event	Raised against invoice
20250906-0700010-RDN-FKIIN41212124	FKIDN41654156	06 Sept 2025	-434.56	30000016006954611 Sept 2025	YNPL25-26/2276

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	20250703-0901497-YNPL25-26/1706FKIIN41475384	03 Jul 2025	4,57,396.27TDS -433.93	—	its own document number	Aug 2025 to till daterow 757
Theirs	Debit noteCREDIT	20250906-0901497-RDN-FKIIN41475384FKIDN41659058	06 Sept 2025	-98,341.54	FKIIN41475384	the reference embedded in the document number	Aug 2025 to till daterow 523
Theirs	Debit noteSTANDARD	20250906-0901497-RDN-FKIIN41475384_ReversedFKIDN41659058Reversed	06 Sept 2025	54,770.94	FKIIN41475384	the reference embedded in the document number	Aug 2025 to till daterow 1713
Ours	InvoiceTAX INVOICE	YNPL25-26/1706	03 Jul 2025	4,57,394.31	—	its own document number	YNPL Ledgerrow 2396
Ours	Credit noteCredit Note New	26-27/June/08/06	08 Jun 2026	-98,342.04	2526/1706	the reference column in the register	YNPL Ledgerrow 7612

Settlement

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

Date	Payment event	Kind	Amount
11 Sept 2025	300000160069546HSBC-071050702001-FKI	CashPaid	-98,341.54
11 Sept 2025	300000160069546HSBC-071050702001-FKI	CashPaid	4,56,962.34
23 Oct 2025	300000196555810HSBC-071050702001-FKI	CashPaid	54,770.94

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
26-27/June/08/06 → YNPL25-26/1706
Matched by the reference column in the register. Raised against our invoice 2526/1706
Their debit note against this invoiceCertain
20250906-0901497-RDN-FKIIN41475384 → 20250703-0901497-YNPL25-26/1706
Matched by the reference embedded in the document number. Document number names FKIIN41475384
Their debit note against this invoiceCertain
20250906-0901497-RDN-FKIIN41475384_Reversed → 20250703-0901497-YNPL25-26/1706
Matched by the reference embedded in the document number. Document number names FKIIN41475384
Matched to our invoiceCertain
20250703-0901497-YNPL25-26/1706 → YNPL25-26/1706
Matched by an exact invoice number match. FKIIN41475384 matches invoice 2526/1706
Reversal of an earlier noteNeeds review
20250906-0901497-RDN-FKIIN41475384_Reversed → 20250906-0901497-RDN-FKIIN41475384
Matched by a shared base reference. Shares base reference RDN-FKIIN41475384 but the amounts do not offset

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