On the 28th of every month at 17:00, list all paid Shop orders from the 28th of the previous month until today.
Group them by company, then by member, and show each order's date, product, quantity, and amount. Add a total for each member and each company, and put members without a company in a separate group at the end.
Email the report to [your email address] with a table for each company and the grand total at the top.