Fetching closing balance

from which table should closing balance of items daywise has to be fetched into reports

Item Ledger Entry

In extension to Sandeep’s reply, u can look at Inventory analysis and create ur own analysis, which can export data in excel.