Banking Application Test Cases in Excel Sheet and PDF 2022 (2023) (2023)

Find out what we've covered in this article

Test case for bank application or test scenario for bank application or bank applicationa test case:In this article, we will learn how to write test cases for a banking application in an Excel spreadsheet. In our previous post, we also showed the Amazon search function test case template. Each bank has its own remittance process.

Therefore, it is difficult to generalize the process of all banks. So I'm trying to figure out the process that most banks are likely to face during a money transfer. Depending on the type of bank you use, you may find many differences.

Mail to:Test Cases for Banking Application
Post type:Test case template
Applies to:Further education and experience
Did you join:our telegram group

But before you start writing test cases for the banking application, here's what you need to know:

(Video) Test Cases in Investment Banking | How to Write Test Cases Manual Testing | Software Testing

What is Internet Banking?

In online banking, customers and organizations are frustrated with electronic methods of transferring money through web applications. Currently, in the 21st century, most people use this method to transfer money because it is faster and there is no need to wait in long lines for a single transaction.

Using this method, you can perform various money transfer operations related to receiving money, paying bills, and many other operations.

Similar test cases

(Video) How to use templates to write test cases in manual testing

Banking Application Test Cases in Excel Sheet and PDF 2022 (2023) (1)

  • Test case for text field
  • Test case for textbox
  • Test cases for tool descriptions
  • Test cases for web elements
  • Test case for loading webpage files
  • Test case for website URL
(Video) How to Write Test Cases in Manual Testing with Template

But when you work on any banking application, developers and testers make sure that the application runs smoothly on all browsers and devices. And web applications are protected against all cyber threats without performance degradation during peak hours.

Banking Application Test Cases in Excel Sheet and PDF 2022 (2023) (2)

Test the banking application

When testing any banking application, QA specialists prioritize several areas:

  • function test:All modules work as expected (both as standalone elements and after integrating all individual modules)
  • Usability testing:Most of the time, people using banking apps are not experienced computer users. So, for them, the form should be clear and have a user interface.
  • Performance Testing:Since this is developed for users, the performance of the application should be faster. And the app should work fine on different platforms.
  • Safety test:Just like they use a banking app, people will use it to transfer money. So, this is one of the prioritiesThe task of an organization to develop applications in a manner that complies with standard security guidelines.

Therefore, in this post, we will discuss the natural flow of a banking application through some basic scenarios:


(Video) How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files

Test steps for bank transactions

Therefore, here are the necessary steps that we follow while performing any money transfer operation:

  • Go to the login page on the bank's website.
  • Enter your username and password.
  • Go to the remittance page.
  • Add the recipient you want to transfer money to.
  • Check your bank account and personal details. Make sure they are correct.
  • Select a specific money transfer method from NEFT/RTGS or SWIFT transfer options.
  • Select the recipient's name and funds, then send the details.
  • Review the amount and other details on the confirmation page.
  • Click Submit for the final action of the funds transfer.

Regardless of the steps you see above, that's the basic flow we've covered here. Maybe if you go to another region then it might be different from the above.

For example, some of you may have SMS authentication before sending money. Some of you may have other ways to verify user information to avoid sending money to the wrong people. But having said that, the process is pretty much the same for most banks.

Another different process that different banks follow may be when you add a user, regardless of the fields you now see in the image below, it may vary between banks. So, the image below shows the number of fields that you can validate and write test cases for them.

Banking Application Test Cases in Excel Sheet and PDF 2022 (2023) (3)

If you add test cases for each page, then the test cases will cover the basic aspects of the test.

