YNPL25-26/2853

26 Sept 2025FKIIN42429756PO FBSWN06927749Warehouse 0600155

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 3,97,015.06Our credit and debit notes differ from theirs by -Rs 6,655.64

Our books

From the Tally ledger and note registers

Invoice: 7,94,032.70
Credit notes: -6,655.64
Debit notes: —
Net due from customer: 7,87,377.06
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,97,017.64
Debit notes: —
Credit notes: —
Net due: 3,97,017.64
TDS deductedExpected 378.11 at 0.1% of taxable value: 378.11
Paid in cash: 3,96,639.53
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,97,015.06
Notes: -6,655.64
Total position difference: 3,90,359.42
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

20251014-0600155-RDN-FKIIN42429756

FKIDN42996694

14 Oct 2025

-6,655.65

FKIIN42429756

This invoice’s payment, 16 Oct 2025 (with 69 other invoices)

Them

Debit noteReversed

20251014-0600155-RDN-FKIIN42429756_Reversed

FKIDN42996694

14 Oct 2025

6,655.65

FKIIN42429756

Another invoice’s payment02 Jan 2026, settling 65 other invoices

Credit note

25-26/Dec/3/6

—

03 Dec 2025

-6,655.64

2526/2853

Not yet recovered

Our notes total -6,655.64Their notes total 0.00on invoice 2526/2853

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
20251014-0600155-RDN-FKIIN42429756_Reversed	FKIDN42996694	14 Oct 2025	6,655.65	30000025539836102 Jan 2026	2526/3612, 2526/3650, 2526/3658, 2526/3660, 2526/3662, 2526/3663 and 59 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	20250926-0600155-YNPL25-26/2853FKIIN42429756	26 Sept 2025	3,97,017.64TDS -378.11	—	its own document number	Aug 2025 to till daterow 1576
Theirs	Debit noteCREDIT	20251014-0600155-RDN-FKIIN42429756FKIDN42996694	14 Oct 2025	-6,655.65	FKIIN42429756	the reference embedded in the document number	Aug 2025 to till daterow 1397
Theirs	Debit noteSTANDARD	20251014-0600155-RDN-FKIIN42429756_ReversedFKIDN42996694Reversed	14 Oct 2025	6,655.65	FKIIN42429756	the reference embedded in the document number	Aug 2025 to till daterow 3012
Ours	InvoiceTAX INVOICE	YNPL25-26/2853	26 Sept 2025	3,97,016.35	—	its own document number	Ledger YNPLrow 3966
Ours	InvoiceTAX INVOICE	YNPL25-26/2853	26 Sept 2025	3,97,016.35	—	its own document number	YNPL Ledgerrow 3966
Ours	Credit noteCredit Note New	25-26/Dec/3/6	03 Dec 2025	-6,655.64	2526/2853	the reference column in the register	Ledger YNPLrow 4891

Settlement

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

Date	Payment event	Kind	Amount
16 Oct 2025	300000192369049HSBC-071050702001-FKI	CashPaid	-6,655.65
16 Oct 2025	300000192369049HSBC-071050702001-FKI	CashPaid	3,96,639.53
02 Jan 2026	300000255398361HSBC-071050702001-FKI	CashPaid	6,655.65

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
25-26/Dec/3/6 → YNPL25-26/2853
Matched by the reference column in the register. Raised against our invoice 2526/2853
Their debit note against this invoiceCertain
20251014-0600155-RDN-FKIIN42429756 → 20250926-0600155-YNPL25-26/2853
Matched by the reference embedded in the document number. Document number names FKIIN42429756
Their debit note against this invoiceCertain
20251014-0600155-RDN-FKIIN42429756_Reversed → 20250926-0600155-YNPL25-26/2853
Matched by the reference embedded in the document number. Document number names FKIIN42429756
Matched to our invoiceCertain
20250926-0600155-YNPL25-26/2853 → YNPL25-26/2853
Matched by an exact invoice number match. FKIIN42429756 matches invoice 2526/2853
Reversal of an earlier noteCertain
20251014-0600155-RDN-FKIIN42429756_Reversed → 20251014-0600155-RDN-FKIIN42429756
Matched by a shared base reference and an offsetting amount. Reverses RDN-FKIIN42429756 exactly

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