Reports for Financial Institutions
Poročila za finančne inštitucije
Reports for financial institutions are used for checking:
1. outstanding and overdue reports for receivables and liabilities at a certain date in the past;
2. debit and credit transactions;
3. debit and credit balances from that date onwards.
 |
HINT
- The first thing you need to do is to open a new document in Financials | Special reports | Reports for financial institutions. The required settings must be carried out in Document Types for Receivables/Payables.
- You can add as many document types as you need.
|
The two examples of reports covered in this chapter are:
Report can be accessed via the menu Financials | Special reports | Report for financial institutions.
Here is a description of the form and its individual elements.
|
HINT
The form is the same for both reports, 10 Largest debtors and Our largest buyers and suppliers.
|
 |
warning
The report is intended for checking account balances, which is related to the setting in the chart of accounts and consequently to the posting of these accounts.
|
Toolbar enables various features on the form.
2.
In the header of the form, enter the data necessary for creating a report.
|
Number
|
The unique number of the document: a two-digit code for the year, a three-digit code for the type of document (same as in the Document Types register), and a six-digit consecutive number.
|
HINT
This number is generated by the program automatically and cannot be changed.
|
|
|
As of
|
Specify the date starting point for the report. The program will display open and past due items for the set number of time units backwards, as you have set for this document type. If you have set the Number to 0 for the document type, then the program will display the open and past due items as of the same date as the date in the Day field.
The dates for the turnover data are also written in the column header for information.
|
HINT
For example, if you set the No. to -12 time units (months) and the report date is for example 30.12.2020, the program will display all transactions between 30.12.2019 and 30.12.2020.
|
|
|
Customer accounts
|
Enter an account or a set of accounts for suppliers separated by a semicolon.
|
|
Supplier accounts
|
Enter an account or a set of accounts for customers separated by a semicolon.
|
|
Show for Customers
|
Enter the number to display the records in the overview for the Receivables tab.
|
hint
Value -1 means that records for all customers are displayed.
|
|
|
Show for Suppliers
|
Enter the number for display the records in the overview for the Payables tab.
|
HINT
Value -1 means that records for all suppliers are displayed.
|
|
|
Sum for others - customers
|
If the value -1 is not entered in the field Show for customers, a separate item with the sum of other customers (Sum for others) can be displayed by checking this checkbox.
|
|
Sum for others - Suppliers
|
If the value -1 is not entered in the field Show for suppliers, a separate item with the sum of other suppliers (Sum for others) can be displayed by checking this checkbox.
|
|
Sort
|
Select the sorting option from the drop-down menu. Data can be sorted descending or ascending. Sorting is linked to a column selected in Sort by in Document Types.
|
|
Confirmed
|
The report can also be confirmed by checking this checkbox.
|
|
Collect Data
|
Collects the data according to the entered criteria.
|
WARNING
Each time you change the entered criteria, you need to click on the Collect Data button again.
|
|
In this section, you can indicate document types whose turnover data you want to include in the report.
|
hint
For turnover data to be collected properly, do not mark the opening and closing journal entry (400 and 490).
|
Right-clicking in the window will open a menu that allows you to:
- Select All – Select all document types.
- Deselect All – Deselect all document types.
- Invert Selection – Select inversely (that is all the document types that are not currently selected).
- Choose group – Select a group of document types.
When creating a report, the data in the report is sorted by columns according to the settings you have previously made on the document type. You can set up several document types for different purposes.
The column that is grayed out is marked in the Document Types register as the default column for sorting the data. If you later sort the data by a different column, the data will be re-sorted, but the gray scale will remain the same as in the default settings.
When collecting documents, the turnover data shall take into account the date set in the Document Types register. This can be one of the following dates: Document Date, Due Date or Period Date (from the Journal Entry header).
Program will display open and overdue receivables items in columns according to the criteria specified in the form header and according to the selected document types.
The dates for the turnover of receivables data are also included in the column header for information.
Program will display open and overdue payables items in columns according to the criteria specified in the form header and according to the selected document types.
The dates for the turnover of payables data are also included in the column header for information.
The Receivables and payables tab contains the combined data from both tabs, Receivables and Payables.
