YNPL25-26/1913

20 Jul 2025FKIIN40052144Warehouse 2140

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 3,48,940.34Our credit and debit notes differ from theirs by -Rs 18,292.68A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice: 6,81,595.82
Credit notes: -15,639.12
Debit notes: —
Net due from customer: 6,65,956.70
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,32,655.48
Debit notes: 2,653.56
Credit notes: —
Net due: 3,35,309.04
TDS deductedExpected 316.81 at 0.1% of taxable value: —
Paid in cash: 3,35,309.04
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,48,940.34
Notes: -18,292.68
Total position difference: 3,30,647.66
TDS: 316.81
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

20250724-2140-RDN-FKIIN40052144_Reversed

FKIDN40163762

24 Jul 2025

2,653.56

FKIIN40052144

Another invoice’s payment05 Jan 2026, settling 17 other invoices

Credit note

FKIDN40163762

—

31 Jul 2025

-7,819.56

FKIDN40163762

Not yet recovered

Credit note

FKIDN40163762

—

31 Jul 2025

-7,819.56

FKIDN40163762

Not yet recovered

Our notes total -15,639.12Their notes total 2,653.56on invoice 2526/1913

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
20250724-2140-RDN-FKIIN40052144_Reversed	FKIDN40163762	24 Jul 2025	2,653.56	30000025722468105 Jan 2026	2526/3694, 2526/3785, 2526/3786, 2526/3789, 2526/3795, 2526/3796 and 11 more

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

Note	Their reference	Date	Amount	Payment event	Raised against invoice
20250728-null-RDN-FKIIN39552115	FKIDN40270328	28 Jul 2025	-20,109.60	30000005597086506 Aug 2025	YNPL25-26/1753
20250726-A274-RDN-FKIIN39433985	FKIDN40244911	26 Jul 2025	-3,953.86	30000005597086506 Aug 2025	YNPL25-26/1717
20250727-6461-RDN-FKIIN39715339	FKIDN40256175	27 Jul 2025	-2,678.76	30000005597086506 Aug 2025	YNPL25-26/1779
20250726-2140-RDN-FKIIN39567510	FKIDN40239993	26 Jul 2025	-2,589.00	30000005597086506 Aug 2025	YNPL25-26/1769
20250728-2140-RDN-FKIIN39397144	FKIDN40296962	28 Jul 2025	-1,056.79	30000005597086506 Aug 2025	YNPL25-26/1697

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	20250720-2140-YNPL25-26/1913FKIIN40052144	20 Jul 2025	3,32,655.48	—	its own document number	Aug 2025 to till daterow 380
Theirs	Debit noteSTANDARD	20250724-2140-RDN-FKIIN40052144_ReversedFKIDN40163762Reversed	24 Jul 2025	2,653.56	FKIIN40052144	the reference embedded in the document number	Aug 2025 to till daterow 2721
Ours	InvoiceTAX INVOICE	YNPL25-26/1913	20 Jul 2025	3,40,797.91	—	its own document number	Ledger YNPLrow 2771
Ours	InvoiceTAX INVOICE	YNPL25-26/1913	20 Jul 2025	3,40,797.91	—	its own document number	YNPL Ledgerrow 2771
Ours	Credit noteCREDIT NOTE-25	FKIDN40163762	31 Jul 2025	-7,819.56	FKIDN40163762	our voucher number naming their note	Ledger YNPLrow 2936
Ours	Credit noteCREDIT NOTE-25	FKIDN40163762	31 Jul 2025	-7,819.56	FKIDN40163762	our voucher number naming their note	YNPL Ledgerrow 2936

Settlement

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

Date	Payment event	Kind	Amount
06 Aug 2025	300000055970865HSBC-071050702001-FKI	CashPaid	3,32,655.48
05 Jan 2026	300000257224681HSBC-071050702001-FKI	CashPaid	2,653.56

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN40163762 → 20250724-2140-RDN-FKIIN40052144_Reversed
Matched by an exact voucher number match. Voucher number is their note FKIDN40163762
Our credit note against their debit noteCertain
FKIDN40163762 → 20250724-2140-RDN-FKIIN40052144_Reversed
Matched by an exact voucher number match. Voucher number is their note FKIDN40163762
Their debit note against this invoiceCertain
20250724-2140-RDN-FKIIN40052144_Reversed → 20250720-2140-YNPL25-26/1913
Matched by the reference embedded in the document number. Document number names FKIIN40052144
Matched to our invoiceCertain
20250720-2140-YNPL25-26/1913 → YNPL25-26/1913
Matched by an exact invoice number match. FKIIN40052144 matches invoice 2526/1913

Run c9ea9d8f-7251-4548-b329-c594a10b12ec