YNPL25-26/1768

08 Jul 2025FKIIN39601167PO FJSWG06491324Warehouse 0800054

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 5,82,296.16Our credit and debit notes differ from theirs by -Rs 19,603.37A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice: 11,64,595.28
Credit notes: -39,206.80
Debit notes: —
Net due from customer: 11,25,388.48
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: 5,82,299.12
Debit notes: -19,603.43
Credit notes: —
Net due: 5,62,695.69
TDS deductedExpected 554.57 at 0.1% of taxable value: 553.96
Paid in cash: 5,62,141.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: 5,82,296.16
Notes: -19,603.37
Total position difference: 5,62,692.79
TDS: 0.61
UnexplainedEvery rupee of difference is attributed to a cause: 0.00

Credit and debit notes

5 notes in the order they were raised

Raised by

Type

Document number

Their reference

Date

Amount

Raised against

Recovered in

Them

Debit note

20250727-A250-RDN-FKIIN39601167

FKIDN40256233

27 Jul 2025

-19,603.43

FKIIN39601167

Another invoice’s payment06 Aug 2025, settling 2 other invoices

Them

Debit note

20250727-0800054-RDN-FKIIN39601167

FKIDN40256233

27 Jul 2025

-19,603.43

FKIIN39601167

This invoice’s payment, 18 Aug 2025 (with 5 other invoices)

Them

Debit note

20250727-0800054-RDN-FKIIN39601167_Duplicate

FKIDN40256233

27 Jul 2025

19,603.43

FKIIN39601167

Another invoice’s payment01 Sept 2025, settling 6 other invoices

Credit note

FKIDN40256233

—

31 Jul 2025

-19,603.40

FKIDN40256233

Not yet recovered

Credit note

FKIDN40256233

—

31 Jul 2025

-19,603.40

FKIDN40256233

Not yet recovered

Our notes total -39,206.80Their notes total -19,603.43on invoice 2526/1768

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
20250727-A250-RDN-FKIIN39601167	FKIDN40256233	27 Jul 2025	-19,603.43	30000005596474106 Aug 2025	2526/1702, 2526/1861
20250727-0800054-RDN-FKIIN39601167_Duplicate	FKIDN40256233	27 Jul 2025	19,603.43	30000014838876001 Sept 2025	2526/2126, 2526/2127, 2526/2205, 2526/2206, 2526/2207, 2526/2208

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

Note	Their reference	Date	Amount	Payment event	Raised against invoice
20250806-0800054-RDN-FKIIN40221256	FKIDN40620755	06 Aug 2025	-100.15	30000007693648718 Aug 2025	YNPL25-26/1954

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	20250708-0800054-YNPL25-26/1768FKIIN39601167	08 Jul 2025	5,82,299.12TDS -553.96	—	its own document number	Aug 2025 to till daterow 464
Theirs	Debit noteCREDIT	20250727-A250-RDN-FKIIN39601167FKIDN40256233	27 Jul 2025	-19,603.43	FKIIN39601167	the reference embedded in the document number	Aug 2025 to till daterow 166
Theirs	Debit noteCREDIT	20250727-0800054-RDN-FKIIN39601167FKIDN40256233	27 Jul 2025	-19,603.43	FKIIN39601167	the reference embedded in the document number	Aug 2025 to till daterow 319
Theirs	Debit noteSTANDARD	20250727-0800054-RDN-FKIIN39601167_DuplicateFKIDN40256233Marked duplicate by them	27 Jul 2025	19,603.43	FKIIN39601167	the reference embedded in the document number	Aug 2025 to till daterow 781
Ours	InvoiceTAX INVOICE	YNPL25-26/1768	08 Jul 2025	5,82,297.64	—	its own document number	Ledger YNPLrow 2521
Ours	InvoiceTAX INVOICE	YNPL25-26/1768	08 Jul 2025	5,82,297.64	—	its own document number	YNPL Ledgerrow 2521
Ours	Credit noteCREDIT NOTE-25	FKIDN40256233	31 Jul 2025	-19,603.40	FKIDN40256233	our voucher number naming their note	Ledger YNPLrow 2928
Ours	Credit noteCREDIT NOTE-25	FKIDN40256233	31 Jul 2025	-19,603.40	FKIDN40256233	our voucher number naming their note	YNPL Ledgerrow 2928

Settlement

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

Date	Payment event	Kind	Amount
06 Aug 2025	300000055964741HSBC-071050702001-FKI	CashPaid	-19,603.43
18 Aug 2025	300000076936487HSBC-071050702001-FKI	CashPaid	-19,603.43
18 Aug 2025	300000076936487HSBC-071050702001-FKI	CashPaid	5,81,745.16
01 Sept 2025	300000148388760HSBC-071050702001-FKI	CashPaid	19,603.43

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN40256233 → 20250727-A250-RDN-FKIIN39601167
Matched by an exact voucher number match. Voucher number is their note FKIDN40256233
Our credit note against their debit noteCertain
FKIDN40256233 → 20250727-A250-RDN-FKIIN39601167
Matched by an exact voucher number match. Voucher number is their note FKIDN40256233
Their debit note against this invoiceCertain
20250727-A250-RDN-FKIIN39601167 → 20250708-0800054-YNPL25-26/1768
Matched by the reference embedded in the document number. Document number names FKIIN39601167
Their debit note against this invoiceCertain
20250727-0800054-RDN-FKIIN39601167 → 20250708-0800054-YNPL25-26/1768
Matched by the reference embedded in the document number. Document number names FKIIN39601167
Their debit note against this invoiceCertain
20250727-0800054-RDN-FKIIN39601167_Duplicate → 20250708-0800054-YNPL25-26/1768
Matched by the reference embedded in the document number. Document number names FKIIN39601167
Matched to our invoiceCertain
20250708-0800054-YNPL25-26/1768 → YNPL25-26/1768
Matched by an exact invoice number match. FKIIN39601167 matches invoice 2526/1768

Run c9ea9d8f-7251-4548-b329-c594a10b12ec