Ratios

This Report provides key ratios and financial data for your Reporting. 

Prerequisite 

1. Logicim XLGL version 5.0 or higher 
2. Microsoft Excel 2016 or higher 
3. Sage 50 Canadian Edition (2014 and above) 

What the Report does  

The Ratios Report generates ratios for your Reporting, including average daily sales, liquidity ratios, and other vital metrics.  

How to use the Report  

1. Enter the Start of Period on cell C10 and End of Period on cell C11 on the Instructions worksheet. 

Common use cases  

This Report provides a clear overview of ratios for analyzing a company’s financial health. It serves as a concise cash flow Report, presenting numbers in a summary view. 

Troubleshooting  

1. Issue: No values appear on the worksheet.  
2. Solution 1: Ensure the correct From and To date.   
3. Solution 2: Ensure your account has the necessary permissions to access the Accounts & General Ledger. 

FAQs  

1. Q: May I just see the headers that I need? 
2. A.1: Yes! You may do this by either hiding/deleting the rows containing the data that you don’t want to see.  

Choose the rows that contain the data and do a right-click; afterward, choose Delete or Hide on the Ratios worksheet.

1. A.2: Yes! You may do this by grouping the rows containing the data you don’t want to see. 

 Once you have highlighted the rows, go to Data > Outline > Group.

Best practices 

Ensure the Refresh after opening checkbox is checked. This enables the Report accurate company-wise and saves you some steps like clicking the Refresh button on the XLGL ribbon.