YLedger Reconciliation

YNPL25-26/2133

10 Aug 2025FKIIN40802264PO FBSWN06661604Warehouse 0600155

Back to register
CREDIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by Rs 50,020.50A debit note was only partly reversed

Reconcile our credit notes against their debit notes for this invoice

Our books

From the Tally ledger and note registers

Invoice
17,99,697.48
Credit notes
—
Debit notes
—
Net due from customer
17,99,697.48
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
17,99,705.62
Debit notes
-50,020.50
Credit notes
—
Net due
17,49,685.12
TDS deductedExpected 1,714.01 at 0.1% of taxable value
1,714.16
Paid in cash
17,47,970.96
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-8.14
Notes
50,020.50
Total position difference
50,012.36
TDS
-0.15
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 note
20250826-0600155-RDN-FKIIN40802264
FKIDN41311306
26 Aug 2025
-52,815.81
FKIIN40802264
This invoice’s payment, 30 Aug 2025 (with 22 other invoices)
Them
Debit noteReversed
20250826-0600155-RDN-FKIIN40802264_Reversed
FKIDN41311306
26 Aug 2025
2,795.31
FKIIN40802264
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Our notes total 0.00Their notes total -50,020.50on invoice 2526/2133

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
20250826-0600155-RDN-FKIIN40802264_ReversedFKIDN4131130626 Aug 20252,795.3130000025722468105 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
20250703-2140-RDN-FKIIN39123471_ReversedFKIDN3936658203 Jul 202543,709.4030000014818051701 Sept 2025YNPL25-26/1494
20250702-2140-RDN-FKIIN39079440_ReversedFKIDN3934173102 Jul 202514,060.0330000014818051701 Sept 2025YNPL25-26/1495
20250707-2140-RDN-FKIIN39017249_ReversedFKIDN3948102107 Jul 202513,943.0030000014818051701 Sept 2025YNPL25-26/1528
20250716-2140-RDN-FKIIN39375905_ReversedFKIDN3979622616 Jul 202510,567.8730000014818051701 Sept 2025YNPL25-26/1685
20250712-6461-RDN-FKIIN39549721_ReversedFKIDN3964887612 Jul 20255,158.2330000014818051701 Sept 2025YNPL25-26/1733

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250810-0600155-YNPL25-26/2133FKIIN4080226410 Aug 202517,99,705.62TDS -1,714.16—its own document numberAug 2025 to till daterows 9, 482
TheirsDebit noteCREDIT20250826-0600155-RDN-FKIIN40802264FKIDN4131130626 Aug 2025-52,815.81FKIIN40802264the reference embedded in the document numberAug 2025 to till daterow 145
TheirsDebit noteSTANDARD20250826-0600155-RDN-FKIIN40802264_ReversedFKIDN41311306Reversed26 Aug 20252,795.31FKIIN40802264the reference embedded in the document numberAug 2025 to till daterow 2886
OursInvoiceTAX INVOICEYNPL25-26/213310 Aug 202517,99,697.48—its own document numberYNPL Ledgerrow 3081

Settlement

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

DatePayment eventKindAmount
30 Aug 20257560110300ZERO BANK ACCSet offAdjusted52,815.81
30 Aug 20257560110300ZERO BANK ACCSet offAdjusted-52,815.81
01 Sept 2025300000148180517HSBC-071050702001-FKICashPaid17,45,175.65
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid2,795.31

How this was matched

Every link is a rule, never a guess

  • Their debit note against this invoiceCertain

    20250826-0600155-RDN-FKIIN40802264 → 20250810-0600155-YNPL25-26/2133

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

  • Their debit note against this invoiceCertain

    20250826-0600155-RDN-FKIIN40802264_Reversed → 20250810-0600155-YNPL25-26/2133

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

  • Matched to our invoiceCertain

    20250810-0600155-YNPL25-26/2133 → YNPL25-26/2133

    Matched by an exact invoice number match. FKIIN40802264 matches invoice 2526/2133

  • Reversal of an earlier noteNeeds review

    20250826-0600155-RDN-FKIIN40802264_Reversed → 20250826-0600155-RDN-FKIIN40802264

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

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