YNPL25-26/1705

03 Jul 2025FKIIN41475409PO FGB3G06405528Warehouse 0901497

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

Our books

From the Tally ledger and note registers

Invoice: 6,65,816.62
Credit notes: -73,820.74
Debit notes: —
Net due from customer: 5,91,995.88
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: 6,65,818.09
Debit notes: -45,238.43
Credit notes: —
Net due: 6,20,579.66
TDS deductedExpected 634.11 at 0.1% of taxable value: 634.11
Paid in cash: 6,04,475.25
Set off against notesBook adjustment, no bank movement: 15,470.30
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: -1.47
Notes: -28,582.31
Total position difference: -28,583.78
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

20250902-0901497-RDN-FKIIN41475409

FKIDN41547226

02 Sept 2025

-73,820.73

FKIIN41475409

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

Them

Debit noteReversed

20250902-0901497-RDN-FKIIN41475409_Reversed

FKIDN41547226

02 Sept 2025

28,582.30

FKIIN41475409

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

Credit note

26-27/June/08/05

—

08 Jun 2026

-73,820.74

2526/1705

Not yet recovered

Our notes total -73,820.74Their notes total -45,238.43on invoice 2526/1705

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
20250902-0901497-RDN-FKIIN41475409_Reversed	FKIDN41547226	02 Sept 2025	15,470.30	756012923607 Nov 2025	2526/1696, 2526/2879, 2526/3207, 2526/3208, 2526/3209, 2526/3221 and 6 more
20250902-0901497-RDN-FKIIN41475409_Reversed	FKIDN41547226	02 Sept 2025	13,112.00	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/1705FKIIN41475409	03 Jul 2025	6,65,818.09TDS -634.11	—	its own document number	Aug 2025 to till daterow 618
Theirs	Debit noteCREDIT	20250902-0901497-RDN-FKIIN41475409FKIDN41547226	02 Sept 2025	-73,820.73	FKIIN41475409	the reference embedded in the document number	Aug 2025 to till daterow 1033
Theirs	Debit noteSTANDARD	20250902-0901497-RDN-FKIIN41475409_ReversedFKIDN41547226Reversed	02 Sept 2025	28,582.30	FKIIN41475409	the reference embedded in the document number	Aug 2025 to till daterows 1475, 2013
Ours	InvoiceTAX INVOICE	YNPL25-26/1705	03 Jul 2025	6,65,816.62	—	its own document number	YNPL Ledgerrow 2395
Ours	Credit noteCredit Note New	26-27/June/08/05	08 Jun 2026	-73,820.74	2526/1705	the reference column in the register	YNPL Ledgerrow 7611

Settlement

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

Date	Payment event	Kind	Amount
11 Sept 2025	300000160069546HSBC-071050702001-FKI	CashPaid	6,65,183.98
11 Sept 2025	300000160069546HSBC-071050702001-FKI	CashPaid	-73,820.73
23 Oct 2025	300000196555810HSBC-071050702001-FKI	CashPaid	13,112.00
07 Nov 2025	7560129236ZERO BANK ACC	Set offAdjusted	15,470.30

How this was matched

Every link is a rule, never a guess

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

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