Test scenario for the Money Transfer banking application

  • Check the bank's websiteurl.
  • Make sure the bank website URL has HTTPS in the address bar and in the URL.
  • Make sure the login page on the bank's website doesn't look fake.
  • Make sure the bank login page has a username and password.
  • Check that the username and password are accepted.
  • Whether to trigger SMS authentication after verifying login.
  • Verify that the user is redirected to the dashboard after passing all authentication processes.
  • Checks if the user has access to the online money transfer function.
  • Check if a user can transfer money during a specific time period (9am-5pm).
  • Check that the funds transfer option shows notifications about transactions outside of business hours.
  • Check if user can add users.
  • Check if user information can be verified.
  • Check if the funds transfer option allows NEFT or RTGS options for nationalized remittances.
  • Check the funds transfer page for the beneficiary name, IFSC code, bank name, fund amount and purpose of the transfer.
  • If the amount of funds is more than 50k, please check if the funds transfer page asks for a PAN number.
  • Make sure the funds transfer site has 2-step verification before completing the transfer.
  • Check to see if an interbank funds transfer is taking place.
  • Check how long it takes to transfer money between business hours.
  • Check how long it takes to transfer money between business hours.
  • Check that notifications of the transfer amount have been sent to both the sender and receiver.
  • Check if the amount has been transferred to the exact person specified by the user.

In addition to this flow, there are several other scenarios; moreover, we have now added to this post. Hope it also gave you some insight into writing bank application test cases.

Banking Application Test Case - Internet Banking Application

  • Verify that a user can log in with a valid username and password
  • Check users can perform basic financial transactions
  • Verify that the user can add recipients with valid names and account information
  • Users of the check can make financial transactions based on the added user
  • Check if user can add decimals to amounts (limited to 2)
  • Check that user cannot add negative numbers in the amount field.
  • The beneficiary of the check can only transfer the money if the account balance is normal.
  • Confirmation checks to secure financial transactions
  • Users of checks receive confirmation of receipt after a successful financial transaction.
  • Check if user can send money to multiple people
  • Check if user is allowed to change password
  • Checking account information also reflects financial transactions.
  • Checks that users with invalid passwords are not allowed to log in.
  • Check after repeated login attempts with an incorrect password (according to restrictions), the user should be blocked.
  • Make sure you implement the timeout function
  • Please check if the username or password is empty, the user is not allowed to log in. Users should also be warned.

Manual Test Cases for Banking Application - Admin

  • Verify that the administrator can log in with valid credentials and cannot log in with invalid credentials.
  • Check if an administrator can log in without valid test data.
  • Check all application links for admin role.
  • Make sure administrators can change passwords with valid information and should not allow password changes with invalid information.
  • Checks that recently used test data is not allowed to be reused.
  • Check if the administrator can log in successfully.

Banking Application Test Case - New Branch

  • Check that you can create a new branch with valid data.
  • Check for invalid data. You cannot add branches.
  • Check out to try creating a new branch with existing test data.
  • Check that the Undo, Cancel and Submit buttons work as expected.
  • Attempts to update branch data with valid and invalid test data.
  • Try to update branch data with test data.
  • Update branch data with existing test branch data
  • Check if the cancel button works.
  • Make sure to allow deletion of branches with and without dependencies.
  • Check that users should be able to search and locate branches.

Test Cases for Banking Application in Excel Spreadsheet - New Role

Let's now look at some sample test cases for the Bank application adding a new role.

(Video) Software Testing Using Excel - How to Create Test Cases

  • Check if a new role can be created with valid information.
  • See if you can create test data without test data.
  • Validate new roles using existing test data
  • Check the role description and role type.
  • Check that cancel and commit works as expected.
  • Make sure you can drop roles without dependencies.
  • Verify that all connections to the new role work as expected.

Let us know if you want to add more points. Now we will move on to other test cases of the banking application for customers and visitors.

(Video) How to Insert PDF Files inside Excel

Test Cases for Banking Application in Excel Spreadsheet - Customers and Visitors

  • Verify that all links in the Customers and Visitors modules work as expected.
  • Verify that all users can log in with their valid credentials.
  • Check if a client cannot register with an invalid date.
  • Check the number of failed account accesses; then, the user account should be locked or unlocked for that day.

Test Case for Banking Application - Adding New User

  • Make sure you can add new users with valid information.
  • Verify that the correct confirmation message is displayed by entering invalid information.
  • Checking after adding the user should show the correct branch details.
  • Verify that all connections are working as expected.
  • Check that all buttons work as expected.
  • If invalid data is entered when updating user data, a validation message will be displayed.
  • Check for warning message when you click submit button during update without changing any details.
  • Check that user functions work as expected.

