YNPL25-26/1913

20 Jul 2025FKIIN40052144Warehouse 2140

Back to register
POSITION MISMATCHOn both sidesInvoice amount differs by Rs 8,142.43Our credit and debit notes differ from theirs by -Rs 10,473.12A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice
3,40,797.91
Credit notes
-7,819.56
Debit notes
Net due from customer
3,32,978.35
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
8,142.43
Notes
-10,473.12
Total position difference
-2,330.69
TDS
316.81
UnexplainedEvery rupee of difference is attributed to a cause
0.00

Credit and debit notes

2 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
Us
Credit note
FKIDN40163762
31 Jul 2025
-7,819.56
FKIDN40163762
Not yet recovered
Our notes total -7,819.56Their 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

NoteTheir referenceDateAmountPayment eventPayment settled invoices
20250724-2140-RDN-FKIIN40052144_ReversedFKIDN4016376224 Jul 20252,653.5630000025722468105 Jan 20262526/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

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250728-null-RDN-FKIIN39552115FKIDN4027032828 Jul 2025-20,109.6030000005597086506 Aug 2025YNPL25-26/1753
20250726-A274-RDN-FKIIN39433985FKIDN4024491126 Jul 2025-3,953.8630000005597086506 Aug 2025YNPL25-26/1717
20250727-6461-RDN-FKIIN39715339FKIDN4025617527 Jul 2025-2,678.7630000005597086506 Aug 2025YNPL25-26/1779
20250726-2140-RDN-FKIIN39567510FKIDN4023999326 Jul 2025-2,589.0030000005597086506 Aug 2025YNPL25-26/1769
20250728-2140-RDN-FKIIN39397144FKIDN4029696228 Jul 2025-1,056.7930000005597086506 Aug 2025YNPL25-26/1697

Source documents

Every row that contributed, with the file and Excel row it came from

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250720-2140-YNPL25-26/1913FKIIN4005214420 Jul 20253,32,655.48its own document numberAug 2025 to till daterow 380
TheirsDebit noteSTANDARD20250724-2140-RDN-FKIIN40052144_ReversedFKIDN40163762Reversed24 Jul 20252,653.56FKIIN40052144the reference embedded in the document numberAug 2025 to till daterow 2721
OursInvoiceTAX INVOICEYNPL25-26/191320 Jul 20253,40,797.91its own document numberYNPL Ledgerrow 2771
OursCredit noteCREDIT NOTE-25FKIDN4016376231 Jul 2025-7,819.56FKIDN40163762our voucher number naming their noteYNPL Ledgerrow 2936

Settlement

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

DatePayment eventKindAmount
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid3,32,655.48
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid2,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

  • 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 721876af-4fea-45ef-8ef8-5412d9b1931d