YNPL25-26/4161

28 Jan 2026FKIIN46366427PO FBSWN07469565Warehouse 0600155

POSITION MISMATCHOn both sidesInvoice amount differs by Rs 1,89,898.48Our credit and debit notes differ from theirs by -Rs 1,543.82

Our books

From the Tally ledger and note registers

Invoice: 3,79,778.50
Credit notes: -1,543.82
Debit notes: —
Net due from customer: 3,78,234.68
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,89,880.02
Debit notes: —
Credit notes: —
Net due: 1,89,880.02
TDS deductedExpected 180.84 at 0.1% of taxable value: 180.84
Paid in cash: 1,89,699.18
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,89,898.48
Notes: -1,543.82
Total position difference: 1,88,354.66
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

20260130-0600155-RDN-FKIIN46366427

FKIDN46398587

30 Jan 2026

-1,543.74

FKIIN46366427

This invoice’s payment, 12 Feb 2026 (with 12 other invoices)

Them

Debit noteReversed

20260130-0600155-RDN-FKIIN46366427_Reversed

FKIDN46398587

30 Jan 2026

1,543.74

FKIIN46366427

Another invoice’s payment09 Feb 2026, settling 28 other invoices

Credit note

25-26/Feb/11/03

—

11 Feb 2026

-1,543.82

2526/4161

Not yet recovered

Our notes total -1,543.82Their notes total 0.00on invoice 2526/4161

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
20260130-0600155-RDN-FKIIN46366427_Reversed	FKIDN46398587	30 Jan 2026	1,543.74	30000028632371909 Feb 2026	2526/4093, 2526/4094, 2526/4106, 2526/4108, 2526/4109, 2526/4117 and 22 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	20260128-0600155-YNPL25-26/4161FKIIN46366427	28 Jan 2026	1,89,880.02TDS -180.84	—	its own document number	Aug 2025 to till daterow 3379
Theirs	Debit noteCREDIT	20260130-0600155-RDN-FKIIN46366427FKIDN46398587	30 Jan 2026	-1,543.74	FKIIN46366427	the reference embedded in the document number	Aug 2025 to till daterow 3046
Theirs	Debit noteSTANDARD	20260130-0600155-RDN-FKIIN46366427_ReversedFKIDN46398587Reversed	30 Jan 2026	1,543.74	FKIIN46366427	the reference embedded in the document number	Aug 2025 to till daterow 3169
Ours	InvoiceTAX INVOICE	YNPL25-26/4161	28 Jan 2026	1,89,889.25	—	its own document number	Ledger YNPLrow 5566
Ours	InvoiceTAX INVOICE	YNPL25-26/4161	28 Jan 2026	1,89,889.25	—	its own document number	YNPL Ledgerrow 5566
Ours	Credit noteCredit Note New	25-26/Feb/11/03	11 Feb 2026	-1,543.82	2526/4161	the reference column in the register	Ledger YNPLrow 5729

Settlement

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

Date	Payment event	Kind	Amount
09 Feb 2026	300000286323719HSBC-071050702001-FKI	CashPaid	1,543.74
12 Feb 2026	300000289740517HSBC-071050702001-FKI	CashPaid	-1,543.74
12 Feb 2026	300000289740517HSBC-071050702001-FKI	CashPaid	1,89,699.18

How this was matched

Every link is a rule, never a guess

Our credit note against this invoiceCertain
25-26/Feb/11/03 → YNPL25-26/4161
Matched by the reference column in the register. Raised against our invoice 2526/4161
Their debit note against this invoiceCertain
20260130-0600155-RDN-FKIIN46366427 → 20260128-0600155-YNPL25-26/4161
Matched by the reference embedded in the document number. Document number names FKIIN46366427
Their debit note against this invoiceCertain
20260130-0600155-RDN-FKIIN46366427_Reversed → 20260128-0600155-YNPL25-26/4161
Matched by the reference embedded in the document number. Document number names FKIIN46366427
Matched to our invoiceCertain
20260128-0600155-YNPL25-26/4161 → YNPL25-26/4161
Matched by an exact invoice number match. FKIIN46366427 matches invoice 2526/4161
Reversal of an earlier noteCertain
20260130-0600155-RDN-FKIIN46366427_Reversed → 20260130-0600155-RDN-FKIIN46366427
Matched by a shared base reference and an offsetting amount. Reverses RDN-FKIIN46366427 exactly

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