Banking Application Test Case PDF - New Account

  • Check all required fields and their corresponding confirmation messages.
  • Check all optional fields and their corresponding validation messages.
  • Check after filling all the required fields, hit submit and check if the new user is added.
  • After depositing the amount into the account, check to see if the updated balance is displayed.
  • Check if the user can withdraw the amount.
  • After withdrawing the amount, check to see if the balance is updated.
  • Review all entered information that appears in the User Profile section.
  • If it is a secondary account, please check whether the primary account exists.
  • If it is a checking account, check that the company details are listed.
  • If it is a joint account, please check that proof is attached.
  • The control zero account is kept in the salary account.
  • Make sure you can keep your non-salary account balance at zero or below the minimum balance.

Test case for the bank account number field

To test the bank account number field, just follow the steps below.

Bank account number: SSSSXXNNNNNNNN (eg 35010100008033)

  • SSSS- The first four digits of your account number are the Point of Sale ID [SOL ID]
  • XX - The fifth and sixth digits of your account number indicate the plan type (01-09).

The different types of programs are:

01 – Savings,
02 – Current Account
03 – Term Deposit
04 - Exceeded
05 – Cash loan
06 - Loans
07 – Packaging Credit
08 – Internal Accounts
09 – Foreign Draft
81 – FI account under SB 150

NNNNNNNN – The remaining -8 bits represent the current serial number.

Bank account number field test case example

  • Check the Accounting field by entering a valid account number.
  • Check the accounting field by entering an invalid account number.
  • Check the account number field by entering an account number longer than 14 digits.
  • Check the account number field by entering an account number with fewer than 14 digits.
  • Check the account number by inserting 14 zeros.
  • Make sure the accounting fields allow letters and special characters.
  • Validate the account number field by entering an alphanumeric value.
  • Make sure the account number field allows blank values.
  • Check for any warning messages by entering an invalid account number.
  • Check whether there is a prompt when the user enters an account that does not exist.
  • Make sure to allow users to paste account numbers into the account number field.
  • Checks when the user enters any closed accounts.
  • Make sure there is a space when the user enters the account number.

in conclusion

(Video) User Acceptance Testing (UAT) Test Case Template xls | Testingshall User Registration Example

I hope we can cover a very basic testing scenario for a banking application. While going through the above scenarios, if you find any missing test cases for banking application, then you can mention those scenarios in the comment section.

If you want to contribute something to related to banking apps or any other topic or tool you can write to。

1. Excel spreadsheet test case for Amazon, Flipkart.

2. ESIC UDC Computer Test 2022 | Ms Excel set-1 (paid pdf)

(Video) Top 10 Excel Interviews Questions – How to pass any Excel Assessment Test

3. How to write test cases in Excel

4. How to write a test scenario for mobile application Google pay|Test Hall

5. How to pass the Excel assessment test for job applications - a step-by-step guide using XLSX worksheets

6. Check and Fee Schedule 1260 1260 QuickBooks Online 2023

Article information

author: Melvina Ondrica

last updated: 06.10.2023

View: 6154

Evaluate: 4.8 / 5 (68 votes)

review: 83% of readers find this page useful

author information

to do: Melvina Ondrica

Birthday: 2000-12-23

address: Suite 382 139 Shaniqua Locks, Paulaborough, UT 90498

Telephone: +636383657021

Work: A dynamic government expert

(Video) Properly Convert PDF to Excel

Hobby: Kite flying, watching movies, knitting, model making, reading, wood carving, paintball

introduce: My name is Melvina Ondricka, I am a helpful, graceful, friendly, naive, brilliant, courageous, thoughtful person who loves to write and wants to share my knowledge and understanding with you.


How do I create a test case for a bank application? ›

3. Test Cases for Customers and Bankers
  1. Check if all visitor and customer links are working properly.
  2. Double-check the customer's login with valid and invalid test data.
  3. Check the customer's login without any data.
  4. Check the banker login without any data.
  5. Check the banker's login with valid or invalid test data.
Jun 30, 2022

How do you write a test case in an Excel spreadsheet? ›

