Revenue and Expense by Program

This Report shows revenues and expenses incurred by each program.

Prerequisites

1. Logicim XLGL version 5.0 or higher
2. Microsoft Excel 2016 or higher
3. Sage 50 Canadian Edition (2014 and later) 

What the Report does

This Report provides a detailed and summarized breakdown of revenues and expenses per program.

How to use the Report

1. On the Instructions worksheet, enter the from and to dates in cells C8 and C9.

2. Click Refresh on the Logicim XLGL ribbon.

3. The pivot table will automatically populate with values.

Common use cases

This Report provides both a summary and drill-down view of a program's revenues and expenses. It helps track when and where they occurred.

Troubleshooting

Issue A: No values appear on the worksheet.

Solution A: Ensure your account has permission to access Accounts & General Ledger.

Issue B: Incorrect values appear on the worksheet.

Solution B: Verify that you are connected to the correct company.

FAQs

Q: Can I hide certain columns in the Detail Report?

A: Yes. Use the pivot table to uncheck the columns you don’t need.

Q: Can I include custom calculations like taxes?

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.