YNPL25-26/4685

20 Mar 2026FKIIN48216352PO FBSWN07848983Warehouse 0600155

Back to register

INVOICE AMOUNT MISMATCHOn both sidesInvoice amount differs by Rs 14,40,489.59A debit note was only partly reversed

Compare our invoice YNPL25-26/4685 against their FKIIN48216352; the difference is Rs 14,40,489.59

Our books

From the Tally ledger and note registers

Invoice: 28,80,985.38
Credit notes: -22,312.61
Debit notes: —
Net due from customer: 28,58,672.77
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: 14,40,495.79
Debit notes: -22,112.54
Credit notes: —
Net due: 14,18,383.25
TDS deductedExpected 1,371.90 at 0.1% of taxable value: 1,371.90
Paid in cash: 14,17,011.35
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: 14,40,489.59
Notes: -200.07
Total position difference: 14,40,289.52
TDS: —
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

20260327-0600155-RDN-FKIIN48216352

FKIDN48416060

27 Mar 2026

-22,312.93

FKIIN48216352

This invoice’s payment, 31 Mar 2026 (with 86 other invoices)

Them

Debit noteReversed

20260327-0600155-RDN-FKIIN48216352_Reversed1

FKIDN48416060

27 Mar 2026

200.39

FKIIN48216352

Another invoice’s payment16 Apr 2026, settling 15 other invoices

Credit note

26-27/Apr/10/11

—

10 Apr 2026

-22,312.61

2526/4685

Not yet recovered

Our notes total -22,312.61Their notes total -22,112.54on invoice 2526/4685

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
20260327-0600155-RDN-FKIIN48216352_Reversed1	FKIDN48416060	27 Mar 2026	200.39	30000035039644216 Apr 2026	2526/4806, 2526/4819, 2526/4821, 2526/4822, 2526/4823, 2526/4824 and 9 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	20260320-0600155-YNPL25-26/4685FKIIN48216352	20 Mar 2026	14,40,495.79TDS -1,371.90	—	its own document number	Aug 2025 to till daterows 3583, 4100
Theirs	Debit noteCREDIT	20260327-0600155-RDN-FKIIN48216352FKIDN48416060	27 Mar 2026	-22,312.93	FKIIN48216352	the reference embedded in the document number	Aug 2025 to till daterow 3779
Theirs	Debit noteSTANDARD	20260327-0600155-RDN-FKIIN48216352_Reversed1FKIDN48416060Reversed	27 Mar 2026	200.39	FKIIN48216352	the reference embedded in the document number	Aug 2025 to till daterow 4075
Ours	InvoiceTAX INVOICE	YNPL25-26/4685	20 Mar 2026	14,40,492.69	—	its own document number	Ledger YNPLrow 6109
Ours	InvoiceTAX INVOICE	YNPL25-26/4685	20 Mar 2026	14,40,492.69	—	its own document number	YNPL Ledgerrow 6109
Ours	Credit noteCredit Note New	26-27/Apr/10/11	10 Apr 2026	-22,312.61	2526/4685	the reference column in the register	Ledger YNPLrow 6434

Settlement

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

Date	Payment event	Kind	Amount
31 Mar 2026	7560178828ZERO BANK ACC	Set offAdjusted	22,312.93
31 Mar 2026	7560178828ZERO BANK ACC	Set offAdjusted	-22,312.93
05 Apr 2026	300000340935204HSBC-071050702001-FKI	CashPaid	14,16,810.96
16 Apr 2026	300000350396442HSBC-071050702001-FKI	CashPaid	200.39

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
26-27/Apr/10/11 → YNPL25-26/4685
Matched by the reference column in the register. Raised against our invoice 2526/4685
Their debit note against this invoiceCertain
20260327-0600155-RDN-FKIIN48216352 → 20260320-0600155-YNPL25-26/4685
Matched by the reference embedded in the document number. Document number names FKIIN48216352
Their debit note against this invoiceCertain
20260327-0600155-RDN-FKIIN48216352_Reversed1 → 20260320-0600155-YNPL25-26/4685
Matched by the reference embedded in the document number. Document number names FKIIN48216352
Matched to our invoiceCertain
20260320-0600155-YNPL25-26/4685 → YNPL25-26/4685
Matched by an exact invoice number match. FKIIN48216352 matches invoice 2526/4685
Reversal of an earlier noteNeeds review
20260327-0600155-RDN-FKIIN48216352_Reversed1 → 20260327-0600155-RDN-FKIIN48216352
Matched by a shared base reference. Shares base reference RDN-FKIIN48216352 but the amounts do not offset

Run c9ea9d8f-7251-4548-b329-c594a10b12ec