How to write test cases in Excel?
  1. Step 1: Build a Test case Repository. Mention the basic details such as Project Name, Prepared By (Tester's Name), Prepared for (Developer's Name), Document Purpose, Application Type, Date and Version. ...
  2. Step 2: Create a Test Case Matrix. ...
  3. Step 3: Make a Detailed Sheet.

What is the test case template? ›

It is a document that outlines the steps, inputs, and expected results for a specific test scenario. A test case template is used to plan and organize software testing efforts, ensuring that all necessary test cases are executed and that any defects are identified and tracked.

How do I create a test case template? ›

Follow the below-given steps to write the test cases.
  1. Step 1 – Test Case ID. Each test case should be illustrated by a unique ID. ...
  2. Step 2 – Test Case Description. ...
  3. Step 3 – Pre-Conditions. ...
  4. Step 4 – Test Steps. ...
  5. Step 5 – Test Data. ...
  6. Step 6 – Expected Result. ...
  7. Step 7 – Post Condition. ...
  8. Step 8 – Actual Result.

What are the different types of testing in banking? ›

Here, we offer you to have a look at the types of software testing that are of primary importance in the context of banking app testing:
  • Functional Testing. ...
  • Database Testing. ...
  • Performance Testing. ...
  • Security Testing. ...
  • Usability testing. ...
  • Accessibility testing. ...
  • Compliance testing.
Dec 27, 2022

How to write test cases in manual testing in Excel sheet download? ›

How to Write Test Cases in an Excel Sheet
  1. Test Case ID: Test Case ID will be the test case number of story number in JIRA.
  2. Test Case Description: The description will be a short description of the functionality.
  3. Assumptions: Assumptions should be mentioned in the assumptions columns if any.
Jan 3, 2022

What is the formula for text case in Excel? ›

In cell B2, type =PROPER(A2), then press Enter. This formula converts the name in cell A2 from uppercase to proper case. To convert the text to lowercase, type =LOWER(A2) instead. Use =UPPER(A2) in cases where you need to convert text to uppercase, replacing A2 with the appropriate cell reference.

What would be the top 5 five test cases for a login feature? ›

Positive Test Cases for Login Page
  • Log in with valid credentials.
  • Check the Show Password feature.
  • Check the Remember Me checkbox.
  • Check the autofill.
  • Check the Log Out button.
  • Restore the password with a registered email.
  • Check the Forgot Password email.
  • Create a new password using valid data.

What is the difference between test case and test scenario? ›

The main difference between test cases and test scenarios is that test cases are specific instructions that can be used to test a particular function or feature of an application, while test scenarios are high-level descriptions of how a specific function or feature of an application should work.

Is there any tool to write test cases? ›

Answer: There are several test management tools such as TestRail, PractiTest, QTest, Zephyr, etc. and are good for writing test cases.

How to write test cases for PDF download? ›

Test Cases For Download
  1. Check whether the Download button is clickable or not.
  2. Check on click of the download file; it should ask for the destination location or not.
  3. Check if the file is downloaded or not when the user clicks on download.
  4. Check if the downloaded file size is equal to the original file size.
Apr 10, 2023

What is a good test case? ›

“(1) A set of test inputs, execution conditions, and expected results developed for a particular objective, such as to exercise a particular program path or to verify compliance with a specific requirement.

How many test cases can you write in a day? ›

41) How many test cases can we run in a day? We can run around 30-55 test cases per day.

Which testing is used for banking application? ›

Security testing is designed to find vulnerabilities that can jeopardize banking applications and websites. Security testing should verify that customer data is being secured properly, and that only authorized and authenticated users are given access to the right application or pages and their own data.

What are the four 4 basic testing methods? ›

It is important that everybody understands this. There are generally four recognized levels of testing: unit/component testing, integration testing, system testing, and acceptance testing.

What is test key in banking? ›

Test Key a digital code calculated in compliance with the algorithm set by the Bank using a TCT or a DigiPass. Transactions with Assets – any activity with Assets in the line with the Terms and Conditions.

How do you write test cases for internet banking? ›

