YLedger Reconciliation

YNPL26-27/0007

01 Apr 2026FKIIN48723246PO FBSWN07899387Warehouse 0600155

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

Our books

From the Tally ledger and note registers

Invoice
1,97,209.95
Credit notes
-3,424.05
Debit notes
—
Net due from customer
1,93,785.90
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
1,97,210.61
Debit notes
—
Credit notes
—
Net due
1,97,210.61
TDS deductedExpected 187.82 at 0.1% of taxable value
187.82
Paid in cash
1,97,022.79
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-0.66
Notes
-3,424.05
Total position difference
-3,424.71
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
20260408-0600155-RDN-FKIIN48723246
FKIDN48888232
08 Apr 2026
-3,424.05
FKIIN48723246
This invoice’s payment, 11 Apr 2026 (with 31 other invoices)
Them
Debit noteReversed
20260408-0600155-RDN-FKIIN48723246_Reversed
FKIDN48888232
08 Apr 2026
3,424.05
FKIIN48723246
Another invoice’s payment18 May 2026, settling 54 other invoices
Us
Credit note
26-27/May/26/16
—
26 May 2026
-3,424.05
2627/7
Not yet recovered
Our notes total -3,424.05Their notes total 0.00on invoice 2627/7

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
20260408-0600155-RDN-FKIIN48723246_ReversedFKIDN4888823208 Apr 20263,424.0530000038072725218 May 20262627/339, 2627/341, 2627/342, 2627/352, 2627/354, 2627/356 and 48 more

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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20260317-0600386-RDN-FKIIN47854106_Reversed1FKIDN4804191717 Mar 202653,434.5030000035039644216 Apr 2026YNPL25-26/4531
20260311-0600155-RDN-FKIIN47855839_Reversed1FKIDN4788139611 Mar 202614,395.5030000035039644216 Apr 2026YNPL25-26/4525
20260304-0600155-RDN-FKIIN47685553_Reversed1FKIDN4771415604 Mar 20267,609.0230000035039644216 Apr 2026YNPL25-26/4472
20260303-0600155-RDN-FKIIN47524239_Reversed1FKIDN4770400703 Mar 20262,751.2130000035039644216 Apr 2026YNPL25-26/4427
20260327-0600155-RDN-FKIIN48216352_Reversed1FKIDN4841606027 Mar 2026200.3930000035039644216 Apr 2026YNPL25-26/4685

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260401-0600155-YNPL26-27/0007FKIIN4872324601 Apr 20261,97,210.61TDS -187.82—its own document numberAug 2025 to till daterows 4521, 4522, 4523
TheirsDebit noteCREDIT20260408-0600155-RDN-FKIIN48723246FKIDN4888823208 Apr 2026-3,424.05FKIIN48723246the reference embedded in the document numberAug 2025 to till daterow 4086
TheirsDebit noteSTANDARD20260408-0600155-RDN-FKIIN48723246_ReversedFKIDN48888232Reversed08 Apr 20263,424.05FKIIN48723246the reference embedded in the document numberAug 2025 to till daterow 5190
OursInvoiceTAX INVOICEYNPL26-27/000701 Apr 20261,97,209.95—its own document numberYNPL Ledgerrow 6291
OursCredit noteCredit Note New26-27/May/26/1626 May 2026-3,424.052627/7the reference column in the registerYNPL Ledgerrow 7273

Settlement

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

DatePayment eventKindAmount
11 Apr 20267560183834ZERO BANK ACCSet offAdjusted-3,424.05
11 Apr 20267560183834ZERO BANK ACCSet offAdjusted3,424.05
16 Apr 2026300000350396442HSBC-071050702001-FKICashPaid97,771.93
20 Apr 2026300000353512431HSBC-071050702001-FKICashPaid95,826.81
18 May 2026300000380727252HSBC-071050702001-FKICashPaid3,424.05

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/May/26/16 → YNPL26-27/0007

    Matched by the reference column in the register. Raised against our invoice 2627/7

  • Their debit note against this invoiceCertain

    20260408-0600155-RDN-FKIIN48723246 → 20260401-0600155-YNPL26-27/0007

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

  • Their debit note against this invoiceCertain

    20260408-0600155-RDN-FKIIN48723246_Reversed → 20260401-0600155-YNPL26-27/0007

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

  • Matched to our invoiceCertain

    20260401-0600155-YNPL26-27/0007 → YNPL26-27/0007

    Matched by an exact invoice number match. FKIIN48723246 matches invoice 2627/7

  • Reversal of an earlier noteCertain

    20260408-0600155-RDN-FKIIN48723246_Reversed → 20260408-0600155-RDN-FKIIN48723246

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

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