Test Cases For Bank Application In Excel Sheet & PDF 2022 (2023) (2023)

What We Are Learn On This Post

Test Cases For Banking Application Or Test Scenarios For Banking Application Or Bank Application Test Case: In this post, we are going to learn how to write test cases for banking application in excel sheet. And in our previous post, we also Amazon Search Functionality test case templates. Each bank has its flow for money transfers.

So it is hard to generalize the flow for all the banks. So I am attempting to come up with a stream that most banks are likely to have in their money transfer process. You may find a lot of differences depending on the type of bank that you are using.

Post On:Test Case For Bank Application
Post Type:Test Case Template
Published On:www.softwaretestingo.com
Applicable For:Freshers & Experience
Have You Joined:Our Telegram Group

But before starting writing the test cases for banking applications, you have to understand the below things:

(Video) test cases for Investment banking domain| How To Write Test Cases manual testing| software testing

What is internet banking?

In internet banking, bother customers and organizations are using an electronic method for money transfer using a web application. Currently, in the 21st century, most people are using this method for money transfer because it’s faster, and also no need to wait for a long time in the queue for doing a single transaction.

By using this method, you can able to various operation-related money transfers like receiving money, paying bills, and so many other operations as well.

(Video) How to Write Test Cases in Manual Testing with Template

But when you are dealing with any bank application, both the developer and testers ensure that the app is running smoothly on all browsers and devices. And the web application also secures all cyber threats, and the performance also doesn’t go down during peak business hours.

Test Cases For Bank Application In Excel Sheet & PDF 2022 (2023) (2)

Bank Application Testing

There are several aspects QA specialists prioritize when testing any Bank Application:

  • Functionality Testing: All modules are working as expected (both as an independent elements & after integrating all separate modules)
  • Usability Testing: Mostof the time, those who are using banking applications that are not proficient PC users. So for them, the form should be clear and have a user-friendly interface.
  • Performance Testing: As this is developed for the users, so the performance of the application should be faster. And the app should be working correctly on various platforms.
  • Security Testing: As by using a banking application, people are going to use it for money transfers. So it’s one of the high-priority tasks for the organization to develop the app in such a way that it meets standard guidelines of security.

So in this post, we are going to discuss the natural flow of the Bank Application with some basic scenarios:

(Video) How To Write TEST CASES In Manual Testing | Software Testing

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

Test Steps for Bank Transactions

So here are the necessary steps which we follow when we perform any currency transfer operation:

  • Go to the bank website login page.
  • Input username and password.
  • Go to the money transfer page.
  • Add the beneficiary to whom you want to transfer money.
  • Check the details of the bank account and person. Verify if they are correct.
  • Select the specific money transfer method from NEFT/RTGS or SWIFT transfer options.
  • Select the beneficiary name, and funds, and then submit the details.
  • Verify the amount and other details on the verification page.
  • Click submit for the final action of fund transfer.

Whatever steps you are seen above, that is the fundamental flow that we cover here. And maybe if you go to another region, then it may be something different from the above scenario.

For example, some of you may have SMS authentication before sending the money. Some of you are likely to have other means of verifying the details of the beneficiary to avoid sending the money to the wrong person. But that being said, flow is pretty much the same for most banks.

Another different process followed by different banks maybe when you are going to add a beneficiary whatever fields you are now seeing in the below image possibly vary from bank to bank. So the picture below shows the number of fields that you can validate and write test cases for as well.

Test Cases For Bank Application In Excel Sheet & PDF 2022 (2023) (3)

If you add the test cases for each page, then the test cases will be a lot covering the essential aspects of the tests.

Test Scenarios For Banking Application Money Transfer

  • Verify the bank website URL.
  • Verify if the bank website URL has HTTPS on the address bar and in the URL.
  • Verify if the bank website login page does not appear forged.
  • Verify if the bank login page has a username and password.
  • Verify whether the username and password are being accepted or not.
  • Verify if the SMS authentication is triggered after login.
  • Verify if the user is redirected to the dashboard after passing all authentication processes.
  • Verify if the user has access to the online money transfer feature.
  • Check if the user can transfer funds option is available during the specific period (9 am to 5 pm).
  • Check if the fund transfer option shows notice for off-business hours transactions.
  • Verify if the user can add the beneficiary.
  • Verify if the beneficiary details can be verified.
  • Verify if the fund transfer option allows NEFT or RTGS option for nationalized money transfers.
  • Verify if the fund transfer page asks for the beneficiary name, IFSC code, bank name, fund amount, and purpose of the transfer.
  • Verify if the fund transfer page asks for a PAN number if the number of funds gets over 50k.
  • Check if the fund transfer page has a 2-step authentication before you finalize the transfer.
  • Check if the interbank fund transfer happens instantly or not.
  • Check the amount of time it takes for the funds transferred between the in-business hours.
  • Check the amount of time it takes for the funds transferred between the off-business hours.
  • Check if the amount transferred notification is sent to the sender and receiver.
  • Check if the amount gets transferred to the exact person mentioned in the beneficiary.