Sample Test Cases for Banking Application
  1. Create a new branch with valid and invalid test data.
  2. Create a new branch without data.
  3. Create a new branch with existing branch data.
  4. Verify the reset and cancel options.
  5. Update branch details with valid and invalid test data.
Apr 24, 2023

What is functional testing of banking applications? ›

Banking Domain Testing is a software testing process of a banking application for functionality, performance, and security. The main purpose of testing banking application is to ensure that all the activities and functionalities of a banking software run smoothly with no errors and it remains protected.

How do you write a test case for a simple login page? ›

Positive Test Cases for Login Page
  1. Log in with valid credentials.
  2. Check the Show Password feature.
  3. Check the Remember Me checkbox.
  4. Check the autofill.
  5. Check the Log Out button.
  6. Restore the password with a registered email.
  7. Check the Forgot Password email.
  8. Create a new password using valid data.

How do you test financial applications? ›

Testing financial applications involves gathering and analysing requirements, developing a comprehensive test plan, designing test cases, executing tests and documenting results, tracking and managing defects, conducting user acceptance testing, performance testing, security testing, and regression testing to ensure ...

What are good test cases? ›

Good test cases have…
  • A clear objective with refined scope. ...
  • Obvious and meaningful pass/fail verifications. ...
  • Clear and concise documentation. ...
  • Traceability to requirements. ...
  • Reusability. ...
  • Independence from other test cases while testing one thing. ...
  • Permutations taken into account by the test case designer.

What is core banking testing? ›

Core banking testing can prove that the financial systems are running on a secure and balanced infrastructure, especially during peak hours. The financial transactions that are performed within the core banking system need to be secure from any attempt to break-in. This can be ensured by the testing process.

What are the two types of functional testing? ›

Types of functional testing and examples
  • Unit testing. This type of testing is executed by developers as they write code and build the application. ...
  • Component testing (Module testing) ...
  • Integration testing. ...
  • Regression testing. ...
  • Sanity testing. ...
  • Smoke testing.

What is the smallest number of test cases required to provide 100 branch coverage? ›

So to achieve 100% decision coverage we will need minimum 5 test cases.

What is a finance test? ›

Financial reasoning tests involve questions that require financial knowledge such as looking at business statements, profit and loss accounts and balance sheets. Like numerical reasoning tests, questions will include data in graphs, tables, and text format.

How to do a basic financial analysis? ›

How to conduct a strategic financial analysis
  1. Compare your forecast to your actuals monthly. ...
  2. Identify where you're off track or exceeding projections. ...
  3. Review your Income statement (profit and loss or P&L) ...
  4. Analyze your cash flow statement. ...
  5. Review your balance sheet.
May 25, 2021

How do I get domain knowledge in banking? ›

The banking domain concepts include agency functions performed like managing payables, checks collection, portfolio management etc. Also, the other subpart termed as utility function is provided to customers like demand drafts, locker facility, underwriting and reporting etc.


1. How To Automatically Sync Your Bank Transactions With Excel [Free Download]
(Excel For Freelancers)
2. #shorts #Quickly find duplicate values in microsoft excel sheet
3. How To Create A Fully Automated Expense Tracker With PDF & Image Parsing & OCR In Excel + Download
(Excel For Freelancers)
4. How To Pass Microsoft Excel Test - Get ready for the Interview
(Online Training for Everyone)
5. How to Import CSV File Into Excel
6. How To Track All Of Your Bills & Payments With This Excel Accounts Payable Manager [FREE Download]
(Excel For Freelancers)


Top Articles
Latest Posts
Article information

Author: Stevie Stamm

Last Updated: 15/10/2023

Views: 6379

Rating: 5 / 5 (60 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Stevie Stamm

Birthday: 1996-06-22

Address: Apt. 419 4200 Sipes Estate, East Delmerview, WY 05617

Phone: +342332224300

Job: Future Advertising Analyst

Hobby: Leather crafting, Puzzles, Leather crafting, scrapbook, Urban exploration, Cabaret, Skateboarding

Introduction: My name is Stevie Stamm, I am a colorful, sparkling, splendid, vast, open, hilarious, tender person who loves writing and wants to share my knowledge and understanding with you.