Reports Glossary - Beta

Definitions of all reports found in our enhanced Report Manager.

Written By Grainne Reidy (Super Administrator)

Updated at April 23rd, 2025

Table of Contents

AR

Set up

  • Customer Listing Detailed: The Customer Listing Detailed report provides comprehensive information about active customers, including their company names, addresses, contact details, VAT numbers, bank information, payment methods, credit terms, and account balances. It helps businesses manage customer relationships, track financial transactions, and ensure accurate billing and payments. This report is essential for maintaining up-to-date records and facilitating efficient customer service and financial management.
  • Customer Listing Summary: The Customer Listing Summary report provides a concise overview of customer accounts, including account numbers, names, contact details, payment methods, credit limits, last transaction dates, and balances. It helps businesses quickly assess the status of their customer accounts, monitor financial transactions, and manage credit limits. This summary report is essential for maintaining efficient customer relationship management and ensuring accurate financial oversight.
  • Customer Notes Extract: The Customer Notes Extract report provides a record of notes related to customer accounts, including account numbers, names, dates and content of notes, and user IDs. It helps businesses track interactions and communications with customers, ensuring that important information and follow-up actions are documented. This report is essential for maintaining accurate customer records and facilitating effective customer relationship management.
  • Inactive Customers List: The Inactive Customers List report identifies customers who are no longer active, including their account numbers, names, addresses, contact details, and email addresses. It helps businesses manage and analyze inactive accounts, potentially re-engage with these customers, and maintain accurate customer records. This report is essential for understanding customer churn and planning reactivation strategies.

Transaction Enquiries

  • Outstanding Sales Orders and Invoices: The Outstanding Sales Orders and Invoices report provides detailed information on pending sales orders and invoices, including account numbers, account names, general ledger account numbers, order numbers, department IDs, item descriptions, outstanding purchase orders, delivered items, and unposted invoices. This report helps businesses track and manage their sales pipeline, monitor order fulfillment, and ensure timely invoicing and payment collection. It is essential for maintaining accurate financial records and optimizing cash flow management.
  • Recurring Sales Invoices Due: The Recurring Sales Invoices Report provides details on recurring invoices for customers, including account numbers, names, billing intervals, start dates, due dates, item descriptions, general ledger account numbers, departments, currencies, and net amounts. It helps businesses track and manage regular billing cycles, ensure timely invoicing, and maintain accurate financial records. This report is essential for managing subscription-based services and recurring revenue streams.
  • Sales Account Summary: The Sales Account Summary report provides a detailed overview of customer transactions, including notes, over a specified period. It includes information such as transaction types, dates, amounts, and customer references. This report helps in tracking sales, managing accounts receivable, and identifying outstanding invoices and credits. It is essential for financial analysis, ensuring accurate billing, and maintaining customer account records.
  • Sales Allocations:  The Sales Allocations report details the allocation of sales transactions, including account numbers, names, allocation numbers, dates, references, departments, and amounts in base or foreign currency. It tracks how sales amounts are distributed across different accounts and departments, ensuring accurate financial reporting and reconciliation. This report is essential for managing and verifying the allocation of sales revenue, maintaining accurate financial records, and supporting financial audits.
  • Sales Commissions Report: The Sales Commissions report details the commissions earned by sales representatives, including information such as sales rep names, account names, order numbers, invoice numbers, dates, items sold, quantities, costs, prices, net amounts, item profits, commission rates, and commission amounts. This report helps businesses track and calculate the commissions owed to their sales team based on their sales performance. It is essential for managing sales incentives, ensuring accurate commission payments, and motivating the sales force.
  • Sales Daybook by Transaction or Period Date: The Sales Daybook by Transaction or Period Date report provides a detailed record of sales transactions over a specified period. It includes transactions by period or transaction date, customer references, amounts, and currency details. This report helps businesses track sales activities, monitor financial performance, and ensure accurate accounting by summarizing sales transactions within the chosen timeframe.
  • Sales Delivery Listing: The Sales Delivery Listing report tracks the delivery status of sales orders, including delivery references, account numbers, account names, order numbers, item details, order quantities, total delivered, outstanding quantities, and delivery status. This report helps businesses monitor the progress of deliveries, ensure timely fulfillment of orders, and manage inventory effectively by providing a detailed overview of each delivery's status.
  • Sales Invoice Listing by Item: The Sales Invoice Listing report provides a detailed record of sales transactions over a specified period. It includes key information such as invoice numbers, dates, customer details, item descriptions, quantities, prices, discounts, and total amounts. This report helps businesses track sales performance, manage accounts receivable, and ensure accurate financial reporting.
  • Sales Invoices Due: The Sales Invoices Due report provides a detailed overview of outstanding invoices and other transactions for various customers. It includes information such as customer names, invoice numbers, due dates, amounts due, and contact details. This report helps businesses track unpaid invoices, manage accounts receivable, and ensure timely follow-up with customers to improve cash flow and financial management.
  • Sales Receipts By Period/Account: The Sales Receipts By Period/Account report details sales transactions over specified periods, categorized by account. It includes information such as transaction dates, amounts, currencies, and account names. The report helps track sales performance, monitor revenue, and analyze trends across different accounts and periods. It is useful for financial analysis, budgeting, and strategic planning.
  • Sales Receipts Listing: The Sales Receipts Listing report provides a comprehensive list of all sales receipts within a specified date range. It includes details such as transaction dates, amounts, and customer information. This report is essential for tracking sales revenue, verifying receipt entries, and ensuring accurate financial records. It helps businesses monitor cash flow, reconcile accounts, and maintain transparency in sales transactions.
  • Unpaid/Unallocated Sales Transactions: The Unpaid/Unallocated Sales Transactions report lists sales transactions that have not been paid or allocated. It includes details such as account numbers, customer names, transaction dates, types, descriptions, and amounts. This report helps in identifying outstanding invoices and unallocated payments, facilitating better financial management and follow-up actions.

Customer Enquiries

  • Customer Activity: The Customer Activity report provides a detailed overview of customer transactions over a specified period, by period or transaction date. It includes information on sales invoices, sales receipts, credit notes, and currency fluctuations, categorized by transaction type and customer. This report helps track financial activities, monitor customer balances, and analyze sales performance.
  • Debtors Audit Trail: The Debtors Audit Trail report tracks all transactions related to debtors, including invoices, receipts, credits, and adjustments. It provides a detailed history of each debtor's account, showing amounts owed, payments made, and outstanding balances. This report is essential for auditing and reconciling debtor accounts, ensuring accuracy in financial records, and identifying any discrepancies or issues in debtor management.

Aging Analysis

  • Aged Debtors Detail Report: The Aged Debtors Detail Report provides a comprehensive breakdown of outstanding debts owed to a company, categorized by the age of the debt. It includes details such as transactions by period or transaction date, customer references, balances due, and aging periods (30, 60, 90 days). This report helps businesses monitor overdue accounts, manage credit risk, and reconcile debtor balances with the trial balance for accurate financial reporting.
  • Aged Debtors Detailed by Due Date: The Aged Debtors Detailed By Due Date report provides a detailed breakdown of outstanding customer invoices, categorized by their due dates. It helps businesses track overdue payments by transaction or period date, manage cash flow, and identify potential credit risks by showing amounts owed in various aging periods (current, 30 days, 60 days, 90 days, and beyond). This report is essential for effective accounts receivable management and financial planning.
  • Aged Debtors Summary- Grouping by Control Account: The Aged Debtors Summary - Grouping by Control Account report provides a summary of outstanding customer invoices by transaction or period date, grouped by control account. It helps businesses monitor and manage their accounts receivable by showing the total amounts owed by customers, in base or foreign currency, under each control account. This report is useful for reconciling the debtors' balances with the general ledger and ensuring accurate financial reporting.
  • Aged Debtors Summary Report: The Aged Debtors Summary Report provides a concise overview of outstanding customer invoices, categorized by customer account. It helps businesses monitor overdue payments by transaction or period date and manage accounts receivable by showing the total amounts owed by each customer in base or foreign currency. This report is essential for tracking financial health, ensuring timely collections, and reconciling debtors' balances with the general ledger for accurate financial reporting.

