YLedger Reconciliation

YNPL25-26/4427

23 Feb 2026FKIIN47524239PO FBSWN07696568Warehouse 0600155

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

Our books

From the Tally ledger and note registers

Invoice
12,97,294.01
Credit notes
-76,860.21
Debit notes
—
Net due from customer
12,20,433.80
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
12,97,299.31
Debit notes
-74,109.39
Credit notes
—
Net due
12,23,189.92
TDS deductedExpected 1,235.52 at 0.1% of taxable value
1,235.52
Paid in cash
12,21,954.40
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-5.30
Notes
-2,750.82
Total position difference
-2,756.12
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
20260303-0600155-RDN-FKIIN47524239
FKIDN47704007
03 Mar 2026
-76,860.60
FKIIN47524239
This invoice’s payment, 09 Mar 2026 (with 28 other invoices)
Them
Debit noteReversed
20260303-0600155-RDN-FKIIN47524239_Reversed1
FKIDN47704007
03 Mar 2026
2,751.21
FKIIN47524239
Another invoice’s payment16 Apr 2026, settling 15 other invoices
Us
Credit note
26-27/Apr/21/06
—
21 Apr 2026
-76,860.21
2526/4427
Not yet recovered
Our notes total -76,860.21Their notes total -74,109.39on invoice 2526/4427

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
20260303-0600155-RDN-FKIIN47524239_Reversed1FKIDN4770400703 Mar 20262,751.2130000035039644216 Apr 20262526/4806, 2526/4819, 2526/4821, 2526/4822, 2526/4823, 2526/4824 and 9 more

Raised against another invoice, but recovered from a payment that settled this one

NoteTheir referenceDateAmountPayment eventRaised against invoice
20260217-0600155-RDN-FKIIN47008851_ReversedFKIDN4714959117 Feb 202611,397.7530000031592582809 Mar 2026YNPL25-26/4308
20260224-0600155-RDN-FKIIN47307197_ReversedFKIDN4749239124 Feb 20266,717.3830000031592582809 Mar 2026YNPL25-26/4384
20260222-0600155-RDN-FKIIN47199540_ReversedFKIDN4743587222 Feb 20266,158.2530000031592582809 Mar 2026YNPL25-26/4349
20260202-0600155-RDN-FKIIN46498937_ReversedFKIDN4651018902 Feb 20262,987.3830000031592582809 Mar 2026YNPL25-26/4192

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260223-0600155-YNPL25-26/4427FKIIN4752423923 Feb 202612,97,299.31TDS -1,235.52—its own document numberAug 2025 to till daterows 3756, 3757
TheirsDebit noteCREDIT20260303-0600155-RDN-FKIIN47524239FKIDN4770400703 Mar 2026-76,860.60FKIIN47524239the reference embedded in the document numberAug 2025 to till daterow 3584
TheirsDebit noteSTANDARD20260303-0600155-RDN-FKIIN47524239_Reversed1FKIDN47704007Reversed03 Mar 20262,751.21FKIIN47524239the reference embedded in the document numberAug 2025 to till daterow 3880
OursInvoiceTAX INVOICEYNPL25-26/442723 Feb 202612,97,294.01—its own document numberYNPL Ledgerrow 5874
OursCredit noteCredit Note New26-27/Apr/21/0621 Apr 2026-76,860.212526/4427the reference column in the registerYNPL Ledgerrow 6634

Settlement

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

DatePayment eventKindAmount
09 Mar 2026300000315925828HSBC-071050702001-FKICashPaid-76,860.60
09 Mar 2026300000315925828HSBC-071050702001-FKICashPaid12,40,492.79
12 Mar 2026300000318788108HSBC-071050702001-FKICashPaid55,571.00
16 Apr 2026300000350396442HSBC-071050702001-FKICashPaid2,751.21

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/Apr/21/06 → YNPL25-26/4427

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

  • Their debit note against this invoiceCertain

    20260303-0600155-RDN-FKIIN47524239 → 20260223-0600155-YNPL25-26/4427

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

  • Their debit note against this invoiceCertain

    20260303-0600155-RDN-FKIIN47524239_Reversed1 → 20260223-0600155-YNPL25-26/4427

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

  • Matched to our invoiceCertain

    20260223-0600155-YNPL25-26/4427 → YNPL25-26/4427

    Matched by an exact invoice number match. FKIIN47524239 matches invoice 2526/4427

  • Reversal of an earlier noteNeeds review

    20260303-0600155-RDN-FKIIN47524239_Reversed1 → 20260303-0600155-RDN-FKIIN47524239

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

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