YLedger Reconciliation

YNPL25-26/1922

21 Jul 2025FKIIN40090148PO FBSWN06545133Warehouse 0600155

Back to register
DEBIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by -Rs 3,223.08TDS short deducted by Rs 2.07A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice
6,51,803.59
Credit notes
-5,764.50
Debit notes
—
Net due from customer
6,46,039.09
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
6,51,805.38
Debit notes
-2,541.42
Credit notes
—
Net due
6,49,263.96
TDS deductedExpected 620.77 at 0.1% of taxable value
618.70
Paid in cash
6,48,645.26
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.79
Notes
-3,223.08
Total position difference
-3,224.87
TDS
2.07
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
20250728-0600155-RDN-FKIIN40090148
FKIDN40292218
28 Jul 2025
-5,764.50
FKIIN40090148
Another invoice’s payment18 Aug 2025, settling 64 other invoices
Them
Debit noteReversed
20250728-0600155-RDN-FKIIN40090148_Reversed
FKIDN40292218
28 Jul 2025
3,223.08
FKIIN40090148
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Us
Credit note
FKIDN40292218
—
03 Aug 2025
-5,764.50
FKIDN40292218
Not yet recovered
Our notes total -5,764.50Their notes total -2,541.42on invoice 2526/1922

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
20250728-0600155-RDN-FKIIN40090148FKIDN4029221828 Jul 2025-5,764.5030000007693036518 Aug 20252526/1714, 2526/1717, 2526/1730, 2526/1747, 2526/1753, 2526/1769 and 58 more
20250728-0600155-RDN-FKIIN40090148_ReversedFKIDN4029221828 Jul 20253,223.0830000025722468105 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
20250728-null-RDN-FKIIN39552115FKIDN4027032828 Jul 2025-20,109.6030000005597086506 Aug 2025YNPL25-26/1753
20250726-A274-RDN-FKIIN39433985FKIDN4024491126 Jul 2025-3,953.8630000005597086506 Aug 2025YNPL25-26/1717
20250727-6461-RDN-FKIIN39715339FKIDN4025617527 Jul 2025-2,678.7630000005597086506 Aug 2025YNPL25-26/1779
20250726-2140-RDN-FKIIN39567510FKIDN4023999326 Jul 2025-2,589.0030000005597086506 Aug 2025YNPL25-26/1769
20250728-2140-RDN-FKIIN39397144FKIDN4029696228 Jul 2025-1,056.7930000005597086506 Aug 2025YNPL25-26/1697

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250721-0600155-YNPL25-26/1922FKIIN4009014821 Jul 20256,51,805.38TDS -618.70—its own document numberAug 2025 to till daterow 247
TheirsDebit noteCREDIT20250728-0600155-RDN-FKIIN40090148FKIDN4029221828 Jul 2025-5,764.50FKIIN40090148the reference embedded in the document numberAug 2025 to till daterow 150
TheirsDebit noteSTANDARD20250728-0600155-RDN-FKIIN40090148_ReversedFKIDN40292218Reversed28 Jul 20253,223.08FKIIN40090148the reference embedded in the document numberAug 2025 to till daterow 2690
OursInvoiceTAX INVOICEYNPL25-26/192221 Jul 20256,51,803.59—its own document numberYNPL Ledgerrow 2785
OursCredit noteCREDIT NOTE-25FKIDN4029221803 Aug 2025-5,764.50FKIDN40292218our voucher number naming their noteYNPL Ledgerrow 2990

Settlement

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

DatePayment eventKindAmount
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid6,51,186.68
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid-5,764.50
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid3,223.08

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40292218 → 20250728-0600155-RDN-FKIIN40090148

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

  • Their debit note against this invoiceCertain

    20250728-0600155-RDN-FKIIN40090148 → 20250721-0600155-YNPL25-26/1922

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

  • Their debit note against this invoiceCertain

    20250728-0600155-RDN-FKIIN40090148_Reversed → 20250721-0600155-YNPL25-26/1922

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

  • Matched to our invoiceCertain

    20250721-0600155-YNPL25-26/1922 → YNPL25-26/1922

    Matched by an exact invoice number match. FKIIN40090148 matches invoice 2526/1922

  • Reversal of an earlier noteNeeds review

    20250728-0600155-RDN-FKIIN40090148_Reversed → 20250728-0600155-RDN-FKIIN40090148

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

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