YNPL25-26/1494

18 Jun 2025FKIIN39123471PO FBSWN06358396Warehouse 2140

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

Our books

From the Tally ledger and note registers

Invoice: 8,95,228.70
Credit notes: -1,56,625.35
Debit notes: —
Net due from customer: 7,38,603.35
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,95,230.07
Debit notes: 43,709.40
Credit notes: —
Net due: 9,38,939.47
TDS deductedExpected 852.60 at 0.1% of taxable value: —
Paid in cash: 7,81,448.19
Set off against notesBook adjustment, no bank movement: —
Outstanding: 1,57,491.28

Difference, by cause

The parts add up to the total exactly

Invoice amount: -1.37
Notes: -2,00,334.75
Total position difference: -2,00,336.12
TDS: 852.60
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

20250703-2140-RDN-FKIIN39123471_Reversed

FKIDN39366582

03 Jul 2025

43,709.40

FKIIN39123471

Another invoice’s payment01 Sept 2025, settling 15 other invoices

Credit note

FKIDN39366582

—

16 Jul 2025

-1,56,625.35

FKIDN39366582

Not yet recovered

Our notes total -1,56,625.35Their notes total 43,709.40on invoice 2526/1494

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
20250703-2140-RDN-FKIIN39123471_Reversed	FKIDN39366582	03 Jul 2025	43,709.40	30000014818051701 Sept 2025	2526/1670, 2526/1697, 2526/1714, 2526/1989, 2526/2061, 2526/2092 and 9 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	20250618-2140-YNPL25-26/1494FKIIN39123471	18 Jun 2025	8,95,230.07	—	its own document number	Jan 2025 to July 2025row 1867
Theirs	Debit noteSTANDARD	20250703-2140-RDN-FKIIN39123471_ReversedFKIDN39366582Reversed	03 Jul 2025	43,709.40	FKIIN39123471	the reference embedded in the document number	Aug 2025 to till daterow 489
Ours	InvoiceTAX INVOICE	YNPL25-26/1494	18 Jun 2025	8,95,228.70	—	its own document number	YNPL Ledgerrow 1998
Ours	Credit noteCREDIT NOTE-25	FKIDN39366582	16 Jul 2025	-1,56,625.35	FKIDN39366582	our voucher number naming their note	YNPL Ledgerrow 2684

Settlement

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

Date	Payment event	Kind	Amount
10 Jul 2025	HSBCN19158084082HDFC BANK LTD	CashActual Payment	7,37,738.79
01 Sept 2025	300000148180517HSBC-071050702001-FKI	CashPaid	43,709.40

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN39366582 → 20250703-2140-RDN-FKIIN39123471_Reversed
Matched by an exact voucher number match. Voucher number is their note FKIDN39366582
Their debit note against this invoiceCertain
20250703-2140-RDN-FKIIN39123471_Reversed → 20250618-2140-YNPL25-26/1494
Matched by the reference embedded in the document number. Document number names FKIIN39123471
Matched to our invoiceCertain
20250618-2140-YNPL25-26/1494 → YNPL25-26/1494
Matched by an exact invoice number match. FKIIN39123471 matches invoice 2526/1494

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