YLedger Reconciliation

YNPL25-26/1940

22 Jul 2025FKIIN40148922PO FBSWN06545133Warehouse 0600155

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

Our books

From the Tally ledger and note registers

Invoice
5,93,114.30
Credit notes
-15,251.76
Debit notes
—
Net due from customer
5,77,862.54
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
5,93,115.52
Debit notes
-2,826.95
Credit notes
—
Net due
5,90,288.57
TDS deductedExpected 564.87 at 0.1% of taxable value
564.54
Paid in cash
5,89,724.03
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-1.22
Notes
-12,424.81
Total position difference
-12,426.03
TDS
0.33
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
20250819-0600155-RDN-FKIIN40148922
FKIDN41055002
19 Aug 2025
-15,251.87
FKIIN40148922
This invoice’s payment, 25 Aug 2025 (with 52 other invoices)
Them
Debit noteReversed
20250819-0600155-RDN-FKIIN40148922_Reversed
FKIDN41055002
19 Aug 2025
12,424.92
FKIIN40148922
Another invoice’s payment29 Sept 2025, settling 10 other invoices
Us
Credit note
FKIDN41055002
—
04 Sept 2025
-15,251.76
FKIDN41055002
Not yet recovered
Our notes total -15,251.76Their notes total -2,826.95on invoice 2526/1940

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
20250819-0600155-RDN-FKIIN40148922_ReversedFKIDN4105500219 Aug 202512,424.9230000017626643129 Sept 20252526/2602, 2526/2603, 2526/2613, 2526/2615, 2526/2616, 2526/2617 and 4 more

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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250820-0600155-RDN-FKIIN40626426FKIDN4110278620 Aug 2025-1,54,759.3330000011026398825 Aug 2025YNPL25-26/2092
20250813-0700010-RDN-FKIIN40274398FKIDN4087403913 Aug 2025-12,037.1430000011026398825 Aug 2025YNPL25-26/1994
20250814-0600159-RDN-FKIIN40402417FKIDN4088081714 Aug 2025-2,583.0830000011026398825 Aug 2025YNPL25-26/2013
20250818-0600155-RDN-FKIIN40610437FKICN4101911318 Aug 20252,541.4230000011026398825 Aug 2025YNPL25-26/2089

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250722-0600155-YNPL25-26/1940FKIIN4014892222 Jul 20255,93,115.52TDS -564.54—its own document numberAug 2025 to till daterow 12
TheirsDebit noteCREDIT20250819-0600155-RDN-FKIIN40148922FKIDN4105500219 Aug 2025-15,251.87FKIIN40148922the reference embedded in the document numberAug 2025 to till daterow 77
TheirsDebit noteSTANDARD20250819-0600155-RDN-FKIIN40148922_ReversedFKIDN41055002Reversed19 Aug 202512,424.92FKIIN40148922the reference embedded in the document numberAug 2025 to till daterow 642
OursInvoiceTAX INVOICEYNPL25-26/194022 Jul 20255,93,114.30—its own document numberYNPL Ledgerrow 2805
OursCredit noteCREDIT NOTE-25FKIDN4105500204 Sept 2025-15,251.76FKIDN41055002our voucher number naming their noteYNPL Ledgerrow 3519

Settlement

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

DatePayment eventKindAmount
25 Aug 2025300000110263988HSBC-071050702001-FKICashPaid5,92,550.98
25 Aug 2025300000110263988HSBC-071050702001-FKICashPaid-15,251.87
29 Sept 2025300000176266431HSBC-071050702001-FKICashPaid12,424.92

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN41055002 → 20250819-0600155-RDN-FKIIN40148922

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

  • Their debit note against this invoiceCertain

    20250819-0600155-RDN-FKIIN40148922 → 20250722-0600155-YNPL25-26/1940

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

  • Their debit note against this invoiceCertain

    20250819-0600155-RDN-FKIIN40148922_Reversed → 20250722-0600155-YNPL25-26/1940

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

  • Matched to our invoiceCertain

    20250722-0600155-YNPL25-26/1940 → YNPL25-26/1940

    Matched by an exact invoice number match. FKIIN40148922 matches invoice 2526/1940

  • Reversal of an earlier noteNeeds review

    20250819-0600155-RDN-FKIIN40148922_Reversed → 20250819-0600155-RDN-FKIIN40148922

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

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