YNPL25-26/2551

07 Sept 2025FKIIN41743894PO FBSWN06760736Warehouse 0600155

Back to register

INVOICE AMOUNT MISMATCHOn both sidesInvoice amount differs by Rs 3,44,908.19A debit note was only partly reversed

Compare our invoice YNPL25-26/2551 against their FKIIN41743894; the difference is Rs 3,44,908.19

Our books

From the Tally ledger and note registers

Invoice: 6,89,817.04
Credit notes: -5,027.00
Debit notes: —
Net due from customer: 6,84,790.04
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: 3,44,908.85
Debit notes: -5,027.00
Credit notes: —
Net due: 3,39,881.85
TDS deductedExpected 328.48 at 0.1% of taxable value: 328.48
Paid in cash: 3,39,553.37
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: 3,44,908.19
Notes: —
Total position difference: 3,44,908.19
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

20250918-0600155-RDN-FKIIN41743894

FKIDN42061318

18 Sept 2025

-18,272.12

FKIIN41743894

This invoice’s payment, 22 Sept 2025 (with 26 other invoices)

Them

Debit noteReversed

20250918-0600155-RDN-FKIIN41743894_Reversed

FKIDN42061318

18 Sept 2025

13,245.12

FKIIN41743894

Another invoice’s payment23 Oct 2025, settling 37 other invoices

Credit note

26-27/June/08/02

—

08 Jun 2026

-5,027.00

2526/2551

Not yet recovered

Our notes total -5,027.00Their notes total -5,027.00on invoice 2526/2551

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
20250918-0600155-RDN-FKIIN41743894_Reversed	FKIDN42061318	18 Sept 2025	13,245.12	30000019655581023 Oct 2025	2526/2608, 2526/2848, 2526/2855, 2526/2946, 2526/2976, 2526/2982 and 31 more

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

Note	Their reference	Date	Amount	Payment event	Raised against invoice
20250909-0700010-RDN-FKIIN41722922	FKIDN41762437	09 Sept 2025	-2,270.20	30000016892463022 Sept 2025	YNPL25-26/2542

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	20250907-0600155-YNPL25-26/2551FKIIN41743894	07 Sept 2025	3,44,908.85TDS -328.48	—	its own document number	Aug 2025 to till daterow 538
Theirs	Debit noteCREDIT	20250918-0600155-RDN-FKIIN41743894FKIDN42061318	18 Sept 2025	-18,272.12	FKIIN41743894	the reference embedded in the document number	Aug 2025 to till daterow 688
Theirs	Debit noteSTANDARD	20250918-0600155-RDN-FKIIN41743894_ReversedFKIDN42061318Reversed	18 Sept 2025	13,245.12	FKIIN41743894	the reference embedded in the document number	Aug 2025 to till daterow 1729
Ours	InvoiceTAX INVOICE	YNPL25-26/2551	07 Sept 2025	3,44,908.52	—	its own document number	Ledger YNPLrow 3563
Ours	InvoiceTAX INVOICE	YNPL25-26/2551	07 Sept 2025	3,44,908.52	—	its own document number	YNPL Ledgerrow 3563
Ours	Credit noteCredit Note New	26-27/June/08/02	08 Jun 2026	-5,027.00	2526/2551	the reference column in the register	Ledger YNPLrow 7587

Settlement

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

Date	Payment event	Kind	Amount
22 Sept 2025	300000168924630HSBC-071050702001-FKI	CashPaid	3,44,580.37
22 Sept 2025	300000168924630HSBC-071050702001-FKI	CashPaid	-18,272.12
23 Oct 2025	300000196555810HSBC-071050702001-FKI	CashPaid	13,245.12

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
26-27/June/08/02 → YNPL25-26/2551
Matched by the reference column in the register. Raised against our invoice 2526/2551
Their debit note against this invoiceCertain
20250918-0600155-RDN-FKIIN41743894 → 20250907-0600155-YNPL25-26/2551
Matched by the reference embedded in the document number. Document number names FKIIN41743894
Their debit note against this invoiceCertain
20250918-0600155-RDN-FKIIN41743894_Reversed → 20250907-0600155-YNPL25-26/2551
Matched by the reference embedded in the document number. Document number names FKIIN41743894
Matched to our invoiceCertain
20250907-0600155-YNPL25-26/2551 → YNPL25-26/2551
Matched by an exact invoice number match. FKIIN41743894 matches invoice 2526/2551
Reversal of an earlier noteNeeds review
20250918-0600155-RDN-FKIIN41743894_Reversed → 20250918-0600155-RDN-FKIIN41743894
Matched by a shared base reference. Shares base reference RDN-FKIIN41743894 but the amounts do not offset

Run c9ea9d8f-7251-4548-b329-c594a10b12ec