YLedger Reconciliation

YNPL25-26/1640

29 Jun 2025FKIIN39290084PO FNNWN06456461Warehouse A274

Back to register
PARTIAL REVERSALOn both sidesTDS short deducted by Rs 1.06A debit note was only partly reversed

Confirm whether the remaining debit note balance is still valid

Our books

From the Tally ledger and note registers

Invoice
2,80,741.83
Credit notes
-376.52
Debit notes
—
Net due from customer
2,80,365.31
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
2,80,743.23
Debit notes
-364.41
Credit notes
—
Net due
2,80,378.82
TDS deductedExpected 267.37 at 0.1% of taxable value
266.31
Paid in cash
2,80,112.51
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.40
Notes
-12.11
Total position difference
-13.51
TDS
1.06
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
20250715-A274-RDN-FKIIN39290084
FKIDN39745752
15 Jul 2025
-376.53
FKIIN39290084
This invoice’s payment, 17 Jul 2025 (with 35 other invoices)
Them
Debit noteReversed
20250715-A274-RDN-FKIIN39290084_Reversed
FKIDN39745752
15 Jul 2025
12.12
FKIIN39290084
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Us
Credit note
FKIDN39745752
—
21 Jul 2025
-376.52
FKIDN39745752
Not yet recovered
Our notes total -376.52Their notes total -364.41on invoice 2526/1640

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
20250715-A274-RDN-FKIIN39290084_ReversedFKIDN3974575215 Jul 202512.1230000025722468105 Jan 20262526/3694, 2526/3785, 2526/3786, 2526/3789, 2526/3795, 2526/3796 and 11 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250629-A274-YNPL25-26/1640FKIIN3929008429 Jun 20252,80,743.23—its own document numberJan 2025 to July 2025row 1942
TheirsTDS memoCREDIT20250629-A274-YNPL25-26/1640-TDS-CM-2067244729 Jun 2025-266.31—the reference embedded in the document numberJan 2025 to July 2025row 1979
TheirsDebit noteCREDIT20250715-A274-RDN-FKIIN39290084FKIDN3974575215 Jul 2025-376.53FKIIN39290084the reference embedded in the document numberJan 2025 to July 2025row 1983
TheirsDebit noteSTANDARD20250715-A274-RDN-FKIIN39290084_ReversedFKIDN39745752Reversed15 Jul 202512.12FKIIN39290084the reference embedded in the document numberAug 2025 to till daterow 2727
OursInvoiceTAX INVOICEYNPL25-26/164029 Jun 20252,80,741.83—its own document numberYNPL Ledgerrow 2272
OursCredit noteCREDIT NOTE-25FKIDN3974575221 Jul 2025-376.52FKIDN39745752our voucher number naming their noteYNPL Ledgerrow 2781

Settlement

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

DatePayment eventKindAmount
17 Jul 2025HSBCN19859500510HDFC BANK LTDCashActual Payment2,80,743.23
17 Jul 2025HSBCN19859500510HDFC BANK LTDCashActual Payment-266.31
17 Jul 2025HSBCN19859500510HDFC BANK LTDCashActual Payment-376.53
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid12.12

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN39745752 → 20250715-A274-RDN-FKIIN39290084

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

  • Their debit note against this invoiceCertain

    20250715-A274-RDN-FKIIN39290084 → 20250629-A274-YNPL25-26/1640

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

  • Their debit note against this invoiceCertain

    20250715-A274-RDN-FKIIN39290084_Reversed → 20250629-A274-YNPL25-26/1640

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

  • Matched to our invoiceCertain

    20250629-A274-YNPL25-26/1640 → YNPL25-26/1640

    Matched by an exact invoice number match. FKIIN39290084 matches invoice 2526/1640

  • Reversal of an earlier noteNeeds review

    20250715-A274-RDN-FKIIN39290084_Reversed → 20250715-A274-RDN-FKIIN39290084

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

  • TDS memo against this invoiceCertain

    20250629-A274-YNPL25-26/1640-TDS-CM-20672447 → 20250629-A274-YNPL25-26/1640

    Matched by the reference embedded in the document number. TDS memo for invoice 2526/1640

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