YLedger Reconciliation

YNPL25-26/1640

29 Jun 2025FKIIN39290084PO FNNWN06456461Warehouse A274

Back to register
POSITION MISMATCHOn both sidesInvoice amount differs by Rs 2,80,740.43Our credit and debit notes differ from theirs by -Rs 388.63TDS short deducted by Rs 1.06A debit note was only partly reversed

Our books

From the Tally ledger and note registers

Invoice
5,61,483.66
Credit notes
-753.04
Debit notes
—
Net due from customer
5,60,730.62
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,80,743.23
Debit notes
-364.41
Credit notes
—
Net due
2,80,378.82
TDS deductedExpected 267.37 at 0.1% of taxable value
266.31
Paid in cash
2,80,112.51
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,80,740.43
Notes
-388.63
Total position difference
2,80,351.80
TDS
1.06
UnexplainedEvery rupee of difference is attributed to a cause
0.00

Credit and debit notes

4 notes in the order they were raised

Raised by
Type
Document number
Their reference
Date
Amount
Raised against
Recovered in
Them
Debit note
20250715-A274-RDN-FKIIN39290084
FKIDN39745752
15 Jul 2025
-376.53
FKIIN39290084
This invoice’s payment, 17 Jul 2025 (with 35 other invoices)
Them
Debit noteReversed
20250715-A274-RDN-FKIIN39290084_Reversed
FKIDN39745752
15 Jul 2025
12.12
FKIIN39290084
Another invoice’s payment05 Jan 2026, settling 17 other invoices
Us
Credit note
FKIDN39745752
—
21 Jul 2025
-376.52
FKIDN39745752
Not yet recovered
Us
Credit note
FKIDN39745752
—
21 Jul 2025
-376.52
FKIDN39745752
Not yet recovered
Our notes total -753.04Their notes total -364.41on invoice 2526/1640

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
20250715-A274-RDN-FKIIN39290084_ReversedFKIDN3974575215 Jul 202512.1230000025722468105 Jan 20262526/3694, 2526/3785, 2526/3786, 2526/3789, 2526/3795, 2526/3796 and 11 more

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250629-A274-YNPL25-26/1640FKIIN3929008429 Jun 20252,80,743.23—its own document numberJan 2025 to July 2025row 1942
TheirsTDS memoCREDIT20250629-A274-YNPL25-26/1640-TDS-CM-2067244729 Jun 2025-266.31—the reference embedded in the document numberJan 2025 to July 2025row 1979
TheirsDebit noteCREDIT20250715-A274-RDN-FKIIN39290084FKIDN3974575215 Jul 2025-376.53FKIIN39290084the reference embedded in the document numberJan 2025 to July 2025row 1983
TheirsDebit noteSTANDARD20250715-A274-RDN-FKIIN39290084_ReversedFKIDN39745752Reversed15 Jul 202512.12FKIIN39290084the reference embedded in the document numberAug 2025 to till daterow 2727
OursInvoiceTAX INVOICEYNPL25-26/164029 Jun 20252,80,741.83—its own document numberLedger YNPLrow 2272
OursInvoiceTAX INVOICEYNPL25-26/164029 Jun 20252,80,741.83—its own document numberYNPL Ledgerrow 2272
OursCredit noteCREDIT NOTE-25FKIDN3974575221 Jul 2025-376.52FKIDN39745752our voucher number naming their noteLedger YNPLrow 2781
OursCredit noteCREDIT NOTE-25FKIDN3974575221 Jul 2025-376.52FKIDN39745752our voucher number naming their noteYNPL Ledgerrow 2781

Settlement

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

DatePayment eventKindAmount
17 Jul 2025HSBCN19859500510HDFC BANK LTDCashActual Payment2,80,743.23
17 Jul 2025HSBCN19859500510HDFC BANK LTDCashActual Payment-266.31
17 Jul 2025HSBCN19859500510HDFC BANK LTDCashActual Payment-376.53
05 Jan 2026300000257224681HSBC-071050702001-FKICashPaid12.12

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN39745752 → 20250715-A274-RDN-FKIIN39290084

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

  • Our credit note against their debit noteCertain

    FKIDN39745752 → 20250715-A274-RDN-FKIIN39290084

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

  • Their debit note against this invoiceCertain

    20250715-A274-RDN-FKIIN39290084 → 20250629-A274-YNPL25-26/1640

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

  • Their debit note against this invoiceCertain

    20250715-A274-RDN-FKIIN39290084_Reversed → 20250629-A274-YNPL25-26/1640

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

  • Matched to our invoiceCertain

    20250629-A274-YNPL25-26/1640 → YNPL25-26/1640

    Matched by an exact invoice number match. FKIIN39290084 matches invoice 2526/1640

  • Reversal of an earlier noteNeeds review

    20250715-A274-RDN-FKIIN39290084_Reversed → 20250715-A274-RDN-FKIIN39290084

    Matched by a shared base reference. Shares base reference RDN-FKIIN39290084 but the amounts do not offset

  • TDS memo against this invoiceCertain

    20250629-A274-YNPL25-26/1640-TDS-CM-20672447 → 20250629-A274-YNPL25-26/1640

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

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