Income Statement by Funds

This report lets you see multiple funds 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 funds. 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 departments that you want to use for analysis.
2. 
3. The value on the report changes once you change the dates and fund 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 fund and the variance from the actual values. Values unassigned on a fund would also be included in the report. Besides this, you can choose to partition the report by department.

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 funds on the report?
2. A: Yes, you can! You can hide the funds 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 fund name on the worksheet and you should see the fund list like this.

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

Note: If you have a vast list of funds and it would take a long time, you can uncheck All and then put a check mark on the funds 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.