Supplier Invoice Payment Timelines

This dataset provides detailed, chronological records of supplier invoices, including submission, due, and payment dates, amounts, and payment statuses. It enables comprehensive analysis of cash flow, payment compliance, and supplier management, supporting audit, financial planning, and process optimization. The flat structure makes it ideal for integration with BI tools and compliance reporting systems.

  • last updated 29 Jul 2025
  • by GoMask
The brief that made it

Cash flow analysis and forecasting

Sample rows

preview · 8 of 200 rows · all 19 columns
invoice_idstringpayment_statusstringinvoice_amountfloatis_overduebooleanpayment_methodstringsupplier_idstringsupplier_namestringsupplier_tax_idstringinvoice_numberstringinvoice_datedateinvoice_due_datedateinvoice_submission_datedatecurrencystringpayment_datedatepayment_amountfloatpayment_referencestringdays_to_paymentintegercreated_atdatetimeupdated_atdatetime
INV-00001paid495.25falsebank_transferSUP-00001Northland Foods Inc.US112233445NF-20240101-0012024-01-022024-01-172024-01-03USD2024-01-10495.25TRX20240110A72024-01-03T10:32:192024-01-10T13:05:22
INV-00002paid12250falsebank_transferSUP-00002Rapid-IT Services Ltd.GB998877665RIT-INV-10012024-01-052024-01-202024-01-06GBP2024-01-1812250TRX20240118R122024-01-06T11:09:142024-01-18T15:20:19
INV-00003paid3050.75falsebank_transferSUP-00003EuroChem LogisticsDE445566778ECL-24-01152024-01-102024-01-252024-01-11EUR2024-01-233050.75SEPA20240123122024-01-11T09:00:002024-01-23T12:01:33
INV-00004pending187falseblankSUP-00001Northland Foods Inc.US112233445NF-20240110-0022024-01-102024-02-092024-01-12USDblankblankblankblank2024-01-12T10:45:342024-01-12T10:45:34
INV-00005overdue2415000trueblankSUP-00004AsiaTech ComponentsCN334455667ATC-INV-2024-0032024-01-152024-02-152024-01-16CNYblankblankblankblank2024-01-16T12:00:002024-03-01T14:53:20
INV-00006paid876.4falsecredit_cardSUP-00005Global Office SuppliesUS556677889GOS-2024-01162024-01-142024-01-292024-01-15USD2024-01-25876.4CC20240125F102024-01-15T08:12:122024-01-25T17:14:57
INV-00007paid21500truebank_transferSUP-00006Bright Energy SolutionsSE990011223BES-2401-0042024-01-182024-02-022024-01-19SEK2024-02-0521500TRX-SE-240205172024-01-19T10:04:082024-02-05T16:36:11
INV-00008cancelled0falseblankSUP-00007Pacific Seafood Corp.blankPSC-2024-172024-01-202024-02-042024-01-21USDblankblankblankblank2024-01-21T08:59:592024-01-21T08:59:59

What the 200 rows show

from the 200-row sample

Overdue (payment status) stands out: 28 of its 28 rows have is_overdue = true, against 21 of 172 for the rest.

  • 25%is_overdue = true
  • 850.7median invoice_amount
  • 9currencies
  • 895.4median payment_amount
  • 12median days_to_payment
Is overdue rate by payment_statusis_overdue = true
0%50%100%2%pending1 of 5021%paid20 of 940%partial0 of 8100%overdue28 of 280%cancel…0 of 20
invoice_amount200 rows, in bands of 500k
09018018074222100202.5M5Minvoice_amount →

Median 850.7, from 0.0 to 5,000,000.

payment_method102 rows with a value · 98 left blank
  1. bank_transfer52
  2. cash28
  3. credit_card9
  4. check8
  5. other5
19 columns by typefrom the column list below
  • string 9
  • integer 1
  • float 2
  • date 4
  • datetime 2
  • boolean 1

Columns

19 columns in four groups
blueprint · 19 columns
columntypedescriptionexample
Text 9 columns
invoice_idstringUnique identifier for each supplier invoice.uniqueINV-00001
supplier_idstringUnique identifier for the supplier associated with the invoice.SUP-00001
supplier_namestringFull legal name of the supplier.Northland Foods Inc.
supplier_tax_idstringTax identification number of the supplier.optionalUS112233445
invoice_numberstringSupplier's invoice number as provided on the document.NF-20240101-001
currencystringThree-letter ISO currency code for the invoice amount (e.g., USD, EUR).9 currenciesUSD
payment_methodstringMethod used to pay the invoice (e.g., bank_transfer, check, credit_card, cash).bank_transfer · check · credit_card · cash · other · optionalbank_transfer
payment_referencestringReference or transaction number for the payment.optionalTRX20240110A
payment_statusstringCurrent payment status of the invoice.pending · paid · partial · overdue · cancelledpaid
Numbers 3 columns
invoice_amountfloatTotal amount billed on the invoice, in the invoice currency.0 or more495.25
payment_amountfloatAmount paid to the supplier for this invoice.0 or more · optional495.25
days_to_paymentintegerNumber of days between invoice submission and payment date (null if unpaid).0 or more · optional7
Dates and times 6 columns
invoice_datedateDate the invoice was issued by the supplier.2024-01-02
invoice_due_datedateDate by which the invoice payment is due.2024-01-17
invoice_submission_datedateDate the invoice was received/submitted to the company.2024-01-03
payment_datedateDate the invoice was paid.optional2024-01-10
created_atdatetimeTimestamp when the invoice record was created in the system.2024-01-03T10:32:19
updated_atdatetimeTimestamp when the invoice record was last updated.2024-01-10T13:05:22
True or false 1 column
is_overduebooleanIndicates if the invoice was paid after the due date or remains unpaid past due date.false

Use it for

  • is overdue25%49 of 200 rowsmean invoice amount b…53.6kpend…6kpaid2.7kpart…1.2Mover…

    A finance dashboard

    The is_overdue rate, invoice_amount by payment_status and a breakdown of payment_method. Excel, Power BI or Tableau.

  • Why do 49 of 200 rows have is_overdue = true?

    A root-cause class exercise

    Hand out the rows and one question. The answer is in the data, not in the brief.

  • A software demo

    Believable invoices with supplier_id, supplier_name and supplier_tax_id to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 19 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

1,000 rows: $1.99 · 10,000: $12.99One-time. No subscription. All prices

This dataset200 rows19 columns
Yours1,000 rows19 columns

blueprint · supplier-invoice-payment-timelines

Behind this dataset

Same schema. As many rows as you need.

These 200 rows came out of a blueprint — 19 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
  • Track invoice issue and payment dates
  • Log supplier and payment method
  • Flag late payments
  • Exclude tax identifiers
Rows
Open the blueprint in Data Factory

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
supplier-invoice-payment-timelines

More in Finance

Browse all
Also in FinanceInvoice RecordsTransaction Categorization DatasetFinancial Statement Fraud IndicatorsAll 1,966 datasets

What should your data show?

Preview 20 rows free
No signup. No card.