YLedger Reconciliation

YNPL25-26/1769

08 Jul 2025FKIIN39567510PO FBSWN06476356Warehouse 0600155

Back to register
PARTIAL REVERSALOn both sidesA debit note was only partly reversed

Confirm whether the remaining debit note balance is still valid

Our books

From the Tally ledger and note registers

Invoice
6,83,559.24
Credit notes
-2,588.99
Debit notes
—
Net due from customer
6,80,970.25
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,83,560.47
Debit notes
-2,589.00
Credit notes
—
Net due
6,80,971.47
TDS deductedExpected 651.01 at 0.1% of taxable value
650.40
Paid in cash
6,80,321.07
Set off against notesBook adjustment, no bank movement
—
Outstanding
0.00

Difference, by cause

The parts add up to the total exactly

Invoice amount
-1.23
Notes
0.01
Total position difference
-1.22
TDS
0.61
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
20250726-2140-RDN-FKIIN39567510
FKIDN40239993
26 Jul 2025
-2,589.00
FKIIN39567510
Another invoice’s payment06 Aug 2025, settling 47 other invoices
Them
Debit note
20250726-0600155-RDN-FKIIN39567510
FKIDN40239993
26 Jul 2025
-2,589.00
FKIIN39567510
This invoice’s payment, 18 Aug 2025 (with 63 other invoices)
Them
Debit note
20250726-0600155-RDN-FKIIN39567510_Duplicate
FKIDN40239993
26 Jul 2025
2,589.00
FKIIN39567510
Another invoice’s payment04 Sept 2025, settling 49 other invoices
Us
Credit note
FKIDN40239993
—
31 Jul 2025
-2,588.99
FKIDN40239993
Not yet recovered
Our notes total -2,588.99Their notes total -2,589.00on invoice 2526/1769

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
20250726-2140-RDN-FKIIN39567510FKIDN4023999326 Jul 2025-2,589.0030000005597086506 Aug 20252526/1747, 2526/1750, 2526/1777, 2526/1784, 2526/1789, 2526/1803 and 41 more
20250726-0600155-RDN-FKIIN39567510_DuplicateFKIDN4023999326 Jul 20252,589.0030000015281599404 Sept 20252526/2138, 2526/2168, 2526/2191, 2526/2192, 2526/2197, 2526/2200 and 43 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-0600155-YNPL25-26/1769FKIIN3956751008 Jul 20256,83,560.47TDS -650.40—its own document numberAug 2025 to till daterow 416
TheirsDebit noteCREDIT20250726-2140-RDN-FKIIN39567510FKIDN4023999326 Jul 2025-2,589.00FKIIN39567510the reference embedded in the document numberAug 2025 to till daterow 354
TheirsDebit noteCREDIT20250726-0600155-RDN-FKIIN39567510FKIDN4023999326 Jul 2025-2,589.00FKIIN39567510the reference embedded in the document numberAug 2025 to till daterow 406
TheirsDebit noteSTANDARD20250726-0600155-RDN-FKIIN39567510_DuplicateFKIDN40239993Marked duplicate by them26 Jul 20252,589.00FKIIN39567510the reference embedded in the document numberAug 2025 to till daterow 1139
OursInvoiceTAX INVOICEYNPL25-26/176908 Jul 20256,83,559.24—its own document numberYNPL Ledgerrow 2522
OursCredit noteCREDIT NOTE-25FKIDN4023999331 Jul 2025-2,588.99FKIDN40239993our voucher number naming their noteYNPL Ledgerrow 2929

Settlement

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

DatePayment eventKindAmount
06 Aug 2025300000055970865HSBC-071050702001-FKICashPaid-2,589.00
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid-2,589.00
18 Aug 2025300000076930365HSBC-071050702001-FKICashPaid6,82,910.07
04 Sept 2025300000152815994HSBC-071050702001-FKICashPaid2,589.00

How this was matched

Every link is a rule, never a guess

  • Our credit note against their debit noteCertain

    FKIDN40239993 → 20250726-2140-RDN-FKIIN39567510

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

  • Their debit note against this invoiceCertain

    20250726-2140-RDN-FKIIN39567510 → 20250708-0600155-YNPL25-26/1769

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

  • Their debit note against this invoiceCertain

    20250726-0600155-RDN-FKIIN39567510 → 20250708-0600155-YNPL25-26/1769

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

  • Their debit note against this invoiceCertain

    20250726-0600155-RDN-FKIIN39567510_Duplicate → 20250708-0600155-YNPL25-26/1769

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

  • Matched to our invoiceCertain

    20250708-0600155-YNPL25-26/1769 → YNPL25-26/1769

    Matched by an exact invoice number match. FKIIN39567510 matches invoice 2526/1769

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