YNPL26-27/0385

01 May 2026FKIIN49623604PO FJSWN08057266Warehouse 0800238

Back to register
CREDIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by Rs 5,15,050.17

Reconcile our credit notes against their debit notes for this invoice

Our books

From the Tally ledger and note registers

Invoice
5,53,424.47
Credit notes
-43,667.31
Debit notes
Net due from customer
5,09,757.16
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
5,53,425.89
Debit notes
-5,58,717.48
Credit notes
Net due
-5,291.59
TDS deductedExpected 527.07 at 0.1% of taxable value
527.07
Paid in cash
2,64,760.57
Set off against notesBook adjustment, no bank movement
2,70,579.23
Outstanding
-5,41,158.46

Difference, by cause

The parts add up to the total exactly

Invoice amount
-1.42
Notes
5,15,050.17
Total position difference
5,15,048.75
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
20260505-3300205-FKIDN49658116
FKIDN49658116
05 May 2026
-5,15,050.00
This invoice’s payment, 17 May 2026
Them
Debit note
20260515-0800238-RDN-FKIIN49623604
FKIDN49958907
15 May 2026
-43,667.48
FKIIN49623604
This invoice’s payment, 17 May 2026
Us
Credit note
26-27/June/24/07
24 Jun 2026
-43,667.31
2627/385
Not yet recovered
Our notes total -43,667.31Their notes total -5,58,717.48on invoice 2627/385

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
20260505-3300205-FKIDN49658116FKIDN4965811605 May 2026-2,70,579.23756023894816 May 20262627/387, 2627/448, 2627/449, 2627/450, 2627/452

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20260501-0800238-YNPL26-27/0385FKIIN4962360401 May 20265,53,425.89TDS -527.07its own document numberAug 2025 to till daterows 4852, 4853
TheirsDebit noteCREDIT20260505-3300205-FKIDN49658116FKIDN4965811605 May 2026-5,15,050.00the other side of the same payment eventAug 2025 to till daterows 5176, 5177
TheirsDebit noteCREDIT20260515-0800238-RDN-FKIIN49623604FKIDN4995890715 May 2026-43,667.48FKIIN49623604the reference embedded in the document numberAug 2025 to till daterow 4872
OursInvoiceTAX INVOICEYNPL26-27/038501 May 20265,53,424.47its own document numberYNPL Ledgerrow 6790
OursCredit noteCredit Note New26-27/June/24/0724 Jun 2026-43,667.312627/385the reference column in the registerYNPL Ledgerrow 8427

Settlement

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

DatePayment eventKindAmount
16 May 20267560238948ZERO BANK ACCSet offAdjusted-2,70,579.23
17 May 20267560239863ZERO BANK ACCSet offAdjusted2,88,138.25
17 May 20267560239863ZERO BANK ACCSet offAdjusted-43,667.48
17 May 20267560239863ZERO BANK ACCSet offAdjusted-2,44,470.77
18 May 2026300000380723635HSBC-071050702001-FKICashPaid2,64,760.57

How this was matched

Every link is a rule, never a guess

  • Our credit note against this invoiceCertain

    26-27/June/24/07 → YNPL26-27/0385

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

  • Their debit note against this invoiceCertain

    20260515-0800238-RDN-FKIIN49623604 → 20260501-0800238-YNPL26-27/0385

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

  • Matched to our invoiceCertain

    20260501-0800238-YNPL26-27/0385 → YNPL26-27/0385

    Matched by an exact invoice number match. FKIIN49623604 matches invoice 2627/385

  • Set off within one payment eventCertain

    20260515-0800238-RDN-FKIIN49623604 → 20260501-0800238-YNPL26-27/0385

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

  • Set off within one payment eventCertain

    20260505-3300205-FKIDN49658116 → 20260501-0800238-YNPL26-27/0385

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

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