Reports menu

Previous Next

On the Reports ribbon, the Reports menu lists all the standard reports, which are required to manage the information in a Set of Books. In addition to these standard reports, you may also create your own user or custom reports in the Report designer.  

These reports that are stored in the " ...\plug_ins\reports\systemreports" folder.

If you are creating transactions from your inventory file (processing documents - invoices, credit notes, purchases and supplier returns documents), you will need to view reports in the inventory ledger, document listing, sales analysis, purchase analysis reports.

To access the Reports menu:

Click on the Reports ribbon. A list of the eighteen (18) reports or groups of reports will be listed.

The summary of these reports, is as follows:

1.T-Ledger analyzer - The T-Ledger analyzer allows you to generate, print or export six (6) different report types of your data which may be printed and exported in various formats. These are:

a)Trial balance

b)Income statement

c)Balance sheet

d)Standard column balances (column view of the Trial balance, Income statement and Balance sheet in one report)

e)Budget vs actual

f)This year vs last year  

In addition to this, you may also view and export the data in column balances (balances per period) for the general ledger, customers and vendors.

Transactions may also be printed from the T-Account viewer.

2.Point-of-Sale - The Cash-up and Sales analysis report for the built-in point-of-sale (if you use point-of-sale).

3.Ledger - The following reports are available to manage all the accounts in the general ledger:

a)Graph - Profit / Loss per week - Net Profit and Loss per week in a bar chart.

b)Listing - List the General ledger accounts (Chart of Accounts).

c)Transactions - Transactions, Transactions - Standard and Transactions - Extra details.

4.Customers - The following reports are available to manage the accounts in the customer's ledger:

a)Graph - Customers per week - Invoices and Debit Transactions, Credit notes and Credit Transactions as well as the difference per week in a bar chart.

b)Age analysis - Various age analysis reports.

c)Listing - Contacts, Listing, List delivery address, List postal address, List details, Tax and Company registration numbers and the Credit control listing (Credit limit vs Current balance and Available balances as at the date and time of printing) report.

d)Print labels - Postal and Delivery address labels.

e)Transactions - Transactions - Open item, Transactions - Standard and Transactions - Extra details.

f)Outstanding - Customer statements, Customer statements - Outstanding, Due date and Outstanding at date.

5.Vendors - The following reports are available to manage the accounts in the vendor's ledger:

a)Graph - Vendors per week - Supplier returns and Debit Transactions, Purchases and Credit Transactions as well as the difference per week in a bar chart.

b)Age analysis - Various age analysis reports.

c)Listing - Contacts, Listing, List delivery address, List postal address, List details, Tax and Company registration numbers and the Credit control listing (Credit limit vs Current balance and Available balances as at the date and time of printing) report.

d)Print labels - Postal and Delivery address labels.

e)Transactions - Transactions - Open item, Transactions - Standard and Transactions - Extra details.

f)Outstanding - Remittance advice, Remittance advice - Outstanding, Due date and Outstanding at date.

6.Sales - Various reports are available to analyze your sales documents. Print Graphs, Customers, Sales and Items reports for Invoices, Credit notes and Estimates.

7.Plugins - Price agreement report for the Price agreement plugin.

8.Inventory - The following reports are available to manage the inventory items:

a)Reorder - Inventory Reorder Report to list only those inventory items that needs to be reordered. The Current Inventory Levels lists all the current inventory levels.

b)Print Barcodes – Print the Barcode or the Yagoda barcodes.

c)Listing - Print lists of All selling prices report (Selling price 1 / 2 /3) and the Inventory item listing report listing the Quantities Cost prices. You may select to print extra details for these reports. You may also print a list of tax classes.

d)Backorder - Print a list of Backorders.

e)Inventory In / Out - The following two (2) reports:

i)Inventory In / Out - Documents - Displays a summary of sales and purchase documents for each inventory item. The details option will  list and display the document dates and document numbers for each inventory item.

ii)Inventory In / Out - Displays a list of the inventory items and the quantities in and out as well as the total prices. The details option will list and display the document dates and document numbers for each inventory item.

9.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).

