YLedger Reconciliation

YNPL25-26/1753

08 Jul 2025FKIIN39552115PO FDTWG06398495Warehouse 0600157

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
1,76,154.30
Credit notes
-20,109.60
Debit notes
—
Net due from customer
1,56,044.70
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,76,158.08
Debit notes
-20,109.60
Credit notes
—
Net due
1,56,048.48
TDS deductedExpected 167.77 at 0.1% of taxable value
167.76
Paid in cash
1,55,880.72
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-3.78
Notes
—
Total position difference
-3.78
TDS
0.01
UnexplainedEvery rupee of difference is attributed to a cause
0.00

Credit and debit notes

2 notes in the order they were raised

Raised by
Type
Document number
Their reference
Date
Amount
Raised against
Recovered in
Them
Debit note
20250728-null-RDN-FKIIN39552115
FKIDN40270328
28 Jul 2025
-20,109.60
FKIIN39552115
Another invoice’s payment06 Aug 2025, settling 47 other invoices
Us
Credit note
FKIDN40270328
—
03 Aug 2025
-20,109.60
FKIDN40270328
Not yet recovered
Our notes total -20,109.60Their notes total -20,109.60on invoice 2526/1753

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
20250728-null-RDN-FKIIN39552115FKIDN4027032828 Jul 2025-20,109.6030000005597086506 Aug 20252526/1747, 2526/1750, 2526/1777, 2526/1784, 2526/1789, 2526/1803 and 41 more

Raised against another invoice, but recovered from a payment that settled this one

NoteTheir referenceDateAmountPayment eventRaised against invoice
20250808-0600157-RDN-FKIIN40224121FKIDN4068307608 Aug 2025-62,794.0830000007693036518 Aug 2025YNPL25-26/1969
20250728-0600159-RDN-FKIIN39824786FKIDN4029190528 Jul 2025-24,435.5730000007693036518 Aug 2025YNPL25-26/1847
20250729-0600159-RDN-FKIIN39610777FKIDN4030958929 Jul 2025-20,847.2630000007693036518 Aug 2025YNPL25-26/1777
20250808-0600157-RDN-FKIIN40224166FKIDN4068615508 Aug 2025-19,037.2230000007693036518 Aug 2025YNPL25-26/1967
20250728-0600159-RDN-FKIIN40061904FKIDN4029161228 Jul 2025-16,937.4930000007693036518 Aug 2025YNPL25-26/1905
20250807-0600386-RDN-FKIIN40316181FKIDN4064287707 Aug 2025-14,583.5030000007693036518 Aug 2025YNPL25-26/1948
20250807-0600386-RDN-FKIIN40313442FKIDN4064151707 Aug 2025-14,131.3630000007693036518 Aug 2025YNPL25-26/1949
20250728-0600155-RDN-FKIIN40012238FKIDN4029211228 Jul 2025-9,465.1230000007693036518 Aug 2025YNPL25-26/1894
20250808-0600159-RDN-FKIIN40285242FKIDN4069203008 Aug 2025-8,957.7630000007693036518 Aug 2025YNPL25-26/1977
20250803-0600159-RDN-FKIIN40171547FKIDN4049818803 Aug 2025-8,563.9530000007693036518 Aug 2025YNPL25-26/1944
20250805-0600159-RDN-FKIIN40171440FKIDN4056610605 Aug 2025-7,501.3830000007693036518 Aug 2025YNPL25-26/1943
20250809-0700010-RDN-FKIIN40253339FKIDN4074213009 Aug 2025-7,275.4530000007693036518 Aug 2025YNPL25-26/1983
20250801-0600159-RDN-FKIIN40285059FKIDN4044608601 Aug 2025-7,245.8430000007693036518 Aug 2025YNPL25-26/1976
20250807-0600386-RDN-FKIIN40236406FKIDN4064425607 Aug 2025-7,197.8030000007693036518 Aug 2025YNPL25-26/1947
20250728-0600155-RDN-FKIIN40090148FKIDN4029221828 Jul 2025-5,764.5030000007693036518 Aug 2025YNPL25-26/1922
20250728-0600159-RDN-FKIIN40203602FKIDN4029358228 Jul 2025-3,954.8930000007693036518 Aug 2025YNPL25-26/1938
20250805-0600386-RDN-FKIIN40357958FKIDN4057376505 Aug 2025-3,246.6030000007693036518 Aug 2025YNPL25-26/2002
20250801-0600386-RDN-FKIIN40076253FKIDN4041934501 Aug 2025-2,204.1630000007693036518 Aug 2025YNPL25-26/1884
20250804-0600159-RDN-FKIIN40099135FKIDN4052377304 Aug 2025-1,286.2830000007693036518 Aug 2025YNPL25-26/1926
20250729-0700010-RDN-FKIIN39648388FKIDN4030910929 Jul 2025-892.3530000007693036518 Aug 2025YNPL25-26/1803
20250806-0600386-RDN-FKIIN40236476FKIDN4062574206 Aug 2025-517.7930000007693036518 Aug 2025YNPL25-26/1946
20250808-0700010-RDN-FKIIN40253059FKIDN4068436408 Aug 2025-365.9530000007693036518 Aug 2025YNPL25-26/1985
20250801-0600159-RDN-FKIIN40284850FKIDN4042700701 Aug 2025-121.2730000007693036518 Aug 2025YNPL25-26/1970
20250809-0600159-RDN-FKIIN40284739FKIDN4071251809 Aug 2025-93.9830000007693036518 Aug 2025YNPL25-26/1972
20250801-0600386-RDN-FKIIN39706093FKIDN4042925701 Aug 2025-54.4930000007693036518 Aug 2025YNPL25-26/1784

Source documents

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

SideTypeDocumentDateAmountRaised againstMatched bySource
TheirsInvoiceSTANDARD20250708-0600157-YNPL25-26/1753FKIIN3955211508 Jul 20251,76,158.08TDS -167.76—its own document numberAug 2025 to till daterow 56
TheirsDebit noteCREDIT20250728-null-RDN-FKIIN39552115FKIDN4027032828 Jul 2025-20,109.60FKIIN39552115the reference embedded in the document numberAug 2025 to till daterow 146
OursInvoiceTAX INVOICEYNPL25-26/175308 Jul 20251,76,154.30—its own document numberYNPL Ledgerrow 2506
OursCredit noteCREDIT NOTE-25FKIDN4027032803 Aug 2025-20,109.60FKIDN40270328our voucher number naming their noteYNPL Ledgerrow 2993

Settlement

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

DatePayment eventKindAmount
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid-20,109.60
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid1,75,990.32

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40270328 → 20250728-null-RDN-FKIIN39552115

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

  • Their debit note against this invoiceCertain

    20250728-null-RDN-FKIIN39552115 → 20250708-0600157-YNPL25-26/1753

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

  • Matched to our invoiceCertain

    20250708-0600157-YNPL25-26/1753 → YNPL25-26/1753

    Matched by an exact invoice number match. FKIIN39552115 matches invoice 2526/1753

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