YNPL26-27/1500

22 Jun 2026FKIIN51146572PO FNNWN08305939Warehouse 0700010

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
1,64,293.10
Credit notes
-15,692.26
Debit notes
Net due from customer
1,48,600.84
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,64,293.88
Debit notes
-15,692.20
Credit notes
Net due
1,48,601.68
TDS deductedExpected 156.47 at 0.1% of taxable value
156.47
Paid in cash
1,48,445.21
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.78
Notes
-0.06
Total position difference
-0.84
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
20260703-0700010-RDN-FKIIN51146572
FKIDN51471338
03 Jul 2026
-15,692.20
FKIIN51146572
Another invoice’s payment06 Jul 2026, settling 136 other invoices
Us
Credit note
26-27/July/30/31
30 Jul 2026
-15,692.26
2627/1500
Not yet recovered
Our notes total -15,692.26Their notes total -15,692.20on invoice 2627/1500

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
20260703-0700010-RDN-FKIIN51146572FKIDN5147133803 Jul 2026-15,692.2030000043385564006 Jul 20262627/1010, 2627/1035, 2627/1061, 2627/1063, 2627/1075, 2627/1094 and 130 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260622-0700010-YNPL26-27/1500FKIIN5114657222 Jun 20261,64,293.88TDS -156.47its own document numberAug 2025 to till daterow 7066
TheirsDebit noteCREDIT20260703-0700010-RDN-FKIIN51146572FKIDN5147133803 Jul 2026-15,692.20FKIIN51146572the reference embedded in the document numberAug 2025 to till daterow 7810
OursInvoiceTAX INVOICEYNPL26-27/150022 Jun 20261,64,293.10its own document numberYNPL Ledgerrow 8307
OursCredit noteCredit Note New26-27/July/30/3130 Jul 2026-15,692.262627/1500the reference column in the registerYNPL Ledgerrow 9729

Settlement

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

DatePayment eventKindAmount
06 Jul 2026300000433855640HSBC-071050702001-FKICashPaid-15,692.20
08 Jul 2026300000437925827HSBC-071050702001-FKICashPaid1,64,137.41

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/July/30/31 → YNPL26-27/1500

    Matched by the reference column in the register. Raised against our invoice 2627/1500

  • Their debit note against this invoiceCertain

    20260703-0700010-RDN-FKIIN51146572 → 20260622-0700010-YNPL26-27/1500

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

  • Matched to our invoiceCertain

    20260622-0700010-YNPL26-27/1500 → YNPL26-27/1500

    Matched by an exact invoice number match. FKIIN51146572 matches invoice 2627/1500

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