Banking Information
Financial Institutions
Overview
Financial Institutions are institutions which provide financial services. Banks are one of the most known financial institutions. In the FreeBalance Accountability Platform, Financial Institutions are used in the Treasury and Human Resources modules. For example: During the Payroll payment, Banks are used to transfer money to the employees. The FreeBalance Accountability Platform also allows associating each Financial Institution with its Vendor, keeping integration across the system modules.
This option allows managing information about each Financial Institution such as Code, Swift Code, Name, Vendor, Offset Code, List of Addresses, and a List of Institution Branches.
Navigation
Admin ► Common Entities ► Banking Information ► Financial Institution
Financial Institution screen Fields and Tabs
Field | Description |
Code | User unique identification code of a financial institution. |
Swift Code | A swift code unique to a financial institution. |
Contact | One or more contacts of the financial institution are added in this field. |
Vendor | Vendor relating to the Financial Institution is selected from this field. |
| Financial Institution Type | Select using the drop-down menu the financial institutional type. Select using the drop-down menu the financial institutional type. |
Bank Account | Bank Account for Financial Institution is added from this field. |
| Bank Account Foreign | Foreign Bank Account for Financial Institution is added from this field. |
Name | Name of the financial institution. |
Address tab | Address of the financial institution is added from this tab. |
Financial Institution Branch tab | Branch office of the financial institution is added from this tab. |
Address
Overview
Information of Address of Financial Institution gets recorded from this tab.
Address Tab screen Fields
Field | Description |
Is Main | This field indicates whether the address to be mentioned is the main address or not. |
Region | Region where the Address is located is mentioned in this field. |
| Country | User selects the Country from the drop-down menu. |
Address Type | Whether the address specified is the office or home address or it is unknown is mentioned in this field. |
Address | The address of the Financial Institution as mentioned in this field. |
Zip Code | The zip code of the address is mentioned in this field. |
Financial Institution Branch
Overview
Information for branch/es of financial institution is kept into record from this tab.
Financial Institution Branch screen fields
Field | Description |
Code | Unique identification code of the Financial Institution branch. |
Active | Whether the branch mentioned in this field is for use or only for reference purpose, is specified in this field. |
Contact | Contact details of the branch of the financial institution is specified in this field. |
Address | Address of the branch of a financial institution is mentioned in this field. |
Name | The name of the branch is mentioned in this field. |
Branch Location | This field indicates whether the branch is located "In Country" or "Outside Country". |
| Branch BSRTN | This Code is used to interface with a corporation. |
DAB Account
Overview
This entity allows the users to create DAB accounts. DAB accounts are used to configured the vendor.
A screenshot of the DAB Account feature is available here.Image shown as reference material; position and names for labels, fields and buttons are subject to parameter, rendering control configuration and installed revision.
Users access DAB Account from within the menu through this navigation path: Admin ► Common Entities ► Banking Information ►DAB Account
Visible Fields
The following table lists and describes all visible fields for the DAB Account feature, in their default order. Note that some fields depend on System Parameters and rendering control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Field | Description |
|---|---|
| DAB CODE | Unique identification code for the entity,store value is manually assigned by users. |
| Bank Name | The bank account name for the specific DAB CODE. |
| Is Active | Flag indicating if the DAB Account is active or not. If this value is changed to false, such DAB Account can not be selected again and it remains for references purposes only. The default value of this field is true. |
| Language | Language used to enter description. |
| Description | The bank account description for the specific bank account. |
| Accounts Tab | This collection allows the users to create one bank account number per currency. |
| Button Image | Description |
|---|---|
 | Set screen to Insert Mode. Users can then create a new record through this button. |
 | Set screen to Search Mode. Users can enter filter criteria and search existing entries. By default, when entering a feature, users are in Search Mode. |
 | Once a record has been created or searched for, users can return to the results screen when necessary. |
 | Add a new item to the detail tab. A screen appears allowing users to enter new information for a detail item. |
 | Remove a record. A screen appears to confirm the record is deleted. |
 | When users are required to sort by a specific filtering criterion, the Select All button allows to highlight all the filter criteria. |
 | When users are required to sort by a specific filtering criterion, the Unselect All button unselects all previously highlighted filter criteria. |
 | Click to save the information inputted. The record is stored and a confirmation message is presented. |
