YLedger Reconciliation

YNPL25-26/1949

22 Jul 2025FKIIN40313442PO FSMWG06522607Warehouse 0600386

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
99,952.65
Credit notes
-14,131.32
Debit notes
—
Net due from customer
85,821.33
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
99,952.48
Debit notes
-14,131.36
Credit notes
—
Net due
85,821.12
TDS deductedExpected 95.19 at 0.1% of taxable value
95.04
Paid in cash
85,726.08
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.17
Notes
0.04
Total position difference
0.21
TDS
0.15
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
20250807-0600386-RDN-FKIIN40313442
FKIDN40641517
07 Aug 2025
-14,131.36
FKIIN40313442
Another invoice’s payment18 Aug 2025, settling 64 other invoices
Us
Credit note
FKIDN40641517
—
04 Sept 2025
-14,131.32
FKIDN40641517
Not yet recovered
Our notes total -14,131.32Their notes total -14,131.36on invoice 2526/1949

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
20250807-0600386-RDN-FKIIN40313442FKIDN4064151707 Aug 2025-14,131.3630000007693036518 Aug 20252526/1714, 2526/1717, 2526/1730, 2526/1747, 2526/1753, 2526/1769 and 58 more

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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250726-0600155-RDN-FKIIN40196074FKIDN4022306226 Jul 2025-8,788.8030000006226254411 Aug 2025YNPL25-26/1962
20250728-0600159-RDN-FKIIN39824746FKIDN4027890228 Jul 2025-6,958.9430000006226254411 Aug 2025YNPL25-26/1848
20250728-0600159-RDN-FKIIN40203564FKIDN4027859428 Jul 2025-5,279.9530000006226254411 Aug 2025YNPL25-26/1937
20250728-0600155-RDN-FKIIN40148989FKIDN4029302728 Jul 2025-1,437.5630000006226254411 Aug 2025YNPL25-26/1939
20250729-0600159-RDN-FKIIN40284716FKIDN4033083229 Jul 2025-297.2730000006226254411 Aug 2025YNPL25-26/1973
20250730-0600159-RDN-FKIIN40284718FKIDN4036277330 Jul 2025-272.9930000006226254411 Aug 2025YNPL25-26/1974
20250729-0600159-RDN-FKIIN39908599FKIDN4032973929 Jul 2025-198.0330000006226254411 Aug 2025YNPL25-26/1868
20250728-0600159-RDN-FKIIN40095569FKIDN4028984528 Jul 2025-111.7330000006226254411 Aug 2025YNPL25-26/1925
20250726-0600159-RDN-FKIIN40168985FKIDN4022146626 Jul 2025-53.0630000006226254411 Aug 2025YNPL25-26/1935

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250722-0600386-YNPL25-26/1949FKIIN4031344222 Jul 202599,952.48TDS -95.04—its own document numberAug 2025 to till daterow 400
TheirsDebit noteCREDIT20250807-0600386-RDN-FKIIN40313442FKIDN4064151707 Aug 2025-14,131.36FKIIN40313442the reference embedded in the document numberAug 2025 to till daterow 167
OursInvoiceTAX INVOICEYNPL25-26/194922 Jul 202599,952.65—its own document numberYNPL Ledgerrow 2814
OursCredit noteCREDIT NOTE-25FKIDN4064151704 Sept 2025-14,131.32FKIDN40641517our voucher number naming their noteYNPL Ledgerrow 3523

Settlement

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

DatePayment eventKindAmount
11 Aug 2025300000062262544HSBC-071050702001-FKICashPaid99,857.44
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid-14,131.36

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40641517 → 20250807-0600386-RDN-FKIIN40313442

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

  • Their debit note against this invoiceCertain

    20250807-0600386-RDN-FKIIN40313442 → 20250722-0600386-YNPL25-26/1949

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

  • Matched to our invoiceCertain

    20250722-0600386-YNPL25-26/1949 → YNPL25-26/1949

    Matched by an exact invoice number match. FKIIN40313442 matches invoice 2526/1949

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