YLedger Reconciliation

YNPL25-26/1967

24 Jul 2025FKIIN40224166PO FDTWG06491340Warehouse 0600157

Back to register
POSITION MISMATCHOn both sidesInvoice amount differs by Rs 2,31,433.44Our credit and debit notes differ from theirs by -Rs 19,038.10

Our books

From the Tally ledger and note registers

Invoice
4,62,862.48
Credit notes
-38,075.32
Debit notes
—
Net due from customer
4,24,787.16
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,31,429.04
Debit notes
-19,037.22
Credit notes
—
Net due
2,12,391.82
TDS deductedExpected 220.41 at 0.1% of taxable value
220.40
Paid in cash
2,12,171.42
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
2,31,433.44
Notes
-19,038.10
Total position difference
2,12,395.34
TDS
0.01
UnexplainedEvery rupee of difference is attributed to a cause
0.00

Credit and debit notes

3 notes in the order they were raised

Raised by
Type
Document number
Their reference
Date
Amount
Raised against
Recovered in
Them
Debit note
20250808-0600157-RDN-FKIIN40224166
FKIDN40686155
08 Aug 2025
-19,037.22
FKIIN40224166
Another invoice’s payment18 Aug 2025, settling 64 other invoices
Us
Credit note
FKIDN40686155
—
28 Aug 2025
-19,037.66
FKIDN40686155
Not yet recovered
Us
Credit note
FKIDN40686155
—
28 Aug 2025
-19,037.66
FKIDN40686155
Not yet recovered
Our notes total -38,075.32Their notes total -19,037.22on invoice 2526/1967

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
20250808-0600157-RDN-FKIIN40224166FKIDN4068615508 Aug 2025-19,037.2230000007693036518 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
TheirsInvoiceSTANDARD20250724-0600157-YNPL25-26/1967FKIIN4022416624 Jul 20252,31,429.04TDS -220.40—its own document numberAug 2025 to till daterow 250
TheirsDebit noteCREDIT20250808-0600157-RDN-FKIIN40224166FKIDN4068615508 Aug 2025-19,037.22FKIIN40224166the reference embedded in the document numberAug 2025 to till daterow 362
OursInvoiceTAX INVOICEYNPL25-26/196724 Jul 20252,31,431.24—its own document numberLedger YNPLrow 2851
OursInvoiceTAX INVOICEYNPL25-26/196724 Jul 20252,31,431.24—its own document numberYNPL Ledgerrow 2851
OursCredit noteCREDIT NOTE-25FKIDN4068615528 Aug 2025-19,037.66FKIDN40686155our voucher number naming their noteLedger YNPLrow 3390
OursCredit noteCREDIT NOTE-25FKIDN4068615528 Aug 2025-19,037.66FKIDN40686155our voucher number naming their noteYNPL Ledgerrow 3390

Settlement

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

DatePayment eventKindAmount
11 Aug 2025300000062262544HSBC-071050702001-FKICashPaid2,31,208.64
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid-19,037.22

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40686155 → 20250808-0600157-RDN-FKIIN40224166

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

  • Our credit note against their debit noteCertain

    FKIDN40686155 → 20250808-0600157-RDN-FKIIN40224166

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

  • Their debit note against this invoiceCertain

    20250808-0600157-RDN-FKIIN40224166 → 20250724-0600157-YNPL25-26/1967

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

  • Matched to our invoiceCertain

    20250724-0600157-YNPL25-26/1967 → YNPL25-26/1967

    Matched by an exact invoice number match. FKIIN40224166 matches invoice 2526/1967

Run c9ea9d8f-7251-4548-b329-c594a10b12ec