YLedger Reconciliation

YNPL25-26/2377

25 Aug 2025FKIIN41325103PO FBSWN06702813Warehouse 0600155

Back to register
DEBIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by -Rs 46,640.17

Our books

From the Tally ledger and note registers

Invoice
7,84,953.86
Credit notes
-46,640.17
Debit notes
—
Net due from customer
7,38,313.69
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
7,84,957.48
Debit notes
—
Credit notes
—
Net due
7,84,957.48
TDS deductedExpected 747.58 at 0.1% of taxable value
747.58
Paid in cash
7,84,209.90
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.62
Notes
-46,640.17
Total position difference
-46,643.79
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
20250908-0600155-RDN-FKIIN41325103
FKIDN41670734
08 Sept 2025
-46,640.16
FKIIN41325103
This invoice’s payment, 11 Sept 2025 (with 33 other invoices)
Them
Debit noteReversed
20250908-0600155-RDN-FKIIN41325103_Reversed
FKIDN41670734
08 Sept 2025
46,640.16
FKIIN41325103
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Us
Credit note
FKIDN41670734
—
17 Sept 2025
-46,640.17
FKIDN41670734
Not yet recovered
Our notes total -46,640.17Their notes total 0.00on invoice 2526/2377

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
20250908-0600155-RDN-FKIIN41325103_ReversedFKIDN4167073408 Sept 202543,348.4230000025539836102 Jan 20262526/3612, 2526/3650, 2526/3658, 2526/3660, 2526/3662, 2526/3663 and 59 more
20250908-0600155-RDN-FKIIN41325103_ReversedFKIDN4167073408 Sept 20253,291.7430000025722468105 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
20250906-0700010-RDN-FKIIN41212124FKIDN4165415606 Sept 2025-434.5630000016006954611 Sept 2025YNPL25-26/2276

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250825-0600155-YNPL25-26/2377FKIIN4132510325 Aug 20257,84,957.48TDS -747.58—its own document numberAug 2025 to till daterow 629
TheirsDebit noteCREDIT20250908-0600155-RDN-FKIIN41325103FKIDN4167073408 Sept 2025-46,640.16FKIIN41325103the reference embedded in the document numberAug 2025 to till daterow 549
TheirsDebit noteSTANDARD20250908-0600155-RDN-FKIIN41325103_ReversedFKIDN41670734Reversed08 Sept 202546,640.16FKIIN41325103the reference embedded in the document numberAug 2025 to till daterows 2757, 2758
OursInvoiceTAX INVOICEYNPL25-26/237725 Aug 20257,84,953.86—its own document numberYNPL Ledgerrow 3338
OursCredit noteCREDIT NOTE-25FKIDN4167073417 Sept 2025-46,640.17FKIDN41670734our voucher number naming their noteYNPL Ledgerrow 3761

Settlement

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

DatePayment eventKindAmount
11 Sept 2025300000160069546HSBC-071050702001-FKICashPaid-46,640.16
11 Sept 2025300000160069546HSBC-071050702001-FKICashPaid7,84,209.90
02 Jan 2026300000255398361HSBC-071050702001-FKICashPaid43,348.42
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid3,291.74

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN41670734 → 20250908-0600155-RDN-FKIIN41325103

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

  • Their debit note against this invoiceCertain

    20250908-0600155-RDN-FKIIN41325103 → 20250825-0600155-YNPL25-26/2377

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

  • Their debit note against this invoiceCertain

    20250908-0600155-RDN-FKIIN41325103_Reversed → 20250825-0600155-YNPL25-26/2377

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

  • Matched to our invoiceCertain

    20250825-0600155-YNPL25-26/2377 → YNPL25-26/2377

    Matched by an exact invoice number match. FKIIN41325103 matches invoice 2526/2377

  • Reversal of an earlier noteCertain

    20250908-0600155-RDN-FKIIN41325103_Reversed → 20250908-0600155-RDN-FKIIN41325103

    Matched by a shared base reference and an offsetting amount. Reverses RDN-FKIIN41325103 exactly

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