Sales & Expenses Tracker
A simple Google Sheets template to track your daily sales, expenses, and monthly profit. Watch the quick tutorial below, then download the template.
Dashboard preview (Monthly totals, profit, and trends).
Download the free template
Enter your email to access the tracker instantly.
No spam. Only useful accounting tools and templates.
How to Use the Sales & Expenses Tracker
1. Make a copy of the template
Click on “Make a copy” to save the spreadsheet to your own Google Drive.
2. Record your daily sales
- Enter the date of each sale
- Record sales by payment method (cash, card, deposits)
- Avoid editing formula cells
3. Log your expenses
- Enter vendor name and expense category
- Record the payment method
- Use one row per transaction
4. Review monthly totals
The summary tab automatically calculates total sales, expenses, and profit for each month.
Disclaimer
Disclaimer:
This template is provided for educational purposes and does not replace professional
accounting or tax advice.
How it works
- Record your daily sales (cash, card, deposits).
- Log expenses with category and payment method.
- Review your monthly totals and profit summary.
What’s included
- Sales Log (daily)
- Expenses Log (daily)
- Monthly Summary (auto totals)
- Category breakdown
FAQ
- Is it free? Yes, it’s completely free.
- Do I need Excel? No—this works in Google Sheets.
- Can I customize categories? Yes, you can edit categories anytime.