Introduction
Our Report Manager lets you:
- Access over 200 accounting reports providing high-quality business performance analysis.
- Report in both base and foreign currency where relevant.
- Run multiple reports or the same report with different parameters.
- Export the report with the selected parameters to PDF, CSV, Excel, Word, PowerPoint, TIFF, MHTML, and XML.
See:
11.0 Reporting and Data Query Overview - AIQ Academy
Accessing Reports
Step One: Select the Report
- Go to Reports > Report Manager.
- Find a report by either using the report search field or selecting from the report menu.
- Under Reports, select the report. The report's filters will appear under Filter Data By.
Step Two: Filter Data
Each report has filters corresponding to the report's fields, such as dates, account names, and transaction types. Any data you select will be remembered next time you use that report.
Filters include:
-
Date ranges: Select a 'from' and a 'to' date to restrict the dates included in the report from the calendar or enter the date manually.
- Drop-downs (single-select): Select one item from the list. For example, budget or revised budget in a P&L.
- Drop-down (multi-select): Select more than one item. For example, to generate a Supplier remittance for several Supplier accounts.
- Free Text Entry: Enter directly in the field, for example, a footer note in Trial Balance.
If you want to export a report to Excel, select No in the Show Header dropdown (where available). This prevents them interfering with any user-defined formulas you may want to add.
Step Three: Viewing the Report
Generate a report by clicking View. The report will appear in a new tab with the following features:
-
Navigation: You can open several reports and navigate between them. Use the single arrows to navigate page by page or the double arrows to skip to the beginning or end. Click the back arrow to navigate to the top screen.
- Refresh: Click the Refresh icon to bring in any new data into the report.
-
Export: Select the desired format from the dropdown.
- Search: This will find a term in the report.
-
Drilldown: Click on the blue financial figures to view the Transaction Details.
- Change Filters: Return to the filters to make another selection.
- Full Screen View: Open the report in full-screen mode as a separate tab. Open as many reports as needed.
- Print: Generate a PDF print file. Ensure that you have Adobe Reader installed if you need to print as a PDF.
-
Email: Email the report in the selected format.
The 'from' email address defaults to the email saved in the user profile and the ‘to’ email opens a lookup screen to search system emails.
Using Period-based Reporting
Date Format
Most reports use the date format specified in your browser's language settings:
- If your language setting is English UK, the date parameters will be in date/month/year format.
- If your language setting is English US, it will be in month/date/year format.
Financial Periods and Yeras
General Ledger Reports show the Calendar Period. If your financial period differs, ensure you select the correct financial year and always double-check the Calendar Period field prior to using the report data as follows:
- Calendar financial year: January 2024 - December 2024 appears as the year 2024, or the year ending 2024. To view a report for August 2024, select Financial Year - 2024 and Financial Period - August.
-
Non-calendar financial year: March 2023 to February 2024 would appear as the year 2024 as the last period is February 2024, or the year ending 2024. To view a report for August 2023, select Financial Year - 2024 and Financial Period - August.
It is possible to have a Retail Calendar applied for your reports. Please contact your local support team to find out more.
See:
Favouriting Reports
As we have over 200 reports, you can favourite them for easy access.
- In Reports > Report Manager, select the relevant report.
- Click Add to My Reports. (Re-click to remove from the report.)
- Now the favourited report will appear in the My Reports > Favourites tab:
And automatically in the Favourites > Reports tab:
Custom Reporting
If none of the Reports included in the Dashboards, General Ledger Explorer or Report Manager meet your requirements, please contact your local support team for information on custom reports.
Any Custom Reports we create will appear under My Reports > Custom.