Transaction Report

This Report lets you view transactions by fund or transaction type.

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 is useful for drilling down into transactions by fund or transaction type.

How to use the Report

1. On the Instructions worksheet, enter the start and end dates in cells C7 and C8.
2. Click Refresh on the Logicim XLGL ribbon.
3. The pivot table will automatically populate with values.

Common use case

This Report provides a detailed view of a fund’s transactions. It helps track when and where they occurred and allows filtering by transaction type (revenue or expense).

Troubleshooting

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

1. Issue B: Wrong values appear on the worksheet.
2. Solution B: Verify that you are connected to the correct company.

FAQs

1. Q: Can I filter by fund and transaction type?
2. A: Yes. On the Transaction Report worksheet (cells C5 and C6), use the drop-down filters for Transaction Type and Fund. Click the drop-down arrows and you can uncheck the funds or transaction type that 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.