Standard and Multi-Period Balance Sheet and Profit & Loss Reports

To facilitate financial comparison purposes, the Balance Sheet and Profit or Loss reports now offer both standard and multi-period views.

Standard reports represent the older version of the report, offering a simple single-column view. Users can generate the report for a specific "As of" date, displaying only one column.

On the other hand, the new multi-period reports provide enhanced filtering capabilities, allowing users to view data based on monthly, quarterly, or yearly periods. By applying filters, users can focus on specific timeframes, gaining valuable insights into their financial performance. This feature provides greater flexibility and a more comprehensive analysis of financial data.

Here is a step-by-step guide on how to use the filter feature in the Multi-period reports for the Balance Sheet and Profit & Loss:

1. Login to Financio.
   
   
2. Access the Reports.

   • Standard

     • Navigate to Reports > Business Report > Balance Sheet / Profit & Loss > Standard Balance Sheet / Standard Profit & Loss.
       
       

   • Multi-Period

     • Navigate to Reports > Business Report > Balance Sheet / Profit & Loss > Multi-Period Balance Sheet / Multi-Period Profit & Loss.

       
       
   • In the next steps, we will focus on the "Multi-Period Balance Sheet" report as an example.
     
     
3. Set the Report Type.
   • By default, the "Yearly" report type will be selected.
   • You may adjust the report type to "Monthly" or "Quarterly" based on your preference. To do so, simply click on the "Filters" button to access the Filters panel. In the Filters panel, you can select the desired report type in the "Report Type" dropdown field.
     
     
     
     
4. Set the Time Range.
   • To facilitate a more comprehensive comparison of financial performance, you have the option to define the time range within the report based on your preferred timeframes.
   • For Monthly and Quarterly report type:
     • Use the "Year" dropdown to select your desired year.
     • Use the "From" and "To" dropdown fields to select your desired months or quarters.
       
       
       
       
   • For Yearly report type:
     • Use the "From" and "To" dropdown fields to select your desired year.
       
       
       
       
5. Apply Filters.
   • Based on the steps described above, you can make the necessary selections in the Filter panel according to your desired report type and timeframes.
   • For all report types, ensure that the selected "From" value is smaller than the selected "To" value. This is to ensure the reports are accurate, and meaningful based on the selections made.
   • Click on the "Apply Filter" button once you have made the necessary selection.
     
     
     
     
   • Please refer here for more details on how the filtering works based on the financial year setup at the Business Settings. 
     
6. View the Report.
   • After applying the filters, the report will be updated to reflect the selected time range.
   • The report will be displayed in a single page, without pagination, for easier viewing.
     
     
7. Export to PDF or Excel.
   • If you wish to export the report, you can use the enhanced export feature to save it as a PDF or Excel file.
   • The PDF export for the Monthly report type will have a custom layout based on the number of selected months. The specifications are as follows:
     • If the number of months selected is 1 – 3;
       • Page orientation: Portrait
       • Page layout: A4
     • If the number of months selected is 4 – 5;
       • Page orientation: Landscape
       • Page layout: A4
     • If the number of months selected is 6 – 18 (more than 12 months are applicable for the first financial year only);
       • Page orientation: Landscape
       • Page layout: A3
         
         
         
         
8. Reset Filters.
   • You may also reset the filter selections by clicking the "Reset" button. This will clear all fields except the "Report Type" field to show the current report type that is being displayed.
   • If the user does not select any report type after resetting the fields, the system will show the report based on the previously selected report type.
     
     
     
     
9. Refresh the Report.
   • If you wish to switch back to the default view, click on the refresh icon.
   • The report will reset to the default "Yearly" report type based on the current financial year.
     
     

Note: If no data is available for the selected month, quarter, or year, the report will display zero amount (0.00).

Following these steps will allow you to effectively use the new filter feature in the Balance Sheet and Profit and Loss reports, enabling you to compare financial data based on different time ranges.