YNPL25-26/1937

22 Jul 2025FKIIN40203564PO FDMWG06534266Warehouse 0600159

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
4,13,096.04
Credit notes
-5,279.95
Debit notes
Net due from customer
4,07,816.09
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
4,13,096.76
Debit notes
-5,279.95
Credit notes
Net due
4,07,816.81
TDS deductedExpected 393.43 at 0.1% of taxable value
393.44
Paid in cash
4,07,423.37
Set off against notesBook adjustment, no bank movement
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-0.72
Notes
Total position difference
-0.72
TDS
-0.01
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 note
20250728-0600159-RDN-FKIIN40203564
FKIDN40278594
28 Jul 2025
-5,279.95
FKIIN40203564
Another invoice’s payment11 Aug 2025, settling 44 other invoices
Us
Credit note
FKIDN40278594
08 Aug 2025
-5,279.95
FKIDN40278594
Not yet recovered
Our notes total -5,279.95Their notes total -5,279.95on invoice 2526/1937

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
20250728-0600159-RDN-FKIIN40203564FKIDN4027859428 Jul 2025-5,279.9530000006226254411 Aug 20252526/1946, 2526/1947, 2526/1948, 2526/1949, 2526/1963, 2526/1964 and 38 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
TheirsInvoiceSTANDARD20250722-0600159-YNPL25-26/1937FKIIN4020356422 Jul 20254,13,096.76TDS -393.44its own document numberAug 2025 to till daterow 265
TheirsDebit noteCREDIT20250728-0600159-RDN-FKIIN40203564FKIDN4027859428 Jul 2025-5,279.95FKIIN40203564the reference embedded in the document numberAug 2025 to till daterow 185
OursInvoiceTAX INVOICEYNPL25-26/193722 Jul 20254,13,096.04its own document numberYNPL Ledgerrow 2802
OursCredit noteCREDIT NOTE-25FKIDN4027859408 Aug 2025-5,279.95FKIDN40278594our voucher number naming their noteYNPL Ledgerrow 3062

Settlement

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

DatePayment eventKindAmount
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid4,12,703.32
11 Aug 2025300000062262544HSBC-071050702001-FKICashPaid-5,279.95

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40278594 → 20250728-0600159-RDN-FKIIN40203564

    Matched by an exact voucher number match. Voucher number is their note FKIDN40278594

  • Their debit note against this invoiceCertain

    20250728-0600159-RDN-FKIIN40203564 → 20250722-0600159-YNPL25-26/1937

    Matched by the reference embedded in the document number. Document number names FKIIN40203564

  • Matched to our invoiceCertain

    20250722-0600159-YNPL25-26/1937 → YNPL25-26/1937

    Matched by an exact invoice number match. FKIIN40203564 matches invoice 2526/1937

Run 721876af-4fea-45ef-8ef8-5412d9b1931d