Anytime a new shop is created in the database, it is automatically added to my calendar. A new task is then automatically created in my to-do app (Todoist) with the due date set to the shop date. There's a note attached to the task which has two links, one that will open my GPS app (Waze) pre-loaded with the location's address, and another to the MSC's website. (The note also includes any notes I included in the original form when adding the shop.) When I mark the shop task as completed, a second task is automatically created for the report, with the due date of that task set to the report due date I specified in the original form (usually the same or next day). When I complete the report task, it marks the shop as 'finished' back in the database, and adds the value of the shop to the "pending payment" amount for the respective MSC.
This is awesome - I will definitely be looking at getting all of this automated or at least some parts! Way cool.