Using Pivot Table (MS Excel)
Daily Cash Transaction Report
MS Excel using Formulas
Note: These are just fictional data.