Data must include vendor/customer name, document date, document number, and transaction amount. Sort on name and date, and group as needed. Typically, this would be 0-30 days, 31-60 days, etc.
Organize it by the date the data was taken. Then, calculate the mean, mode, and median of the data. Calculate standard deviation, variance, and other information required. That will organize it.
