it’s possible to build P&L or Balance Sheet style reports with SuiteQL but it takes some work. SuiteQL gives you access to transaction and GL impact data so you can replicate financial reports by aggregating balances across accounts, subsidiaries and periods.