YNPL25-26/2773

22 Sept 2025FKIIN42254829PO FSMWG06759901Warehouse 0600386

Back to register

INVOICE AMOUNT MISMATCHOn both sidesInvoice amount differs by Rs 7,78,647.52A debit note was only partly reversed

Compare our invoice YNPL25-26/2773 against their FKIIN42254829; the difference is Rs 7,78,647.52

Our books

From the Tally ledger and note registers

Invoice: 15,57,299.10
Credit notes: -8,105.28
Debit notes: —
Net due from customer: 15,49,193.82
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: 7,78,651.58
Debit notes: -8,105.28
Credit notes: —
Net due: 7,70,546.30
TDS deductedExpected 741.57 at 0.1% of taxable value: 741.57
Paid in cash: 7,69,804.73
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: 7,78,647.52
Notes: —
Total position difference: 7,78,647.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 noteReversed

20250930-0600386-RDN-FKIIN42254829_Reversed

FKIDN42484675

30 Sept 2025

28,350.00

FKIIN42254829

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

Them

Debit note

20250930-0600386-RDN-FKIIN42254829

FKIDN42484675

30 Sept 2025

-36,455.28

FKIIN42254829

This invoice’s payment, 06 Oct 2025 (with 39 other invoices)

Credit note

26-27/June/08/09

—

08 Jun 2026

-8,105.28

2526/2773

Not yet recovered

Our notes total -8,105.28Their notes total -8,105.28on invoice 2526/2773

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
20250930-0600386-RDN-FKIIN42254829_Reversed	FKIDN42484675	30 Sept 2025	28,350.00	30000019655581023 Oct 2025	2526/2608, 2526/2848, 2526/2855, 2526/2946, 2526/2976, 2526/2982 and 31 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	20250922-0600386-YNPL25-26/2773FKIIN42254829	22 Sept 2025	7,78,651.58TDS -741.57	—	its own document number	Aug 2025 to till daterow 1699
Theirs	Debit noteSTANDARD	20250930-0600386-RDN-FKIIN42254829_ReversedFKIDN42484675Reversed	30 Sept 2025	28,350.00	FKIIN42254829	the reference embedded in the document number	Aug 2025 to till daterow 1219
Theirs	Debit noteCREDIT	20250930-0600386-RDN-FKIIN42254829FKIDN42484675	30 Sept 2025	-36,455.28	FKIIN42254829	the reference embedded in the document number	Aug 2025 to till daterow 1761
Ours	InvoiceTAX INVOICE	YNPL25-26/2773	22 Sept 2025	7,78,649.55	—	its own document number	Ledger YNPLrow 3881
Ours	InvoiceTAX INVOICE	YNPL25-26/2773	22 Sept 2025	7,78,649.55	—	its own document number	YNPL Ledgerrow 3881
Ours	Credit noteCredit Note New	26-27/June/08/09	08 Jun 2026	-8,105.28	2526/2773	the reference column in the register	Ledger YNPLrow 7615

Settlement

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

Date	Payment event	Kind	Amount
06 Oct 2025	300000182502740HSBC-071050702001-FKI	CashPaid	7,77,910.01
06 Oct 2025	300000182502740HSBC-071050702001-FKI	CashPaid	-36,455.28
23 Oct 2025	300000196555810HSBC-071050702001-FKI	CashPaid	28,350.00

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
26-27/June/08/09 → YNPL25-26/2773
Matched by the reference column in the register. Raised against our invoice 2526/2773
Their debit note against this invoiceCertain
20250930-0600386-RDN-FKIIN42254829_Reversed → 20250922-0600386-YNPL25-26/2773
Matched by the reference embedded in the document number. Document number names FKIIN42254829
Their debit note against this invoiceCertain
20250930-0600386-RDN-FKIIN42254829 → 20250922-0600386-YNPL25-26/2773
Matched by the reference embedded in the document number. Document number names FKIIN42254829
Matched to our invoiceCertain
20250922-0600386-YNPL25-26/2773 → YNPL25-26/2773
Matched by an exact invoice number match. FKIIN42254829 matches invoice 2526/2773
Reversal of an earlier noteNeeds review
20250930-0600386-RDN-FKIIN42254829_Reversed → 20250930-0600386-RDN-FKIIN42254829
Matched by a shared base reference. Shares base reference RDN-FKIIN42254829 but the amounts do not offset

Run c9ea9d8f-7251-4548-b329-c594a10b12ec