YNPL26-27/0070

06 Apr 2026FKIIN49016026PO FJSWN07902872Warehouse 0800238

Back to register
POSITION MISMATCHOn both sidesInvoice amount differs by Rs 36,278.19Our credit and debit notes differ from theirs by Rs 1,65,892.00

Our books

From the Tally ledger and note registers

Invoice
72,555.24
Credit notes
-116.58
Debit notes
—
Net due from customer
72,438.66
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
36,277.05
Debit notes
-1,66,008.58
Credit notes
—
Net due
-1,29,731.53
TDS deductedExpected 34.55 at 0.1% of taxable value
34.55
Paid in cash
—
Set off against notesBook adjustment, no bank movement
1,29,766.08
Outstanding
-2,59,532.16

Difference, by cause

The parts add up to the total exactly

Invoice amount
36,278.19
Notes
1,65,892.00
Total position difference
2,02,170.19
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
20260416-0800238-RDN-FKIIN49016026
FKIDN49147483
16 Apr 2026
-116.58
FKIIN49016026
This invoice’s payment, 28 Apr 2026
Them
Debit note
20260422-0600159-FKIDN49288824
FKIDN49288824
22 Apr 2026
-1,65,892.00
—
This invoice’s payment, 28 Apr 2026
Us
Credit note
26-27/June/19/08
—
19 Jun 2026
-116.58
2627/70
Not yet recovered
Our notes total -116.58Their notes total -1,66,008.58on invoice 2627/70

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
20260422-0600159-FKIDN49288824FKIDN4928882422 Apr 2026-75,255.80756023488609 May 20262627/386, 2627/389
20260422-0600159-FKIDN49288824FKIDN4928882422 Apr 2026-35,065.31756022761025 Apr 20262627/190, 2627/191, 2627/192, 2627/193, 2627/194, 2627/195 and 15 more
20260422-0600159-FKIDN49288824FKIDN4928882422 Apr 2026-19,444.97756023650412 May 20262627/388

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260406-0800238-YNPL26-27/0070FKIIN4901602606 Apr 202636,277.05TDS -34.55—its own document numberAug 2025 to till daterow 4219
TheirsDebit noteCREDIT20260416-0800238-RDN-FKIIN49016026FKIDN4914748316 Apr 2026-116.58FKIIN49016026the reference embedded in the document numberAug 2025 to till daterow 4448
TheirsDebit noteCREDIT20260422-0600159-FKIDN49288824FKIDN4928882422 Apr 2026-1,65,892.00—the other side of the same payment eventAug 2025 to till daterows 3892, 3893, 4663, 4664
OursInvoiceTAX INVOICEYNPL26-27/007006 Apr 202636,277.62—its own document numberLedger YNPLrow 6354
OursInvoiceTAX INVOICEYNPL26-27/007006 Apr 202636,277.62—its own document numberYNPL Ledgerrow 6354
OursCredit noteCredit Note New26-27/June/19/0819 Jun 2026-116.582627/70the reference column in the registerLedger YNPLrow 8152

Settlement

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

DatePayment eventKindAmount
25 Apr 20267560227610ZERO BANK ACCSet offAdjusted-35,065.31
28 Apr 20267560229534ZERO BANK ACCSet offAdjusted-36,125.92
28 Apr 20267560229534ZERO BANK ACCSet offAdjusted36,242.50
28 Apr 20267560229534ZERO BANK ACCSet offAdjusted-116.58
09 May 20267560234886ZERO BANK ACCSet offAdjusted-75,255.80
12 May 20267560236504ZERO BANK ACCSet offAdjusted-19,444.97

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/June/19/08 → YNPL26-27/0070

    Matched by the reference column in the register. Raised against our invoice 2627/70

  • Their debit note against this invoiceCertain

    20260416-0800238-RDN-FKIIN49016026 → 20260406-0800238-YNPL26-27/0070

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

  • Matched to our invoiceCertain

    20260406-0800238-YNPL26-27/0070 → YNPL26-27/0070

    Matched by an exact invoice number match. FKIIN49016026 matches invoice 2627/70

  • Set off within one payment eventCertain

    20260422-0600159-FKIDN49288824 → 20260406-0800238-YNPL26-27/0070

    Matched by the other side of the same payment event. Set-off batch 7560229534 nets to zero against this invoice

  • Set off within one payment eventCertain

    20260416-0800238-RDN-FKIIN49016026 → 20260406-0800238-YNPL26-27/0070

    Matched by the other side of the same payment event. Set-off batch 7560229534 nets to zero against this invoice

  • Set off within one payment eventCertain

    20260422-0600159-FKIDN49288824 → 20260501-0800238-YNPL26-27/0388

    Matched by the other side of the same payment event. Set-off batch 7560236504 nets to zero against this invoice

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