YNPL25-26/1685

01 Jul 2025FKIIN39375905PO FBSWN06420945Warehouse 2140

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

Our books

From the Tally ledger and note registers

Invoice: 8,60,784.32
Credit notes: -28,564.68
Debit notes: —
Net due from customer: 8,32,219.64
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,60,786.11
Debit notes: 10,567.87
Credit notes: —
Net due: 8,71,353.98
TDS deductedExpected 819.80 at 0.1% of taxable value: —
Paid in cash: 8,41,971.47
Set off against notesBook adjustment, no bank movement: —
Outstanding: 29,382.51

Difference, by cause

The parts add up to the total exactly

Invoice amount: -1.79
Notes: -39,132.55
Total position difference: -39,134.34
TDS: 819.80
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

20250716-2140-RDN-FKIIN39375905_Reversed

FKIDN39796226

16 Jul 2025

10,567.87

FKIIN39375905

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

Credit note

FKIDN39796226

—

23 Jul 2025

-28,564.68

FKIDN39796226

Not yet recovered

Our notes total -28,564.68Their notes total 10,567.87on invoice 2526/1685

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
20250716-2140-RDN-FKIIN39375905_Reversed	FKIDN39796226	16 Jul 2025	10,567.87	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	20250701-2140-YNPL25-26/1685FKIIN39375905	01 Jul 2025	8,60,786.11	—	its own document number	Jan 2025 to July 2025row 1994
Theirs	Debit noteSTANDARD	20250716-2140-RDN-FKIIN39375905_ReversedFKIDN39796226Reversed	16 Jul 2025	10,567.87	FKIIN39375905	the reference embedded in the document number	Aug 2025 to till daterow 578
Ours	InvoiceTAX INVOICE	YNPL25-26/1685	01 Jul 2025	8,60,784.32	—	its own document number	YNPL Ledgerrow 2349
Ours	Credit noteCREDIT NOTE-25	FKIDN39796226	23 Jul 2025	-28,564.68	FKIDN39796226	our voucher number naming their note	YNPL Ledgerrow 2821

Settlement

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

Date	Payment event	Kind	Amount
21 Jul 2025	HSBCN20260141091HDFC BANK LTD	CashActual Payment	8,31,403.60
01 Sept 2025	300000148180517HSBC-071050702001-FKI	CashPaid	10,567.87

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN39796226 → 20250716-2140-RDN-FKIIN39375905_Reversed
Matched by an exact voucher number match. Voucher number is their note FKIDN39796226
Their debit note against this invoiceCertain
20250716-2140-RDN-FKIIN39375905_Reversed → 20250701-2140-YNPL25-26/1685
Matched by the reference embedded in the document number. Document number names FKIIN39375905
Matched to our invoiceCertain
20250701-2140-YNPL25-26/1685 → YNPL25-26/1685
Matched by an exact invoice number match. FKIIN39375905 matches invoice 2526/1685

Run ee373c98-4948-4d9d-8585-10ded418bd78