Loading documents preview...
T24 Reporting Introduction
Temenos University - May 2012
1
T24 Reporting Introduction
Temenos University - May 2012
2
T24 Reporting Introduction
Temenos University - May 2012
3
T24 Reporting Introduction
Temenos University - May 2012
4
T24 Reporting Introduction
Temenos University - May 2012
5
T24 Reporting Introduction
In Financial Accounting course, you have learnt how various types of accounting entries are generated and how they are consolidated into CAL and CPL records. You will, in this course, learn about the different tools and techniques used for generating reports using the data available in CAL and CPL records.
Temenos University - May 2012
6
T24 Reporting Introduction
In T24, a report is built like a traditional house. To build a house, first we build a strong foundation, upon which we build the Columns, then the Roof and finally the Walls. Of course, we build the house depending upon the requirements and specifications. Extending this analogy, for a T24 financial report, the foundation or the primary source of information is the CRF (Central Reporting File), which as you know comprises the two consolidation tables CAL and CPL (CONSOLIDATE.ASST.LIAB and CONSOLIDATE.PRFT.LOSS). A T24 financial report is like any other report, a two dimensional array of columns and rows. In T24, we refer to the rows as lines. Similar to building a house, to design a T24 financial report, you have to first design its Columns and Lines. The Columns are the type of information to be reported across a report column. In T24, once you design a column, you can use it across any report. It could represent an opening balance, a closing balance, total credit transactions, total, etc. Finally, the Lines decide which information is reported in a row. For example, in the first row, you may decide to report deposits and in the second row the loans.
Temenos University - May 2012
7
T24 Reporting Introduction
Temenos University - May 2012
8
T24 Reporting Introduction
You will now see some of the financial reports generated in T24 to learn their important design components. Various types of reports can be produced from T24 Central Reporting File (CRF) balances. The screenshot shows the specimen of a report produced. This report shows the Closing Balances under different groupings like Cash, Due from Banks, etc. Above the Line 0030 CASH, you can see individual CAL keys listed with balances. Such a report which reports CAL keys and information from them, are known as CRF reports. If you further analyse the report, you can see that it has three Columns and multiple Lines. The first column holds sequence Nos. and the second column is the description of Lines. You can see that they do not hold any financial information, and thus we will refer to them as “Descriptive Columns”. While the third one, which reports financial amounts will be referred to as a “Financial Column”. If you look at the first and second Lines, there is no amount under the financial column, and we will refer to such Lines as “Heading” Lines. You can see that in the Line 0030 Cash Balance, there is an amount, and we will refer to it as a “Detail” Line. Finally, you can see that in the TOTAL CASH Line, though there is a financial amount, no keys are listed above that. Why? Because, it is not reported from CAL keys, but a calculated total is printed here. We will refer to such Lines as “Total” Lines. To recap, CRF reports contain amounts only from CRF i.e. CAL and CPL tables. A report comprises of some descriptive and some financial columns. Similarly some Lines are just Headings, some report financial amounts and some just report totals.
Temenos University - May 2012
9
T24 Reporting Introduction
If you compare this report, with the previous one, you can see that this report gives the details of individual cash account balances under the row Cash Balance. For instance, details like Customer, Account Number, Interest rate, Interest Day basis, Value date etc. which are fetched from T24 Balance files/Applications like Accounts and Contracts. Such a report, which gives the balances of individual accounts and contracts under a consolidation key, is referred to as a CRB report. CRB reports are also based on the CRF base i.e. CAL and CPL tables, and in addition they report the balances of underlying contracts and accounts.
Temenos University - May 2012
10
The screenshot shows a CRD (Difference) report containing the balances of underlying contracts and accounts. The report lists the difference, if any, between consolidation records’ balances and balances of underlying contracts and accounts. CRF GLSHORT is a This report shows the Asset and Liabilities position balancing against the P&L and net position equals to zero
T3TRE - Financial Reporting - R10.1
11
T24 Reporting Introduction
Combined CRF reports can be produced for a group of Companies. The reports are known as CRC reports, and the Report Id will be pre-fixed with CRC. This functionality is available for both Multi-Company and Multi-Book environments. Combined reports can be produced online by verifying the RE.CONSOL.REQUEST application record or by attaching such records in the Batch: EB.CONSOL.PRINT.
Temenos University - May 2012
12
T24 Reporting Introduction
Temenos University - May 2012
13
T24 Reporting Introduction
Temenos University - May 2012
14
T24 Reporting Introduction
A sample Report on Credit Lines to be reviewed based on the information from Limit Application .
Temenos University - May 2012
15
T24 Reporting Introduction
Here is an example of how to review the reports based on the Enquiry called ENQ REPORT.LIST
Temenos University - May 2012
16
T24 Reporting Introduction
Temenos University - May 2012
17
T24 Reporting Introduction
Temenos University - May 2012
18
T24 Reporting Introduction
Temenos University - May 2012
19
T24 Reporting Introduction
Temenos University - May 2012
20
T24 Reporting Introduction
Temenos University - May 2012
21