Sales Analysis

  • Sales Analysis by Customer (Overall): The Sales Analysis by Customer (Overall) report provides a detailed breakdown of sales performance by customer over a specified period. It includes monthly sales figures, cumulative totals, and comparisons across different time frames. This report helps businesses identify key customers, track sales trends, and make informed decisions to optimize sales strategies and customer relationships.
  • Sales Analysis By Period Report: The Sales Analysis By Customer By Period report provides a detailed breakdown of sales performance over specific periods, segmented by customer, region, area, and product group. It includes actual sales, budgeted sales, and various cost metrics, allowing for comparison and analysis of sales trends, customer contributions, and regional performance. This report is essential for identifying sales patterns, evaluating customer profitability, and making informed business decisions.
  • Sales Analysis By Product: The Sales Analysis By Product report provides a detailed breakdown of sales performance by product group over specific periods. It includes actual sales, budgeted sales, item costs, and gross margins, allowing for comparison and analysis of sales trends, product profitability, and performance against budget. This report is essential for identifying top-performing products, evaluating cost efficiency, and making informed decisions on product strategy and inventory management.
  • Sales of Items By Customer: The Sales of Items By Customer report details sales transactions by customer, including invoice numbers, dates, items sold, quantities, prices, and net amounts. It provides insights into customer purchasing behavior, sales performance, and revenue generation. This report is essential for identifying key customers, tracking sales trends, and making informed decisions on customer relationship management and sales strategies.

Business Doc/Reprint

  • Customer Statements - Head Office Remittance: The Customer Statements - Head Office Remittance report provides a summary of outstanding invoices for a head office customer, including invoice dates, types, references, descriptions, and amounts. It helps in tracking due payments, managing customer accounts, and ensuring timely remittance. This report is essential for maintaining accurate financial records and facilitating communication with customers regarding their account status.
  • Customer Statements - Report: The Customer Statement report provides a detailed overview of transactions. It includes invoices, receipts, credit notes, and refunds, detailing amounts, dates, references, and outstanding balances. This report helps track financial interactions, monitor account statuses, and ensure accurate reconciliation of accounts.
  • Despatch Docket Reprint: The Despatch Docket Reprint Report provides details of items dispatched to customers, including customer account information, delivery dates, status, sales order references, and item quantities. This report is essential for tracking deliveries, verifying dispatched quantities, and ensuring accurate record-keeping of sales orders and customer shipments.
  • Sales Batch Credit Note Reprint: The Sales Batch Credit Note Reprint report provides a detailed record of credit notes issued. It includes information such as credit note numbers, account numbers, dates, currencies, external references, item descriptions, net amounts, VAT rates, and total amounts. This report is useful for verifying and reprinting credit notes, ensuring accurate financial records, and facilitating account reconciliation.
  • Sales Product Credit Note Default: The Sales Product Credit Note Default report details credit notes issued. It includes information such as credit note numbers, account numbers, dates, due dates, external references, item codes, descriptions, quantities, prices, discounts, VAT rates, and net amounts. This report helps track adjustments, ensuring accurate financial records and facilitating account reconciliation.
  • Sales Product Order Reprint: The Sales Product Order Reprint report provides a detailed record of sales orders. It includes information such as order numbers, account numbers, order dates, expected delivery dates, statuses, credit terms, item codes, descriptions, quantities, prices, net amounts, VAT rates, and total amounts. This report is useful for verifying and reprinting sales orders, ensuring accurate financial records, and facilitating order management and reconciliation.
  • Sales Product Quote Reprint: The Sales Product Quote Reprint report provides a detailed record of sales quotes. It includes information such as quote numbers, account numbers, dates, statuses, expected delivery dates, external references, item codes, descriptions, quantities, prices, net amounts, VAT rates, and total amounts. This report is useful for verifying and reprinting sales quotes, ensuring accurate financial records, and facilitating quote management and reconciliation.
  • Sales Receipt Reprint: The Sales Receipt Reprint report provides a detailed record of receipts issued for sales transactions. It includes information such as receipt numbers, account numbers, dates, payment references, invoice amounts, and total amounts. This report is useful for verifying and reprinting sales receipts, ensuring accurate financial records, and facilitating account reconciliation.

Extracts

  • Aged Debtors Detailed - Export Format: The Aged Debtors Detailed Report provides a comprehensive overview of outstanding debts owed to a company, categorized by the age of the debt. It includes details such as account numbers, company names, transactions by period or transaction date, types, amounts, and balances. The report helps in tracking overdue payments, managing credit control, and reconciling with the Creditors Control Account in the Trial Balance. It ensures accurate financial reporting and aids in identifying potential cash flow issues.
  • Sales Orders & Invoices Listing Extract: This report provides a detailed listing of sales orders and invoices, including information such as invoice numbers, order dates, supplier names, departments, item descriptions, quantities, prices, currencies, exchange rates, tax rates, and order statuses. It tracks financial transactions across various departments and projects, highlighting commission statements, dealing fees, recharges, custody fees, and tax fees. The report helps in managing and auditing financial records, ensuring accurate billing and payment processing.
  • Unpaid/Unallocated Sales Transactions - Export Format: This report lists sales transactions that are unpaid and unallocated, including details such as account numbers, account names, transaction dates, types, invoice numbers, external references, descriptions, amounts, VAT amounts, and unallocated and unpaid amounts. It helps in identifying outstanding sales transactions that need to be addressed, ensuring accurate financial tracking and facilitating follow-up actions for payment collection and allocation.
 
 

AP

Set up

  • Supplier Listing: This report provides a comprehensive list of suppliers, including details such as account numbers, account names, addresses, contact names, phone numbers, email addresses, last transaction dates, and balances. It helps in managing supplier information, tracking transactions, and monitoring outstanding balances, ensuring efficient supplier relationship management and accurate financial records.
  • Supplier Lists - Active: This report lists active suppliers, including details such as account numbers, account names, account groups, creation dates, addresses, phone numbers, VAT numbers, bank details, payment methods, credit terms, currencies, contact names, and email addresses. It helps in managing supplier information, tracking transactions, and ensuring accurate financial records for active suppliers.
  • Supplier Lists - Inactive: This report lists inactive suppliers, including details such as account numbers, account names, addresses, contact names, phone numbers, email addresses, and last transaction dates. It helps in managing supplier information, tracking historical transactions, and identifying suppliers that are no longer active, ensuring accurate and up-to-date supplier records.

Transaction Enquiries

  • Contractors Payments: This report details payments made to contractors, including information such as payment dates, tax amounts, and total payments. It helps in tracking and managing contractor expenses, ensuring accurate financial records and compliance with tax regulations. This comprehensive overview of contractor payments over a specified period, facilitates budgeting and financial planning.
  • Goods Received Listing: This report provides a detailed listing of goods received, including information such as delivery references, account numbers, account names, order numbers, item descriptions, order quantities, total deliveries, outstanding quantities, and delivery statuses. It helps in tracking and managing inventory, ensuring accurate records of received goods, monitoring partial and complete deliveries, and facilitating efficient supply chain management.
  • Purchase Allocations: This report details the allocation of purchase transactions over a specified period, including information such as allocation numbers, allocation dates, account numbers, account names, transaction types, external references, department IDs, transaction IDs, amounts in base or foreign currency, and statuses. It helps in tracking and managing the allocation of purchases, ensuring accurate financial records, monitoring outstanding amounts, and facilitating efficient budgeting and financial planning. 
  • Purchase Daybook Listing by Transaction or Period Date: The Purchase Daybook Listing by Transaction or Period Date report provides a detailed record of supplier transactions by transaction or period date, including purchase invoices, debit notes, payments, reversals, journals, and currency fluctuations. This report helps track and manage financial activities, ensuring accurate accounting and auditing.
  • Purchase Invoice Details: The Purchase Invoice Details report provides a comprehensive overview of all purchase invoices within a specified date range. It includes details such as supplier names, invoice dates, descriptions, amounts, and account codes. This report is essential for tracking expenses, managing accounts payable, and ensuring accurate financial records. It helps in auditing, budgeting, and financial analysis by offering a detailed breakdown of all transactions related to purchases.
  • Purchase Invoice Listing by Item: The Purchase Invoice Listing by Item report provides a detailed breakdown of purchase invoices and credit notes categorized by individual items. It includes information such as invoice numbers, dates, suppliers, item descriptions, quantities, prices, and amounts. This report is crucial for tracking inventory, analyzing purchasing patterns, and managing expenses. It helps ensure accurate financial records and supports decision-making related to procurement and inventory management.
  • Purchase Ledger Audit Trail: The Purchase Ledger Audit Trail report provides a comprehensive record of all transactions related to the purchase ledger. It includes details such as supplier names, invoice numbers, dates, descriptions, amounts, and payment statuses. This report is essential for tracking and verifying all purchase transactions, ensuring accuracy in financial records, and supporting audits and compliance checks. It helps in identifying discrepancies, managing supplier accounts, and maintaining a clear audit trail for all purchases.
  • Purchase Ledger Journals Details: The Purchase Ledger Journals Details report provides a detailed record of all journal entries related to the purchase ledger. It includes information such as supplier names, dates, account codes, descriptions, debit and credit amounts. This report is essential for tracking and verifying all journal entries, ensuring accuracy in financial records, supporting audits and compliance checks, and managing supplier accounts.
  • Purchase Ledger Transactions: The Purchase Ledger Transactions report provides a comprehensive record of all transactions related to the purchase ledger. It includes details such as supplier names, transaction dates, invoice numbers, amounts, and transaction type. This report is crucial for tracking and managing all purchase-related financial activities, ensuring accuracy in financial records, supporting audits and compliance checks and monitoring supplier accounts.
  • Supplier Invoices Due: The Supplier Invoices Due report lists all outstanding invoices from suppliers, including details such as supplier names, invoice dates, due dates, amounts, transaction type, and payment methods. This report is crucial for managing cash flow, ensuring timely payments, maintaining good supplier relationships, and avoiding late fees or disruptions in supply.
  • Unpaid/Unallocated Purchase Transactions: The Unpaid/Unallocated Purchase Transactions report lists purchase transactions that have not been paid or allocated. It includes details such as transaction dates, types, amounts, and descriptions. This report is essential for identifying outstanding liabilities, managing cash flow, ensuring accurate financial records, and facilitating better financial planning and decision-making.

