YNPL25-26/1519

19 Jun 2025FKIIN39011590PO FBSWN06386987Warehouse 2140

Back to register
DEBIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by -Rs 80,133.90A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice
9,07,686.16
Credit notes
-40,066.95
Debit notes
Net due from customer
8,67,619.21
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
9,07,687.53
Debit notes
40,066.95
Credit notes
Net due
9,47,754.48
TDS deductedExpected 864.46 at 0.1% of taxable value
Paid in cash
9,06,823.07
Set off against notesBook adjustment, no bank movement
Outstanding
40,931.41

Difference, by cause

The parts add up to the total exactly

Invoice amount
-1.37
Notes
-80,133.90
Total position difference
-80,135.27
TDS
864.46
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
20250707-2140-RDN-FKIIN39011590_Reversed
FKIDN39479055
07 Jul 2025
40,066.95
FKIIN39011590
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Us
Credit note
FKIDN39479055
08 Jul 2025
-40,066.95
FKIDN39479055
Not yet recovered
Our notes total -40,066.95Their notes total 40,066.95on invoice 2526/1519

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

NoteTheir referenceDateAmountPayment eventPayment settled invoices
20250707-2140-RDN-FKIIN39011590_ReversedFKIDN3947905507 Jul 202540,066.9530000025722468105 Jan 20262526/3694, 2526/3785, 2526/3786, 2526/3789, 2526/3795, 2526/3796 and 11 more

Source documents

Every row that contributed, with the file and Excel row it came from

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250619-2140-YNPL25-26/1519FKIIN3901159019 Jun 20259,07,687.53its own document numberJan 2025 to July 2025row 1865
TheirsDebit noteSTANDARD20250707-2140-RDN-FKIIN39011590_ReversedFKIDN39479055Reversed07 Jul 202540,066.95FKIIN39011590the reference embedded in the document numberAug 2025 to till daterow 2933
OursInvoiceTAX INVOICEYNPL25-26/151919 Jun 20259,07,686.16its own document numberYNPL Ledgerrow 2026
OursCredit noteCREDIT NOTE-25FKIDN3947905508 Jul 2025-40,066.95FKIDN39479055our voucher number naming their noteYNPL Ledgerrow 2525

Settlement

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

DatePayment eventKindAmount
10 Jul 2025HSBCN19158084082HDFC BANK LTDCashActual Payment8,66,756.12
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid40,066.95

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN39479055 → 20250707-2140-RDN-FKIIN39011590_Reversed

    Matched by an exact voucher number match. Voucher number is their note FKIDN39479055

  • Their debit note against this invoiceCertain

    20250707-2140-RDN-FKIIN39011590_Reversed → 20250619-2140-YNPL25-26/1519

    Matched by the reference embedded in the document number. Document number names FKIIN39011590

  • Matched to our invoiceCertain

    20250619-2140-YNPL25-26/1519 → YNPL25-26/1519

    Matched by an exact invoice number match. FKIIN39011590 matches invoice 2526/1519

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