Reports for financial institutions

Poročila za finančne inštitucije

We use these reports for:

1. Outstanding and overdue reports for receivables and liabilities at certanin date in the past.

2. Review for debit and credit transactions and

3. Debit and credit balances from that date onwards

First thing to do is to open new document in Financials/Special reports/Reports for financial  institutions.  Necessary setting must be done in document types for Receivables/Payables.

Report is created by pressing on button  .

Date must be entered  and desired document types must be checked. For correct report initial and end journal entry must be unchecked (400 and 490).

The data is collected by clicking on button . Any change requires new data collect.

When creating a report, we have the data in the report sorted by columns according to the settings we made earlier on the document type. We set up several types of documents for different purposes.

A column that is grayed out is marked in the document type settings  as the default column for sorting data. If we later sort the data in the second column, the data will be sorted anew, and the gray will remain the same as in the default settings.

Data gathering takes into account dete preset in document type (Document date, Date due, Target date from entry header)

By setting the date we derermine the starting point for report. Program will show debit and credit transactions for the preset number of units back as we set in document types. If we set No. to -12 amd interval to month and date of report is  e.g. 30 12 2008. , program will show all transaction between dates 30 12 2007 and 30 12 2008. However, open and outstanding modes takes into account interval and number only as last point of report.  If we set No. to -1 amd interval to month and date of report is  e.g. 30 12 2008, program will show open document till date 30 11 2008.

dates for all data are also displayed in the header of column

Customer accounts	Enter an account or a set of accounts fpr 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 ro display the records in the overview for receivable tab. Value -1 means review for all customers
Show for suppliers	Enter the number ro display the records in the overview for payables tab. Value -1 means review for all suppliers
Sum for athers - customers	if Show for customer ins not set to -1, sum for other can be displayed in one row
Sum for athers - suppliers	if Show for supplier ins not set to -1, sum for other can be displayed in one row
Sort	Iz spustnega menija izberemo možnost razvrščanja. Podatke lahko razvrstimo po saldu padajoče ali po saldu naraščajoče. Razvrščanje je vezano na stolpec, ki ga izberemo v "razvrsti po" v šifrantu vrst dokumentov.
	Poročilo je možno s klikom na ikono izvoziti v datoteko Excel.

Za ogled primerov sledite povezavama:

10 največjih dolžnikov in

Naši največji kupci in dobavitelji.