YNPL25-26/1495

18 Jun 2025FKIIN39079440PO FBSWN06386987Warehouse 2140

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

Our books

From the Tally ledger and note registers

Invoice: 8,62,196.61
Credit notes: -26,262.50
Debit notes: —
Net due from customer: 8,35,934.11
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,62,199.60
Debit notes: 14,060.03
Credit notes: —
Net due: 8,76,259.63
TDS deductedExpected 821.14 at 0.1% of taxable value: —
Paid in cash: 8,49,175.89
Set off against notesBook adjustment, no bank movement: —
Outstanding: 27,083.74

Difference, by cause

The parts add up to the total exactly

Invoice amount: -2.99
Notes: -40,322.53
Total position difference: -40,325.52
TDS: 821.14
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

20250702-2140-RDN-FKIIN39079440_Reversed

FKIDN39341731

02 Jul 2025

14,060.03

FKIIN39079440

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

Credit note

FKIDN39341731

—

06 Jul 2025

-26,262.50

FKIDN39341731

Not yet recovered

Our notes total -26,262.50Their notes total 14,060.03on invoice 2526/1495

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
20250702-2140-RDN-FKIIN39079440_Reversed	FKIDN39341731	02 Jul 2025	14,060.03	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/1495FKIIN39079440	18 Jun 2025	8,62,199.60	—	its own document number	Jan 2025 to July 2025row 1797
Theirs	Debit noteSTANDARD	20250702-2140-RDN-FKIIN39079440_ReversedFKIDN39341731Reversed	02 Jul 2025	14,060.03	FKIIN39079440	the reference embedded in the document number	Aug 2025 to till daterow 893
Ours	InvoiceTAX INVOICE	YNPL25-26/1495	18 Jun 2025	8,62,196.61	—	its own document number	YNPL Ledgerrow 1999
Ours	Credit noteCREDIT NOTE-25	FKIDN39341731	06 Jul 2025	-26,262.50	FKIDN39341731	our voucher number naming their note	YNPL Ledgerrow 2467

Settlement

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

Date	Payment event	Kind	Amount
07 Jul 2025	HSBCN18857228258HDFC BANK LTD	CashActual Payment	8,35,115.86
01 Sept 2025	300000148180517HSBC-071050702001-FKI	CashPaid	14,060.03

How this was matched

Every link is a rule, never a guess

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

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