Is there a way to get an income statement broken out by Department and Periods? Or is this a saved search export + pivot in excel type of report?

Yes. Add Dept to the Financial “Layout”. Then use Columns = Period