Ratios 

This Report provides ratios and data for 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 Reporting, such as Average daily sales, Liquidity ratios, and much more.  

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. 
2. 

Common use cases  

This Report provides an efficient overview of key ratios for analyzing a company’s financial health. It functions as a de-facto cash flow Report, allowing you to review numbers in a concise view. 

Troubleshooting  

1. Issue A: No values appear on the worksheet. 
2. Solution A.1: Ensure that the From date doesn’t surpass the To date.  
3. Solution A.2: Ensure that your account has necessary permissions to access the Accounts & General ledger. 

FAQs  

1. Q: Can I just see the headers that I need? 
2. A.1: Yes! You can 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. Afterwards choose either Delete or Hide on the Ratios worksheet. 

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

After highlighting the rows, go to Data > Outline > Group. 

Best practices 

Connect to the correct company before loading this Report. Ensure that the Refresh after opening checkbox is checked. This will make the Report accurate company-wise and will save you some steps like clicking the Refresh button on the Logicim XLGL ribbon.