Apart from this flow, there are a few other scenarios; also, we are now added to this post. Hope that also gives you a little bit of an idea on writing a banking application test case.

Test Cases For Banking Application – Net Banking Application

  • Check user is able to log in with a valid username and password
  • Check user is able to perform basic financial transactions
  • Check user is able to add a beneficiary with a valid name and account details
  • Check user is able to make financial transactions to the added beneficiary
  • Check user is able to add the decimal number into the amount ( limited by 2 numbers)
  • Check user is not able to add the negative number into the amount field.
  • Check user is allowed to transfer money only if there is a proper account balance.
  • Check there is a confirmation check for financial transactions
  • Check user is given an acknowledgment receipt upon successful financial transaction.
  • Check customer is able to send money to multiple people
  • Check user is allowed to change the password
  • Check account details reflect financial transactions also.
  • Check user with an invalid password is not allowed to log in.
  • Check after repeated attempts to log in with an incorrect password( as per the limits), the user should be blocked.
  • Check time-out feature is implemented
  • Check if either the username or password is blank, the user is not allowed to log in. The user should be given an alert also.

Manual Test Cases For Banking Application – Admin

  • Check admin can log in with valid credentials and is not able to log in with the invalid credential date.
  • Check Admin can log in without the valid test data.
  • Check all the links of the application for the admin role.
  • Check Admin can change the password with valid data and should not allow changing with invalid data.
  • Check that recently used test data should not allow reused again.
  • Check Admin can log in successfully or not.

Banking Application Test Cases – New Branch

  • Check With valid data, you can create a new branch.
  • Check with invalid data. You are not allowed to add a branch.
  • Check to try to create a new branch with the existing test data.
  • Check the reset, cancel & submit button is working as expected or not.
  • Try to Update branch details with valid and invalid test data.
  • Try to update branch details with test data.
  • Update branch details with existing branch test data
  • Check whether the cancel button is working or not.
  • Check branch deletion is allowed with and without dependencies.
  • Check user should be able to search and locate the Branch.

Test Cases For Banking Application In Excel Sheet – New Role

Let us now see some of the sample test cases for the Bank application adding a new role.

(Video) Software testing using excel - How to build test cases

  • Check whether you can create a new role with valid data or not.
  • Check if you can create test data without test data.
  • Verify new role with existing test data
  • Check the role description and role types.
  • Check the Cancel & Submit is working as expected or not.
  • Check if you can delete a role without dependency.
  • Check all the links to the new role are working as expected.

If you want to add a few more points, then let us know about those. Now we will move towards other test cases of Banking applications for customers & visitors.

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

Test Cases For Banking Application In Excel Sheet – Customers & Visitors

  • Check all the links of the Customer and Visitors modules are working as expected.
  • Check all the customers can log in with their valid credentials.
  • Check if the Customer is not able to log in with the invalid date.
  • Check after the number of unsuccessful account access; then, the user account should be locked for that day or not.

Test Cases For Banking Application – Adding New Users

  • Check if you can add a new user with valid data.
  • Check correct validation messages are displayed by entering invalid data.
  • Check after adding a user correct branch details should display.
  • Check all the links are working as expected.
  • Check all buttons are working as expected.
  • Check validation messages are showing when invalid data are entered during updating user details.
  • Check the Warning message when you click the submit button without changing any details during an update.
  • Check to delete user functionality is working as expected or not.

Test Cases For Banking Application Pdf – New Account

  • Check all the mandatory fields and their corresponding validation messages.
  • Check all the optional fields and their corresponding validation messages.
  • Check after filling all the required fields, click the submit, and check whether the new user is added or not.
  • Check after depositing the amount in the account, whether the updated balance is displaying or not.
  • Check whether the user is able to withdraw the amount or not.
  • Check after withdrawing the amount whether the balance is updated or not.
  • Check all the inputted details appearing in the user profile section.
  • Check is there any primary account is provided or not when that’s a secondary account.
  • Check whether the company details are provided or not if that’s a current account.
  • Check whether the proof is provided or not if that’s a joint account.
  • Check zero account is maintained in a salary account.
  • Check if you can maintain zero or less than the minimum balance for a non-salary account.

Test Cases for Bank Account Number Field

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

