B2B Invoice Payment Patterns
This dataset provides detailed B2B invoice payment histories, including invoice amounts, payment delays, business entity profiles, and payment terms. It enables financial planning, cash flow optimization, and risk assessment by revealing payment patterns and behaviors across industries and geographies.
Sample rows
preview · 8 of 200 rows · all 26 columns| invoice_idstring | payment_statusstring | invoice_amountfloat | discount_appliedboolean | industry_sectorstring | seller_idstring | buyer_idstring | invoice_datedate | due_datedate | payment_datedate | currencystring | payment_delay_daysinteger | late_fee_appliedboolean | seller_namestring | seller_street_addressstring | seller_citystring | seller_statestring | seller_postal_codestring | seller_countrystring | buyer_namestring | buyer_street_addressstring | buyer_citystring | buyer_statestring | buyer_postal_codestring | buyer_countrystring | invoice_termsstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| INV-00001 | paid | 1423.55 | true | Retail | SELLER0021 | BUYER1001 | 2023-01-05 | 2023-02-04 | 2023-02-01 | USD | 0 | false | Bayshore Retail LLC | 950 Market St | San Francisco | CA | 94103 | USA | Urban Solutions Inc. | 21 Broadway Ave | Austin | TX | 78701 | USA | Net 30 |
| INV-00002 | overdue | 2739.1 | false | Services | SELLER0022 | BUYER1002 | 2023-01-10 | 2023-01-24 | 2023-02-02 | USD | 9 | true | Silverleaf Services LLC | 520 Oak Dr | Dallas | TX | 75202 | USA | Midtown Group PLC | 88 Lincoln St | Chicago | IL | 60601 | USA | Net 14 |
| INV-00003 | unpaid | 4998 | false | Manufacturing | SELLER0023 | BUYER1003 | 2023-01-12 | 2023-02-11 | blank | USD | blank | false | Crestview Hospitality Inc. | 1472 Beach Ave | Miami | FL | 33139 | USA | Sunrise Manufacturing GmbH | 11 Werkstrasse | Hamburg | HH | 20095 | Germany | Net 30 |
| INV-00004 | overdue | 70012.25 | false | Luxury Goods | SELLER0024 | BUYER1004 | 2023-01-15 | 2023-01-30 | 2023-02-20 | EUR | 21 | true | EuroTech Solutions GmbH | 17 Bahnhofstrasse | Zurich | ZH | 8001 | Switzerland | Premier Luxury SA | 101 Rue du Rhône | Geneva | GE | 1204 | Switzerland | Net 15 |
| INV-00005 | paid | 655.75 | true | Food | SELLER0025 | BUYER1005 | 2023-01-18 | 2023-02-17 | 2023-02-17 | USD | 0 | false | Greenfield Food Co. | 302 Elm St | Seattle | WA | 98101 | USA | Fresh Eats Ltd. | 65 King St | Toronto | ON | M5H 2N2 | Canada | Net 30 |
| INV-00006 | unpaid | 23870 | false | Technology | SELLER0026 | BUYER1006 | 2023-01-20 | 2023-02-19 | blank | INR | blank | false | Indus Services Pvt Ltd | 12 MG Road | Mumbai | MH | 400001 | India | Skyline Technologies Ltd. | 104 Nehru Place | Delhi | DL | 110019 | India | Net 30 |
| INV-00007 | paid | 98.5 | false | Hospitality | SELLER0027 | BUYER1007 | 2023-01-22 | 2023-01-22 | 2023-01-22 | CAD | 0 | false | Maple Hospitality Ltd. | 812 Queen St | Vancouver | BC | V5K 0A1 | Canada | Northern Events Inc. | 33 1st Ave | Calgary | AB | T2P 1J9 | Canada | Due on Receipt |
| INV-00008 | overdue | 1800.6 | false | Real Estate | SELLER0028 | BUYER1008 | 2023-01-25 | 2023-02-24 | 2023-03-02 | USD | 6 | true | Sunrise Entertainment LLC | 900 Las Vegas Blvd | Las Vegas | NV | 89101 | USA | Pacific Real Estate PLC | 120 Ocean Ave | Los Angeles | CA | 90001 | USA | Net 30 |
| INV-00009 | paid | 1199.99 | true | Automotive | SELLER0029 | BUYER1009 | 2023-01-28 | 2023-02-27 | 2023-02-25 | USD | 0 | false | Bluewater Automotive Inc. | 550 Speedway Rd | Detroit | MI | 48201 | USA | AutoParts Distribution Ltd. | 25 Main St | Columbus | OH | 43215 | USA | Net 30 |
| INV-00010 | unpaid | 150000 | false | Government | SELLER0030 | BUYER1010 | 2023-02-01 | 2023-02-16 | blank | GBP | blank | false | British Gov PLC | 10 Downing St | London | ENG | SW1A 2AA | UK | TechVision Ltd. | 212 Innovation Ave | Manchester | ENG | M1 1AE | UK | Net 15 |
| INV-00011 | overdue | 32810 | false | Healthcare | SELLER0021 | BUYER1011 | 2023-02-05 | 2023-03-07 | 2023-03-10 | JPY | 3 | true | Bayshore Retail LLC | 950 Market St | San Francisco | CA | 94103 | USA | Osaka Healthcare Co. | 7 Nakanoshima | Osaka | OS | 530-0005 | Japan | Net 30 |
| INV-00012 | paid | 88.45 | true | Luxury Goods | SELLER0032 | BUYER1012 | 2023-02-08 | 2023-02-22 | 2023-02-22 | CHF | 0 | false | Swiss Luxury Goods SA | 22 Bahnhofstrasse | Zurich | ZH | 8001 | Switzerland | Geneva Boutique GmbH | 44 Rue du Rhône | Geneva | GE | 1204 | Switzerland | Net 14 |
| INV-00013 | unpaid | 1890000 | false | Real Estate | SELLER0033 | BUYER1013 | 2023-02-10 | 2023-02-25 | blank | USD | blank | false | Pacific Real Estate PLC | 120 Ocean Ave | Los Angeles | CA | 90001 | USA | Sunset Holdings Inc. | 321 Market St | San Diego | CA | 92101 | USA | Net 15 |
| INV-00014 | overdue | 60002.15 | false | Automotive | SELLER0034 | BUYER1014 | 2023-02-13 | 2023-03-15 | 2023-03-23 | CHF | 8 | true | Zurich Manufacturing AG | 50 Fabrikstrasse | Zurich | ZH | 8005 | Switzerland | Davos Automotive SA | 18 Promenade | Davos | GR | 7270 | Switzerland | Net 30 |
| INV-00015 | paid | 22.75 | true | Hospitality | SELLER0035 | BUYER1015 | 2023-02-16 | 2023-02-16 | 2023-02-16 | JPY | 0 | false | Tokyo Foodworks Ltd. | 8 Ginza | Tokyo | TK | 104-0061 | Japan | Kyoto Hospitality Co. | 99 Shijo Dori | Kyoto | KY | 600-8031 | Japan | Due on Receipt |
| INV-00016 | overdue | 10000000 | false | Luxury Goods | SELLER0036 | BUYER1016 | 2023-02-18 | 2023-03-20 | 2023-03-27 | CHF | 7 | true | Geneva Luxury Goods SA | 100 Rue du Rhône | Geneva | GE | 1204 | Switzerland | Zurich Holdings AG | 18 Bahnhofstrasse | Zurich | ZH | 8001 | Switzerland | Net 30 |
| INV-00017 | paid | 135.99 | false | Retail | SELLER0037 | BUYER1017 | 2023-02-20 | 2023-02-20 | 2023-02-20 | INR | 0 | false | Bangalore Services Pvt Ltd | 15 Residency Rd | Bangalore | KA | 560025 | India | Hyderabad Retail Ltd. | 20 Jubilee Hills | Hyderabad | TG | 500033 | India | Due on Receipt |
| INV-00018 | overdue | 12000 | false | Services | SELLER0038 | BUYER1018 | 2023-02-22 | 2023-03-24 | 2023-03-29 | EUR | 5 | true | Frankfurt Real Estate GmbH | 20 Mainzer Landstr | Frankfurt | HE | 60329 | Germany | Berlin Services GmbH | 50 Alexanderplatz | Berlin | BE | 10178 | Germany | Net 30 |
| INV-00019 | unpaid | 750000 | false | Automotive | SELLER0039 | BUYER1019 | 2023-02-25 | 2023-03-27 | blank | EUR | blank | false | Munich Manufacturing GmbH | 9 Bayerstrasse | Munich | BY | 80335 | Germany | Dusseldorf Automotive GmbH | 44 Konigsallee | Dusseldorf | NW | 40212 | Germany | Net 30 |
| INV-00020 | paid | 250 | true | Retail | SELLER0040 | BUYER1020 | 2023-03-01 | 2023-03-01 | 2023-03-01 | USD | 0 | false | Liberty Food Corp. | 10 Liberty St | Boston | MA | 02109 | USA | New England Retail Inc. | 275 Main St | Cambridge | MA | 02142 | USA | Due on Receipt |
What the 200 rows show
from the 200-row samplePaid (payment status) stands out: 45 of its 69 rows have discount_
- 24%discount_
applied = true - 1,793median invoice_
amount - 7currencies
- 7seller countries
- 7invoice termses
- 8buyer countries
Median 1,793, from 22.8 to 10,000,000.
- string 19
- integer 1
- float 1
- date 3
- boolean 2
Columns
26 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 19 columns | |||
invoice_id | string | Unique identifier for the invoiceunique | INV-00001 |
seller_id | string | Unique identifier for the selling business | SELLER0021 |
buyer_id | string | Unique identifier for the buying business | BUYER1001 |
currency | string | Currency code for the invoice amount (ISO 4217)7 currencies | USD |
payment_status | string | Current payment status of the invoicepaid · unpaid · partial · overdue | paid |
seller_name | string | Legal name of the selling business | Bayshore Retail LLC |
seller_street_address | string | Street address of the selling businessoptional | 950 Market St |
seller_city | string | City of the selling businessoptional | San Francisco |
seller_state | string | State or province of the selling businessoptional | CA |
seller_postal_code | string | Postal code of the selling businessoptional | 94103 |
seller_country | string | Country of the selling business7 countries · optional | USA |
buyer_name | string | Legal name of the buying business | Urban Solutions Inc. |
buyer_street_address | string | Street address of the buying businessoptional | 21 Broadway Ave |
buyer_city | string | City of the buying businessoptional | Austin |
buyer_state | string | State or province of the buying businessoptional | TX |
buyer_postal_code | string | Postal code of the buying businessoptional | 78701 |
buyer_country | string | Country of the buying business8 countries · optional | USA |
industry_sector | string | Industry sector of the buyer (e.g., Manufacturing, Retail, Services)12 sectors · optional | Retail |
invoice_terms | string | Payment terms for the invoice (e.g., Net 30, Net 60)7 termses · optional | Net 30 |
| Numbers 2 columns | |||
invoice_amount | float | Total amount due on the invoice0 or more | 1423.55 |
payment_delay_days | integer | Number of days payment was delayed past the due date (0 if paid on or before due date)0 or more · optional | 0 |
| Dates and times 3 columns | |||
invoice_date | date | Date the invoice was issued | 2023-01-05 |
due_date | date | Date payment is due for the invoice | 2023-02-04 |
payment_date | date | Date payment was received for the invoiceoptional | 2023-02-01 |
| True or false 2 columns | |||
discount_applied | boolean | Indicates if any early payment discount was applied | true |
late_fee_applied | boolean | Indicates if any late payment fee was applied | false |
Use it for
A finance dashboard
The discount_
applied rate, invoice_ amount by payment_ status and a breakdown of industry_ sector. Excel, Power BI or Tableau. Why do 47 of 200 rows have discount_
applied = true? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Invoices200INV-000011423.55paidINV-000022739.1overdueINV-00005655.75paid
A software demo
Believable invoices with seller_
id, buyer_ id and invoice_ date to fill a screen in front of a buyer.
blueprint · b2b-invoice-payment-patterns
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 26 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.
- Invoice issue and due dates recorded
- Payment delay classified
- Client sector mapped
- Invoice amount provided
1 credit per row. Preview 20 rows free. Buy rows for the full run.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- b2b-invoice-payment-patterns