How to find accrued interest on fds which shall appear in the balance sheet on 31/03/2019 ?

golfer (trading & investment)   (38 Points)

01 June 2019  

I want to show live FDs with added accrued interests. My excel calculations gives too much erroneous results over a long period of time as they don't consider TDS for every year.

form 26 AS gives a sum of interests for both live and matured FDs in the  FY 2018-19 .

when I see saving account details, it also shows the interests on FDs for previous years (FY18, fy17, fy16  etc) but matured in FY 2018-19.

How to find accrued interest of FDs that shall appear in the BS of FY 2018-19