YLedger Reconciliation

YNPL25-26/1419

12 Jun 2025FKIIN38788864PO FBSWN06358396Warehouse 2140

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

Our books

From the Tally ledger and note registers

Invoice
12,58,920.24
Credit notes
-3,665.05
Debit notes
—
Net due from customer
12,55,255.19
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,58,922.74
Debit notes
3,621.24
Credit notes
—
Net due
12,62,543.98
TDS deductedExpected 1,198.97 at 0.1% of taxable value
—
Paid in cash
12,57,681.26
Set off against notesBook adjustment, no bank movement
—
Outstanding
4,862.72

Difference, by cause

The parts add up to the total exactly

Invoice amount
-2.50
Notes
-7,286.29
Total position difference
-7,288.79
TDS
1,198.97
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
20250710-2140-RDN-FKIIN38788864_Reversed
FKIDN39583148
10 Jul 2025
3,621.24
FKIIN38788864
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Us
Credit note
FKIDN39583148
—
16 Jul 2025
-3,665.05
FKIDN39583148
Not yet recovered
Our notes total -3,665.05Their notes total 3,621.24on invoice 2526/1419

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
20250710-2140-RDN-FKIIN38788864_ReversedFKIDN3958314810 Jul 20253,621.2430000025722468105 Jan 20262526/3694, 2526/3785, 2526/3786, 2526/3789, 2526/3795, 2526/3796 and 11 more

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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250611-2140-RDN-FKIIN38319148_ReversedFKIDN3864927111 Jun 202556,754.18HSBCN1955877580514 Jul 2025YNPL25-26/1120
20250620-A274-RDN-FKIIN38573077_ReversedFKIDN3896690120 Jun 202523,124.50HSBCN1955877580514 Jul 2025YNPL25-26/1281
20250613-2140-RDN-FKIIN38453187_ReversedFKIDN3871530713 Jun 20256,756.87HSBCN1955877580514 Jul 2025YNPL25-26/1151
20250616-6461-RDN-FKIIN38404995_ReversedFKIDN3881456716 Jun 20255,452.42HSBCN1955877580514 Jul 2025YNPL25-26/1192
20250606-2140-RDN-FKIIN38080470_ReversedFKIDN3849534006 Jun 2025752.05HSBCN1955877580514 Jul 2025YNPL25-26/0995

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250612-2140-YNPL25-26/1419FKIIN3878886412 Jun 202512,58,922.74—its own document numberJan 2025 to July 2025row 1903
TheirsDebit noteSTANDARD20250710-2140-RDN-FKIIN38788864_ReversedFKIDN39583148Reversed10 Jul 20253,621.24FKIIN38788864the reference embedded in the document numberAug 2025 to till daterow 2819
OursInvoiceTAX INVOICEYNPL25-26/141912 Jun 202512,58,920.24—its own document numberYNPL Ledgerrow 1884
OursCredit noteCREDIT NOTE-25FKIDN3958314816 Jul 2025-3,665.05FKIDN39583148our voucher number naming their noteYNPL Ledgerrow 2683

Settlement

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

DatePayment eventKindAmount
14 Jul 2025HSBCN19558775805HDFC BANK LTDCashActual Payment12,54,060.02
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid3,621.24

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN39583148 → 20250710-2140-RDN-FKIIN38788864_Reversed

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

  • Their debit note against this invoiceCertain

    20250710-2140-RDN-FKIIN38788864_Reversed → 20250612-2140-YNPL25-26/1419

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

  • Matched to our invoiceCertain

    20250612-2140-YNPL25-26/1419 → YNPL25-26/1419

    Matched by an exact invoice number match. FKIIN38788864 matches invoice 2526/1419

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