Generate Basic Reports

Acxite’s intelligent document processing automatically extracts data from your uploaded bills, receipts, sales invoices, and other financial documents. This not only streamlines your bookkeeping but also empowers you to generate comprehensive reports directly within the platform. These reports allow you to quickly analyse your business’s financial performance, evaluate costs and revenue, and gain insights into various financial dimensions without any manual data entry.

This article provides a step-by-step guide on how to generate and customise financial reports using the data automatically extracted from your submitted documents in Acxite.

Generate reports

To generate and customise your financial reports in Acxite, follow these steps:

Step 1 – Navigate to the Reports page from the business menu.

Step 2 – Select the type of report you want to view.

Acxite offers ten types of reports, each providing a different perspective on your business’s financial data:

• Summary by category: Provides a breakdown of total costs or revenue grouped by categories or your chart of accounts.
• Summary by contact: Provides a breakdown of total costs or revenue grouped by customer or supplier.
• Summary by user: Provides a breakdown of total costs or revenue grouped by the user who submitted the document. This is particularly useful for managing expense claims within Acxite.
• Summary by VAT: Provides a breakdown of the VAT amount grouped by the applicable VAT rate.
• Profit & Loss: Provides a summary of income and expenses, showing net profit or loss for a defined period.
• Balance Sheet: Provides an overview of assets, liabilities, and equity as of a specific date.
• Trial Balance: Provides a list of all accounts with their debit and credit balances to ensure accuracy in financial records.
• General Ledger: Provides detailed records of every transaction for each account.
• Ageing Payables: Provides details of outstanding supplier invoices, organised by due date.
• Ageing Receivables: Provides details of outstanding customer invoices, grouped by due date.

Step 3 – Select the desired date range for your report. By default, this is set to the previous 365 days, but you can adjust it as needed.

Step 4 – Apply filters to refine your report data by clicking the filter icon. You can filter based on the following fields:

• Module: Choose to view purchases, sales, or both types of documents.
• Record as: Filter transactions based on how they were recorded (e.g., expense, bill). This can be used to exclude errors or duplicate documents from your reports.
• Doc status: Filter the report by document statuses such as processing, processed, or approved.
• Doc type: Filter the report by the specific document types or titles (e.g., exclude cheques).
• Contact: Filter the report for a specific customer or supplier.
• Year: Filter by the year in which the invoice or document was issued.
• Month: Filter by the month in which the invoice or document was issued. This can be used in conjunction with the Year filter to compare expenses for a specific month across different years.

Step 5 – Sort the data within your reports by clicking the arrow icon next to the column headers.

Step 6 – Click the Download Excel icon located in the top right corner of the page.

Your customised report will be downloaded in Excel format, allowing for further offline analysis and sharing.

Frequently asked questions

Related articles

• Overview of Business Dashboard
• Download Original Receipts/Bills/Invoices in Bulk with Advanced Filter