Fund Budget by Period

This Report shows budgeted revenues and expenses allocated to each fund.

Prerequisites

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 provides a detailed and summarized breakdown of revenues and expenses per fund.

How to use the Report

1. On the Instructions worksheet, select the fiscal period in cell C8.
2. Click Refresh on the Logicim XLGL ribbon.
3. The pivot table will automatically populate with values.

Common use cases

This Report allows you to track and analyze budgeted revenues and expenses for each fund.

Troubleshooting

1. Issue A: No values appear on the worksheet.
2. Solution A: Ensure your account has permission to access Accounts & General Ledger.
3. Issue B: Wrong values appear on the worksheet.
4. Solution B: Verify that you are connected to the correct company.

FAQs

1. Q: Can I exclude certain funds from the Report?
2. A: Yes. Use the pivot table filters to uncheck the funds you don’t want to see.
3. Q: Can I include custom calculations like taxes?
4. A: Yes. Fully customized Reports are available: Logicim Custom Reports

Best practices

Always connect to the correct company before loading this Report. Select the Refresh after opening checkbox to ensure company-specific data loads automatically, without the need to click Refresh manually.