YLedger Reconciliation

YNPL25-26/2120

07 Aug 2025FKIIN40773121PO FDMWG06654630Warehouse 0600159

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
12,85,159.96
Credit notes
-32,179.35
Debit notes
—
Net due from customer
12,52,980.61
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
12,85,163.65
Debit notes
-32,238.53
Credit notes
—
Net due
12,52,925.12
TDS deductedExpected 1,223.97 at 0.1% of taxable value
1,223.96
Paid in cash
12,51,701.16
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-3.69
Notes
59.18
Total position difference
55.49
TDS
0.01
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
20250830-0600159-RDN-FKIIN40773121
FKIDN41420614
30 Aug 2025
-32,238.53
FKIIN40773121
Another invoice’s payment04 Sept 2025, settling 49 other invoices
Us
Credit note
FKIDN41420614
—
02 Sept 2025
-32,179.35
FKIDN41420614
Not yet recovered
Our notes total -32,179.35Their notes total -32,238.53on invoice 2526/2120

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
20250830-0600159-RDN-FKIIN40773121FKIDN4142061430 Aug 2025-32,238.5330000015281599404 Sept 20252526/2138, 2526/2168, 2526/2191, 2526/2192, 2526/2197, 2526/2200 and 43 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
TheirsInvoiceSTANDARD20250807-0600159-YNPL25-26/2120FKIIN4077312107 Aug 202512,85,163.65TDS -1,223.96—its own document numberAug 2025 to till daterow 932
TheirsDebit noteCREDIT20250830-0600159-RDN-FKIIN40773121FKIDN4142061430 Aug 2025-32,238.53FKIIN40773121the reference embedded in the document numberAug 2025 to till daterow 644
OursInvoiceTAX INVOICEYNPL25-26/212007 Aug 202512,85,159.96—its own document numberYNPL Ledgerrow 3049
OursCredit noteCREDIT NOTE-25FKIDN4142061402 Sept 2025-32,179.35FKIDN41420614our voucher number naming their noteYNPL Ledgerrow 3468

Settlement

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

DatePayment eventKindAmount
01 Sept 2025300000148180517HSBC-071050702001-FKICashPaid12,83,939.69
04 Sept 2025300000152815994HSBC-071050702001-FKICashPaid-32,238.53

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN41420614 → 20250830-0600159-RDN-FKIIN40773121

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

  • Their debit note against this invoiceCertain

    20250830-0600159-RDN-FKIIN40773121 → 20250807-0600159-YNPL25-26/2120

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

  • Matched to our invoiceCertain

    20250807-0600159-YNPL25-26/2120 → YNPL25-26/2120

    Matched by an exact invoice number match. FKIIN40773121 matches invoice 2526/2120

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