Revenue and Expense by Fund

This report lets you see the revenues and expenses incurred by each fund.

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 want a detailed and summary breakdown of the expenses and revenues incurred per fund.

How to use the Report

1. Cell C8 and C9 on the Instructions worksheet is where you enter your as from and to date
2. 
3. Once you set up the dates, click the Refresh button on the Logicim XLGL ribbon.
4. 
5. The Report will then automatically populate the pivot table with values.

Common use cases

This report gives you a good drill-down and a summary of your fund's revenues and expenses. It is a good way of tracking when where those occured.

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 only want to see columns relevant to what I want on Detail Report.
2. A: Yes, you can! The report is a pivot table, and you can uncheck columns that you don't want to see.

1. Q: Can a custom calculation be done for this Report? Like taxes and such?
2. A: Yes, a fully customized Report is available here: Logicim Custom Reports

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.