YNPL25-26/2072

02 Aug 2025FKIIN40580057PO FLGWN06570412Warehouse 0900572

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 18,47,930.41Our credit and debit notes differ from theirs by Rs 48,773.86TDS short deducted by Rs 1.74

Our books

From the Tally ledger and note registers

Invoice: 36,95,873.02
Credit notes: —
Debit notes: —
Net due from customer: 36,95,873.02
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: 18,47,942.61
Debit notes: -48,773.86
Credit notes: —
Net due: 17,99,168.75
TDS deductedExpected 1,759.95 at 0.1% of taxable value: 1,758.21
Paid in cash: 17,97,410.54
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: 18,47,930.41
Notes: 48,773.86
Total position difference: 18,96,704.27
TDS: 1.74
UnexplainedEvery rupee of difference is attributed to a cause: 0.00

Credit and debit notes

1 note in the order they were raised

Raised by

Type

Document number

Their reference

Date

Amount

Raised against

Recovered in

Them

Debit note

20250819-0900572-RDN-FKIIN40580057

FKIDN41062535

19 Aug 2025

-48,773.86

FKIIN40580057

Another invoice’s payment25 Aug 2025, settling 13 other invoices

Our notes total 0.00Their notes total -48,773.86on invoice 2526/2072

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
20250819-0900572-RDN-FKIIN40580057	FKIDN41062535	19 Aug 2025	-48,773.86	30000011027860625 Aug 2025	2526/2027, 2526/2028, 2526/2029, 2526/2030, 2526/2068, 2526/2069 and 7 more

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	20250802-0900572-YNPL25-26/2072FKIIN40580057	02 Aug 2025	18,47,942.61TDS -1,758.21	—	its own document number	Aug 2025 to till daterow 476
Theirs	Debit noteCREDIT	20250819-0900572-RDN-FKIIN40580057FKIDN41062535	19 Aug 2025	-48,773.86	FKIIN40580057	the reference embedded in the document number	Aug 2025 to till daterow 109
Ours	InvoiceTAX INVOICE	YNPL25-26/2072	02 Aug 2025	18,47,936.51	—	its own document number	Ledger YNPLrow 2966
Ours	InvoiceTAX INVOICE	YNPL25-26/2072	02 Aug 2025	18,47,936.51	—	its own document number	YNPL Ledgerrow 2966

Settlement

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

Date	Payment event	Kind	Amount
25 Aug 2025	300000110278606HSBC-071050702001-FKI	CashPaid	-48,773.86
01 Sept 2025	300000148397127HSBC-071050702001-FKI	CashPaid	18,46,184.40

How this was matched

Every link is a rule, never a guess

Their debit note against this invoiceCertain
20250819-0900572-RDN-FKIIN40580057 → 20250802-0900572-YNPL25-26/2072
Matched by the reference embedded in the document number. Document number names FKIIN40580057
Matched to our invoiceCertain
20250802-0900572-YNPL25-26/2072 → YNPL25-26/2072
Matched by an exact invoice number match. FKIIN40580057 matches invoice 2526/2072

Run 8aff1fbc-38b3-48cf-92cd-f32dfeef7a99