Tuesday, April 19, 2011
Hi folks, this time I will be introducing you all to our new product from the Treasury Science Product Suite in the field of Analytics namely Enterprise Treasury Analytics (ETA). This would be our very first step towards data analytics, and as it is popularly said and believed that “Charity begins at home” we too stuck to this and developed a tool which is integrated with one for our flagship product CMO and analyzes the data stored by it. ETA’s rich user interface and graphical presentation allows you to decipher the data in a very interactive manner. The web based application comprises of two kinds of reporting capabilities, i.e. Adhoc and Canned. Adhoc Reports are easy to create because of its XML based configuration, whereas Canned Reports are system defined and are developed based on certain specific user requirements and criteria. Canned Reports also give the capability to view both the chart and the data together for a more comprehensive analysis. Currently we have created a couple of reports both Adhoc and Canned based on the data stored with CMO which are generic in nature and gives a birds eye view of the treasury to our existing clients. Let me explain a few reports which we have been working on: Investment Position Report: This is an Adhoc Report providing you with details of your Investments. Based on the simple logic that your Total Investment would be equal to all you Current Investments minus any Redemption/Maturities for the period you are running the report. You have the ability to drill down into minute details of your investments and redemptions and identify any kind of pattern. 
Balance Report: This Canned Report, reports the different kinds of summary balances of each account which you have with your banker such as the Opening Available Balance, Closing Available Balance, Opening Ledger Balance, and Closing Ledger Balance and so on. Balance of each accounts are reported and grouped allowing you to analyze the data by viewing the charts. The report equips you with the ability to run a trend analysis of different balances across currencies for each account across all your banks. 
Transaction Summary Report: You can view the summary of the different type of transactions executed by you using our treasury products both EFTNextGen and CMO across currencies over a period of time and determine the most availed service from your banker and the volume of the transactions. 
Daily Cash Position Report: To sum up all your daily treasury activities which would also work as an icing on the cake at the end of the day is this Cash Position Report which would not only define the Preliminary Cash Position and the Final Cash Position but also by how much the two differ in both absolute and percentage terms. 
ETA’s ability to tailor views and groups of data based on your organization's unique needs is sure to make a difference in the way you have been managing your Treasury.
Tuesday, October 19, 2010
Treasury Sciences Applications a consortium of free web based treasury tools extracted from our flagship products namely EFTNextGen and CMO. It’s an effort to equip organizations with small but powerful tools to efficaciously manage their big-small treasury. BAI2Excel which was one of our very first effort towards free web based applications has been integrated with other products like Bank Fees Analysis, Transaction Manager, IBAN Validator and CMO (trial) delivering a smooth single sign on experience. You can start using all the mentioned tools by registering with us. In this post my main focus will be to get you familiarized with Bank Fees Analysis. Bank Fees Analysis also known as Bank Account Analysis, and as the name suggests that you are able to manage and analyze your bank accounts with respect to the services availed by you from your banker in a time period.
Bank Fees Analysis has two sections, first being the data input (you will have to feed in bank charges per bank per service for a time period), second being the report which will calculate the total bank fees for all your accounts for all your banks for a given time period. The system has the ability to fetch data from dual data source namely BAI2Excel and CMO. Transaction data will be fetched from both Prior Day and Current Day Bank Reporting Files converted by you in Excel using the BAI2Excel application or imported by you in CMO. If you are going to use BAI2Excel and would want the same data to be used for bank fees analysis, you will have to allow Treasury Sciences to save the data being converted into Excel and you can do the following by checking the preference in BAI2Excel as shown below: 
Apart from this you will also have to define the data source in the preference section of Bank Fees Analysis as shown below: 
Once this is done you are all set to start your bank account analysis, and get in a position to crack better deals with your banks as it will provide you with a comprehensive picture of all your banking relations. You can start off by entering some basic information about your contractual agreement with different banks in the following manner: 
You are provided with some standard and globally accepted services and can also add customized services. Banks will be populated based on the ABA Number or the Bank Routing Code in your Bank Reporting File or created by you in CMO based on the preferred data source. To begin with we support two Service Type Models namely the Flat Charge and Volume Times Price including Tier Pricing. When you have finished entering the basic information you can go to the reporting section and generate the report for a time period grouped by bank and flow codes, enabling you to analyze your banking expenses and reduce cost wherever required. This application not only allows you to keep track of your banking expenses but also empowers you to get much better deals with banks as you have a clear picture of your expense across banks.
Feel free to get in touch with us at support@treasurysciences.com
Powered by:
Copyright © Shashank Kajaria
|