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

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 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 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. This is not financial or legal advice.

Open the Data Generator

Related tool pages

  • 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: 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: Generate fake student data for class projects: IDs, names, courses, marks and attendance. Download CSV, Excel, JSON or Parquet. Free.
  • 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: Generate sample tables for SQL practice (students, orders, employees), download CSV and query it in your browser. Free.
  • 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

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.