Accounts
Overview
This child entity allows users to create DAB account number for the DAB Account.
A screenshot of the Account tab is available here. Image shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Paramters and Rendering Control configuration.
Visible Fields
| Fields | Description |
| Serial Number | Serial number of the accounts tab, automatically generated by the system. |
| Currency | The currency for the given bank account number. |
| Bank Account Number | Bank account number per DAB Account. |
Financial Institution Type
Overview
This screen is used to define all the types of Financial Institution. This helps to categorize the Financial Institution.
Navigation
Admin ► Common Entities ► Banking Information ► Financial Institution Type
Financial Institution Screen Fields
| Field | Description |
| Code | System generated a unique identification code. |
| Active | If false, the Financial Institution Type cannot be used in new transactions. |
| Name | Name of the Financial Institution Type. |
| Description | The description of the Financial Institution Type. |
Nicaragua Reports
Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report
Overview
This report allows user to display the available balances of the Secondary Accounts versus the Principal Treasury Bank Account
A screenshot of the Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report feature is available here<. Image is shown as reference material; position and names for labels, fields and buttons are subject to the installed revision, System Parameters and Rendering Control configuration.
Users access Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report from within the menu through this navigation path: Admin ► Common Entities ► Banking Information ► Nicaragua reports ► Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report
Filters
The following table lists and describes all visible fields for the Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report, in their default order. Note that some fields depend on System Parameters and Rendering Control configuration to be visible and/or editable by users. Field names are subject to change through language label configuration.
| Fields | Description |
|---|---|
| Institution | It allows application users to select the Institution using lookup feature or can enter manually. |
| Currency | It allows application users to select currency related to bank account using lookup feature or can enter manually. |
| Bank | It allows application users to select Bank using lookup feature or can enter manually. |
| Bank Account No. | It allows application users to display all accounts from treasury bank accounts entity |
| Comment | It allows application users to enter comments related to report. |
Visible Fields
A sample of the report is available here.The following table lists and describes all visible fields for the Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report, in their default order. Note that some fields depend on filters selection and the language of the report depends on the configuration of the system.
| Fields | Description |
|---|---|
| Fiscal Year | It displays current fiscal year. |
| Account | It displays the account number. |
| Description | Display the name of the Principal Treasury Bank Account or and the Secondary Accounts. |
| Balance | Display the amount. |
| Currency | Display the currency of the selected bank. |
| Sub-Total | Display the sub-total amount. |
| Difference | Display the difference amount. |
Buttons
The following table describes actions associated to the depicted button image. Note that some images are associated with several buttons, used for more than one purpose within the Balance Of The Secondary Accounts Vs Principal Treasury Bank Account Report.
| Button Image | Description |
|---|---|
 | This button allows users to generate the report as PDF format. |
 | This button allows users to generate the report as MS Excel format. |
 | This button allows users to generate the report in ODS format. |
 | This button allows users to generate the report in RTF format. |
 | This button allows the users to generate the report in MS Word format. |
 | This button allows users to generate the report in ODT format. |
