Automated project income statement

This report is useful for comparing income statements per project.

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

The Automated project income statement gives you an overview of the income statements per project. It also has the budget and variance fields to compare the budget versus actual performance.

How to use the report

1. Enter your date range in cells D1 and D2 on the Income statement by project worksheet to run your query.

1. After setting the dates as parameters, values would appear as appropriate.

Common use cases

This report gives an overview of all company projects and automatically calculates the income statement. It also includes budget values and variances between actual and budgeted amounts. Use this report to get a high-level view of project performance and compare totals with your overall income statement. It also highlights unassigned amounts.

Troubleshooting

1. Issue: No values appear on the worksheet.
2. Solution: Ensure that your account has the necessary permissions to access the Accounts & General Ledger.

FAQs

1. Q: Why are the values incorrect?
2. A: Please ensure that you are connected to the right company by going to the XLGL

Best practices

Always remember to connect to the right company before loading this report. Also, ensure that the Refresh after opening checkbox is checked. This ensures the report is accurate for the selected company and saves you steps such as clicking the Refresh button on the XLGL ribbon.