# Fake Bank, Loan and Insurance Claims Test Data (IBAN, Credit Score, Claim Status)

> Generate fake bank accounts with valid-format IBANs, loans and insurance claims as CSV, Excel or Parquet. Free banking test data, no real customers.

Page: https://datautility.in/blog/fake-bank-loan-insurance-claims-test-data
This is the Markdown copy of the page. The tool itself runs in the browser: your files are processed on your own device and are not uploaded.

Published 2026-11-15 · Create · fake bank account data, iban test data, loan dataset csv, insurance claims dataset, banking test data

Banking and insurance systems are tested with data that looks real but must never be real. Generate fake bank accounts, loans and insurance claims in your browser and download them for free.

Open the tool: [Data Generator](https://datautility.in/mock-data-generator)

## Three finance and insurance datasets

Bank accounts has an account id, holder name, IBAN, SWIFT-style code, account type, balance, currency, credit score and opening date. Loans has a loan id, customer id, loan type, amount, interest rate, term in months, status and start date. Insurance claims has a claim id, policy number, policy type, claim type, claim amount, status and filing date.

## Numbers that behave

The IBANs use the GB layout and have correct check digits, so they pass an IBAN validator. They are random and are not real accounts. Credit scores follow a bell curve around 690 between 300 and 850. Loan statuses are weighted, so most loans are Current and only a few are in Default. Claim statuses are weighted the same way, with most claims Approved or Paid and some Rejected.

## What to test with it

Check that your form accepts valid IBANs and rejects a changed digit. Test a loan-to-risk report by grouping on status. Build a claims dashboard and a fraud-rule demo that flags claim amounts far above the average for their claim type. In SQL, SELECT claim_type, COUNT(*), ROUND(AVG(claim_amount), 2) FROM insurance_claims GROUP BY claim_type; gives a quick average claim by type. Use [SQL on Your Files](https://datautility.in/sql-on-your-files) to run it in the browser.

## Customer ids that join

Bank account ids start at 700001. After you generate Bank accounts, the related datasets panel offers Loans whose customer ids all exist in your accounts file, so the two join on the customer at any size.

## What it is not

All values are random. They are format-valid, not real, and it is possible, though very unlikely, that a random number matches a real one. Never put the data into a payment system, a sanctions check or anything that sends money. If your tests need personal data hidden from a real file instead, see [data masking for testing](https://datautility.in/data-masking-for-testing). This is not financial or legal advice.

## How to use the Data Generator: step by step

1. Open the Data Generator and pick Bank accounts, Loans or Insurance claims.
2. Choose the number of rows.
3. Pick CSV, Excel, JSON or Parquet.
4. Download the file and load it into your test system.

## When to use the Data Generator

- Test IBAN validation in a form
- Build a loan portfolio dashboard
- Demo an insurance claims workflow
- Practise SQL group by on claim types

## Example

Input:

```
Dataset: Customers, 3 rows
```

Output:

```
id,name,email
1,Maya Patel,maya.patel@example.com
2,Leo Fischer,leo.fischer@example.com
```

## Frequently asked questions

### Are the IBANs real?
No. They have the GB layout and correct check digits, so validators accept them, but the numbers are random and are not real accounts.

### Can I use this data for load testing a payments system?
Use it for data shape and volume tests in your own test environment. Never send it into a live payment, banking or sanctions service.

### Do loans join to bank accounts?
Yes. Generate Bank accounts, then add Loans from the related datasets panel. Every loan customer id is an account id in your accounts file, so a join always matches.

Tip: To test how your system treats missing values, set an empty percentage on the credit score column before you download.

## Related tool pages

- [Fake Data Generator](https://datautility.in/fake-data-generator): Generate realistic fake data online: names, emails, addresses, dates and more, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- [Test Data Generator](https://datautility.in/test-data-generator): Generate test data for databases and apps: names, emails, addresses, dates and numbers, up to 500,000 rows, as CSV, JSON, Parquet or Excel. Free.
- [Student Data Generator: Fake Student Records](https://datautility.in/student-data-generator): Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
- [Student Marks Dataset Generator](https://datautility.in/student-marks-dataset-generator): Create a student marks dataset by student, subject and exam for SQL, Excel pivot tables and charts. Free, in your browser.
- [Sample Data for SQL Practice](https://datautility.in/sample-data-for-sql-practice): Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
- [Dummy Data for Excel Practice](https://datautility.in/dummy-data-for-excel-practice): Generate dummy sales, student or employee data and download Excel to practise filters, pivot tables and VLOOKUP. Free.

## Also try

- [Data masking for testing](https://datautility.in/data-masking-for-testing)
- [Test data without production data](https://datautility.in/blog/test-data-without-production-data)
- [Test data from a schema](https://datautility.in/blog/generate-test-data-from-schema)
- [Free test data generator: all datasets](https://datautility.in/blog/fake-datasets-by-industry-orders-healthcare-finance-climate)

## More guides

- [Free Mock Data Generator: Realistic Test Data in 1 Minute](https://datautility.in/blog/free-mock-data-generator-test-data)
- [Generate Test Data from a CREATE TABLE (500k Rows)](https://datautility.in/blog/generate-test-data-from-schema)
- [Synthetic Data vs Random Fake Data: What Is the Difference?](https://datautility.in/blog/synthetic-data-vs-fake-data-generator)
