Creating Individual Statements

I have a spreadsheet full of data that I download from a database and dump into Excel. (I also dump it into a financial software package to generate payments). The problem is that there isn't a good option in the financial software for creating a statement to send with the check. So the recipients oftentimes can't determine why I am paying them what I am.

What I end up with in the Excel spreadsheet is approximately 800 rows by twelve columns of data. Some customers have one row of information, while others may have up to six or seven. Out of the roughly 800 rows are about 400 clients.

What I want to do is create a separate statement for each client that shows the information in the row, will show the one to seven rows of information, and will total the sums. Then I can stuff the individual statement with the check that matches it and my clients will have a better understanding of what I am sending them.

example

Invoice# - client #1 - date1 - date2 - # of days - amount - reason - rate
Invoice# - client #1 - date1 - date2 - # of days - amount - reason - rate
Invoice# - client #1 - date1 - date2 - # of days - amount - reason - rate
Invoice# - client #1 - date1 - date2 - # of days - amount - reason - rate
Total

Invoice# - client #2 - date1 - date2 - # of days - amount - reason - rate
Total

Invoice# - client #3 - date1 - date2 - # of days - amount - reason - rate
Invoice# - client #3 - date1 - date2 - # of days - amount - reason - rate
Total