YLedger Reconciliation

YNPL25-26/0620

30 Apr 2025FKIIN37309386PO FBSWN06149469Warehouse 2140

Back to register
POSITION MISMATCHOn both sidesInvoice amount differs by Rs 2,17,469.81Our credit and debit notes differ from theirs by -Rs 49,954.59

Our books

From the Tally ledger and note registers

Invoice
4,34,941.94
Credit notes
-49,954.59
Debit notes
—
Net due from customer
3,84,987.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
2,17,472.13
Debit notes
—
Credit notes
—
Net due
2,17,472.13
TDS deductedExpected 207.12 at 0.1% of taxable value
207.12
Paid in cash
2,17,265.01
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
2,17,469.81
Notes
-49,954.59
Total position difference
1,67,515.22
TDS
—
UnexplainedEvery rupee of difference is attributed to a cause
0.00

Credit and debit notes

5 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-FKIIN37309386
FKIDN37748755
16 May 2025
-16,651.68
FKIIN37309386
This invoice’s payment, 19 May 2025 (with 67 other invoices)
Them
Debit noteReversed
20250516-2140-RDN-FKIIN37309386_Reversed
FKIDN37748755
16 May 2025
16,651.68
FKIIN37309386
Another invoice’s payment03 Jul 2025, settling 40 other invoices
Us
Credit note
FKIDN37748755
—
24 May 2025
-16,651.53
FKIDN37748755
Not yet recovered
Us
Credit note
FKIDN37748755
—
24 May 2025
-16,651.53
FKIDN37748755
Not yet recovered
Us
Credit note
644
—
11 Jul 2025
-16,651.53
2526/620
Not yet recovered
Our notes total -49,954.59Their notes total 0.00on invoice 2526/620

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-FKIIN37309386_ReversedFKIDN3774875516 May 202516,651.68HSBCN1845618898403 Jul 20252425/2531, 2425/2754, 2425/2786, 2425/3218, 2526/1212, 2526/1224 and 34 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsTDS memoCREDIT20250430-2140-YNPL25-26/0620-TDS-CM-1962246130 Apr 2025-207.12—the reference embedded in the document numberJan 2025 to July 2025row 853
TheirsInvoiceSTANDARD20250430-2140-YNPL25-26/0620FKIIN3730938630 Apr 20252,17,472.13—its own document numberJan 2025 to July 2025row 892
TheirsDebit noteCREDIT20250516-2140-RDN-FKIIN37309386FKIDN3774875516 May 2025-16,651.68FKIIN37309386the reference embedded in the document numberJan 2025 to July 2025row 954
TheirsDebit noteSTANDARD20250516-2140-RDN-FKIIN37309386_ReversedFKIDN37748755Reversed16 May 202516,651.68FKIIN37309386the reference embedded in the document numberJan 2025 to July 2025row 1768
OursInvoiceTAX INVOICEYNPL25-26/062030 Apr 20252,17,470.97—its own document numberLedger YNPLrow 653
OursInvoiceTAX INVOICEYNPL25-26/062030 Apr 20252,17,470.97—its own document numberYNPL Ledgerrow 653
OursCredit noteCREDIT NOTE-25FKIDN3774875524 May 2025-16,651.53FKIDN37748755our voucher number naming their noteLedger YNPLrow 1378
OursCredit noteCREDIT NOTE-25FKIDN3774875524 May 2025-16,651.53FKIDN37748755our voucher number naming their noteYNPL Ledgerrow 1378
OursCredit noteDebit Note New644In the register but not the ledger11 Jul 2025-16,651.532526/620the reference column in the registerDebit note Registerrow 28

Settlement

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

DatePayment eventKindAmount
19 May 2025HSBCN13944054014HDFC BANK LTDCashActual Payment-207.12
19 May 2025HSBCN13944054014HDFC BANK LTDCashActual Payment2,17,472.13
19 May 2025HSBCN13944054014HDFC BANK LTDCashActual Payment-16,651.68
03 Jul 2025HSBCN18456188984HDFC BANK LTDCashActual Payment16,651.68

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN37748755 → 20250516-2140-RDN-FKIIN37309386

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

  • Our credit note against their debit noteCertain

    FKIDN37748755 → 20250516-2140-RDN-FKIIN37309386

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

  • Our credit note against this invoiceCertain

    644 → YNPL25-26/0620

    Matched by the reference column in the register. Raised against our invoice 2526/620

  • Their debit note against this invoiceCertain

    20250516-2140-RDN-FKIIN37309386 → 20250430-2140-YNPL25-26/0620

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

  • Their debit note against this invoiceCertain

    20250516-2140-RDN-FKIIN37309386_Reversed → 20250430-2140-YNPL25-26/0620

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

  • Matched to our invoiceCertain

    20250430-2140-YNPL25-26/0620 → YNPL25-26/0620

    Matched by an exact invoice number match. FKIIN37309386 matches invoice 2526/620

  • Reversal of an earlier noteCertain

    20250516-2140-RDN-FKIIN37309386_Reversed → 20250516-2140-RDN-FKIIN37309386

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

  • TDS memo against this invoiceCertain

    20250430-2140-YNPL25-26/0620-TDS-CM-19622461 → 20250430-2140-YNPL25-26/0620

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

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