YNPL25-26/4308

12 Feb 2026FKIIN47008851PO FBSWN07551632Warehouse 0600155

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 1,06,391.42Our credit and debit notes differ from theirs by -Rs 11,398.71A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice: 2,12,772.84
Credit notes: -22,858.92
Debit notes: —
Net due from customer: 1,89,913.92
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,06,381.42
Debit notes: -11,460.21
Credit notes: —
Net due: 94,921.21
TDS deductedExpected 101.32 at 0.1% of taxable value: 101.31
Paid in cash: 94,819.90
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: 1,06,391.42
Notes: -11,398.71
Total position difference: 94,992.71
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

20260217-0600155-RDN-FKIIN47008851

FKIDN47149591

17 Feb 2026

-22,857.96

FKIIN47008851

This invoice’s payment, 27 Feb 2026 (with 47 other invoices)

Them

Debit noteReversed

20260217-0600155-RDN-FKIIN47008851_Reversed

FKIDN47149591

17 Feb 2026

11,397.75

FKIIN47008851

Another invoice’s payment09 Mar 2026, settling 29 other invoices

Credit note

25-26/Mar/23/10

—

23 Mar 2026

-22,858.92

2526/4308

Not yet recovered

Our notes total -22,858.92Their notes total -11,460.21on invoice 2526/4308

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
20260217-0600155-RDN-FKIIN47008851_Reversed	FKIDN47149591	17 Feb 2026	11,397.75	30000031592582809 Mar 2026	2526/4389, 2526/4393, 2526/4394, 2526/4395, 2526/4396, 2526/4397 and 23 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	20260212-0600155-YNPL25-26/4308FKIIN47008851	12 Feb 2026	1,06,381.42TDS -101.31	—	its own document number	Aug 2025 to till daterows 3341, 3722
Theirs	Debit noteCREDIT	20260217-0600155-RDN-FKIIN47008851FKIDN47149591	17 Feb 2026	-22,857.96	FKIIN47008851	the reference embedded in the document number	Aug 2025 to till daterow 3258
Theirs	Debit noteSTANDARD	20260217-0600155-RDN-FKIIN47008851_ReversedFKIDN47149591Reversed	17 Feb 2026	11,397.75	FKIIN47008851	the reference embedded in the document number	Aug 2025 to till daterow 3784
Ours	InvoiceTAX INVOICE	YNPL25-26/4308	12 Feb 2026	1,06,386.42	—	its own document number	Ledger YNPLrow 5740
Ours	InvoiceTAX INVOICE	YNPL25-26/4308	12 Feb 2026	1,06,386.42	—	its own document number	YNPL Ledgerrow 5740
Ours	Credit noteCredit Note New	25-26/Mar/23/10	23 Mar 2026	-22,858.92	2526/4308	the reference column in the register	Ledger YNPLrow 6137

Settlement

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

Date	Payment event	Kind	Amount
27 Feb 2026	7560165475ZERO BANK ACC	Set offAdjusted	-22,857.96
27 Feb 2026	7560165475ZERO BANK ACC	Set offAdjusted	22,857.96
02 Mar 2026	300000308168433HSBC-071050702001-FKI	CashPaid	83,422.15
09 Mar 2026	300000315925828HSBC-071050702001-FKI	CashPaid	11,397.75

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
25-26/Mar/23/10 → YNPL25-26/4308
Matched by the reference column in the register. Raised against our invoice 2526/4308
Their debit note against this invoiceCertain
20260217-0600155-RDN-FKIIN47008851 → 20260212-0600155-YNPL25-26/4308
Matched by the reference embedded in the document number. Document number names FKIIN47008851
Their debit note against this invoiceCertain
20260217-0600155-RDN-FKIIN47008851_Reversed → 20260212-0600155-YNPL25-26/4308
Matched by the reference embedded in the document number. Document number names FKIIN47008851
Matched to our invoiceCertain
20260212-0600155-YNPL25-26/4308 → YNPL25-26/4308
Matched by an exact invoice number match. FKIIN47008851 matches invoice 2526/4308
Reversal of an earlier noteNeeds review
20260217-0600155-RDN-FKIIN47008851_Reversed → 20260217-0600155-RDN-FKIIN47008851
Matched by a shared base reference. Shares base reference RDN-FKIIN47008851 but the amounts do not offset

Run c9ea9d8f-7251-4548-b329-c594a10b12ec