Bank Account Number: SSSSXXNNNNNNNN (e.g. 35010100008033)

  • SSSS- The first four digits of your Account Number is the Service Outlet ID [SOL ID]
  • XX-The fifth & sixth digit of your Account Number denotes the Scheme Type (01-09).

The various Scheme Types are:

01 – Savings,
02 – Current Account
03 – Term Deposit
04 – Overdraft
05 – Cash Credit
06 – Loans
07 – Packing Credit
08 – Inland Bills
09 – Foreign Bills
81 – FI Accounts under SB 150

NNNNNNNN – The remaining -8- digits denote the running serial number.

Sample Test Cases for Bank account Number Field

  • 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 the account number of more than 14 digits.
  • Check the account number field by entering the account number of fewer than 14 digits.
  • Check the account number by inserting 14 zeros.
  • Check if the accounting field is allowing alphabets and special characters.
  • Check the account number field by entering the alphanumeric value.
  • Check if the account number field is allowing a blank value.
  • Check if any warning message is displayed or not by entering an invalid account number.
  • Check if any message is showing when the user enters an account number that does not exist.
  • Check if the user is allowed to paste the account number in the account number field.
  • Check that when users enter any closed account number.
  • Check that when the user enters an account number with a blank space in between.

Conclusion

(Video) user acceptance testing(UAT) test cases template xls | user registration examples testingshala

I hope we can cover the very basic test scenario of the Bank Application. While going through those in the above scenario, if you find any missing test cases of Bank Application, then you can mention those scenarios in the comment section.

If you want to contribute something on Softwaretestingo.com regarding Bank applications or any other topics or tools, then you can write to us at softwaretestingo.com@gmail.com.

1. Test Cases for Amazon, Flipkart in Excel Sheet.

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

(Video) How To Automatically Sync Your Bank Transactions With Excel [Free Download]

3. How to Write test cases in Excel

4. how to write the test scenarios for Google pay mobile app | testingshala

5. How to Pass Excel Assessment Test For Job Applications - Step by Step Tutorial with XLSX work files

6. 1260 Check & Expense Form 1260 QuickBooks Online 2023

Article information

Author: Melvina Ondricka

Last Updated: 10/06/2023

Views: 6154

Rating: 4.8 / 5 (68 voted)

Reviews: 83% of readers found this page helpful

Author information

Name: Melvina Ondricka

Birthday: 2000-12-23

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

Phone: +636383657021

Job: Dynamic Government Specialist

(Video) How to Insert PDF Files inside Excel

Hobby: Kite flying, Watching movies, Knitting, Model building, Reading, Wood carving, Paintball

Introduction: My name is Melvina Ondricka, I am a helpful, fancy, friendly, innocent, outstanding, courageous, thoughtful person who loves writing and wants to share my knowledge and understanding with you.

FAQs

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.

Which test activity answers the question how to test? ›

- test design answers the question "how to test?" A set of preconditions, inputs, actions (where applicable), expected results and postconditions, developed based on test conditions.

What is a test case with example? ›

A test case is a singular set of actions or instructions for a tester to perform that validates a specific aspect of a product or application functionality. If the test fails, the result might be a software defect that the organization can triage.

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.

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

How do you pass a test test? ›

Follow these study tips to make your best grade!
  1. Get informed. Don't walk into your test unprepared for what you will face. ...
  2. Think like your teacher. ...
  3. Make your own study aids. ...
  4. Practice for the inevitable. ...
  5. Study every day. ...
  6. Cut out the distractions. ...
  7. Divide big concepts from smaller details. ...
  8. Don't neglect the “easy” stuff.

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.

What is basic test case? ›

A test case is a set of actions performed on a system to determine if it satisfies software requirements and functions correctly.

What is the test case format? ›

The test case details the steps, data, prerequisites, and postconditions necessary to verify a feature. It will lay out particular variables that QAs need to compare expected and actual results to conclude if the feature works. Test case components mention input, execution, and expected output/response.

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 tool is best for writing test cases? ›

What is the best tool to write test cases?
  • qTest Manager.
  • PractiTest.
  • Smartbear Zephyr.
  • TestRail.
  • QMetry Test Management.
Jan 18, 2023

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 real life example of manual testing? ›

A real-world example would be a driver pressing the hazard lights button in their car and observing both that: a) the hazard lights begin to toggle, and b) that the indicator lights on the instrument cluster are illuminated. Finally, manual testing is done during the development phase by the team writing the software.

What is an example of a failing test case? ›

An example failing test case would be tbug:{(4000000, 170000), false}, where averageSales is 4000000, current salary is 170000, and the return value is true (expected to be false).

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.

