YLedger Reconciliation

YNPL25-26/3814

22 Dec 2025FKIIN45266955PO FSMWG07350974Warehouse 0600386

Back to register
INVOICE AMOUNT MISMATCHOn both sidesInvoice amount differs by Rs 4,77,325.42

Compare our invoice YNPL25-26/3814 against their FKIIN45266955; the difference is Rs 4,77,325.42

Our books

From the Tally ledger and note registers

Invoice
9,54,654.12
Credit notes
-4,094.82
Debit notes
—
Net due from customer
9,50,559.30
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
4,77,328.70
Debit notes
-4,094.87
Credit notes
—
Net due
4,73,233.83
TDS deductedExpected 454.60 at 0.1% of taxable value
454.60
Paid in cash
4,72,779.23
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,77,325.42
Notes
0.05
Total position difference
4,77,325.47
TDS
—
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
20251231-0600386-RDN-FKIIN45266955
FKIDN45508081
31 Dec 2025
-4,094.87
FKIIN45266955
Another invoice’s payment02 Jan 2026, settling 65 other invoices
Us
Credit note
25-26/Jan/9/22
—
09 Jan 2026
-4,094.82
2526/3814
Not yet recovered
Our notes total -4,094.82Their notes total -4,094.87on invoice 2526/3814

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
20251231-0600386-RDN-FKIIN45266955FKIDN4550808131 Dec 2025-4,094.8730000025539836102 Jan 20262526/3612, 2526/3650, 2526/3658, 2526/3660, 2526/3662, 2526/3663 and 59 more

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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250707-2140-RDN-FKIIN39011590_ReversedFKIDN3947905507 Jul 202540,066.9530000025722468105 Jan 2026YNPL25-26/1519
20250826-0600155-RDN-FKIIN40887045_ReversedFKIDN4130332126 Aug 202514,348.4030000025722468105 Jan 2026YNPL25-26/2160
20250710-2140-RDN-FKIIN38788864_ReversedFKIDN3958314810 Jul 20253,621.2430000025722468105 Jan 2026YNPL25-26/1419
20250908-0600155-RDN-FKIIN41325103_ReversedFKIDN4167073408 Sept 20253,291.7430000025722468105 Jan 2026YNPL25-26/2377
20250728-0600155-RDN-FKIIN40090148_ReversedFKIDN4029221828 Jul 20253,223.0830000025722468105 Jan 2026YNPL25-26/1922
20250826-0600155-RDN-FKIIN40802264_ReversedFKIDN4131130626 Aug 20252,795.3130000025722468105 Jan 2026YNPL25-26/2133
20250724-2140-RDN-FKIIN40052144_ReversedFKIDN4016376224 Jul 20252,653.5630000025722468105 Jan 2026YNPL25-26/1913
20250804-0600155-RDN-FKIIN40514709_ReversedFKIDN4053764104 Aug 20251,991.9030000025722468105 Jan 2026YNPL25-26/2042
20250804-0600155-RDN-FKIIN40514642_ReversedFKIDN4053736504 Aug 20251,253.7030000025722468105 Jan 2026YNPL25-26/2043
20250715-A274-RDN-FKIIN39290084_ReversedFKIDN3974575215 Jul 202512.1230000025722468105 Jan 2026YNPL25-26/1640

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20251222-0600386-YNPL25-26/3814FKIIN4526695522 Dec 20254,77,328.70TDS -454.60—its own document numberAug 2025 to till daterow 2885
TheirsDebit noteCREDIT20251231-0600386-RDN-FKIIN45266955FKIDN4550808131 Dec 2025-4,094.87FKIIN45266955the reference embedded in the document numberAug 2025 to till daterow 2750
OursInvoiceTAX INVOICEYNPL25-26/381422 Dec 20254,77,327.06—its own document numberLedger YNPLrow 5192
OursInvoiceTAX INVOICEYNPL25-26/381422 Dec 20254,77,327.06—its own document numberYNPL Ledgerrow 5192
OursCredit noteCredit Note New25-26/Jan/9/2209 Jan 2026-4,094.822526/3814the reference column in the registerLedger YNPLrow 5395

Settlement

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

DatePayment eventKindAmount
02 Jan 2026300000255398361HSBC-071050702001-FKICashPaid-4,094.87
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid4,76,874.10

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    25-26/Jan/9/22 → YNPL25-26/3814

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

  • Their debit note against this invoiceCertain

    20251231-0600386-RDN-FKIIN45266955 → 20251222-0600386-YNPL25-26/3814

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

  • Matched to our invoiceCertain

    20251222-0600386-YNPL25-26/3814 → YNPL25-26/3814

    Matched by an exact invoice number match. FKIIN45266955 matches invoice 2526/3814

Run 8aff1fbc-38b3-48cf-92cd-f32dfeef7a99