How to view reports - P&L, BS and CF

Profit and Loss

01. To run a Profit and Loss report. Just go to your Accounting Module > Reporting > Profit and Loss. 


02. After clicking on Profit and Loss, you will be directed to this page. You can add filters by using the buttons highlighted in the red box below. 


03.Date Filter 
Current Period- Can be This Month, This Quarter, or This Financial Year
Previous Period - Can be End of Last Month / Quarter / Year  
Custom - You can add the date range and click on Apply.  


04. Comparison Filter
No Comparison - If you do not want to have any comparison.
Previous Period - If you want to compare it to the previous period. You can also select the number of periods to which you want to have a comparison.
Same Period Last year - If you want to compare your PL report to the same period as last year. You can also select the number of periods to which you want to compare your PL reports.
Custom - If you want to compare it to a specific period. Add the date range and click on Apply.  

05. Journals - if you only want to see PL transactions affecting specific journals, you can select the Journal/s from here. But we always use "All" journals for the Profit and Loss report. 
 

06. i) Analytic Group By- This will be used if you have analytic accounts. Report can be view according to the                                                        analytic classifications  (Accounts & Plans)
      ii) Analytic Filter -  Report can be filtered with the analytic accounts created. 



07. Options:
Include Unposted Entries - Check on this option if you want to include draft entries in your profit and loss. We normally use this option at the implementation stage wherein we will be importing entries for balances. But we don't use it after the implementation stage.
Include Analytic Simulations - Analytic filters will include anylatic items without accounting correspondance
Hierarchy and Subtotals - if you want to include the subtotals in your report.
Unfold All - If you want to have a detailed report, check on Unfold all. But if you only need a summary, uncheck this option.
Cash Basis Method- Report in cash basis
 


08. Print Preview, Export and Save button
PDF- Click on this button if you want to save your Profit and Loss report into a pdf document.
XLSX - Click on this button if you want to export this report to an excel file.
Save - Click on this button if you want to Save your Profit and Loss report in your Documents app. 



Balance Sheet

01. To run a Balance Sheet report, go to the Accounting Module > Reporting > Balance Sheet. 

02. After clicking on the Balance Sheet, you will be directed to this page. You can add filters by using the buttons highlighted in the red box below.

03. Date Filter 
Today -As of Today
Previous Period - End of Last Month / Quarter /  Year  
Custom - You can add the date range and click on Apply. 

04. Comparison Filter
No Comparison - If you do not want to have any comparison.
Previous Period - If you want to compare it to the previous period. You can also select the number of periods to which you want to have a comparison.
Same Period Last year - If you want to compare your Balance Sheet to the same period as last year. You can also select the number of periods to which you want to compare your Balance Sheet.
Custom - If you want to compare it to a specific period. Add the date range and click on Apply. 


05. Journals - if you only want to see Balance Sheet transactions affecting specific journals, you can select the Journal/s from here. But we always use "All" journals for Balance. 

06.  Analytic Group By- This will be used if you have analytic accounts. Report can be view according to the analytic classifications. (Accounts & Plans) 




07. Options:
Include Unposted Entries - Check on this option if you want to include draft entries in your Balance Sheet. We normally use this option at the implementation stage wherein we will be importing entries for balances. But we don't use it after the implementation stage.
Include Analytic Simulations - Analytic filters will include anylatic items without accounting correspondance
Hierarchy and Subtotals - if you want to include the subtotals in your report.
Unfold All - If you want to have a detailed report, check on Unfold all. But if you only need a summary, uncheck this option. 
Cash basis method-  Report in cash basis 

08. Print Preview, Export and Save button
PDF- Click on this button if you want to save your Balance Sheet into a pdf document.
XLSX- Click on this button if you want to export this report to an excel file.
Save - Click on this button if you want to Save your Balance Sheet in your Documents app. 




Executive Summary

01. To run an Executive Summary report, go to the Accounting Module > Reporting > Executive Summary. 

02. After clicking on Executive Summary, you will be directed to this page. You can add filters by using the buttons highlighted in the red box below. 

03. Date Filter 
Current period - Can be This Month, This Quarter, or This Financial Year
Previous period - Can be Last Month, Last Quarter, Last Financial Year
Custom - You can add the date range and click on Apply. 

04. Comparison Filter
No Comparison - If you do not want to have any comparison.
Previous Period - If you want to compare it to the previous period. You can also select the number of periods to which you want to have a comparison.
Same Period Last year - If you want to compare your Executive Summary to the same period as last year. You can also select the number of periods to which you want to compare your Executive Summary.
Custom - If you want to compare it to a specific period. Add the date range and click on Apply. 

05. Options:
Include Unposted Entries - Check on this option if you want to include draft entries in your Executive Summary. We normally use this option at the implementation stage wherein we will be importing entries for balances. But we don't use it after the implementation stage. 
Cash Basis - View the report in cash basis  
 


06. Print Preview, Export and Save button
PDF - Click on this button if you want to save your Executive Summary report into a pdf document.
XLSX- Click on this button if you want to export this report to an excel file.
Save - Click on this button if you want to Save your Executive Summary in your Documents app. 



Cash Flow Statement 

This will enable us to see the current situation of the company's cash. If you can remember when we created GL accounts, there is an option to add tags so some GL accounts. The tags that we added for the accounts will be used for the Cash flow statement.

01. Go to the Accounting Module > Reporting > Cash flow Statement 

02. After clicking on Cash Flow Statement, you will be directed to this page. You can add filters by using the buttons highlighted in the red box below.