Running a report

Before running a report, make sure you have connected to your Sage 50 company data. 

Running a report included with Logicim XLGL

1. Click "reports and forms" from the Logicim XLGL ribbon tab in Excel. This will open the reports panel on the left side of the window. This panel shows a list of report templates available from Logicim XLGL.
2. Open a category to see the reports it contains. For example, expand "financials," click on "project income statement," then click "load." The report is loaded and updated with your Sage 50 company data.
3. Review the reports included with Logicim XLGL. Most reports included with Logicim XLGL will contain an Instructions worksheet with some information on the report. Another sheet will contain the report itself. Click on the income statement by project tab to see this report. The income statement shows the actual budget and variance for the entire company, amounts not assigned to any project, and then for each project in the company.
4. Change the period to anything you wish. By default, the report will show data for your current fiscal year, but you can change the period to anything you wish. For example, if we want to see results only for the month of March 2025, we can change the dates in D1 and D2 to March 1st, 2025, and March 31st, 2025. We recommend entering dates as year-month-day to make sure they are well interpreted by Excel. When you change one or both dates, you will see the report update automatically.
5. Click "Refresh" on the Logicim XLGL menu if you enter new transactions in Sage 50 and want the report to update.

Make quick modifications and save your report

You can quickly modify this report to make it yours without knowing anything else about Logicim XLGL. For example, you can make formatting changes such as font size and color, just like you usually would in Excel.

The report is dynamic, and Logicim XLGL will retain your changes to keep them consistent throughout. 

Once you are happy with your change, remember to save your file so you can keep your changes and load it again later. Logicim XLGL template reports available in the Report panel will always keep their original look, but you can save as many copies as you need and keep the report dynamic and updatable.

Custom report made for you

Whether you have a report file, you modified yourself or a custom report that was built for you. You can always open it just like any other Excel file. Simply click File, then Open. Remember to connect to your Sage 50 company data before trying to update a report.