Supplier Enquiries

  • Creditors Transactions by GL Account: The Creditors Transactions by GL Account report details transactions with creditors, categorized by general ledger accounts. It includes information such as transaction dates, amounts, descriptions, and associated suppliers. This report helps in tracking and managing creditor payments, ensuring accurate financial records, and facilitating audits and financial analysis.
  • Supplier Activity: The Supplier Activity report provides a detailed overview of transactions between a company and its suppliers by transaction or period date. It includes information on purchase invoices, payments, credit and debit journals, and currency fluctuations. The report helps track financial activities, monitor supplier performance, and manage accounts payable efficiently.
  • Supplier Statements Listing Format: The Supplier Statements Listing Format report provides a summary of transactions with suppliers, including purchase invoices, payments, credit and debit notes, and outstanding balances. It details the amounts due within different aging periods (30, 60, 90 days) and the total outstanding balance. This report helps in tracking supplier payments, managing cash flow, and ensuring timely settlements.
  • Top Suppliers By Transactions: The Top Suppliers By Transactions report identifies the suppliers with the highest transaction volumes within a specified period. It includes details such as supplier names, account numbers, base or foreign currency, and balances. This report helps in analyzing supplier performance, managing procurement strategies, and optimizing supplier relationships by highlighting the most active suppliers based on transaction amounts.

Workflow Reports

  • Approval Workflow Details Export: The Approval Workflow Details Report outlines the approval process for the selected workflow. It includes information such as workflow names, process types, auto-approval limits, and re-approval rules. The report details each approval step, specifying approvers, their decision modes, and approval limits. This report is essential for understanding and managing the invoice approval workflow, ensuring compliance with approval policies and efficient processing of invoices and orders.
  • Approver Listing: The Approver Listing report provides a detailed list of individuals authorized to approve transactions within a company. It includes their names, email addresses, approval limits, and associated departments or projects. This report helps in managing and verifying approval workflows, ensuring that only designated personnel can authorize expenditures and other financial activities.

Purchase Commitments

  • Purchase Commitment: The Purchase Commitment report tracks the company's committed expenditures against its budget. It includes details such as budget codes, cost categories, departments, and actual year-to-date spending. This report helps in monitoring financial commitments, ensuring budget compliance, and managing future cash flows by comparing actual expenditures with budgeted amounts.
  • Purchase Commitment by Approver [Use with Budget Holder Approval Only]: The Purchase Commitment by Approver report details the financial commitments approved by a specific individual within a company. It includes budget allocations, actual year-to-date expenditures, outstanding purchase orders, and delivered items. The report helps track spending against budgets and provides a breakdown of transactions by department and account, highlighting variances and ensuring compliance with budgetary constraints.

Payments

  • Bulk Payments Report: The Bulk Payments Report provides a summary of multiple supplier payments processed in a single bulk payment. It includes details such as payment batch number, bank account, payment date, exchange rate, and batch status. The report lists each supplier's payment amount, currency, exchange rate, and bank account details. It helps in tracking and verifying bulk payments, ensuring accuracy and completeness of financial transactions.
  • Purchase Payments Listing: The Purchase Payments Listing report provides a detailed record of all purchase payments made within a specified period. It includes information such as payment dates, supplier names, payment amounts, bank accounts, and transaction references. This report helps in tracking and verifying payments, ensuring accurate financial records, facilitating reconciliation processes, and maintaining accountability in financial operations.

Aging Analysis

  • Aged Creditors Detail Report: The Aged Creditors Detail Report provides a comprehensive breakdown of outstanding creditor balances, categorized by the age of the debt. It includes details such as transactions by period or transaction date, supplier names, amounts due, and aging periods (e.g., 30, 60, 90 days). This report helps in managing and monitoring overdue payments, ensuring timely settlements, and maintaining healthy supplier relationships. It is crucial for financial planning and control, aiding in the reconciliation of creditor balances with the general ledger.
  • Aged Creditors Detailed by Due Date: The Aged Creditors Detailed by Due Date report provides a detailed breakdown of outstanding creditor balances, categorized by their due dates. It helps track unpaid invoices by period or transaction date, including information such as creditor names, invoice dates, amounts due, and aging periods (current, 30 days, 60 days, etc.). This aids in identifying overdue payments, maintaining good supplier relationships, managing cash flow, and prioritizing payments.
  • Aged Creditors Summary- Grouping by Control Account:  The Aged Creditors Summary - Grouping by Control Account report provides a summarized view of outstanding creditor balances by period or transaction date. It helps to quickly assess total amounts owed to different creditors in base or foreign currency. This report includes details such as creditor names, amounts due, and aging periods, facilitating efficient financial management and reconciliation with the Creditors Control Account in the Trial Balance.
  • Aged Creditors Summary Report: The Aged Creditors Summary Report provides an overview of outstanding creditor balances, displayed by period or transaction date. It helps businesses monitor and manage their payables by summarizing the total amounts owed, in base or foreign currency, to each creditor and highlighting overdue payments. This report includes details such as creditor names, amounts due, and aging periods, facilitating efficient financial management and reconciliation with the Creditors Control Account in the Trial Balance. 

Purchase Analysis

  • Purchase Analysis By Product: The Purchase Analysis By Product report provides a detailed breakdown of purchases categorized by product groups. It helps businesses analyze purchasing trends, compare actual purchases against budgeted amounts, and track product-specific expenditures. This report includes product names, purchase quantities, actual versus budgeted costs, and time periods, enabling efficient financial planning and inventory management.
  • Purchase Analysis by Supplier (Overall): The Purchase Analysis by Supplier (Overall) report provides a comprehensive overview of purchases made from various suppliers over multiple years. It includes detailed monthly and yearly purchase values, allowing for analysis of spending patterns, supplier performance, and cost management. This report helps in identifying trends, optimizing supplier relationships, and making informed procurement decisions.
  • Purchase Analysis by Supplier by Period: The Purchase Analysis by Supplier by Period report provides a detailed breakdown of purchases from various suppliers over specific periods. It includes monthly and quarterly purchase values, allowing businesses to track spending trends, compare actual purchases against budgets, and analyze supplier performance over time. This report helps in managing procurement strategies and optimizing supplier relationships.
  • Purchase of Items By Supplier: The Purchase of Items By Supplier report provides a detailed listing of items purchased from various suppliers over a specified period. It includes information such as supplier names, item descriptions, quantities, prices, and total amounts. This report helps businesses track and analyze their purchasing activities, manage inventory, and optimize supplier relationships by providing a comprehensive view of item-level purchases.
  • Supplier Activity By Period: The Supplier Activity By Period report tracks financial transactions with suppliers over specified periods. It includes supplier names, account numbers, currency codes, and monthly movements in base or foreign currency. This report helps monitor spending, identify trends, and manage supplier relationships effectively by providing a comprehensive view of payments and balances over time.