10.Contacts - Lists the details of all your contacts. To list only the contacts for customer accounts, you need to print it in Customers → Listing - Contacts. To list only the contacts for vendor accounts, you need to print it in Vendors → Listing - Contacts.

11.Calendar - Print the appointments (events) (i.e. Appointment, Customer Appointment, Vendor Appointment and Hours) that was scheduled in the Calendar / Planner.

12.Journal entry - Print the transactions of posted invoices, credit notes purchase and supplier return documents as well as posted journal transactions (i.e. sales journal, purchase journal, payments journals, receipts journals, general journals, etc.).

13.Purchases - Various reports are available to analyze your purchase documents. Print Graphs, Vendors, Purchases and Items reports for Purchase and Supplier return documents as well as Orders.

14.Company info -

oBank accounts List the details of the company bank accounts details "List Bank accounts" for up to two (2) bank accounts as entered / edited in the Company info (Setup ribbon).

oCompany info – Information – Lists the details of the following:

Information - Document heading and messages (up to 3 lines) as entered in the Documents setup (Setup ribbon) for each of the Sales documents (i.e. Invoices, Credit notes and Estimates tabs) as well as Purchase documents (i.e. Purchases, Supplier returns and Orders tabs). This information is standard and will be printed on all documents.

Global statement message (up to 3 lines) as entered on the Statement setup tab on Documents setup (Setup ribbon). This information will print standard on all Statements (Reports → Customers – Outstanding (Reports ribbon)). This is in addition to the specific messages (up to 4 lines) that can be entered in the Delivery address tab individual customer accounts (Customers (Action ribbon)).

Selling price descriptions – The descriptions of Selling price 1, Selling price 2 and Selling price 3 as entered in the Selling price descriptions fields (Inventory information - Setup ribbon).

Cost of Sales

Create Cost of Sales        - Yes - Cost of Sales is activated.

     - No - Cost of Sales is not activated.

Average cost - Yes – Average Cost of Sales is activated.

- No – Latest Cost of Sales is activated.

15.Currencies - The Currencies report will list the currencies (added / edited in the Setup Currencies menu on the Setup ribbon).

You may process Multi-currency documents (i.e. invoices, credit notes and estimates for customers or purchases, supplier returns and orders for vendors.

You may (once currency or currencies are added) select a currency when processing documents. The currency will be printed in the document layout files.

16.Documents - Lists your documents, such as invoices, credit notes, purchases, supplier returns documents, orders and estimates or a selection of documents or for a selected period.

17.Sales analysis - You may print reports for five (5) reporting groups (i.e. Customer group 1, Customer group 2, Document group 1, Document group 2 and Salespersons) for each of your sales document types (i.e. Invoices, Credit notes and Estimates). You may also print a Sales analysis report for each of these five (5) reporting groups which includes both posted Invoices and Credit notes.

a)Sales documents for each document type (i.e. Invoices, Credit notes and Estimates) - You may print reports for five (5) reporting groups (i.e. Customer group 1, Customer group 2, Document group 1, Document group 2 and Salespersons).

b)Invoices and Credit notes  - You may print reports for five (5) reporting groups (i.e. Vendor group 1, Vendor group 2, Document group 1, Document group 2 and Salespersons).  

c)Sales per product - Inventory group 1 andInventory  group  2 are also available to analyze the sales (invoices) and returns (credit notes of trading inventory items (default inventory item type).

18.Tax - If you are registered as a 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 VAT/GST/Sales Tax, Output VAT/GST/Sales Tax, Zero-rated VAT/GST/Sales Tax, etc.

19.Purchase analysis -

a)Purchase documents for each document type (i.e. Purchases, Supplier returns and Orders) - You may print reports for five (5) reporting groups (i.e. Vendor group 1, Vendor group 2, Document group 1, Document group 2 and Salespersons).

b)Purchase and Supplier return documents - You may print reports for five (5) reporting groups (i.e. Vendor group 1, Vendor group 2, Document group 1, Document group 2 and Salespersons).  

c)Purchases per Product - Inventory group 1 andInventory group  2 are also available to analyze the purchases and returns for trading inventory items (default inventory item type).

Created with the Personal Edition of HelpNDoc: Qt Help documentation made easy