Finance
25 columns
200 rows
8 formats

Invoice Records

This dataset provides detailed business invoice records, including invoice numbers, customer information, payment terms, due dates, and line item breakdowns with amounts and payment status tracking. It enables comprehensive financial analysis, accounts receivable management, and payment compliance monitoring for businesses of any size.

last updated 29 Oct 2025
by GoMask

The brief that made it

Automated accounts receivable tracking and aging analysis

Sample rows

preview · 8 of 200 rows · all 25 columns

invoice_idstring	payment_statusstring	line_item_quantityfloat	customer_statestring	invoice_numberstring	issue_datedate	due_datedate	customer_idstring	customer_namestring	customer_emailstring	customer_phonestring	customer_street_addressstring	customer_citystring	customer_postal_codestring	customer_countrystring	payment_termsstring	line_item_idstring	line_item_descriptionstring	line_item_unit_pricefloat	line_item_totalfloat	invoice_total_amountfloat	currencystring	payment_datedate	amount_paidfloat	notesstring
INV-00001	Paid	12	NY	2023-001	2023-06-11	2023-07-11	CUST-001	Acme Corporation	billing@acme.com	+1-212-555-0134	123 Main St	New York	10001	USA	Net 30	LI-00001	Consulting services June	500	6000	6000	USD	2023-06-30	6000	Paid in full within terms
INV-00002	Unpaid	1	blank	UK-2023-002	2023-03-15	2023-04-14	CUST-002	Smith & Sons	accounts@smithsons.co.uk	+44-20-7946-0012	22 High Street	London	SW1A 1AA	UK	Net 30	LI-00002	Legal advisory retainer	2800	2800	2800	GBP	blank	0	Awaiting client payment
INV-00003	Overdue	2	blank	FR-2023-003	2022-12-10	2023-01-09	CUST-003	Paris Consulting	contact@parisconsult.fr	+33-1-8765-4321	15 Rue du Commerce	Paris	75015	France	Net 30	LI-00003	Market analysis report	1250	2500	2500	EUR	blank	0	Follow-up sent for overdue invoice
INV-00004	Unpaid	5	blank	INV-004	2023-10-05	2023-11-04	CUST-004	BerlinTech GmbH	finance@berlintech.de	+49-30-1234-5678	Brandenburger Str. 44	Berlin	10117	Germany	Net 30	LI-00004	Software license renewal	980	4900	4900	EUR	blank	0	blank
INV-00005	Paid	150	CA	2023-005	2023-09-01	2023-09-15	CUST-005	Sunrise Grocers	info@sunrisegrocers.com	+1-415-555-0199	234 Market Ave	San Francisco	94103	USA	Net 14	LI-00005	Organic produce delivery	3.75	562.5	562.5	USD	2023-09-10	562.5	Paid early
INV-00006	Cancelled	80	QC	CA-2023-006	2022-06-01	2022-07-01	CUST-006	Montreal Café	blank	+1-514-555-0110	45 Rue Sainte-Catherine	Montreal	H3B 1E7	Canada	Net 30	LI-00006	Coffee supplies	42	3360	3360	CAD	blank	0	Order cancelled by customer
INV-00007	Paid	1	NSW	AUS-23-007	2023-01-15	2023-01-25	CUST-007	Green Gardens Pty Ltd	sales@greengardens.com.au	+61-2-5555-0123	7 Queen St	Sydney	2000	Australia	Net 10	LI-00007	Landscaping monthly service	1200	1200	1200	AUD	2023-01-24	1200	blank
INV-00008	Unpaid	60	blank	JP-2022-008	2022-04-21	2022-04-21	CUST-008	Sushi Zen Co.	info@sushizen.jp	+81-3-5555-0111	1-2-3 Ginza	Tokyo	104-0061	Japan	Due on Receipt	LI-00008	Premium fish shipment	75	4500	4500	JPY	blank	0	Immediate payment requested
INV-00009	Partially Paid	1	FL	INV-009	2023-12-07	2024-01-06	CUST-009	Big Spender Inc.	ar@bigspender.com	+1-305-555-0147	789 Ocean Drive	Miami	33139	USA	Net 30	LI-00009	Enterprise solution package	90000	90000	90000	USD	2023-12-21	45000	Partial payment received
INV-00010	Cancelled	0.01	blank	INV-010	2023-08-12	2023-08-12	CUST-010	Edge Case LLC	edge@case.com	blank	blank	blank	blank	blank	Due on Receipt	LI-00010	Zero value test	0	0	0	USD	blank	0	Invoice issued in error, cancelled
INV-00011	Unpaid	24	MH	INR-2023-011	2023-05-22	2024-05-21	CUST-011	TechNova Pvt Ltd	billing@technova.in	+91-22-5555-0121	101 Tech Park	Mumbai	400001	India	Net 365	LI-00011	Software implementation	2300	55200	55200	INR	blank	0	Annual payment term
INV-00012	Cancelled	0.01	blank	INV-012	2023-04-18	2023-05-18	CUST-012	MinMax Ltd	blank	+44-161-555-0192	400 Crown St	Manchester	M1 2WD	UK	Net 30	LI-00012	Minimal charge test	0.01	0.0001	0.0001	GBP	blank	0	Minimal invoice; cancelled
INV-00013	Paid	120	blank	INV-013	2022-11-11	2022-11-21	CUST-013	Chen Trading	sales@chentrading.cn	+86-10-5555-0138	88 Silk Road	Beijing	100020	China	Net 10	LI-00013	Bulk material order	90	10800	10800	CNY	2022-11-20	10800	Paid before due date
INV-00014	Unpaid	300	blank	INV-014	2023-01-07	2023-01-07	CUST-014	Sushi Zen Co.	blank	+81-3-5555-0111	1-2-3 Ginza	Tokyo	104-0061	Japan	Due on Receipt	LI-00014	Sushi rice bulk	5.5	1650	1650	JPY	blank	0	blank
INV-00015	Partially Paid	1	TX	INV-015	2023-07-07	2023-07-17	CUST-015	Long Term Client	longterm@client.com	blank	555 Longview Ave	Dallas	75201	USA	Net 10	LI-00015	Retainer fee	10000	10000	10000	USD	2023-07-10	8000	Partial payment received
INV-00016	Paid	10	blank	DE-2023-016	2023-02-13	2023-02-23	CUST-016	BerlinTech GmbH	finance@berlintech.de	+49-30-1234-5678	Brandenburger Str. 44	Berlin	10117	Germany	Net 10	LI-00016	IT infrastructure upgrade	750	7500	7500	EUR	2023-02-22	7500	blank
INV-00017	Overdue	50	MA	INV-017	2023-06-01	2023-07-01	CUST-017	The Tiny Store	thetinystore@store.com	+1-617-555-0144	8 Main Plaza	Boston	02108	USA	Net 30	LI-00017	Stationery supplies	7.5	375	375	USD	blank	0	Invoice overdue, reminder sent
INV-00018	Unpaid	120	CA	INV-018	2023-05-10	2023-05-20	CUST-018	Sunrise Grocers	blank	+1-415-555-0199	234 Market Ave	San Francisco	94103	USA	Net 10	LI-00018	Grocery delivery	2.9	348	348	USD	blank	0	blank
INV-00019	Cancelled	1	blank	INV-019	2023-07-23	2023-08-07	CUST-019	Test User	testuser@email.com	blank	blank	blank	blank	blank	Net 15	LI-00019	Test charge	0.01	0.01	0.01	USD	blank	0	Test invoice, cancelled
INV-00020	Paid	2	MH	INR-2023-020	2023-03-11	2023-03-21	CUST-020	TechNova Pvt Ltd	ar@technova.in	+91-22-5555-0121	101 Tech Park	Mumbai	400001	India	Net 10	LI-00020	Monthly maintenance	1800	3600	3600	INR	2023-03-20	3600	blank

