YNPL25-26/1745

07 Jul 2025FKIIN39558792PO FLHWG06491345Warehouse 0900572

Back to register

PARTIAL REVERSALOn both sidesA debit note was only partly reversed

Confirm whether the remaining debit note balance is still valid

Our books

From the Tally ledger and note registers

Invoice: 9,98,982.40
Credit notes: -37,238.17
Debit notes: —
Net due from customer: 9,61,744.23
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: 9,98,985.18
Debit notes: -37,238.18
Credit notes: —
Net due: 9,61,747.00
TDS deductedExpected 951.41 at 0.1% of taxable value: 951.13
Paid in cash: 9,23,557.69
Set off against notesBook adjustment, no bank movement: 37,238.18
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: -2.78
Notes: 0.01
Total position difference: -2.77
TDS: 0.28
UnexplainedEvery rupee of difference is attributed to a cause: 0.00

Credit and debit notes

4 notes in the order they were raised

Raised by

Type

Document number

Their reference

Date

Amount

Raised against

Recovered in

Them

Debit note

20250726-3347-RDN-FKIIN39558792

FKIDN40244660

26 Jul 2025

-37,238.18

FKIIN39558792

Another invoice’s payment06 Aug 2025, settling 6 other invoices

Them

Debit note

20250726-0900572-RDN-FKIIN39558792

FKIDN40244660

26 Jul 2025

-37,238.18

FKIIN39558792

This invoice’s payment, 18 Aug 2025 (with 7 other invoices)

Them

Debit note

20250726-0900572-RDN-FKIIN39558792_Duplicate

FKIDN40244660

26 Jul 2025

37,238.18

FKIIN39558792

Another invoice’s payment30 Aug 2025, settling 8 other invoices

Credit note

FKIDN40244660

—

31 Jul 2025

-37,238.17

FKIDN40244660

Not yet recovered

Our notes total -37,238.17Their notes total -37,238.18on invoice 2526/1745

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

Note	Their reference	Date	Amount	Payment event	Payment settled invoices
20250726-3347-RDN-FKIIN39558792	FKIDN40244660	26 Jul 2025	-37,238.18	30000005596412306 Aug 2025	2526/1692, 2526/1877, 2526/1896, 2526/1897, 2526/1899, 2526/1900
20250726-0900572-RDN-FKIIN39558792_Duplicate	FKIDN40244660	26 Jul 2025	37,238.18	756010841530 Aug 2025	2526/1740, 2526/2110, 2526/2113, 2526/2180, 2526/2182, 2526/2183 and 2 more

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

Note	Their reference	Date	Amount	Payment event	Raised against invoice
20250806-0900572-RDN-FKIIN40245913	FKIDN40625107	06 Aug 2025	-139.25	30000007694641718 Aug 2025	YNPL25-26/1959

Source documents

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

Side	Type	Document	Date	Amount	Raised against	Matched by	Source
Theirs	InvoiceSTANDARD	20250707-0900572-YNPL25-26/1745FKIIN39558792	07 Jul 2025	9,98,985.18TDS -951.13	—	its own document number	Aug 2025 to till daterow 427
Theirs	Debit noteCREDIT	20250726-3347-RDN-FKIIN39558792FKIDN40244660	26 Jul 2025	-37,238.18	FKIIN39558792	the reference embedded in the document number	Aug 2025 to till daterow 188
Theirs	Debit noteCREDIT	20250726-0900572-RDN-FKIIN39558792FKIDN40244660	26 Jul 2025	-37,238.18	FKIIN39558792	the reference embedded in the document number	Aug 2025 to till daterow 228
Theirs	Debit noteSTANDARD	20250726-0900572-RDN-FKIIN39558792_DuplicateFKIDN40244660Marked duplicate by them	26 Jul 2025	37,238.18	FKIIN39558792	the reference embedded in the document number	Aug 2025 to till daterow 378
Ours	InvoiceTAX INVOICE	YNPL25-26/1745	07 Jul 2025	9,98,982.40	—	its own document number	YNPL Ledgerrow 2498
Ours	Credit noteCREDIT NOTE-25	FKIDN40244660	31 Jul 2025	-37,238.17	FKIDN40244660	our voucher number naming their note	YNPL Ledgerrow 2926

Settlement

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

Date	Payment event	Kind	Amount
06 Aug 2025	300000055964123HSBC-071050702001-FKI	CashPaid	-37,238.18
18 Aug 2025	300000076946417HSBC-071050702001-FKI	CashPaid	-37,238.18
18 Aug 2025	300000076946417HSBC-071050702001-FKI	CashPaid	9,98,034.05
30 Aug 2025	7560108415ZERO BANK ACC	Set offAdjusted	37,238.18

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN40244660 → 20250726-3347-RDN-FKIIN39558792
Matched by an exact voucher number match. Voucher number is their note FKIDN40244660
Their debit note against this invoiceCertain
20250726-3347-RDN-FKIIN39558792 → 20250707-0900572-YNPL25-26/1745
Matched by the reference embedded in the document number. Document number names FKIIN39558792
Their debit note against this invoiceCertain
20250726-0900572-RDN-FKIIN39558792 → 20250707-0900572-YNPL25-26/1745
Matched by the reference embedded in the document number. Document number names FKIIN39558792
Their debit note against this invoiceCertain
20250726-0900572-RDN-FKIIN39558792_Duplicate → 20250707-0900572-YNPL25-26/1745
Matched by the reference embedded in the document number. Document number names FKIIN39558792
Matched to our invoiceCertain
20250707-0900572-YNPL25-26/1745 → YNPL25-26/1745
Matched by an exact invoice number match. FKIIN39558792 matches invoice 2526/1745

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