Business Doc/Reprint

  • Goods Received Note Reprint: The Goods Received Note Reprint provides a detailed record of goods received from suppliers. It includes information such as supplier details, delivery date, purchase order reference, item descriptions, quantities received, and status of the delivery. This report helps businesses verify and track the receipt of goods, ensuring accurate inventory management and reconciliation with purchase orders.
  • Purchase (Product) Debit Note Reprint: The Purchase Product Debit Note Reprint documents reprinted debit notes issued to suppliers for returned or disputed items. It includes details such as supplier names, item descriptions, quantities, prices, and total amounts. This report helps businesses manage and track returns, adjustments, and credits with suppliers, ensuring accurate financial records and reconciliation of accounts.
  • Purchase (Product) Invoice Reprint: The Purchase (Product) Invoice Reprint report provides detailed records of purchase invoices issued to suppliers. It includes information such as supplier names, item descriptions, quantities, prices, and total amounts. This report helps businesses track and verify their purchasing transactions, manage accounts payable, and ensure accurate financial records by providing a comprehensive view of all purchase invoices.
  • Supplier Batch Payments Report Reprint: The Supplier Batch Payments Report Reprint provides a detailed record of batch payments made to suppliers. It includes information such as payment batch number, bank account details, payment date, exchange rate, payment status, and total payment amount. Additionally, it lists individual supplier payments, including supplier names, payment amounts, due dates, and approvers. This report helps businesses manage and track bulk payments to suppliers, ensuring accurate financial records and efficient payment processing.
  • Supplier Cheque Batch Print: The Supplier Cheque Batch Print provides a detailed record of cheques issued to suppliers in bulk payments. It includes information such as cheque numbers, dates, supplier names, invoice references, amounts, and payment statuses. This report helps businesses manage and track cheque payments to suppliers, ensuring accurate financial records and efficient payment processing.
  • Supplier Remittance: Allows bulk email for supplier remittances related to batch payments.
  • Supplier Remittance Batch Print: The Supplier Remittance Batch Print report provides a detailed record of remittance advices sent to suppliers for bulk payments. It includes information such as supplier names, addresses, payment dates, invoice references, amounts paid, and outstanding balances. This report helps businesses communicate payment details to suppliers, ensuring transparency and accurate financial records.
  • Supplier Remittance Bulk Email: The Supplier Remittance Bulk Email Report details payments made to suppliers, including information such as supplier names, account numbers, invoice references, payment dates, amounts, and bank account details. This report is essential for communicating payment information to suppliers, ensuring transparency and accuracy in financial transactions, and facilitating efficient bulk email notifications for remittances.
  • Supplier Statements: The Supplier Statements report provides a detailed record of supplier transactions. It includes information such as transaction dates, types, references, amounts, and outstanding balances. This report helps in tracking payments, managing accounts payable, and ensuring accurate financial records. It also aids in reconciling supplier accounts and monitoring overdue payments.

Extracts

  • Aged Creditors Detailed - Export Format: The Aged Creditors Detailed Report provides a comprehensive breakdown of outstanding balances owed to creditors, categorized by age (current, 30 days, 60 days, 90 days, and over 90 days). It includes details such as account numbers, creditor names, transactions by period or transaction date, and amounts in base or foreign currency. This report is essential for financial reconciliation, helping businesses track and manage their payables, ensuring accuracy in the Creditors Control Account within the Trial Balance.
  • Purchase Orders & Invoices Listing Extract: The Purchase Orders Invoices Listing Report provides a detailed overview of purchase orders or invoices. It includes information such as order or invoice numbers, dates, supplier names, item descriptions, quantities, prices, and statuses. This report is crucial for tracking and managing procurement activities, ensuring accurate record-keeping and facilitating financial reconciliation between purchase orders and invoices.
  • Supplier Notes Extract: The Supplier Notes Extract Report compiles notes related to suppliers, including details such as account numbers, supplier names, and dates and content of notes. This report is useful for tracking communications, negotiations, and payment statuses with suppliers, providing a historical record of interactions and decisions made over time.
  • Unpaid/Unallocated Purchase Transactions - Export Format: The Unpaid and Unallocated Purchase Transactions Report lists purchase transactions that have not been paid or allocated. It includes details such as account numbers, supplier names, transaction dates, descriptions, amounts, and VAT. This report is crucial for identifying outstanding liabilities, ensuring accurate financial tracking, and facilitating the reconciliation of accounts payable.
 
 

Items

Set Up

  • Stock Listing: The Stock Listing report provides a detailed inventory of all stock items, including their categories, item IDs, descriptions, types, quantities, and costs. It includes information on pricing, last purchase and sale dates, and average costs. This report is essential for managing inventory, tracking stock levels, and analyzing stock performance. 

Transaction Enquiries

  • Sales Order Picking List: The Sales Order Picking List report provides a detailed list of items to be picked for delivery based on orders. It includes information such as item IDs, descriptions, order numbers, delivery dates, quantities ordered, quantities delivered, and customer details. This report is essential for managing the order fulfillment process, ensuring accurate and timely delivery of items, maintaining inventory control, and improve customer satisfaction.
  • Stock Orders Uninvoiced: The Stock Orders Uninvoiced report lists all stock orders that have been delivered but not yet invoiced. It includes details such as order numbers, invoice numbers, account names, item descriptions, quantities, values, and delivery dates. This report is essential for tracking outstanding invoices, identifying discrepancies between delivered goods and invoiced amounts, and facilitating timely invoicing and payment collection.
  • Stock Outstanding Orders: The Stock Outstanding Orders report lists all sales or purchase orders that have been placed but not yet fully delivered. It includes details such as order numbers, statuses, account names, item descriptions, order quantities, delivered quantities, and outstanding values. This report is essential for tracking pending orders, managing inventory, and ensuring timely fulfillment. It helps identify any delays or shortages in order processing, facilitating better customer service and efficient inventory management.
  • Stock Quotes: The Stock Quotes report provides a list of stock quotes for various items within a specified date range. It includes details such as account names, order numbers, item descriptions, quantities, status, prices, and outstanding values. This report is essential for tracking quoted prices, managing potential sales, analyzing market trends. It helps in understanding customer interest, preparing for future orders, and making informed pricing decisions. 
  • Stock Received Orders: The Stock Received Orders report lists all sales or purchase orders that have been delivered within a specified period. It includes details such as account names, order numbers, item descriptions, quantities ordered, quantities delivered, delivery dates, and outstanding values. This report is essential for tracking received orders, verifying deliveries match orders, managing inventory, and ensuring accurate record-keeping. 
  • Stock Reorders: The Stock Reorders report lists items that need to be reordered to maintain adequate inventory levels. It includes details such as item groups, item IDs, descriptions, and quantities to be reordered. This report is essential for managing stock levels, preventing stockouts, and ensuring timely replenishment of inventory. 

Item Enquiries

  • Stock Locations Listing: The Stock Locations Listing report provides a detailed inventory of stock items across various locations. It includes information such as item groups, item IDs, descriptions, quantities, costs, and values. This report is essential for managing inventory across multiple locations, ensuring accurate record-keeping, optimizing stock distribution, and supporting efficient inventory management and decision-making.
  • Stock Movements Report: The Stock Movements Report tracks the movement of stock items within a specified period. It includes details such as item descriptions, transaction types, order numbers, references, order dates, accounts, quantities, and values. This report is essential for monitoring inventory changes, managing stock levels, ensuring accurate record-keeping, and identifying trends in stock usage.
  • Stock Out Report: The Stock Out Report lists items that have reached or fallen below their reorder levels, indicating a need for replenishment. It includes details such as item groups, item IDs, descriptions, and reorder levels. This report is essential for managing inventory, preventing stockouts, and ensuring timely restocking of items. It helps maintain smooth operations by identifying items that require immediate attention.
  • Stock Valuation - Historical: The Stock Valuation report provides an assessment of the value of stock items within a specified date range. It includes details such as item IDs, descriptions, quantities on hand, average costs, and total stock values. This report is essential for understanding the financial worth of inventory, evaluating investments, making informed purchasing decisions, and ensuring accurate financial records.
 
 

Bank

Set up

  • Bank Listing: The Bank Listing report provides a summary of various bank accounts, including their account numbers, names, currencies, and balances. It shows both the beginning and current balances for each account, helping to track financial positions across different currencies. This report is useful for financial reconciliation, monitoring cash flow, and ensuring accurate financial records.
  • Supplier (Vendor) Bank Account Details Audit Report: The Supplier (Vendor) Bank Account Details Audit Report tracks changes in bank account details for suppliers over a specified period. It includes information such as account numbers, descriptions, old and new bank codes, sort codes, IBANs, and SWIFT codes. This report helps ensure the accuracy and integrity of supplier payment information, aiding in the detection of unauthorized changes and supporting financial audits.

Transaction Enquiries

  • Bank Daybook Listing Period Date: The Bank Daybook Listing Period Date report provides a detailed record of all bank transactions within a specified period. It includes entries for bank journals, customer receipts, supplier payments, and sundry bank payments and receipts. The report helps in tracking and reconciling bank account activities, ensuring accuracy in financial records, and identifying any discrepancies. It is essential for maintaining up-to-date and accurate financial statements.
  • Cash Bank Summary: The Cash Bank Summary report provides an overview of the bank account activities for a specified period. It includes details such as the account number, base or foreign currency amounts, and dates. This report helps in summarizing the cash flow and bank transactions, offering a snapshot of the financial position of the bank account. It is useful for financial analysis and ensuring accurate record-keeping.
  • Cash and Bank Payments List: The Cash and Bank Payments List report details all cash and bank payments made within a specified period. It includes transaction types, account numbers, descriptions, dates, and amounts. This report helps in tracking and reconciling payments, ensuring accurate financial records, and identifying any discrepancies. It is essential for maintaining transparency and control over cash flow and bank transactions.
  • Cash and Bank Receipts List: The Cash and Bank Receipts List report provides a detailed record of all cash and bank receipts within a specified period. It includes transaction types, account numbers, descriptions, dates, and amounts. This report is essential for tracking incoming funds, ensuring accurate financial records, and reconciling receipts. It helps maintain transparency and control over cash flow and bank transactions, aiding in financial analysis and auditing.
  • Cashflow Past Periods: The Cashflow Past Periods report provides a detailed summary of cash inflows and outflows over specific periods. It includes transaction types, account numbers, descriptions, dates, and amounts. This report is essential for tracking historical cash movements, analyzing financial trends, and managing liquidity. It helps in understanding the financial health of the organization by showing net cash flow for each period and overall net cash flow, aiding in financial planning and decision-making.
  • Check Register Report: The Check Register Report provides a record of all checks issued within a specified date range. It includes details such as check numbers, dates, batch numbers, bank account numbers, user IDs, and payment amounts. This report is essential for tracking check payments, ensuring accurate financial records, and reconciling bank accounts. It helps maintain transparency and control over check transactions, aiding in financial management and auditing.

Bank Reconciliation

  • Bank Reconciliation Report: The Bank Reconciliation Report compares the bank statement balance with the company's ledger balance for a specified period. It includes details such as transaction IDs, dates, account numbers, descriptions, and amounts. This report helps identify discrepancies between the bank statement and the company's records, ensuring accurate financial reporting. It is essential for verifying the completeness and accuracy of financial transactions, aiding in the detection of errors or fraudulent activities, and maintaining the integrity of financial records.
  • Unreconciled Cash and Bank Items: The Unreconciled Cash and Bank Items report lists all cash and bank transactions that have not been reconciled within a specified period. It includes details such as transaction types, account numbers, descriptions, dates, and amounts. This report is essential for identifying discrepancies between the company's ledger and bank statements, ensuring accurate financial records, and facilitating the reconciliation process. It helps maintain transparency and control over financial transactions, aiding in the detection of errors or omissions and ensuring the integrity of financial data.

Business Doc/Reprint

  • Bank Payment/Receipt Reprint: The Bank Payment/Receipt Reprint report provides a reprint of specific bank payment or receipt transactions. It includes details such as transaction type, account name, external reference, description, and amount. This report is useful for generating copies of payment or receipt records for verification, auditing, or record-keeping purposes. It helps ensure accurate financial documentation and facilitates easy access to transaction details when needed.

Extracts

  • Bank Reconciliation Report - Export Format: The Bank Reconciliation Report compares the bank statement balance with the company's ledger balance for a specified period. It includes details such as transaction IDs, dates, account numbers, descriptions, and amounts. This report helps identify discrepancies between the bank statement and the company's records, verifying the completeness and accuracy of financial transactions, and aiding in the detection of fraudulent activities.
 
 

GL

Set Up

  • Analysis Structure Mapping: The Analysis Structure Mapping report provides a detailed analysis of the GL coding structure, including departments such as divisions, locations, and projects. It includes details such as department IDs, department names, activity status, and associated codes and descriptions. This report is essential for understanding the hierarchical structure of the organization, managing departmental data, ensuring accurate record-keeping, and supporting efficient management and decision-making.
  • Chart of Accounts Layout: The Chart of Accounts Layout report provides a structured overview of all general ledger accounts used by the organization. It includes details such as account categories, subcategories, account numbers, account names, and associated departments. This report is essential for managing financial records, ensuring accurate bookkeeping, and supporting financial reporting. It helps maintain a comprehensive and organized account structure, facilitating efficient financial management and decision-making.

Transaction Enquiries

  • General Journals List: The General Journals List report provides a detailed record of all journal entries made within a specified period, including year end journals. It includes transaction IDs, dates, account numbers, descriptions, and debit/credit amounts. This report is essential for tracking financial transactions, ensuring accuracy in accounting records, and facilitating audits and financial analysis.
  • General Ledger - Budgets by Period: The General Ledger - Budgets by Period report provides a detailed breakdown of budgeted amounts for general ledger accounts across periods within a financial year. It includes information on account numbers, account names, department IDs, and budgeted amounts for each period. This report helps in tracking and comparing budget allocations and expenditures over time, ensuring financial planning and control.
  • General Ledger Audit Trail: The General Ledger Audit Trail report provides a detailed record of all transactions affecting the general ledger accounts over a specified period. It includes transaction IDs, types, external references, internal numbers, user IDs, dates, periods, account codes, account names, descriptions, and debit/credit amounts. This report is essential for tracking changes, ensuring accuracy, and maintaining transparency in financial records.
  • General Ledger Audit Trail By BI Code: The General Ledger Audit Trail By Dept report provides a detailed record of transactions affecting general ledger accounts, categorized by department. It includes transaction IDs, types, external references, internal numbers, user IDs, dates, periods, department codes, account numbers, account names, descriptions, and debit/credit amounts. This report is essential for tracking departmental financial activities, ensuring accuracy, and maintaining transparency in financial records.
  • General Ledger Daybook by transaction or period date: The General Ledger Daybook by Transaction or Period Date report provides a detailed record of all transactions affecting the general ledger accounts within a specified date range. It includes transactions by period or transaction date, types, references, user IDs, account codes, account names, descriptions, and debit/credit amounts. This report is essential for tracking daily financial activities, ensuring accuracy, and maintaining transparency in financial records.

Profit & Loss

  • P&L By Dimension: The P&L By Dimension report provides a detailed analysis of the profit and loss statement, broken down by various dimensions such as location, department, or project. It includes period amounts, budgets, variances, and percentages for different income and expense categories. This report is essential for understanding financial performance across different segments of the business, identifying trends, and making informed decisions.
  • Profit & Loss - Extended Parameters: The Profit and Loss - Extended Parameters report provides a comprehensive overview of a company's financial performance over a specified period. It includes details on operating income, cost of sales, administrative expenses, financial costs, and staff costs, broken down by month, year-to-date, and budget comparisons. This report is essential for assessing profitability, identifying trends, and making informed business decisions.
  • Profit & Loss Forecast - Extended Parameters: This Profit and Loss Forecast report provides a detailed forecast of the company's financial performance. It includes actual and budgeted figures for operating income, expenses, and EBITDA, broken down by categories such as advisory fees, management fees, office costs, and financial costs. The report helps in tracking revenue, costs, and profitability over time, aiding in financial planning and decision-making.
  • Profit & Loss: The Profit and Loss provides a detailed comparison of the company's financial performance against the previous year. It includes categories such as operating income, cost of sales, office costs, staff costs, administrative expenses, and financial costs. Each category is broken down into specific accounts, showing the actual amounts, budgets, and variances. This report helps in assessing financial performance, identifying areas of improvement, and making informed business decisions.
  • Profit & Loss as Percentage of Sales: The Profit and Loss as Percentage of Sales report provides a detailed analysis of the company's financial performance, expressed as a percentage of sales. It includes operating income, cost of sales, administrative expenses, staff costs, and financial costs, broken down by categories and subcategories. This report is essential for understanding the relationship between sales and various financial metrics, helping to identify trends, assess profitability, and make informed business decisions. It supports efficient financial management and strategic planning by providing a clear view of how sales impact overall financial performance.
  • Profit & Loss By BI Code: The Profit and Loss By BI Code report provides a detailed breakdown of income, expenses, and net profit for various departments within a company. It compares actual amounts against budgeted figures for each category, highlighting variances. This helps in assessing departmental performance, identifying areas of overspending or underspending, and making informed financial decisions. 
  • Profit & Loss By BI Code - Multiple Years: The Profit & Loss By Dept Multi Year report provides a detailed comparison of actual income and expenses against budgeted amounts across multiple departments over several years. It helps in analyzing financial performance, identifying variances, and making informed decisions for future budgeting and financial planning.
  • Profit & Loss by Period Summary: The Profit and Loss by Period Summary report provides a snapshot of the company's financial performance for a specific period. It compares actual income and expenses against budgeted amounts, highlighting variances. This summary helps in assessing financial health, identifying trends, and making informed decisions for future financial planning and budgeting.
  • Profit & Loss DR/CR Format: The Profit and Loss DR/CR Format report presents the company's financial transactions in a debit and credit format. It details revenue and expenses across various categories, showing amounts for specific periods and years. This format helps in tracking financial performance, ensuring accurate accounting, and identifying discrepancies between debits and credits for better financial management.
  • Profit & Loss Vs Budget Detailed: The Profit and Loss Vs Budget Detailed report provides a comprehensive comparison of actual income and expenses against budgeted amounts for various categories. It includes detailed monthly and year-to-date figures, highlighting variances. This report helps in analyzing financial performance, identifying areas of over or under-spending, and making informed decisions for future budgeting and financial planning.
  • Profit & Loss Vs Budget Summary: The Profit and Loss Vs Budget Summary report provides a high-level comparison of actual income and expenses against budgeted amounts for various categories. It includes monthly and year-to-date figures, highlighting variances. This summary helps in quickly assessing financial performance, identifying trends, and making informed decisions for future budgeting and financial planning.
  • Profit & Loss Vs Previous Year Detailed: The Profit and Loss Vs Previous Year Detailed report compares the company's financial performance for the current period against the same period in the previous year. It includes detailed figures for income and expenses, highlighting variances in both percentage and absolute terms. This report helps in identifying trends, assessing year-over-year performance, and making informed decisions for future financial planning and strategy.
  • Profit & Loss Vs Previous Year Summary: The Profit and Loss Vs Previous Year Summary report provides a high-level comparison of the company's financial performance for the current period against the same period in the previous year. It includes summary figures for income and expenses, highlighting variances in both percentage and absolute terms. This report helps in quickly assessing year-over-year performance, identifying trends, and making informed decisions for future financial planning and strategy.

Balance Sheet

  • Balance Sheet - Extended Parameters: The Balance Sheet Extended Format report provides a comprehensive overview of the company's financial position as of a specific date. It includes detailed figures for fixed assets, current assets, current liabilities, and capital and reserves. The report compares actual amounts to budgeted figures, highlighting variances. This format helps in assessing financial health, ensuring accurate accounting, and making informed decisions for resource allocation and financial planning.
  • Balance Sheet By BI Code By Period: The Balance Sheet By BI Code By Period report provides a detailed view of the company's financial position, broken down by department and period. It includes assets, liabilities, and equity, comparing actual amounts to budgeted figures and highlighting variances. This report helps in tracking financial health, ensuring departmental accountability, and making informed decisions for resource allocation and financial planning.
  • Balance Sheet By Dimension: The Balance Sheet By Dimension report provides a detailed view of the company's financial position, categorized by various dimensions such as location, department, and project. It includes period amounts and budget comparisons, highlighting variances. This report helps in tracking financial health, ensuring accurate accounting, and making informed decisions for resource allocation and financial planning.
  • Balance Sheet By Period Summary: The Balance Sheet By Period Summary report provides a snapshot of the company's financial position at the end of each period. It includes detailed figures for assets, liabilities, and equity, comparing actual amounts to budgeted figures and highlighting variances. This summary helps in tracking financial health over time, ensuring accurate accounting, and making informed decisions for resource allocation and financial planning.
  • Balance Sheet DR/CR Format: The Balance Sheet DR/CR Format report presents the company's financial position using a debit and credit format. It details assets, liabilities, and equity, showing amounts for specific periods and years. This format helps in tracking financial performance, ensuring accurate accounting, and identifying discrepancies between debits and credits for better financial management.
  • Balance Sheet Standard Format: The Balance Sheet Standard Format report provides a comprehensive overview of the company's financial position as of a specific date. It includes detailed figures for fixed assets, current assets, current liabilities, and capital and reserves. It compares actual amounts to budgeted figures, highlighting variances. This format helps in assessing financial health, ensuring accurate accounting, and making informed decisions for resource allocation and financial planning.

Trial Balance

  • Trial Balance - Extended Parameters: The Trial Balance - Extended Parameters report provides a summary of all ledger accounts and their balances at a specific point in time. It lists the debit and credit balances for each account, ensuring that total debits equal total credits. This report is crucial for verifying the accuracy of bookkeeping entries and preparing financial statements. It helps identify discrepancies and ensures the financial records are balanced and accurate.
  • Trial Balance by BI Code: The Trial Balance By BI Code report provides a detailed summary of the financial balances for various departments within a company. It includes information on fixed assets, current assets, liabilities, and operating income, categorized by department and month. This report helps in verifying the accuracy of financial records, ensuring that debits and credits are balanced, and identifying discrepancies for each department.
  • Trial Balance By Dimension: The Trial Balance By Dimension report provides a detailed summary of financial balances categorized by various dimensions such as location. It includes information on assets, liabilities, and income, comparing actual amounts to budgeted amounts and showing variances for period or year to date. This report helps in verifying the accuracy of financial records, ensuring that debits and credits are balanced, and identifying discrepancies across different dimensions.
  • Trial Balance by Period Summary: The Trial Balance by Period Summary report provides a detailed overview of the company's financial transactions over time. It includes period amounts for various general ledger accounts, categorized by year, quarter, and month. This report helps ensure accurate accounting, track financial health, and make informed decisions by summarizing debits and credits for each account.
  • Trial Balance by Transaction Details - Period Date: The Trial Balance by Transaction Details - Period Date report provides a detailed ledger of financial transactions for a company over a specified period. It includes information on trade debtors, such as account numbers, transaction IDs, descriptions, debit and credit amounts, balances including opening balance and subsequent transactions. This assists with accurate financial tracking and auditing.
  • Trial Balance DR/CR Format: The Trial Balance DR/CR Format report provides a summary of the company's general ledger accounts, showing the debit and credit balances for each account. It includes details such as account numbers, account names, monthly and yearly debit and credit amounts. This report helps ensure that the total debits equal the total credits, verifying the accuracy of the company's financial records.
  • Trial Balance DR/CR Movement Report: The Trial Balance Period Movement report tracks the opening balances, debits, credits, and closing balances of general ledger accounts over a specific period. It includes details such as account numbers, account names, and transaction amounts, helping to ensure that the total debits equal the total credits. This report is essential for verifying the accuracy of financial records and identifying any discrepancies.
  • Trial Balance Standard Format: The Trial Balance Standard Format report provides a summary of the company's general ledger accounts, showing the balances for each account at a specific point in time. It includes details such as account numbers, account names, and the amounts for the current period and year-to-date. This report helps ensure that the total debits equal the total credits, verifying the accuracy of the company's financial records.
  • Trial Balance Vs Budget: The Trial Balance Vs Budget report compares the actual financial performance of the company against its budgeted figures for a specific period. It includes details such as account numbers, account names, actual amounts, budgeted amounts, and variances for both the current period and year-to-date. This report helps identify discrepancies between actual and budgeted figures, aiding in financial planning and management.
  • Trial Balance Vs Previous Year: The Trial Balance Vs Previous Year report compares the company's financial performance for the current period against the same period in the previous year. It includes details such as account numbers, account names, amounts for the current and previous periods, and year-to-date figures. This report helps identify trends and variances in financial performance, aiding in historical analysis and strategic planning.

Cashflow

  • Cashflow Statement: The Cashflow report details the adjustments made to the operating profit to calculate the net cash inflow from operating activities. It includes sections on operating profit, movements in working capital, investment activities, and changes in cash and cash equivalents. This report helps in understanding the cash flow dynamics and the impact of various financial activities on the company's cash position.
  • Monthly Cash Flow Statement: The Monthly Cashflow Statement report details the changes in the company's cash position over a specified period. It includes sections on operating profit, movements in working capital, investment activities, financing activities, and changes in cash and cash equivalents. This report helps in understanding the cash flow dynamics and the impact of various financial activities on the company's cash position.

Report Packs

  • Management Accounts Pack (Balance Sheet, Profit & Loss vs. Budget, Prior Year, and Forecast): The Management Accounts Pack provides a detailed financial overview, comparing actual performance against budget and last year's figures. It includes profit and loss statements, balance sheets, and forecasts. This report helps management assess financial health, identify variances, and make informed decisions.

Control Reports

  • Bank Control Foreign Currency Report: The Bank Control Foreign Currency Report tracks transactions in a foreign currency bank account over a specified period by transaction or period date. It includes details on opening and closing balances, sundry bank payments and receipts, customer and supplier transactions, bank transfers, and journals. This report helps in monitoring and reconciling foreign currency transactions to ensure accurate financial records.
  • Bank Control Report: The Bank Control Report monitors transactions in a specific bank account over a defined period by transaction or period date. It includes details on opening and closing balances in base or foreign currency, sundry bank payments and receipts, customer and supplier transactions, bank transfers, and journals. This report helps in tracking and reconciling bank account activities to ensure accurate financial records.
  • Creditors Control Account: The Creditors Control Account report tracks transactions related to creditors over a specified period. It includes details on opening and closing balances, fluctuations, invoices, debits, journal entries, payments, and unrealized gains/losses. This report helps in monitoring and reconciling creditor activities to ensure accurate financial records and manage liabilities effectively.
  • Debtors Control Report: The Debtors Control Report tracks transactions related to debtors over a specified period. It includes details on opening and closing balances, fluctuations, invoices, credits, journal entries, receipts, and unrealized gains/losses. This report helps in monitoring and reconciling debtor activities to ensure accurate financial records and manage receivables effectively.
  • Trial Balance vs. Aged Debtors/Creditors Reconciliation Report: The Trial Balance vs. Aged Debtors/Creditors Reconciliation Report provides a snapshot of account balances. It includes details such as trade debtors, inter-company debtors, creditors, inter-company creditors as well as the trial balance, aged reconciliation, and differences for each account. This helps in verifying the accuracy of account balances and identifying discrepancies.

Business Intelligence

  • Extended Business Analysis – Dimension Comparative Reporting: The Business Analysis Comparative report provides a detailed comparison of financial data across different divisions and locations. It includes budgeted and actual figures for various asset categories, liabilities, income, and expenses. The report helps in analyzing financial performance, identifying discrepancies, and making informed decisions for budgeting and financial planning.
  • Extended Business Analysis – Reporting By BI Code/Dimension: The Extended Business Analysis – Reporting By BI Code/Dimension report provides a detailed financial analysis of various assets, liabilities, income, and expenses for different dimensions/BI Codes within a company. It includes data on fixed assets, current assets, current liabilities, operating income, cost of sales, office costs, staff costs, administrative expenses, and financial costs. The report compares actual amounts against budgeted figures, highlighting variances and percentages to assess financial performance and identify areas for improvement.
  • GL/BI Vertical Report: The GL/BI Vertical Report provides a detailed breakdown of financial transactions for various accounts by BI Code or Dimension. It includes period amounts or year to date, budgeted amounts, and variances for accounts, and more. The report helps in analyzing financial performance, identifying discrepancies, and ensuring accurate financial records by comparing actual figures against budgeted targets.

FX Analysis

  • FX Analysis Summary Report: The FX Analysis Summary Report report tracks the financial position of assets and liabilities in base or foreign currency for a specified period. It includes details on trade debtors, cash at bank, and trade payables, showing adjustments, realized gains/losses, and revised base amounts. This report helps in monitoring foreign currency transactions, assessing financial performance, and ensuring accurate financial records.
  • Realized FX Gain/Loss Report: The Realized FX Gain/Loss Report report provides a comprehensive record of transactions over a selected timeframe, in base or foreign currency. It includes details on creditors control accounts, trade debtors, realized gains/losses, invoice information, payment details, and exchange rates. This report helps in tracking and analyzing the impact of currency fluctuations on financial transactions, ensuring accurate financial reporting and effective currency risk management.
  • Unrealized FX Gain/Loss Report: The Currency Unrealised Gain Loss Report tracks unrealized gains and losses on foreign currency transactions for debtors, creditors, and cash and bank accounts. It includes details on original foreign amounts, recorded base amounts, revised base amounts, and adjustments for various accounts. This report helps in assessing the impact of currency fluctuations on financial positions, ensuring accurate financial reporting, and managing currency risk effectively.

Tax Reports

  • Sales and Purchases Tax Detail Combined: The Sales and Purchases Tax Detail Combined report provides a comprehensive summary of VAT transactions for a specified period. It includes details on sales and purchases, VAT amounts, transaction types, and account information. This report helps businesses track VAT liabilities and ensure compliance with tax regulations.
  • Summary of EU Sales: The Summary of EU Sales report provides a summary of VAT transactions for various customers over a specified period. It includes details such as account names, VAT numbers, addresses, transaction types, tax rates, and net amounts. This report helps in tracking VAT-related transactions and ensuring compliance with tax regulations.
  • Tax Exceptions Report: The Tax Exceptions report identifies and details discrepancies in tax transactions. It includes information on transactions by transaction period or date, account numbers, internal numbers, transaction types, tax rates, and variances. This report helps in detecting and addressing tax anomalies, ensuring accurate tax reporting and compliance with tax regulations.
  • VAT End of Year Report (RTD): This report provides a summary of sales and purchases, categorized by VAT rates, for a specified period. It details the VAT amounts, sales, and purchases under different VAT categories, helping to ensure accurate VAT accounting and compliance. The report supports financial tracking and tax reporting by summarizing the total amounts for each VAT category.

Extracts

  • Trial Balance by Transaction Details - Period Date - Export Format: This Trial Balance by Transaction Details report summarizes the financial transactions for a specified period, detailing debits and credits across various accounts. It details transaction dates, descriptions, and amounts. The report ensures accurate financial tracking by maintaining a running balance of debits and credits, highlighting key financial movements and ensuring thorough record-keeping.
 
 

FAR

  • Fixed Assets- Asset Class Value Variances: The Fixed Assets- Asset Class Value Variances report provides a comparison between the General Ledger (GL) asset class values and the register asset class values. It includes details such as asset class codes, values from the GL, values from the register, differences between these values, and the percentage difference. This report is essential for verifying the accuracy of asset records, identifying discrepancies, and ensuring consistent financial reporting by highlighting differences that need to be addressed.
  • Fixed Assets- Financial Period Variance: The Fixed Asset Purchases report provides a detailed record of all fixed asset acquisitions within the organization. It includes information such as purchase dates, asset classes, descriptions, codes, names, costs, and invoice references. This report is essential for tracking and managing the organization's fixed assets, ensuring accurate financial reporting, and supporting asset management. It helps maintain a comprehensive and organized record of asset purchases, facilitating efficient financial management and decision-making.
  • Fixed Assets GL List: The Fixed Assets GL List Report provides a detailed record of transactions related to fixed assets. It includes information such as transaction dates, references, supplier codes, supplier names, GL account numbers, GL account names, descriptions, and amounts. This report is essential for tracking the financial activities associated with fixed assets, ensuring accurate accounting and compliance with financial reporting standards.
  • Fixed Assets Register Listing: The Fixed Asset Depreciation report provides a detailed overview of the organization's fixed assets, including their purchase dates, costs, accumulated depreciation, current values, and depreciation rates. It includes information on asset classes, names, statuses, and depreciation schedules. This report is essential for tracking the depreciation of fixed assets and supporting asset management. It helps maintain a comprehensive and organized record of asset values, facilitating efficient financial management and decision-making.
 
 

Consolidated Reports

AR/AP: Customer/Supplier Enquiries

  • Aged Debtors/Creditors: The Aged Consolidated report provides a detailed overview of outstanding debts owed, categorized by the age of the debt. It includes transaction details such as account numbers, entity names, transaction, period, or due dates, types, and balances, segmented into aging periods (0-30 days, 31-60 days etc.). This helps in assessing the financial health and credit management of the company by identifying overdue accounts and managing cash flow.
  • Sales Analysis: This report provides a detailed analysis of sales activities for the Group, including actual and budgeted sales figures, sales activity before discounts, and sales by item group and location. It covers various periods and includes comparisons between actual and budgeted amounts. This helps in tracking sales performance, identifying trends, and making informed decisions to optimize sales strategies.

Bank: Bank Reconciliation

  • Consolidated Bank Reconciliation: This report provides a summary of general ledger balances for various bank accounts as of a specific date. It includes details such as account names, currencies, reconciled status, opening and closing balances, movements, GL balances, receipts, and payments. The report helps in tracking the financial status and movements within different bank accounts, ensuring accurate financial reporting and reconciliation.

GL: Set up

  • Analysis Structure Mapping: The Analysis Structure Mapping report categorizes and maps dimensions such as divisions, locations, and projects to BI Codes where relevant. It includes names, codes, and descriptions. This report helps in understanding the hierarchy and organization of various departments and projects within the organization, facilitating better management and analysis of organizational data.
  • Chart of Accounts Layout: The Chart of Accounts Layout report provides a detailed listing of all general ledger accounts used by the organization, categorized by account types such as fixed assets, current assets, liabilities, capital and reserves, operating income, and expenses. It includes account numbers, names, and descriptions, helping in organizing and tracking financial transactions systematically. This report is essential for financial reporting, budgeting, and ensuring accurate accounting practices.

GL: Transaction Enquiries

  • General Journals List: The General Journals List report provides a detailed record of all general journal entries made within the organization over a specified period. It includes transaction IDs, internal numbers, types, dates, account numbers, descriptions, departments, and debit and credit amounts. This report is essential for tracking and auditing financial transactions, ensuring accurate and comprehensive accounting records.
  • General Ledger Audit Trail: The General Ledger Audit Trail report provides a detailed record of all transactions posted to the general ledger over a specified period. It includes transaction IDs, types, external and internal references, user IDs, creation and posting dates, periods, account codes, descriptions, and debit and credit amounts. This report is essential for auditing and verifying the accuracy and integrity of financial records, ensuring compliance with accounting standards and facilitating detailed financial analysis.
  • General Ledger Daybook by transaction or period date: The General Ledger Daybook by Transaction or Period Date report provides a detailed record of all transactions posted to the general ledger within a specified date range. It includes transaction or period dates, types, references, account names, descriptions, and amounts in base or foreign currency. This report helps in tracking daily financial activities and ensuring accurate accounting records.

