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