I need a single Google Sheet that I can open each day, type in the latest sales and purchase figures, and have every total, balance, and daily-to-monthly summary fill in automatically. The sheet only has to accommodate both sales and purchase data; no inventory or payroll modules are required right now. Because I will be entering the numbers manually, the focus is on dependable formulas, clear date-driven summaries, and error-proof data entry ranges rather than API connections or file uploads. A clean, no-frills layout is fine: simple columns for date, description, amount, and category are enough as long as the back-end calculations roll everything into daily, weekly, and month-to-date dashboards. Conditional formatting to flag negative margins, a running cash-flow line, and separate tabs for raw entries versus summaries will cover the essentials. Deliverable • A shareable Google Sheet set up with protected formula cells, ready for manual inputs. • Built-in calculations for daily totals, cumulative monthly totals, and an automatic profit figure (sales minus purchases). • Brief inline notes so anyone can understand where to type and how the numbers flow. Once the file is transferred I will test it with a week’s worth of dummy data—if the totals, summaries, and profit calculation update correctly, the job is done.