What the 200 rows show

from the 200-row sample

10.0median line_item_quantity
9payment termses
9currencies
11customer countries
42customer cities
94.3median line_item_unit_price

payment_status200 rows by value

line_item_quantity200 rows, in bands of 200

Median 10.0, from 0.01 to 2,000.

customer_state127 rows with a value · 73 left blank

NY17
CA16
MH13
QC11
TX10
BE8
NSW7
VIC5
FL4
Tokyo4

25 columns by typefrom the column list below

string 17
float 5
date 3

Columns

25 columns in three groups

blueprint · 25 columns
column	type	description	example
Text 17 columns
`invoice_id`	string	Unique identifier for each invoice recordunique	INV-00001
`invoice_number`	string	Business-facing invoice number, may be different from invoice_idunique	2023-001
`customer_id`	string	Unique identifier for the customer or client	CUST-001
`customer_name`	string	Name of the customer or client	Acme Corporation
`customer_email`	string	Email address of the customeroptional	billing@acme.com
`customer_phone`	string	Phone number of the customeroptional	+1-212-555-0134
`customer_street_address`	string	Street address of the customeroptional	123 Main St
`customer_city`	string	City of the customeroptional	New York
`customer_state`	string	State or province of the customeroptional	NY
`customer_postal_code`	string	Postal code of the customeroptional	10001
`customer_country`	string	Country of the customer11 countries · optional	USA
`payment_terms`	string	Payment terms (e.g., Net 30, Due on Receipt)9 termses	Net 30
`line_item_id`	string	Unique identifier for the line itemunique	LI-00001
`line_item_description`	string	Description of the product or service billed in this line item	Consulting services June
`currency`	string	Currency code for the invoice (e.g., USD, EUR)9 values	USD
`payment_status`	string	Current payment status of the invoiceUnpaid · Partially Paid · Paid · Overdue · Cancelled	Paid
`notes`	string	Additional notes or comments related to the invoiceoptional	Awaiting client payment
Numbers 5 columns
`line_item_quantity`	float	Quantity of the product or service billed0.01 or more	12
`line_item_unit_price`	float	Unit price for the product or service0 or more	500
`line_item_total`	float	Total amount for this line item (quantity x unit price)0 or more	6000
`invoice_total_amount`	float	Total amount of the invoice (sum of all line items)0 or more	6000
`amount_paid`	float	Total amount paid towards the invoice0 or more · optional	6000
Dates and times 3 columns
`issue_date`	date	Date when the invoice was issued	2023-06-11
`due_date`	date	Date by which payment is due	2023-07-11
`payment_date`	date	Date when payment was received (if applicable)optional	2023-06-30

Use it for

A finance dashboard
Line_item_quantity by payment_status and a breakdown of customer_state. Excel, Power BI or Tableau.
What pattern can you find in 200 rows?
A class exercise
Hand out the rows and one question. Everyone works from the same 200 rows.
Invoices200
INV-0000112Paid
INV-000021Unpaid
INV-000032Overdue
A software demo
Believable invoices with invoice_number, issue_date and due_date to fill a screen in front of a buyer.

This dataset200 rows25 columns

Yours1,000 rows25 columnscustomer_street_address: UK only

blueprint · invoice-records

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 25 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.

Rules it was built with

Invoice date before due date
Payment terms: net 30, net 60, due on receipt
Status: unpaid, partially paid, paid, overdue
Late fees applied after due date
Invoice total matches line item sum

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. New accounts start with 25 free credits.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: invoice-records

What should your data show?

No signup. No card.

Sample rows

What the 200 rows show

Columns

Use it for

A finance dashboard

A class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Finance

What should your data show?