Create Bank Statement – A summary of the activity

Component overview

This activity allows you to download the bank statement from an external file like an MS-Excel spread sheet, an XML document or a text file. This statement must have been received from the bank in the specified format. A statement can be uploaded for every account number for a date range. The opening and the closing debit or credit balances can also be entered for every bank account number.

This activity also allows you to enter the details of the bank statement manually. Apart from the opening and closing balances, you can also enter the type of transaction for which the payment has been received or issued. You can also record the details of the payment and the organization unit in which it has been received or paid. The system calculates the total balance of the transaction and saves the statement details. The system also generates a unique number identifying the statement. The system also updates the status the bank statement as “Active”. The system also stores the login ID of the user and the system date along with the newly created bank statement.

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

What you can do in this activity

Enter statement manually

Automatic download from an external source

Compute running balance of the statement

 

 

 

 

 

 

 

 

 

 

 

 

Enter statement manually

The details of the bank statement like the opening / closing balances, the type of the transactions and the organization unit in which it has been received or paid can be entered manually.  

Automatic download from an external source

The bank details can be downloaded from an external source for every account number. The external source can be an MS-Excel spreadsheet, an XML document or a text file.

Compute running balance of the statement

The system calculates the running balance of the account while creating the bank statement. The running balance in the first row is the sum of the derived opening balance and the derived amount in the first row. The running balance in the other rows is the aggregate of the running balance in the preceding row and the derived amount in the said row.