Fund Budget by Period

This report lets you see the budgeted revenues and expenses allocated to 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 on the Instructions worksheet is where you choose the fiscal period.
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 of your fund’s budgeted revenues and expenses. It is a good way of tracking when and where those occurred.

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 funds that I want to analyze for the time being.
2. A: Yes, you can! The report is a pivot table, and you can uncheck funds 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.