YNPL26-27/0127

11 Apr 2026FKIIN49056254PO FBSWN07957038Warehouse 0600155

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

Our books

From the Tally ledger and note registers

Invoice
16,33,753.46
Credit notes
-10,737.31
Debit notes
Net due from customer
16,23,016.15
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
16,33,758.01
Debit notes
-5,487.56
Credit notes
Net due
16,28,270.45
TDS deductedExpected 1,555.96 at 0.1% of taxable value
1,555.96
Paid in cash
16,26,714.49
Set off against notesBook adjustment, no bank movement
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-4.55
Notes
-5,249.75
Total position difference
-5,254.30
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
20260422-0600155-RDN-FKIIN49056254
FKIDN49309663
22 Apr 2026
-10,737.35
FKIIN49056254
This invoice’s payment, 25 Apr 2026 (with 19 other invoices)
Them
Debit noteReversed
20260422-0600155-RDN-FKIIN49056254_Reversed
FKIDN49309663
22 Apr 2026
5,249.79
FKIIN49056254
Another invoice’s payment18 May 2026, settling 54 other invoices
Us
Credit note
26-27/June/18/25
18 Jun 2026
-10,737.31
2627/127
Not yet recovered
Our notes total -10,737.31Their notes total -5,487.56on invoice 2627/127

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
20260422-0600155-RDN-FKIIN49056254_ReversedFKIDN4930966322 Apr 20265,249.7930000038072725218 May 20262627/339, 2627/341, 2627/342, 2627/352, 2627/354, 2627/356 and 48 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260411-0600155-YNPL26-27/0127FKIIN4905625411 Apr 202616,33,758.01TDS -1,555.96its own document numberAug 2025 to till daterows 4366, 4367
TheirsDebit noteCREDIT20260422-0600155-RDN-FKIIN49056254FKIDN4930966322 Apr 2026-10,737.35FKIIN49056254the reference embedded in the document numberAug 2025 to till daterow 3851
TheirsDebit noteSTANDARD20260422-0600155-RDN-FKIIN49056254_ReversedFKIDN49309663Reversed22 Apr 20265,249.79FKIIN49056254the reference embedded in the document numberAug 2025 to till daterow 4703
OursInvoiceTAX INVOICEYNPL26-27/012711 Apr 202616,33,753.46its own document numberYNPL Ledgerrow 6451
OursCredit noteCredit Note New26-27/June/18/2518 Jun 2026-10,737.312627/127the reference column in the registerYNPL Ledgerrow 8113

Settlement

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

DatePayment eventKindAmount
25 Apr 20267560227869ZERO BANK ACCSet offAdjusted-10,737.35
25 Apr 20267560227869ZERO BANK ACCSet offAdjusted10,737.35
27 Apr 2026300000359399502HSBC-071050702001-FKICashPaid16,21,464.70
18 May 2026300000380727252HSBC-071050702001-FKICashPaid5,249.79

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/June/18/25 → YNPL26-27/0127

    Matched by the reference column in the register. Raised against our invoice 2627/127

  • Their debit note against this invoiceCertain

    20260422-0600155-RDN-FKIIN49056254 → 20260411-0600155-YNPL26-27/0127

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

  • Their debit note against this invoiceCertain

    20260422-0600155-RDN-FKIIN49056254_Reversed → 20260411-0600155-YNPL26-27/0127

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

  • Matched to our invoiceCertain

    20260411-0600155-YNPL26-27/0127 → YNPL26-27/0127

    Matched by an exact invoice number match. FKIIN49056254 matches invoice 2627/127

  • Reversal of an earlier noteNeeds review

    20260422-0600155-RDN-FKIIN49056254_Reversed → 20260422-0600155-RDN-FKIIN49056254

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

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