Free Excel Sales Journal Template — Daily Activity Log with Pipeline Tracking
Record daily sales activities (calls, meetings, proposals) and track your pipeline from lead to close. Includes monthly performance dashboard and customer database.
You meet clients and make calls every day, but when someone asks “How many proposals did we send this month?” the answer takes too long to find. This sales journal connects your daily activity records directly to monthly performance analytics — automatically.
Key Features
📝 Daily Activity Logging
- Client name, contact person, and phone/email fields
- Activity type dropdown: Visit / Call / Email / Meeting / Proposal Sent
- Free-text notes field for conversation details
- Next action item + follow-up date
- Pipeline stage tracking: Prospect → Contact → Proposal → Negotiation → Won / Lost
📊 Monthly Performance Dashboard
- Activity breakdown by type (X visits, Y calls, Z proposals…)
- Pipeline summary: number of opportunities and expected revenue per stage
- Win rate (Won / Proposals) calculated automatically
- Client contact frequency heatmap
👥 Customer Database
- Company name, contact person, phone, email, industry, products of interest
- Auto-lookup: selecting a client name on the log sheet fills in contact details
- Last contact date updated automatically
How to Use
Step 1: Register Your Clients
In the “Customer DB” sheet, enter the companies you work with. When logging activities, select the client from a dropdown and contact details auto-populate.
Step 2: Log Daily Activities
On the “Sales Log” sheet, record each activity as it happens. Select the activity type and pipeline stage from dropdowns.
Step 3: Review Performance
The “Dashboard” sheet summarizes your month’s activities, pipeline health, and win rate.
Tips
Use It as a Team Sales Log
Give each rep their own tab and create a “Team Summary” sheet that aggregates everyone’s numbers for management reporting.
Auto-Generate Weekly Reports
The “Weekly Report” sheet auto-compiles that week’s activities every Friday. Copy it into your regular reporting format.
FAQ
Can this integrate with Salesforce or HubSpot?
Not directly, but you can export data as CSV and import it into most CRM platforms.
Can I customize the pipeline stages?
Yes. Edit the stage names and order in the “Settings” sheet. The dropdowns and dashboard will reflect your changes.