How do you pass 100% on a test? ›

Spend at least 30 minutes studying each day.

To retain the most information, it's best to study for at least 20-30 minutes every day in the weeks leading up to the test. Set aside a 30-minute block of time every day to review your notes, go over your flash cards, read new chapters, and work on practice tests.

How can I study for a test in 2 days? ›

At Home:
  1. Organize your notes. Rewrite or type them up so you can actually read what you've written. ...
  2. Review the material. ...
  3. If you don't already have them, make flashcards with a question, term, or vocabulary word on the front of the card, and the answer on the back.
  4. Stay focused!
Aug 11, 2019

What are 5 testing strategies? ›

However, there are some general test taking strategies that will improve your chances of getting the grade you want on most, if not all, tests.
  1. Listen to the Instructions. ...
  2. Read the Entire Test. ...
  3. Do a “Brain Dump” ...
  4. Answer the Questions You Know First. ...
  5. Answer the Questions You Skipped. ...
  6. Be Sure the Test is Complete.
Sep 29, 2022

What is the basic format of the test plan? ›

The test plan conveys how the test will be performed. This includes defining test objectives, test approach, test tools, test environment, test schedules and team responsibilities and composition.

How do you write a test plan for manual testing with example? ›

How to write a test plan
  1. 1) Learn about the software. Before testing starts, it's important to learn everything you can about the software. ...
  2. 2) Define the scope of testing. ...
  3. 3) Create test cases. ...
  4. 4) Develop a test strategy. ...
  5. 5) Define the test objective. ...
  6. 6) Choose testing tools. ...
  7. 7) Find bugs early. ...
  8. 8) Define your test criteria.
Sep 22, 2021

What are 3 tests of a good test? ›

4 Main Characteristics of a Good Test
  • Characteristic # 1. Validity:
  • Characteristic # 2. Reliability:
  • Characteristic # 3. Objectivity:
  • Characteristic # 4. Norms:

What is the most important part of a test case? ›

The purpose of writing a test case is to test the behaviour of the application, the most important thing in a test case it must inculde both positive and negative test cases of the application.

What must a test case contain? ›

The test case should include its number, a description, the test data, expected result, actual result and status (whether the test passed or failed).

How long does it take to write test cases? ›

For example, it takes about two to three days to build and review a simple test plan without test cases. Creating one test case usually takes about 10 minutes. The more test cases your product needs, the more time you should estimate for their development. However, not all projects require full test case coverage.

How long should a test case be? ›

Not too long or too short

Test suits should be defined so they take between 45 and 90 minutes to run, while still covering a significant area of the system in ”one swoop”.

How do you calculate the number of test cases? ›

Number of Test Cases = (Number of Function Points) × 1.2

Once you have the number of test cases, you can take productivity data from organizational database and arrive at the effort required for testing.

How do you write test cases for internet banking? ›

Test Cases For Net Banking Application
  1. Check if the user is able to open the bank site.
  2. Check if all the links on the site are working.
  3. Verify if the user is able to create a new account.
  4. Check if the user is able to login with a valid and invalid username and password.
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 test bank questions? ›

A test bank is a collection of exam questions and answers that instructors use to assess their students' knowledge and understanding of a subject or course material.

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

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.

Videos

1. Excel Budget Template | Automate your budget in 15 minutes
(Work Smarter Not Harder)
2. How To Pass LinkedIn Excel Assessment Test
(Online Training for Everyone)
3. How To Pass Microsoft Excel Test - Get ready for the Interview
(Online Training for Everyone)
4. Finance Committee - 05 Jun 2023
(District of Metchosin)
5. How to make Summary Report in Excel within 2 minutes, How to Summarize Data in Excel
(Microsoft Office Tutorials)
6. How to Mail Merge with Attachments, Custom Subject & CC / BCC - using Word, Excel, & Outlook
(Kevin Stratvert)

References

Top Articles
Latest Posts
Article information

Author: Ouida Strosin DO

Last Updated: 25/09/2023

Views: 6271

Rating: 4.6 / 5 (76 voted)

Reviews: 91% of readers found this page helpful

Author information

Name: Ouida Strosin DO

Birthday: 1995-04-27

Address: Suite 927 930 Kilback Radial, Candidaville, TN 87795

Phone: +8561498978366

Job: Legacy Manufacturing Specialist

Hobby: Singing, Mountain biking, Water sports, Water sports, Taxidermy, Polo, Pet

Introduction: My name is Ouida Strosin DO, I am a precious, combative, spotless, modern, spotless, beautiful, precious person who loves writing and wants to share my knowledge and understanding with you.