YNPL25-26/4525

09 Mar 2026FKIIN47855839PO FBSWN07696568Warehouse 0600155

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

Our books

From the Tally ledger and note registers

Invoice
4,96,563.38
Credit notes
-16,916.82
Debit notes
Net due from customer
4,79,646.56
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
4,96,571.74
Debit notes
-2,521.32
Credit notes
Net due
4,94,050.42
TDS deductedExpected 472.93 at 0.1% of taxable value
472.92
Paid in cash
4,93,577.50
Set off against notesBook adjustment, no bank movement
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-8.36
Notes
-14,395.50
Total position difference
-14,403.86
TDS
0.01
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
20260311-0600155-RDN-FKIIN47855839
FKIDN47881396
11 Mar 2026
-16,916.82
FKIIN47855839
This invoice’s payment, 31 Mar 2026 (with 86 other invoices)
Them
Debit noteReversed
20260311-0600155-RDN-FKIIN47855839_Reversed1
FKIDN47881396
11 Mar 2026
14,395.50
FKIIN47855839
Another invoice’s payment16 Apr 2026, settling 15 other invoices
Us
Credit note
26-27/June/05/15
05 Jun 2026
-16,916.82
2526/4525
Not yet recovered
Our notes total -16,916.82Their notes total -2,521.32on invoice 2526/4525

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
20260311-0600155-RDN-FKIIN47855839_Reversed1FKIDN4788139611 Mar 202614,395.5030000035039644216 Apr 20262526/4806, 2526/4819, 2526/4821, 2526/4822, 2526/4823, 2526/4824 and 9 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260309-0600155-YNPL25-26/4525FKIIN4785583909 Mar 20264,96,571.74TDS -472.92its own document numberAug 2025 to till daterows 3591, 4107
TheirsDebit noteCREDIT20260311-0600155-RDN-FKIIN47855839FKIDN4788139611 Mar 2026-16,916.82FKIIN47855839the reference embedded in the document numberAug 2025 to till daterow 3504
TheirsDebit noteSTANDARD20260311-0600155-RDN-FKIIN47855839_Reversed1FKIDN47881396Reversed11 Mar 202614,395.50FKIIN47855839the reference embedded in the document numberAug 2025 to till daterow 3853
OursInvoiceTAX INVOICEYNPL25-26/452509 Mar 20264,96,563.38its own document numberYNPL Ledgerrow 5983
OursCredit noteCredit Note New26-27/June/05/1505 Jun 2026-16,916.822526/4525the reference column in the registerYNPL Ledgerrow 7477

Settlement

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

DatePayment eventKindAmount
31 Mar 20267560178828ZERO BANK ACCSet offAdjusted-16,916.82
31 Mar 20267560178828ZERO BANK ACCSet offAdjusted16,916.82
02 Apr 2026300000338536566HSBC-071050702001-FKICashPaid4,79,182.00
16 Apr 2026300000350396442HSBC-071050702001-FKICashPaid14,395.50

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/June/05/15 → YNPL25-26/4525

    Matched by the reference column in the register. Raised against our invoice 2526/4525

  • Their debit note against this invoiceCertain

    20260311-0600155-RDN-FKIIN47855839 → 20260309-0600155-YNPL25-26/4525

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

  • Their debit note against this invoiceCertain

    20260311-0600155-RDN-FKIIN47855839_Reversed1 → 20260309-0600155-YNPL25-26/4525

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

  • Matched to our invoiceCertain

    20260309-0600155-YNPL25-26/4525 → YNPL25-26/4525

    Matched by an exact invoice number match. FKIIN47855839 matches invoice 2526/4525

  • Reversal of an earlier noteNeeds review

    20260311-0600155-RDN-FKIIN47855839_Reversed1 → 20260311-0600155-RDN-FKIIN47855839

    Matched by a shared base reference. Shares base reference RDN-FKIIN47855839 but the amounts do not offset

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