YLedger Reconciliation

YNPL25-26/1848

14 Jul 2025FKIIN39824746PO FDGN06522609Warehouse 0600159

Back to register
SETTLED IN FULLOn both sides

Our books

From the Tally ledger and note registers

Invoice
6,92,745.43
Credit notes
-6,958.86
Debit notes
—
Net due from customer
6,85,786.57
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
6,92,749.78
Debit notes
-6,958.94
Credit notes
—
Net due
6,85,790.84
TDS deductedExpected 659.76 at 0.1% of taxable value
659.57
Paid in cash
6,85,131.27
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-4.35
Notes
0.08
Total position difference
-4.27
TDS
0.19
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-0600159-RDN-FKIIN39824746
FKIDN40278902
28 Jul 2025
-6,958.94
FKIIN39824746
Another invoice’s payment11 Aug 2025, settling 44 other invoices
Us
Credit note
FKIDN40278902
—
04 Aug 2025
-6,958.86
FKIDN40278902
Not yet recovered
Our notes total -6,958.86Their notes total -6,958.94on invoice 2526/1848

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-0600159-RDN-FKIIN39824746FKIDN4027890228 Jul 2025-6,958.9430000006226254411 Aug 20252526/1946, 2526/1947, 2526/1948, 2526/1949, 2526/1963, 2526/1964 and 38 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
TheirsInvoiceSTANDARD20250714-0600159-YNPL25-26/1848FKIIN3982474614 Jul 20256,92,749.78TDS -659.57—its own document numberAug 2025 to till daterow 139
TheirsDebit noteCREDIT20250728-0600159-RDN-FKIIN39824746FKIDN4027890228 Jul 2025-6,958.94FKIIN39824746the reference embedded in the document numberAug 2025 to till daterow 224
OursInvoiceTAX INVOICEYNPL25-26/184814 Jul 20256,92,745.43—its own document numberYNPL Ledgerrow 2643
OursCredit noteCREDIT NOTE-25FKIDN4027890204 Aug 2025-6,958.86FKIDN40278902our voucher number naming their noteYNPL Ledgerrow 3010

Settlement

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

DatePayment eventKindAmount
11 Aug 2025300000062262544HSBC-071050702001-FKICashPaid-6,958.94
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid6,92,090.21

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40278902 → 20250728-0600159-RDN-FKIIN39824746

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

  • Their debit note against this invoiceCertain

    20250728-0600159-RDN-FKIIN39824746 → 20250714-0600159-YNPL25-26/1848

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

  • Matched to our invoiceCertain

    20250714-0600159-YNPL25-26/1848 → YNPL25-26/1848

    Matched by an exact invoice number match. FKIIN39824746 matches invoice 2526/1848

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