YLedger Reconciliation

YNPL25-26/1697

02 Jul 2025FKIIN39397144Warehouse 2140

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
1,91,733.48
Credit notes
-1,056.79
Debit notes
—
Net due from customer
1,90,676.69
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,91,734.19
Debit notes
-1,056.79
Credit notes
—
Net due
1,90,677.40
TDS deductedExpected 182.60 at 0.1% of taxable value
181.67
Paid in cash
1,90,495.73
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.71
Notes
—
Total position difference
-0.71
TDS
0.93
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
20250728-2140-RDN-FKIIN39397144
FKIDN40296962
28 Jul 2025
-1,056.79
FKIIN39397144
Another invoice’s payment06 Aug 2025, settling 47 other invoices
Us
Credit note
FKIDN40296962
—
03 Aug 2025
-1,056.79
FKIDN40296962
Not yet recovered
Our notes total -1,056.79Their notes total -1,056.79on invoice 2526/1697

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
20250728-2140-RDN-FKIIN39397144FKIDN4029696228 Jul 2025-1,056.7930000005597086506 Aug 20252526/1747, 2526/1750, 2526/1777, 2526/1784, 2526/1789, 2526/1803 and 41 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
TheirsTDS memoCREDIT20250702-2140-YNPL25-26/1697-TDS-CM-2105567302 Jul 2025-181.67—the reference embedded in the document numberAug 2025 to till daterow 97
TheirsInvoiceSTANDARD20250702-2140-YNPL25-26/1697FKIIN3939714402 Jul 20251,91,734.19—its own document numberAug 2025 to till daterow 756
TheirsDebit noteCREDIT20250728-2140-RDN-FKIIN39397144FKIDN4029696228 Jul 2025-1,056.79FKIIN39397144the reference embedded in the document numberAug 2025 to till daterow 373
OursInvoiceTAX INVOICEYNPL25-26/169702 Jul 20251,91,733.48—its own document numberYNPL Ledgerrow 2387
OursCredit noteCREDIT NOTE-25FKIDN4029696203 Aug 2025-1,056.79FKIDN40296962our voucher number naming their noteYNPL Ledgerrow 3000

Settlement

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

DatePayment eventKindAmount
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid-181.67
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid-1,056.79
01 Sept 2025300000148180517HSBC-071050702001-FKICashPaid1,91,734.19

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40296962 → 20250728-2140-RDN-FKIIN39397144

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

  • Their debit note against this invoiceCertain

    20250728-2140-RDN-FKIIN39397144 → 20250702-2140-YNPL25-26/1697

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

  • Matched to our invoiceCertain

    20250702-2140-YNPL25-26/1697 → YNPL25-26/1697

    Matched by an exact invoice number match. FKIIN39397144 matches invoice 2526/1697

  • TDS memo against this invoiceCertain

    20250702-2140-YNPL25-26/1697-TDS-CM-21055673 → 20250702-2140-YNPL25-26/1697

    Matched by the reference embedded in the document number. TDS memo for invoice 2526/1697

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