Where is the opening or Closing balance stored for specific Period

I want monthly opening balance of every GL account. I viewed the report of balance sheet.From where is the data fecthed or is it calculated on the fly. If it is fetched from the database, I want the table name.