Treasury Bank Accounts
Overview
This entity represents the bank accounts used by government organizations for expenditures/revenues. The idea is to provide a catalog of government bank accounts that could be referenced by one or more institutions.
Navigation
Admin ► Common Entities ► Banking Information ► Treasury Bank Account
Treasury Bank Accounts screen fields
Field | Description |
|---|---|
Code | Unique identification code associated which each Treasury Bank Account. |
| Workflow Status | Determines the status of the request depending on the system configuration. At the initial stage, it is as “Created” and it changes as per the process of the workflow i.e. Approval Requested, Approved, Rejected and Cancelled. |
Active | Determines whether the Treasury Bank Account is Active or not. |
Is Default | If the parameter Multi Funds Accounting is populated, this means that is Default can be TRUE, else it means that for the same financial institution there can only be one is Default = TRUE. |
| Use Check Book | User can check this box as per the requirement, by default this feature is unchecked. |
| Is Cash Book | User can check this box as per the requirement, by default this feature is unchecked. |
| Is Payment Quota | User can check this box as per the requirement, by default this feature is unchecked. |
| Is Payment Zero | User can check this box as per the requirement, by default this feature is unchecked. |
| Is Check Manager | User can check this box as per the requirement, by default this feature is unchecked. |
| Is EFT Manager | User can check this box as per the requirement, by default this feature is unchecked. |
| Is Project | User can check this box as per the requirement, by default this feature is unchecked. |
| Has Children | User can check this box as per the requirement, by default this feature is unchecked. |
| Transfer Package Number | Number of the packaged transfer. |
| Funding Source | This feature shows the source of financial funding. |
Used In | User can select from the dropdown list in which cases to use the TBA. |
| Used For | Possible values are Null, Both, Domestic and Foreign |
| Treasury Bank Account Type | It shows the type of bank account is it physical or secondary or virtual. Physical is related to the bank account and it has control over the cheque. |
| Treasury Bank Account Parent | Treasury bank account parent check some time system validates its origin (father, Grandfather, etc.…). |
| Collection Account | It will display the collection account summary. |
Offset Code | Offset code reference. if applicable, the system will validate that no two GL_offset code are same among the three attributes |
Offset Code for Bank in Transit Revenues | Offset code reference. If this value is entered, then it could be used to implement Cash Control, if parameter. |
Offset Code for Bank in Transit Payments | GL Offset Code for Bank in Transit Payments |
Tolerance | Applied only when General Parameter Treasury Bank Account cash Control is needed. |
Cheque Series | Alphanumeric series entered by the use. |
Cheque Number From | Initial cheque number. |
Cheque Number To | Final cheque number to use. |
Next Cheque Number | Sequential field identifies the next cheque number to use. |
Print Format | User will be able to select which report format the system should use to print cheques related to this treasury bank account. |
Printer Name | Name of identified printer. |
| Transfer Id Prefix | Alphanumeric series entered by the user. |
| Cheque ID Format Type | Possible Values ('Simple Number', 'Number with leading Zeros'). |
| Transfer ID Format Type | Possible Values ('Simple Number', 'Number with leading Zeros', 'Prefix + Simple Number', 'Prefix + Number with leading Zeros'). |
Next Transfer Number | Configured by the user if transfers or electronic payments are needed. |
Amount Limit | If this value remains zero, then no limit applies. If this value is higher than zero, the system will validate that no payment (cheque or transfer) can surpass this limit. Should be validated at the EV payment detail level and also when producing the payment extract. |
| Available to All Institutions | If true, TBA is available to all institutions. |
| Also Allow Child Institutions | If it is true, allow the child institution. |
| Abbreviation | A brief description of the Treasury Bank Account. |
| Description | A detailed description of the Treasury Bank Account, this description will be useful as a reference of the purpose of this Treasury Bank Account for the institutions. |
| Bank Account | It gives information about the account associated with the treasury bank account |
| Institution Owner | It provides the information about the institution belongs to. |
| Primary Signature | Signature that must be printed in cheque. |
| Secondary Signature | Signature that must be printed in cheque. |
| Is Collecting Account | If checked – collecting account is available. |
| Is Tax Collecting Account | If checked – Tax collecting account is available |
| Open From Date | Activation start date. |
| Open To Date | Activation end date. |
| Has Mix Account | If checked, indicates that this account is related to a current Account |
| Address | Collection of addresses details. |
Address Tab
Address Tab Screen fields
| Fields | Description |
| Is Main? | By default, it is not selected user can select it as main. |
| Region | Select region information from the list. |
| Address Type | User select the address type from the drop-down menu as it is mandatory to select. |
| Address | Address of the financial institution should be filled. |
| Location | Location of the address |
| City | City details |
| State | State details |
| Zip Code | Zip code of the area |
| Country | Country related details |