YNPL25-26/4531

09 Mar 2026FKIIN47854106PO FSGWN07770786Warehouse 0600386

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

Our books

From the Tally ledger and note registers

Invoice
9,85,957.25
Credit notes
-76,325.07
Debit notes
Net due from customer
9,09,632.18
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,85,960.32
Debit notes
-22,891.27
Credit notes
Net due
9,63,069.05
TDS deductedExpected 939.01 at 0.1% of taxable value
939.01
Paid in cash
9,62,130.04
Set off against notesBook adjustment, no bank movement
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-3.07
Notes
-53,433.80
Total position difference
-53,436.87
TDS
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
20260317-0600386-RDN-FKIIN47854106
FKIDN48041917
17 Mar 2026
-76,325.77
FKIIN47854106
This invoice’s payment, 31 Mar 2026 (with 86 other invoices)
Them
Debit noteReversed
20260317-0600386-RDN-FKIIN47854106_Reversed1
FKIDN48041917
17 Mar 2026
53,434.50
FKIIN47854106
Another invoice’s payment16 Apr 2026, settling 15 other invoices
Us
Credit note
26-27/Apr/16/08
16 Apr 2026
-76,325.07
2526/4531
Not yet recovered
Our notes total -76,325.07Their notes total -22,891.27on invoice 2526/4531

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
20260317-0600386-RDN-FKIIN47854106_Reversed1FKIDN4804191717 Mar 202653,434.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-0600386-YNPL25-26/4531FKIIN4785410609 Mar 20269,85,960.32TDS -939.01its own document numberAug 2025 to till daterows 3660, 4242
TheirsDebit noteCREDIT20260317-0600386-RDN-FKIIN47854106FKIDN4804191717 Mar 2026-76,325.77FKIIN47854106the reference embedded in the document numberAug 2025 to till daterow 3810
TheirsDebit noteSTANDARD20260317-0600386-RDN-FKIIN47854106_Reversed1FKIDN48041917Reversed17 Mar 202653,434.50FKIIN47854106the reference embedded in the document numberAug 2025 to till daterow 3868
OursInvoiceTAX INVOICEYNPL25-26/453109 Mar 20269,85,957.25its own document numberYNPL Ledgerrow 5989
OursCredit noteCredit Note New26-27/Apr/16/0816 Apr 2026-76,325.072526/4531the reference column in the registerYNPL Ledgerrow 6541

Settlement

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

DatePayment eventKindAmount
31 Mar 20267560178828ZERO BANK ACCSet offAdjusted76,325.77
31 Mar 20267560178828ZERO BANK ACCSet offAdjusted-76,325.77
02 Apr 2026300000338536566HSBC-071050702001-FKICashPaid9,08,695.54
16 Apr 2026300000350396442HSBC-071050702001-FKICashPaid53,434.50

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/Apr/16/08 → YNPL25-26/4531

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

  • Their debit note against this invoiceCertain

    20260317-0600386-RDN-FKIIN47854106 → 20260309-0600386-YNPL25-26/4531

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

  • Their debit note against this invoiceCertain

    20260317-0600386-RDN-FKIIN47854106_Reversed1 → 20260309-0600386-YNPL25-26/4531

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

  • Matched to our invoiceCertain

    20260309-0600386-YNPL25-26/4531 → YNPL25-26/4531

    Matched by an exact invoice number match. FKIIN47854106 matches invoice 2526/4531

  • Reversal of an earlier noteNeeds review

    20260317-0600386-RDN-FKIIN47854106_Reversed1 → 20260317-0600386-RDN-FKIIN47854106

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

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