Excel Pharmacy Sales Dashboard

I need a streamlined Microsoft Excel dashboard that lets me record every sale in my pharmacy and instantly see how much profit I am making. The file should accept daily transaction entries (date, product, quantity, unit cost, selling price, cashier) and then feed a clean, visual dashboard...

(Budget: $10 - $30 USD, Jobs: Analytics, Data Analysis, Data Processing, Data Visualization, Excel, POS development, Visual Basic, Visual Basic for Apps)