We provide:

• Over 200 accounting reports providing high-quality business performance analysis.
• Some reports available in both base and foreign currency. 
• Run and view multiple reports or the same report with different parameters. 
• Export the report in a variety of formats including Word, Excel, XLS, CSV, and PDF with your selected parameters.

See:

Changing a Report layout‍ 

11.0 Reporting and Data Query Overview - AIQ Academy

11.1 Report Manager - AIQ Academy

11.2 Commonly Used Reports - AIQ Academy

Step One: Select the Report

1. Go to Reports > Report Manager.
2. Select a report by either:
   • Enter the search term in the field in the top-left of the Report Manager screen. The system will then return a list of matching reports.
   • Reports are grouped according to their content and purpose, such as Sales, Cash and Bank, Purchases, or Stock. Select one.
3. In the Reports column, select the report name. The report's data parameters appear under Filter Data By.

Step Two: Select Parameters

Each report has its own parameters that correspond to the fields on the report, such as dates, account names, and transaction types.  When you select a report, most parameter filters will contain default values. However, you can change them, and the system will remember the last parameters you selected. The most common filters are:

• 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.
• Drop-down (multi-select): Select more than one item. For example, to generate a Supplier (Vendor) remittance for several Supplier (Vendor) accounts, select the Supplier (Vendor) account codes that you want on the report.
• Free Text Entry: Enter the filter criterion in the field.

The parameters normally appear in the header section of each report. When you run some reports there is an option Show Header. Select No if you intend to export the report to Excel for further analysis as headers can interfere with user-defined formulas.

Step Three: View the Report

Generate a report by clicking View. This creates a new tab for the report. Many of the reports feature a drill-down capability. Click any of the figures in the report and, where drill down is available, you can view the detail behind that number. In some cases, you can drill down multiple times.

In the header, find the following:

• Navigate: You can open several reports at one time and navigate between them in the different tabs. This is useful for comparing information in different reports. Use the single arrows to navigate through a report page by page or the double arrows to skip to the end or beginning of a multi-page report. Click the back arrow to navigate back 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.

In the footer, find the following:

• Print: Generate a PDF print file by clicking Print. Ensure that you have Adobe Reader installed on your computer to enable you to open the report as a PDF.
• Email: Click Email to email the report directly. This opens the email screen with the report attached as a PDF document. Enter the email address, cc, subject, and message. The 'from' email address defaults to the email saved in the user profile.
• Full Screen View: Click to open the report in full-screen mode.
• Change Filters: This brings you back to the main report screen where you can change your parameters and click View to re-generate the report. This lets you view multiple versions of the same report as they will appear in different tabs.
• Close Report: When you are finished viewing a report, close its tab by clicking Close Report.

As we have over 200 reports, you can add favourite reports to both the Report Manager and Favourites, for easy access.

1. In Reports > Report Manager, select the relevant report. 
2. Click Add to My Reports.  (Re-click to remove from the report.)

Now the favourited report will appear in the My Reports tab:

And automatically in the Favourites > Reports tab:

Date Format

Most reports use the date format specified in your browser's language settings. Therefore, if your language setting is English UK, the date parameters will be in date/month/year format. Alternatively, if your language setting is English US, it will be in month/date/year format. 

Financial Periods

Financial periods do not always coincide with calendar periods. For clarity, General Ledger Reports show the Calendar Period. Ensure you select the correct financial year and always double-check the Calendar Period field prior to using the data contained in the relevant General Ledger Report.

Financial years can be either:

• Calendar financial year: January 2024 to December 2024 would appear as the year 2024, or the year ending 2024. To view a Trial Balance for August 2024, select Financial Year - 2024 and Financial Period - August. The data displayed would list August 2024.  
• 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 Trial Balance for the month of August 2023, select Financial Year - 2024 and Financial Period - August. The data displayed would list August 2023.

It is possible to have a Retail Calendar applied for your reports. Please contact your local support team to find out more about this.

See:

Managing Financial Periods 

Changing Financial Year Ends 

Selecting the Correct Year for Period-based 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. We can build a customized report for you.