The new report filtering functionality in Financio allows users to customize their data views for both Balance Sheet and Profit & Loss reports. This knowledge base provides instructions on how to apply various filtering scenarios to tailor the reports according to specific financial periods according to the Financial Year that has been setup in the Business Settings.
Pre-requisite:
- Financial year setup
- Users must have already set up the financial year settings in the Business Setting in Financio. The filtering feature relies on this information to determine the default data for the reports.
- Go to Control Panel > Company > Business Setting
- Familiarity with filtering fields
- Users should be familiar with the available filtering fields in the system, such as Report Type, From and To fields. Understanding how to use these fields to specify custom filtering options is crucial.
- Read here for more details.
How does the filtering work in the latest version of the multi-Period view for Balance Sheet and Profit & Loss reports?
- This knowledge base provides detailed information on how the filtering works specifically for the Multi-Period Balance Sheet report.
- The scenarios below offer examples of the default data applied in the report when users do not make any selections in the filtering fields:
- Scenario example 1: Financial Year 1/1/2019 - 31/12/2019 (Current date: 9/7/2023)
- Yearly Report Type:
- The system displays the current financial year by default.
- Default data applied to the report:
- From FY field = 2023
- To FY field = 2023
- Quarterly Report Type:
- The system shows the current quarter for the current financial year by default.
- Default data applied to the report:
- Financial Year field = 2023
- From field = Quarter 3
- To field = Quarter 3
- Monthly Report Type:
- The system displays the current month for the current financial year by default.
- Default data applied to the report:
- Financial Year field = 2023
- From field = July
- To field = July
- Yearly Report Type:
- Scenario example 2: Financial Year 1/4/2019 - 31/3/2020 (Current date: 9/7/2023)
- Yearly Report Type:
- The system displays the current financial year by default.
- Default data applied to the report:
- From FY field = 2024
- To FY field = 2024
- Quarterly Report Type:
- The system shows the current quarter for the current financial year by default.
- Default data applied to the report:
- Financial Year field = 2024
- From field = Quarter 2
- To field = Quarter 2
- Monthly Report Type:
- The system displays the current month for the current financial year by default.
- Default data applied to the report:
- Financial Year field = 2024
- From field = July
- To field = July
- Yearly Report Type:
- Scenario example 1: Financial Year 1/1/2019 - 31/12/2019 (Current date: 9/7/2023)
- The scenarios below offer examples of the data applied in the report when users made selection with the following filter, specifying their desired report type and timeframes.
- Scenario example 1: Financial Year 1/1/2019 - 31/12/2019 (Current date: 9/7/2023)
- Yearly Report Type:
- The system will display the report based on the financial year(s) selected.
- Example selection made in the Filter panel when users wish to view one financial year only:
- Report Type: Yearly
- From FY: 2022
- To FY: 2022
- Example selection made in the Filter panel when users wish to compare current financial year with the previous financial year:
- Report Type: Yearly
- From FY: 2022
- To FY: 2023
- Quarterly Report Type:
- The system will display the report based on the selected quarter(s) within the selected financial year.
- Example selection made in the Filter panel when users wish to view data from Quarter 1 to Quarter 4 in the 2022 financial year:
- Report Type: Quarterly
- Financial year: 2022
- From: Quarter 1
- To: Quarter 4
- Monthly Report Type:
- The system will display the report based on the selected month(s) within the selected financial year.
- Example selection made in the Filter panel when users wish to view data from January until December in the 2022 financial year:
- Report Type: Monthly
- Financial Year: 2022
- From: January
- To: December
- Yearly Report Type:
- Scenario example 1: Financial Year 1/1/2019 - 31/12/2019 (Current date: 9/7/2023)
- Scenario example 2: Financial Year 1/4/2019 - 31/3/2020 (Current date: 9/7/2023)
- Yearly Report Type:
- The system will display the report based on the financial year(s) selected.
- Example selection made in the Filter panel when users wish to view one financial year only:
- Report Type: Yearly
- From FY: 2022
- To FY: 2022
- Example selection made in the Filter panel when users wish to compare current financial year with the previous financial year:
- Report Type: Yearly
- From FY: 2023
- To FY: 2024
- Quarterly Report Type:
- The system will display the report based on the selected quarter(s) within the selected financial year.
- Example selection made in the Filter panel when users wish to view data from Quarter 1 to Quarter 4 in the 2022 financial year:
- Report Type: Quarterly
- Financial year: 2022
- From: Quarter 1
- To: Quarter 4
- Monthly Report Type:
- The system will display the report based on the selected month(s) within the selected financial year.
- Example selection made in the Filter panel when users wish to view data from April until March in the 2022 financial year:
- Report Type: Monthly
- Financial Year: 2022
- From: April
- To: March
- Yearly Report Type:
In conclusion, with the comprehensive filtering guide provided, users should now have a clear understanding of how the filtering works in the Multi-Period Balance Sheet and Profit & Loss reports. With this knowledge, using the filtering functionality will likely become an easier and more intuitive process for users.
Comments
0 comments
Please sign in to leave a comment.