YLedger Reconciliation

YNPL25-26/2123

07 Aug 2025FKIIN40764501PO FBSWN06580498Warehouse 0600155

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
2,00,287.71
Credit notes
-1,66,109.11
Debit notes
—
Net due from customer
34,178.60
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
2,00,288.88
Debit notes
-1,66,110.18
Credit notes
—
Net due
34,178.70
TDS deductedExpected 190.75 at 0.1% of taxable value
190.75
Paid in cash
33,987.95
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.17
Notes
1.07
Total position difference
-0.10
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
20250829-0600155-RDN-FKIIN40764501
FKIDN41398264
29 Aug 2025
-1,66,110.18
FKIIN40764501
Another invoice’s payment01 Sept 2025, settling 19 other invoices
Us
Credit note
FKIDN41398264
—
06 Sept 2025
-1,66,109.11
FKIDN41398264
Not yet recovered
Our notes total -1,66,109.11Their notes total -1,66,110.18on invoice 2526/2123

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
20250829-0600155-RDN-FKIIN40764501FKIDN4139826429 Aug 2025-1,66,110.1830000014834875701 Sept 20252526/2092, 2526/2138, 2526/2146, 2526/2156, 2526/2159, 2526/2160 and 13 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-0600155-YNPL25-26/2123FKIIN4076450107 Aug 20252,00,288.88TDS -190.75—its own document numberAug 2025 to till daterow 1124
TheirsDebit noteCREDIT20250829-0600155-RDN-FKIIN40764501FKIDN4139826429 Aug 2025-1,66,110.18FKIIN40764501the reference embedded in the document numberAug 2025 to till daterow 779
OursInvoiceTAX INVOICEYNPL25-26/212307 Aug 20252,00,287.71—its own document numberYNPL Ledgerrow 3052
OursCredit noteCREDIT NOTE-25FKIDN4139826406 Sept 2025-1,66,109.11FKIDN41398264our voucher number naming their noteYNPL Ledgerrow 3551

Settlement

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

DatePayment eventKindAmount
01 Sept 2025300000148348757HSBC-071050702001-FKICashPaid-1,66,110.18
01 Sept 2025300000148180517HSBC-071050702001-FKICashPaid2,00,098.13

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN41398264 → 20250829-0600155-RDN-FKIIN40764501

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

  • Their debit note against this invoiceCertain

    20250829-0600155-RDN-FKIIN40764501 → 20250807-0600155-YNPL25-26/2123

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

  • Matched to our invoiceCertain

    20250807-0600155-YNPL25-26/2123 → YNPL25-26/2123

    Matched by an exact invoice number match. FKIIN40764501 matches invoice 2526/2123

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