YLedger Reconciliation

YNPL25-26/2092

05 Aug 2025FKIIN40626426PO FBSWN06617732Warehouse 0600155

Back to register
CREDIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by Rs 1,17,079.19TDS short deducted by Rs 3.27

Reconcile our credit notes against their debit notes for this invoice

Our books

From the Tally ledger and note registers

Invoice
13,63,085.18
Credit notes
-37,680.14
Debit notes
—
Net due from customer
13,25,405.04
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
13,63,089.67
Debit notes
-1,54,759.33
Credit notes
—
Net due
12,08,330.34
TDS deductedExpected 1,298.18 at 0.1% of taxable value
1,294.91
Paid in cash
12,07,035.43
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-4.49
Notes
1,17,079.19
Total position difference
1,17,074.70
TDS
3.27
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
20250820-0600155-RDN-FKIIN40626426
FKIDN41102786
20 Aug 2025
-1,54,759.33
FKIIN40626426
Another invoice’s payment25 Aug 2025, settling 53 other invoices
Us
Credit note
26-27/June/09/18
—
09 Jun 2026
-37,680.14
2526/2092
Not yet recovered
Our notes total -37,680.14Their notes total -1,54,759.33on invoice 2526/2092

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
20250820-0600155-RDN-FKIIN40626426FKIDN4110278620 Aug 2025-1,54,759.3330000011026398825 Aug 20252526/1714, 2526/1884, 2526/1893, 2526/1940, 2526/2041, 2526/2044 and 47 more

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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250829-0600155-RDN-FKIIN40764501FKIDN4139826429 Aug 2025-1,66,110.1830000014834875701 Sept 2025YNPL25-26/2123
20250829-0600157-RDN-FKIIN40815536FKIDN4139872129 Aug 2025-72,093.9830000014834875701 Sept 2025YNPL25-26/2132
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
TheirsInvoiceSTANDARD20250805-0600155-YNPL25-26/2092FKIIN4062642605 Aug 202513,63,089.67TDS -1,294.91—its own document numberAug 2025 to till daterows 841, 842
TheirsDebit noteCREDIT20250820-0600155-RDN-FKIIN40626426FKIDN4110278620 Aug 2025-1,54,759.33FKIIN40626426the reference embedded in the document numberAug 2025 to till daterow 270
OursInvoiceTAX INVOICEYNPL25-26/209205 Aug 202513,63,085.18—its own document numberYNPL Ledgerrow 3020
OursCredit noteCredit Note New26-27/June/09/1809 Jun 2026-37,680.142526/2092the reference column in the registerYNPL Ledgerrow 7656

Settlement

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

DatePayment eventKindAmount
25 Aug 2025300000110263988HSBC-071050702001-FKICashPaid-1,54,759.33
01 Sept 2025300000148348757HSBC-071050702001-FKICashPaid9,23,799.18
01 Sept 2025300000148180517HSBC-071050702001-FKICashPaid4,37,995.58

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/June/09/18 → YNPL25-26/2092

    Matched by the reference column in the register. Raised against our invoice 2526/2092

  • Their debit note against this invoiceCertain

    20250820-0600155-RDN-FKIIN40626426 → 20250805-0600155-YNPL25-26/2092

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

  • Matched to our invoiceCertain

    20250805-0600155-YNPL25-26/2092 → YNPL25-26/2092

    Matched by an exact invoice number match. FKIIN40626426 matches invoice 2526/2092

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