Departmental Income Statement

This report lets you see multiple department’s income statements side by side through a given date range.

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

This report is exceptionally useful when you need to compare income statements per department. Besides that, it also has the budget and variance functionality that gets computed automatically.

How to use the Report

1. Cell C8 and C9 on the Instructions worksheet is where you enter your as from and to date. Cell C10 on the same worksheet will let you choose the fund that you want to use for analysis.
2. 
3. The value on the report changes once you change the dates and department selection.

Common use cases

This report saves you time in getting a side-by-side analysis of income statements per funds through your specified date range. This is particularly great when you also need to see the budget allotted for that department and the variance from the actual values. Values unassigned on a department would also be included in the report. Besides this, you can choose to partition the report by fund.

Troubleshooting

1. Issue A: No values appear on the worksheet.
2. Solution A: Ensure your account has the necessary permissions to access the Accounts & General Ledger.

1. Issue B: Wrong values appear on the worksheet.
2. Solution B: Ensure that you are connected to the right company.

FAQs

1. Q: I am seeing a lot of funds can I lessen the number of departments on the report?
2. A: Yes, you can! You can hide the departments that you don't want to see. Make sure that you are connected to your company data then go to the right panel of the report and click the arrow button.

Click on a department name on the worksheet and you should see the department list like this.

You can uncheck specific departments that you don't want to see.

Note: If you have a vast list of departments and it would take a long time, you can uncheck All and then put a check mark on the departments that you would want to see.

Best practices

Always connect to the correct company before loading this Report. Ensure the Refresh after opening checkbox is selected. This ensures the Report loads company-specific data accurately and eliminates the need to click the Refresh button on the Logicim XLGL ribbon.