Below are the sample entries I made using Microsoft Excel when I manually create an Daily reports and Clients Masterfile. I usually use Pivot tables and VLOOKUP.