Notion Template for Freelancer Project and Time Tracker

This comprehensive Notion template is designed specifically for freelancers who need to manage multiple projects, track time accurately, monitor client relationships, and calculate earnings efficiently. Whether you’re a graphic designer, writer, consultant, or any type of freelancer, this template provides everything you need to stay organized and profitable.

What This Template Does

This template serves as your complete freelance business command center, allowing you to:

• Track all client projects from initial contact to completion
• Log time spent on tasks with automatic earnings calculations
• Manage deadlines and project milestones
• Store client information and communication history
• Generate invoice-ready summaries
• Monitor your overall business performance

Who This Template Is For

• Solo freelancers managing multiple clients
• Consultants tracking billable hours
• Creative professionals juggling various projects
• Service providers needing organized client management
• Anyone transitioning from employee to freelancer
• Freelancers looking to professionalize their workflow

Template Sections and Fields

1. Projects Database

Purpose: Central hub for all your freelance projects

Fields:

• Project Name (Title): Unique identifier for each project
• Client (Relation): Links to client database
• Status (Select): Not Started, In Progress, Under Review, Completed, On Hold
• Project Type (Select): Website Design, Content Writing, Consulting, Marketing, Development, Other
• Start Date (Date): Project commencement date
• Deadline (Date): Final delivery date
• Budget (Number): Total project value
• Hourly Rate (Number): Rate per hour for time-based projects
• Total Hours (Rollup): Automatically calculated from time entries
• Total Earned (Formula): Calculates earnings based on hours and rate
• Progress (Select): 0%, 25%, 50%, 75%, 100%
• Priority (Select): Low, Medium, High, Urgent
• Description (Text): Detailed project scope and requirements
• Deliverables (Text): List of expected outputs
• Notes (Text): Additional project information

2. Time Tracking Database

Purpose: Log all work sessions with precise time tracking

Fields:

• Date (Date): When the work was performed
• Project (Relation): Links to projects database
• Task Description (Title): Brief description of work done
• Start Time (Date with time): Work session start
• End Time (Date with time): Work session end
• Duration (Formula): Automatically calculates time spent
• Hourly Rate (Rollup): Pulls rate from related project
• Earnings (Formula): Calculates session earnings
• Billable (Checkbox): Whether time can be invoiced
• Category (Select): Design, Writing, Research, Meeting, Admin, Revision
• Notes (Text): Additional details about the work

3. Clients Database

Purpose: Comprehensive client relationship management

Fields:

• Client Name (Title): Company or individual name
• Contact Person (Text): Primary point of contact
• Email (Email): Primary contact email
• Phone (Phone): Contact phone number
• Company (Text): Client’s company name
• Address (Text): Billing address
• Status (Select): Active, Inactive, Prospect, Former
• Payment Terms (Select): Net 15, Net 30, Net 45, Upon Completion
• Preferred Communication (Select): Email, Phone, Slack, Teams
• Total Projects (Rollup): Count of projects for this client
• Total Earned (Rollup): Total earnings from this client
• Notes (Text): Important client information
• Contracts (Files): Uploaded contract documents

4. Invoices Database

Purpose: Track billing and payment status

Fields:

• Invoice Number (Title): Unique invoice identifier
• Client (Relation): Links to clients database
• Project (Relation): Associated project
• Invoice Date (Date): When invoice was sent
• Due Date (Date): Payment due date
• Amount (Number): Invoice total
• Status (Select): Draft, Sent, Overdue, Paid, Cancelled
• Payment Date (Date): When payment was received
• Payment Method (Select): Bank Transfer, PayPal, Check, Credit Card
• Notes (Text): Additional billing information

5. Dashboard View

Purpose: Overview of business performance and current status

Components:

• Active projects counter
• This month’s earnings
• Outstanding invoices
• Upcoming deadlines
• Time logged this week
• Top clients by earnings
• Project status distribution

Step-by-Step Instructions

Initial Setup

1. Duplicate the template using the link below
2. Customize rate settings by updating your standard hourly rates
3. Set up your first client in the Clients database
4. Create your first project linking it to the client
5. Configure your preferred project categories and statuses

Daily Workflow

1. Start your work session:

   • Open the Time Tracking database
   • Click “New” to create a time entry
   • Select your project from the relation field
   • Enter start time and task description

2. Log your work:

   • Update the task description as you work
   • Mark whether the time is billable
   • Add any relevant notes about the work performed

3. End your session:

   • Enter the end time
   • Verify the duration calculation is correct
   • Ensure the project relation is properly set

Project Management

1. Create new projects:

   • Add project details including budget and timeline
   • Set the appropriate priority level
   • Link to the correct client
   • Define clear deliverables

2. Track progress:

   • Update project status regularly
   • Monitor time spent vs. budget
   • Adjust deadlines if necessary
   • Update progress percentage

3. Project completion:

   • Mark project as completed
   • Generate invoice from tracked time
   • Archive completed projects
   • Update client relationship status

Monthly Review

1. Review dashboard metrics:

   • Analyze earnings trends
   • Identify top-performing clients
   • Review time allocation across projects

2. Clean up data:

   • Archive completed projects
   • Update client statuses
   • Review and adjust hourly rates

3. Plan ahead:

   • Review upcoming deadlines
   • Follow up on overdue invoices
   • Plan capacity for new projects

Duplicate this template for free

FAQ

Q: How do I handle projects with different billing structures?

A: The template supports both hourly and fixed-rate projects. For fixed-rate projects, enter the total budget in the Budget field and leave the hourly rate blank. For hourly projects, set your rate in the Hourly Rate field. The template will automatically calculate earnings based on tracked time for hourly projects, while fixed-rate projects will show the full budget amount.

Q: Can I track non-billable time like admin work or business development?

A: Yes! Each time entry has a “Billable” checkbox that you can uncheck for non-billable work. This allows you to track all your time while keeping billable and non-billable hours separate for accurate client billing. You can create projects for internal work like “Business Development” or “Administration” to categorize this time.

Q: How do I generate invoices from my tracked time?

A: While this template tracks all the data you need for invoicing, you’ll need to export the information to your preferred invoicing tool. You can filter the Time Tracking database by project and billable status, then copy the relevant data. The Projects database shows total billable hours and earnings, making it easy to create accurate invoices.

---

🚀 Get the Complete Freelancer Business Bundle

Ready to take your freel