YLedger Reconciliation

YNPL25-26/0648

01 May 2025FKIIN37299566PO FBSWN06149469Warehouse 2140

Back to register
DEBIT NOTE MISMATCHOn both sidesOur credit and debit notes differ from theirs by -Rs 29,586.06

Our books

From the Tally ledger and note registers

Invoice
1,16,222.83
Credit notes
-29,586.06
Debit notes
—
Net due from customer
86,636.77
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,16,222.98
Debit notes
—
Credit notes
—
Net due
1,16,222.98
TDS deductedExpected 110.69 at 0.1% of taxable value
110.69
Paid in cash
1,16,112.29
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.15
Notes
-29,586.06
Total position difference
-29,586.21
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
20250516-2140-RDN-FKIIN37299566
FKIDN37749972
16 May 2025
-29,586.06
FKIIN37299566
This invoice’s payment, 19 May 2025 (with 67 other invoices)
Them
Debit noteReversed
20250516-2140-RDN-FKIIN37299566_Reversed
FKIDN37749972
16 May 2025
29,586.06
FKIIN37299566
Another invoice’s payment23 Jun 2025, settling 77 other invoices
Us
Credit note
FKIDN37749972
—
20 May 2025
-29,586.06
FKIDN37749972
Not yet recovered
Our notes total -29,586.06Their notes total 0.00on invoice 2526/648

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
20250516-2140-RDN-FKIIN37299566_ReversedFKIDN3774997216 May 202529,586.06HSBCN1745243867523 Jun 20252526/1240, 2526/1245, 2526/1249, 2526/1259, 2526/1260, 2526/1269 and 71 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsTDS memoCREDIT20250501-2140-YNPL25-26/0648-TDS-CM-1962780501 May 2025-110.69—the reference embedded in the document numberJan 2025 to July 2025row 850
TheirsInvoiceSTANDARD20250501-2140-YNPL25-26/0648FKIIN3729956601 May 20251,16,222.98—its own document numberJan 2025 to July 2025row 907
TheirsDebit noteCREDIT20250516-2140-RDN-FKIIN37299566FKIDN3774997216 May 2025-29,586.06FKIIN37299566the reference embedded in the document numberJan 2025 to July 2025row 957
TheirsDebit noteSTANDARD20250516-2140-RDN-FKIIN37299566_ReversedFKIDN37749972Reversed16 May 202529,586.06FKIIN37299566the reference embedded in the document numberJan 2025 to July 2025row 1601
OursInvoiceTAX INVOICEYNPL25-26/064801 May 20251,16,222.83—its own document numberYNPL Ledgerrow 748
OursCredit noteCREDIT NOTE-25FKIDN3774997220 May 2025-29,586.06FKIDN37749972our voucher number naming their noteYNPL Ledgerrow 1299

Settlement

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

DatePayment eventKindAmount
19 May 2025HSBCN13944054014HDFC BANK LTDCashActual Payment-110.69
19 May 2025HSBCN13944054014HDFC BANK LTDCashActual Payment1,16,222.98
19 May 2025HSBCN13944054014HDFC BANK LTDCashActual Payment-29,586.06
23 Jun 2025HSBCN17452438675HDFC BANK LTDCashActual Payment29,586.06

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN37749972 → 20250516-2140-RDN-FKIIN37299566

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

  • Their debit note against this invoiceCertain

    20250516-2140-RDN-FKIIN37299566 → 20250501-2140-YNPL25-26/0648

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

  • Their debit note against this invoiceCertain

    20250516-2140-RDN-FKIIN37299566_Reversed → 20250501-2140-YNPL25-26/0648

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

  • Matched to our invoiceCertain

    20250501-2140-YNPL25-26/0648 → YNPL25-26/0648

    Matched by an exact invoice number match. FKIIN37299566 matches invoice 2526/648

  • Reversal of an earlier noteCertain

    20250516-2140-RDN-FKIIN37299566_Reversed → 20250516-2140-RDN-FKIIN37299566

    Matched by a shared base reference and an offsetting amount. Reverses RDN-FKIIN37299566 exactly

  • TDS memo against this invoiceCertain

    20250501-2140-YNPL25-26/0648-TDS-CM-19627805 → 20250501-2140-YNPL25-26/0648

    Matched by the reference embedded in the document number. TDS memo for invoice 2526/648

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