Questions about trial balance and journal

I wish to understand how journal entries can be extracted from Globus database and from which tables and fields.

A first overview shows that Globus uses three files: STMT.ENTRY, CATEG.ENTRY and RE.CONSOL.SPEC.ENTRY.
What is the definition of each field in the three tables??

I wish to understand how accountant journal and trial balance can be generated from those tables??

All accounting entries based on those three files in Gloubs. I can give you some of the Tips. Please follow temeno user guide for More Details

GLOBUS accounting method

There is no actual General Ledger account for accounting entries ? only `virtual? accounts , Hence information is held at a KEY (grouping condition) level ie Classifies accounting entries as STMT.ENTRY, CATEG.ENTRY and RE.CONSOL.SPEC.ENTRY


GLOBUS does not require General Ledger accounts, so how does it maintain a General Ledger system?
In order to understand this let us consider the problems in systems that use General Ledger accounts. An account must be opened in each currency you deal in, for transactions such as loans you may have many different types such as corporate loans, inter-bank loans, Education loans, to name just a few. If you need these broken down by residence, nationality and industry that would mean for a basket of 12 active currencies there would need to be at least 108 accounts! Obviously you may not open these all at once, but over a period you will accumulate many accounts and their administration would require a lot of effort.
In GLOBUS the transaction data is used to feed the General Ledger, this is accomplished by telling GLOBUS how you wish to analyse the data. One of the first files set-up on implementation is the CONSOLIDATE.COND, which has just two records viz. ASSET & LIAB and PROFIT & LOSS.
Here you specify where GLOBUS search for the required data such as Industry code, Nationality, and Residence.
Once this file and the application parameters are in place GLOBUS is ready to create and maintain a General Ledger.

All transactions / contracts create the relevant accounting entries across the clients accounts and for the banks own internal records. Entries are automatically generated once the transactions are authorised. Combination of entries generated from STMT.ENTRY, CATEG.ENTRY and RE.CONSOL.SPEC.ENTRY.

There are three types of Account -
Customer Type, Internal/Suspance Accont, P/L Account.
Customer type Accounts -- Current Account, Savings Account, Nostro Account, Vostro Account etc
Internal Accounts ---Cash Account, Suspense Account, Furniture Account etc
Profit & Loss Accounts -- Interest earned account, Salary account, Miscellaneous expenses account etc

Let's Say: A want to transfer 50$ to B's account and bank will Charege 1$ as a transaction commission. In this case globus will raise account entries link below
DR A/C of A - 50.00 ** STMT.ENTRY
CR A/c of B - 49.00 *** STMT.ENTRY
CR P/L Account 1.00***CATEG.ENTRY
In above case, if there was no bank commission there wont have Categ Entry.

What I mean to say is, if there are only customer and Internal/Suspance Account involved during transaction process then globus will generate only STMT Entry if there Charge or Commission came into picture then Globus make a respective Caget entry like above.

If there is contract related transaction like ... MM, LD, FD, MG etc then globus will produce Consol Entry you can see transaction detail in CONSOL.ENT.TODAY file.
Accounting can be :--
DR Customer A/C 25000.00 (STMT Entry)
CR LD/MM Contract 25000.00 (Consol Entry)
After batch process all transaction move int RE.CONSOL.SPEC.ENTRY file.


One of the important aspects of GLOBUS is that all dealings with customers are classified either as ?Accounts? or ?Contracts?.
The main difference between an Account and a Contract is an Account permits the balance to be debit or credit from time to time, whereas in any particular contract, while the balance may change from time to time, its sign will not change from the original ? viz debit will not be allowed to become credit and credit into debit. At the end of the contract, the balance only become NIL.

STMT.ENTRY
The STMT.ENTRY file contains the debit/credit movements generated by transactions, either at the time of the input of the deal or during the live of the deal, concerning customer/counter party accounts and internal accounts.
It will allow to retrieve the operation movements on accounts, generated either on-line or by batches (COB).
Main Data Fields are: account number, value date , Transaction code, transaction reference, Transaction Amount etc

ACCOUNT
The ACCOUNT file contains non-financial and financial data. Financial data such as OPEN.ACTUAL.BAL, OPEN.CLEARED.BAL , ONLINE OPEN.ACTUAL BAL, ONLINE CLEARED.BAL, WORKING BAL, as well as various debit and credit last movements.
CATEG.ENTRY
The CATEG.ENTRY file contains all P/L movements generated from transactions. For the profit and loss movements no physical accounts are available in Globus, it is an analytical accounting.
Main Data Fields are: Product Categy, PL account, value date , Transaction code, transaction reference, Transaction Amount etc

CONSOL.ENT.TODAY
The CONSOL.ENT.TODAY file contains all movements, generated by transactions, not being in STMT.ENTRY nor in CATEG.ENTRY, but only movements from the day, the End of Day procedure will move all movements to the file RE.CONSOL.SPEC.ENTRY..
Main Data Fields are : Product (MM, SC,etc) , txn ref, value date , maturity date, Customer, consolidate key, amount (Lcy/Fcy), Product category etc
RE.CONSOL.SPEC.ENTRY
The RE.CONSOL.SPEC.ENTRY file contains all movements that are not contained in CATEG.ENTRY nor STMT.ENTRY files.
Accounting entries raised for contracts
Accrual/suspense entries raised for Accounts or Contracts
Capitalisation entries for such Accruals
Contingent entries raised by the system for FX, LC etc.
Movement Entries *
Entries raised for revaluation during End of Day
MOVEMENT / ENTRIES :
Consolidation Entries are raised exclusively OFF-LINE for all movements in the automated General Ledger account not supported by an ?account? entry.
They are kept in the RE.CONSOL.SPEC.ENTRY file.
For example a customer?s sector could have changed from Partnership to Public Company.
This would initiate a Movement entry (for the balance held in the respective account) from one group to the other.
Also, a change in sign of the customer?s balance (from debit to credit or vice versa) would necessitate a movement entry from one bucket to another. Such entries raised for static changes are also held in the Special entry file.

FX, MM, LD, SC, ETC FILES
These various files contain the details of transactions, since no general ledger accounts in Globus.


Account Based Entries:
The movements for account are generated in ??Stmt.Entry?? file and the movements for profit and loss are genereated in ??Categ.Entry?? file.
Then according to the ??Consolidate.Cond?? file, the consolidation keys are created and recorded in the CRB which are the ??Consolidate.Asst.Liab?? and ??Consolidate.Prft.Loss?? files.
Some entries such as accruals, contract event modification will be generated in the file ??Re.Consol.Spec.Entry?? by running the COB.

Contract Based Entries:
The entries for a contract are firstly generated in the file ??Consol.Ent.Today?? and by running the COB, these entries will be generated in the file ??Re.Consol.Spec.Entry??.
The movements for account are generated in ??Stmt.Entry?? file and the movements for profit and loss are genereated in ??Categ.Entry?? file.
Then according to the ??Consolidate.Cond?? file, the consolidation keys are created and recorded in the CRB which are the ??Consolidate.Asst.Liab?? and ??Consolidate.Prft.Loss?? files.
_________________
Ashok Pandey
Mayor Street
Dublin
Ireland

Thank you Ashok for your clarifications!!

If there is contract related transaction like ... MM, LD, FD, MG etc then globus will produce Consol Entry you can see transaction detail in CONSOL.ENT.TODAY file.
Can you give all types of contract like MM, LD, FD, MG and their signification?

ACCOUNT
The ACCOUNT file contains non-financial and financial data. Financial data such as OPEN.ACTUAL.BAL, OPEN.CLEARED.BAL , ONLINE OPEN.ACTUAL BAL, ONLINE CLEARED.BAL, WORKING BAL, as well as various debit and credit last movements.
Can you give me more information about this fields?

RE.CONSOL.SPEC.ENTRY
The RE.CONSOL.SPEC.ENTRY file contains all movements that are not contained in CATEG.ENTRY nor STMT.ENTRY files.
Accounting entries raised for contracts
Accrual/suspense entries raised for Accounts or Contracts
Capitalisation entries for such Accruals
Contingent entries raised by the system for FX, LC etc.
Movement Entries *
Entries raised for revaluation during End of Day
MOVEMENT / ENTRIES :
Consolidation Entries are raised exclusively OFF-LINE for all movements in the automated General Ledger account not supported by an ?account? entry.
They are kept in the RE.CONSOL.SPEC.ENTRY file.
What is the meaning of FX and LC?
How to distinguish non-financial data from RE.CONSOL.SPEC.ENTRY file?? Is there a flag or something like this to find data related to accountancy?

What is the meaning of the column CONSOL.KEY.TYPE in RE.CONSOL.SPEC.ENTRY?

Thank you very very much to help me to understand accountancy mechanism in Globus? I have user guide but they are not so exhaustive like what you described?

Hi Mehdi,

It it not possible to expaling all the things. I think you have to learn some banking terms. I dont think I have time to explain all never the less I can share some time with you people.


MM, LD, FD, MG are used to track Lending and deposit operation peform by bank.

OPEN.ACTUAL.BAL - 0
OPEN.CLEARED.BAL - 0
ONLINE OPEN.ACTUAL BAL - 0 ,
ONLINE CLEARED.BAL- 0
WORKING BAL 0

AFTER TRANSACTION OF 1000
OPEN.ACTUAL.BAL - 0
OPEN.CLEARED.BAL - 0
ONLINE OPEN.ACTUAL BAL - 1000 ,
ONLINE CLEARED.BAL- 1000
WORKING BAL - 1000

AFTER COB
OPEN.ACTUAL.BAL - 1000
OPEN.CLEARED.BAL - 1000
ONLINE OPEN.ACTUAL BAL - 1000 ,
ONLINE CLEARED.BAL- 1000
WORKING BAL - 1000

With Draw 500 Before Authorisation
OPEN.ACTUAL.BAL - 1000
OPEN.CLEARED.BAL - 1000
ONLINE OPEN.ACTUAL BAL - 1000 ,
ONLINE CLEARED.BAL- 1000
WORKING BAL - 500

With Draw 500 Before Authorisation
OPEN.ACTUAL.BAL - 1000
OPEN.CLEARED.BAL - 1000
ONLINE OPEN.ACTUAL BAL - 500 ,
ONLINE CLEARED.BAL- 500
WORKING BAL - 500
Note that during deposit time no effet in account before authorisation of account.
_________________
Ashok Pandey
Mayor Street
Dublin
Ireland

Thank you for explanations.
Another question about these 3 files : STMT.ENTRY, CATEG.ENTRY and RE.CONSOL.SPEC.ENTRY. If we have the three files full with data regarding one year.
Is it possible or is there a program / script that allow to extract General ledger and trial balance from data located in these files?

I understand in your first reply that RE.CONSOL.SPEC.ENTRY contains all movements, generated by transactions, not being in STMT.ENTRY nor in CATEG.ENTRY, but only movements from the day. So, RE.CONSOL.SPEC.ENTRY contains financial data and non-financial data! Is it possible to distinguish between financial data and non-financial data?
Is there a column or information in the row that allow to do that?
Thank you for you cooperation!