There have been numerous requests to summarize sales by day of week, and within month by day of week.  I have created the following spreadsheets to address this issue.

These spreadsheets are not “commercial grade”; what I mean by that is that they have not undergone the level of rigorous testing that commercial grade software does.  They are provided “as-is” and you assume all risk in using them.

Here’s a screenshot of the result using the sample product based company for calendar 2013.

There are four versions of the spreadsheet, as follows (click on the link which is appropriate for your situation).  Files are stored in the “zip” format.

1. You do not use Jobs – Accrual Basis of Accounting
2. You do not use Jobs – Cash Basis of Accounting
3. You use Jobs – Accrual Basis of Accounting*
4. You use Jobs – Cash Basis of Accounting*

* Spreadsheet only supports one level of Jobs; sub-Jobs are not supported at this time

All you need to do is export your “Sales by Customer Detail” report into this spreadsheet and verify the dates used in the summary reflect those dates.  That’s it! — the spreadsheet does the rest.

These spreadsheets are available to registered users of my website (registration is quick, easy and free!) in the “Downloads” area.

I hope you find this useful!