The Excel Past Due Invoice Data Set

This is a fabricated sample data set that is meant to be used for practicing and training your Excel skills.

This data set in particular is made for those who work in Accounts Receivable or Finance.

Here is a list of fields that are included in the data set:

• Invoice ID
  
• Customer Name
  
• Order ID
  
• Product ID
  
• Product Description
  
• Invoice Qty
  
• Subtotal
  
• Taxes
  
• Total
  
• Payment Due Date
  
• Days Past Due
  
• Aged Category
  

Using this data, you can practice building aged receivables dashboard models that could include things like aged category with largest sum/total value past due, customer with the most past due receivables, oldest invoice and value required and left to collect etc...

This data set is meant only to be used for Excel training and practice.