Follow the steps below starting with a blank excel workbook and see how quickly you can build a set of basic financial statements.
1. Open Excel and Connect to the Data Feed.
2. Load only the df_Trial_Balance table into your workbook.
3. Once the table is loaded, in the Queries & Connections pane right click the df_Trial_Balance table and choose “Load To” > “PivotTable Report”.
4. Build a PivotTable with [account_type_id] and [account_type_name] in the Rows. Add [date] to the Columns. Add [amount] (Sum) to the Values.
5. Get account-level detail by bringing in [account_num] and/or [account_name]. Limit the TB and get a basic Income Statement by adding the [IS_BS] column to Filters.
Here is an example Income Statement:
