The Reports ribbon is used to access and print all reports, user reports and reports from the Ledger analyser 1 / 2 and T-Account viewer. It is also used to access the Printer setup and Report designer.

e following seven (7) options are available:

  1. Reports - List the reports in the following groups: 
    1. Ledger - You may print the Budget vs actual (3 periods) report, Net Profit and Loss per week graph in a bar chart, List the General ledger accounts (Chart of accounts) and Transaction reports.
    2. Debtors - You may print Debtors per week graph in a bar chart, various age analysis reports, various listing reports, address labels, transaction reports and debtor statements.
    3. Creditors - You may print Creditors per week graph in a bar chart, various age analysis reports, various listing reports, address labels, transaction reports and creditor remittance advises.
    4. Stock - Reorder reports, listing reports, stock movements, backorder reports. You may also print labels (barcodes). 
    5. Contacts - Lists the details of all your contacts. 
    6. Calendar - Print the appointments (events) (i.e. Appointment, Debtor appointment, Creditor appointment and Hours) that was scheduled in the Calendar / Planner. 
    7. Batch entry - Print the transactions of posted invoices, credit notes purchase and supplier return documents as well as posted batch transactions (i.e. sales journal, purchase journal, payments journals, receipts journals, general journals, etc.).
    8. Documents - Lists your documents, such as invoices, credit notes, purchases, supplier returns documents, orders and quotes or a selection of documents or for a selected period. 
    9. Tax - If you are registered as a Tax (VAT/GST/Sales tax) vendor, you need to print and view reports for a specific period for all your Tax (VAT/GST/Sales tax) or for a specific tax code such as Input Tax (VAT/GST/Sales tax), Output Tax (VAT/GST/Sales tax), Zero-rated Tax (VAT/GST/Sales tax), etc.
    10. Sales - Various reports are available to analyse your sales documents. Print Graphs, Debtors, Sales and Items reports for Invoices, Credit notes and Quotes. 
    11. Sales analysis - You may print reports for five (5) reporting groups (i.e. Debtor group 1, Debtor group 2, Document group 1, Document group 2 and Salespersons) for each sales documents (i.e. quotes, invoices and credit notes). You may also print sales per product for stock group 1 or stock group 2 reports for sales documents.
    12. Purchases - Various reports are available to analyse your purchase documents. Print Graphs, Creditors, Purchases and Items reports for Purchase and Supplier return documents as well as Orders. 
    13. Purchase analysis - You may print reports for five (5) reporting groups (i.e. Creditor group 1, Creditor group 2, Document group 1, Document group 2 and Salespersons) for each purchase documents (i.e. orders, purchases and supplier returns). You may also print purchases per product for stock group 1 or stock group 2 reports for purchase documents.
    14. Company info - You may print the details of the bank accounts or the company information, messages and cost of sales settings.
    15. Currencies - If you process Multi-currency documents (i.e. Invoices, Credit notes and Quotes for debtors (customers / clients) or Purchases, Supplier returns and Orders for creditors (suppliers / vendors).  you may print a list of the "Currencies" (added / edited in the Setup → Currencies menu on the Setup ribbon.
    16. Plugins - Price agreement report for the Price agreement plugin.
    17. Point-of-sale - Sales and Receipt reports for the plugin point-of-sale systems (if you purchased and use the HorecaPOS or RetailPOS point-of-sale systems).
  2. User reports - Any other reports that are under construction. Users may add their own reports in the ...\plug_ins\reports\userreports folder.
  3. Spreadsheet reports - 
  4. Ledger analyser 1 - Trial balance, Income statement, Balance sheet, Standard column balances (column view of the Trial balance, Income statement and Balance sheet in one report), Budget vs actual, This year vs last year as well as Column balances.

Export button for all Report types on Ledger analyser 1 / Ledger analyser 2 - 

You may save the export file as Text files (*.txt) (default file type); or as CSV files (*.csv) (Comma Separated Values) file type. This will automatically open (launch) the exported file in the program associated with the selected file type:

    • Text files e.g. (Export.txt) - This should automatically open the exported text file of your system's default text file program associated with Text file type (*.txt) file types (e.g. Notepad, etc). You need to close the exported text file and launch your spreadsheet program. In your spreadsheet program, Open the text file to launch the "Text Import" options.
    • CSV files e.g. (Export.csv) - This should automatically open the "Text Import" options of your system's default spreadsheet program associated with Comma Separated Value file type (*.csv) file types (e.g. Microsoft Excel, LibreOffice Calc, OpenOffice Calc, Ultra Office, etc.). 
  1. Ledger analyser 2 - The same reports are available as for the Ledger analyser 1, but it gives you another option to generate. print or export different views and reports. 
  2. Age analysis - View and choose options for the new Age analysis report on screen and print it on the Reports ribbon and on the Open item - Due tab (Default ribbon).
  3. T-Account viewer - Analyse and print transactions for specific accounts, etc.

Column balances - Report types on Ledger analyser 1 / Ledger analyser 2 - The column balances report types will list the transactions of a selected account for each period of Last year and This year in a spreadsheet format. 

You may select an account and double-click on any period. This will launch the T-Account viewer with a list of all the transactions for the selected period. You may be print and / or export the transactions. 

The following six (6) column balances report types is available:

  1. Column balances - Lists all ledger account balances in a spreadsheet view. These are the ledger accounts reported in the Trial balance (this includes both the accounts reported in the Income statement and Balance sheet).
  2. Column balances debtors - Lists the balances of all the individual debtor (customer / client) accounts (Debtors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Debtor's control account on the Trial balance and the Balance sheet.
  3. Column balances creditors - Lists the balances of all the individual creditor (supplier / vendor) accounts (Creditors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Creditor's control account on the Trial balance and the Balance sheet.
  4. Column balances D/C - Lists all debit and credit ledger account balances in a spreadsheet view. These are the accounts reported in the Trial balance (this includes both the accounts reported in the Income statement and Balance sheet).
  5. Column balances debtors D/C - Lists the debit and credit account balances of all the individual debtor (customer / client) accounts (Debtors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Debtor's control account on the Trial balance and the Balance sheet.
  6. Column balances creditors D/C - Lists all debit and credit balances of all the individual creditor (supplier / vendor) accounts (Creditors on the Default ribbon) in a spreadsheet view. The total of these accounts are reported in the Creditor's control account on the Trial balance and the Balance sheet.
  1. Printer - Setup and configure the printers on your system.
  2. Report designer - Edit, create layout files for documents and reports.  Users may add their own reports in the ...\plug_ins\reports\userreports folder.