GL: Profit and Loss

  • Profit and Loss: The Profit and Loss report provides a summary of the company's revenues, costs, and expenses during a specific period. It includes categories such as operating income, cost of sales, gross profit, and various expenses, with budget, revised budget, and last year comparisons. This report helps in assessing the company's financial performance, identifying profitability, and making informed business decisions.
  • Profit and Loss By Entity - Extended parameters: The Profit & Loss report provides a detailed summary of the company's revenues, costs, and expenses for a specific period, including operating income, cost of sales, gross profit, and various expenses. It includes options for font type, logo, and decimal format, in addition to four comparative columns, and dimension and element analysis.This report helps assess financial performance and profitability, enabling informed business decisions and financial planning.
  • Profit and Loss by Period Summary: The Profit and Loss by Period Summary report provides a detailed summary of the company's revenues, costs, and expenses for each period within a specified timeframe. It includes categories such as operating income, cost of sales, gross profit, and various expenses. This report helps assess financial performance and profitability over different periods and year to date, enabling trend analysis and informed business decisions. 
  • Profit and Loss Vs Budget Detailed: The Profit and Loss Vs Budget Detailed report compares the company's actual revenues, costs, and expenses against the budgeted amounts for a specific period. It includes detailed account level breakdowns of operating income, cost of sales, gross profit, and various expenses. This report helps in identifying variances between actual and budgeted figures, enabling better financial management and decision-making.
  • Profit and Loss Vs Budget Summary: The Profit and Loss Vs Budget Summary report compares the company's actual revenues, costs, and expenses against the budgeted amounts for a specific period. It includes category summaries of operating income, cost of sales, gross profit, and various expenses. This report helps in identifying variances between actual and budgeted figures, enabling better financial management and decision-making.
  • Profit and Loss Vs Previous Year Summary: The Profit & Loss report compares financial performance between the current and previous year. It can include categories such as operating income, cost of sales, administrative expenses, financial costs, and staff costs. This report helps in analyzing trends, identifying areas of improvement, and making informed financial decisions by highlighting year-over-year changes in income and expenses.

GL: Balance Sheet

  • Balance Sheet - Extended parameters: The Balance Sheet - Extended parameters report provides a snapshot of the company's financial position at a specific point in time. It includes details of assets, liabilities, and equity, categorized into sections such as fixed assets, current assets, current liabilities, and capital and reserves. The report compares actual amounts to budgeted figures, highlighting variances. This report helps in understanding the company's financial health, liquidity, and overall stability, enabling informed financial planning and decision-making.
  • Balance Sheet Standard Format: The Balance Sheet Standard Format report provides a snapshot of the company's financial position at a specific point in time. It includes details of assets, liabilities, and equity, categorized into sections such as fixed assets, current assets, current liabilities, and capital and reserves. It compares actual amounts to budgeted figures, highlighting variances. This report helps in understanding the company's financial health, liquidity, and overall stability, enabling informed financial planning and decision-making.
  • Consolidated Balance Sheet - Split By Subsidiary: This Consolidated Balance Sheet - Split By Subsidiary report provides a detailed comparative analysis of the profit and loss statements for a Group, comparing figures by entity. It includes YTD, budget, and variance figures with optional BI analysis options. This helps in evaluating financial performance over time, identifying trends, and making informed decisions for future financial planning.

GL: Trial Balance

  • Consolidated Trial Balance By BI Code: The GL Trial Balance Consolidated by Department report provides a summary of the general ledger accounts, showing the actual and budgeted amounts for each department within a company. It helps in tracking financial performance, ensuring budget compliance, and identifying discrepancies across different departments. This report is essential for financial analysis and decision-making.
  • Consolidated Trial Balance - Split By Subsidiary: The Consolidated Trial Balance report provides a comprehensive overview of a company's financial position by listing all account balances from multiple subsidiaries. It includes assets, liabilities, equity, revenues, and expenses, ensuring that debits and credits are balanced. This report is crucial for preparing financial statements, identifying discrepancies, and ensuring accurate financial reporting across the organization.
  • Trial Balance - Extended parameters: The Trial Balance - Extended parameters report provides a detailed overview of the organization's financial status. It includes debit and credit transactions, month-to-date and year-to-date balances, and depreciation values for various assets across multiple departments. This report is crucial for ensuring accurate financial tracking, supporting audits, and facilitating informed decision-making by providing a comprehensive snapshot of the organization's financial activities and balances.
  • Trial Balance by Period Summary: The Trial Balance by Period Summary report provides a comprehensive overview of a company's financial transactions over a specified period. It lists all general ledger accounts, including assets, liabilities, equity, revenues, and expenses, along with their balances for each period or YTD. This report helps ensure that total debits equal total credits, aiding in the detection of discrepancies and the preparation of financial statements.
  • Trial Balance Vs Budget: The Trial Balance vs Budget report compares actual financial performance against budgeted amounts for a specific period. It lists general ledger accounts with their actual amounts, budgeted amounts, and variances for the period and year-to-date. This report helps identify discrepancies between actual and planned financial outcomes, aiding in budget management and financial planning.
  • Trial Balance Vs Previous Year: The Trial Balance vs Previous Year report compares the current period's financial data with the same period from the previous year. It lists general ledger accounts with their amounts for the current period, previous year, and year-to-date figures. This report helps identify trends, variances, and changes in financial performance over time, aiding in historical analysis and decision-making.

GL: Cashflow

  • Consolidated Cashflow: The Consolidated Cashflow report details the reconciliation process between operating profit and net cash inflow from operating activities. It includes accumulated movements for various financial categories such as advisory fees, commissions, cost of sales, occupancy, personnel, and more. This report helps in understanding how operating profit translates into cash flow, highlighting adjustments for non-cash items and changes in working capital.

GL: Report Packs

  • Consolidated Management Report Pack (KPIs, Balance Sheet, P&L reporting, and summary graphics): The Consolidated Management Report Pack provides a comprehensive overview of financial performance, including revenue, gross profit, expenses, and profit after taxation across different departments and periods. It includes detailed breakdowns of various financial metrics, comparisons with budgets and previous periods, and insights into cost management and profitability. This report is essential for strategic decision-making, financial planning, and performance evaluation.
  • Management Accounts Pack (Balance Sheet, Profit and Loss versus Budget, Profit and Loss versus Last Year, and Profit and Loss Forecast): The Management Accounts Pack provides a detailed financial overview, comparing current year figures against budget and last year’s performance. It includes details of profit and loss, revenue, expenses, EBITDA, and profit before and after taxation. The report helps management assess financial health, identify variances, and make informed decisions.

GL: Business Intelligence

  • Dimensional Analysis: The Dimensional Analysis report lists all the general ledger accounts and their balances, categorized by dimension. It includes actual and budgeted amounts broken down by account and dimension. This report helps compare the performance of dimensions against across the GL as a whole and ensure budgets are on track.
  • Extended Business Analysis - Dimension Comparative Reporting: This report provides a comparative analysis of financial data across periods. It includes details on assets, liabilities, income, and expenses, segmented by various dimensions, such as locations and departments. The report helps in tracking budget versus actual figures, identifying variances, and analyzing financial performance across different departments.
  • Extended Business Analysis - Reporting By BI Code/Dimension: This report provides a detailed financial analysis of a group's assets, liabilities, income, and expenses across various BI Codes or dimensions. It includes year-to-date, budget, and variance figures at GL account level. The report helps in understanding the financial performance and budgeting variances for different categories and departments.

Intercompany

  • Intercompany Balance: This report provides a summary of intercompany balances for the Group, detailing transactions between subsidiaries. It includes creditor company codes, company codes, and converted amounts, highlighting intercompany sales and balances. This helps in tracking and reconciling intercompany transactions, ensuring accurate financial consolidation and reporting.
  • Intercompany Matrix: This report provides a summary of intercompany balances and transactions across different subsidiaries. It includes details on creditor company codes, company codes, and currency values, highlighting discrepancies and unlinked transactions. This helps in identifying and reconciling intercompany balances, ensuring accurate financial consolidation and reporting.
  • Intercompany Profits: This report details intercompany transactions and profits for the Group, such as recurrent product purchases, employee expenses, intercompany clearing, and software licenses across different subsidiaries. It provides transaction details such as company codes, account names, transaction dates, and amounts. This helps in tracking intercompany profits, ensuring accurate financial consolidation, and identifying areas for financial optimization.