YNPL25-26/0648

01 May 2025FKIIN37299566PO FBSWN06149469Warehouse 2140

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 1,16,222.68Our credit and debit notes differ from theirs by -Rs 59,172.12

Our books

From the Tally ledger and note registers

Invoice: 2,32,445.66
Credit notes: -59,172.12
Debit notes: —
Net due from customer: 1,73,273.54
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: 1,16,222.98
Debit notes: —
Credit notes: —
Net due: 1,16,222.98
TDS deductedExpected 110.69 at 0.1% of taxable value: 110.69
Paid in cash: 1,16,112.29
Set off against notesBook adjustment, no bank movement: —
Outstanding: 0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount: 1,16,222.68
Notes: -59,172.12
Total position difference: 57,050.56
TDS: —
UnexplainedEvery rupee of difference is attributed to a cause: 0.00

Credit and debit notes

4 notes in the order they were raised

Raised by

Type

Document number

Their reference

Date

Amount

Raised against

Recovered in

Them

Debit note

20250516-2140-RDN-FKIIN37299566

FKIDN37749972

16 May 2025

-29,586.06

FKIIN37299566

This invoice’s payment, 19 May 2025 (with 67 other invoices)

Them

Debit noteReversed

20250516-2140-RDN-FKIIN37299566_Reversed

FKIDN37749972

16 May 2025

29,586.06

FKIIN37299566

Another invoice’s payment23 Jun 2025, settling 77 other invoices

Credit note

FKIDN37749972

—

20 May 2025

-29,586.06

FKIDN37749972

Not yet recovered

Credit note

FKIDN37749972

—

20 May 2025

-29,586.06

FKIDN37749972

Not yet recovered

Our notes total -59,172.12Their notes total 0.00on invoice 2526/648

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
20250516-2140-RDN-FKIIN37299566_Reversed	FKIDN37749972	16 May 2025	29,586.06	HSBCN1745243867523 Jun 2025	2526/1240, 2526/1245, 2526/1249, 2526/1259, 2526/1260, 2526/1269 and 71 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	TDS memoCREDIT	20250501-2140-YNPL25-26/0648-TDS-CM-19627805	01 May 2025	-110.69	—	the reference embedded in the document number	Jan 2025 to July 2025row 850
Theirs	InvoiceSTANDARD	20250501-2140-YNPL25-26/0648FKIIN37299566	01 May 2025	1,16,222.98	—	its own document number	Jan 2025 to July 2025row 907
Theirs	Debit noteCREDIT	20250516-2140-RDN-FKIIN37299566FKIDN37749972	16 May 2025	-29,586.06	FKIIN37299566	the reference embedded in the document number	Jan 2025 to July 2025row 957
Theirs	Debit noteSTANDARD	20250516-2140-RDN-FKIIN37299566_ReversedFKIDN37749972Reversed	16 May 2025	29,586.06	FKIIN37299566	the reference embedded in the document number	Jan 2025 to July 2025row 1601
Ours	InvoiceTAX INVOICE	YNPL25-26/0648	01 May 2025	1,16,222.83	—	its own document number	Ledger YNPLrow 748
Ours	InvoiceTAX INVOICE	YNPL25-26/0648	01 May 2025	1,16,222.83	—	its own document number	YNPL Ledgerrow 748
Ours	Credit noteCREDIT NOTE-25	FKIDN37749972	20 May 2025	-29,586.06	FKIDN37749972	our voucher number naming their note	Ledger YNPLrow 1299
Ours	Credit noteCREDIT NOTE-25	FKIDN37749972	20 May 2025	-29,586.06	FKIDN37749972	our voucher number naming their note	YNPL Ledgerrow 1299

Settlement

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

Date	Payment event	Kind	Amount
19 May 2025	HSBCN13944054014HDFC BANK LTD	CashActual Payment	-110.69
19 May 2025	HSBCN13944054014HDFC BANK LTD	CashActual Payment	1,16,222.98
19 May 2025	HSBCN13944054014HDFC BANK LTD	CashActual Payment	-29,586.06
23 Jun 2025	HSBCN17452438675HDFC BANK LTD	CashActual Payment	29,586.06

How this was matched

Every link is a rule, never a guess

Our credit note against their debit noteCertain
FKIDN37749972 → 20250516-2140-RDN-FKIIN37299566
Matched by an exact voucher number match. Voucher number is their note FKIDN37749972
Our credit note against their debit noteCertain
FKIDN37749972 → 20250516-2140-RDN-FKIIN37299566
Matched by an exact voucher number match. Voucher number is their note FKIDN37749972
Their debit note against this invoiceCertain
20250516-2140-RDN-FKIIN37299566 → 20250501-2140-YNPL25-26/0648
Matched by the reference embedded in the document number. Document number names FKIIN37299566
Their debit note against this invoiceCertain
20250516-2140-RDN-FKIIN37299566_Reversed → 20250501-2140-YNPL25-26/0648
Matched by the reference embedded in the document number. Document number names FKIIN37299566
Matched to our invoiceCertain
20250501-2140-YNPL25-26/0648 → YNPL25-26/0648
Matched by an exact invoice number match. FKIIN37299566 matches invoice 2526/648
Reversal of an earlier noteCertain
20250516-2140-RDN-FKIIN37299566_Reversed → 20250516-2140-RDN-FKIIN37299566
Matched by a shared base reference and an offsetting amount. Reverses RDN-FKIIN37299566 exactly
TDS memo against this invoiceCertain
20250501-2140-YNPL25-26/0648-TDS-CM-19627805 → 20250501-2140-YNPL25-26/0648
Matched by the reference embedded in the document number. TDS memo for invoice 2526/648

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