Notion Invoice Template for Freelancers: Create and Track Payments

Tracking invoices across email threads, spreadsheets and your bank account gets messy fast. You send an invoice, forget to follow up, and suddenly realize you’re still waiting on payment from three months ago.

A Notion invoice template keeps your billing, client details, and payment status in one place. You can see which invoices are overdue, calculate your outstanding balance, and link each invoice to the client or project it belongs to—without switching between apps.

This guide walks you through building a flexible invoice tracker in Notion from scratch. You’ll learn how to structure the database, automate status updates, and create views that show exactly what you’re owed and when.

Why Use Notion for Invoice Tracking?

Most freelancers already use Notion for project planning, client notes, or task lists. Adding invoices to the same workspace means you can link billing directly to clients and projects, so every invoice sits alongside the work it’s for.

You can filter invoices by status, sort by due date, and see your total unpaid amount at a glance. Notion’s database features—relations, rollups, and formulas—let you automate calculations and track payment history without manual updates.

Notion won’t replace dedicated invoicing software if you need automatic payment reminders or integrations with accounting tools. But for freelancers who want a simple, visual system to create and track invoices in the same place they manage clients, it’s a solid choice. If you’re already managing client relationships in Notion, check out our Notion CRM template for freelancers to see how invoices can connect to your broader client workflow.

How to Build a Notion Invoice Template Step by Step

Start with a blank Notion page. This will become your invoice hub—a single place to create new invoices, track payments, and review your billing history.

Step 1: Create the Invoices Database

Type /table and select “Table – Inline” to create a new database. Name it “Invoices” and add the following properties:

• Invoice Number (Title): A unique reference for each invoice, like INV-001 or 2024-001
• Client (Relation): Link to a separate Clients database (create one if you don’t have it yet)
• Amount (Number, formatted as currency): The total invoice value
• Issue Date (Date): When you sent the invoice
• Due Date (Date): Payment deadline
• Status (Select): Options like Draft, Sent, Paid, Overdue, Cancelled
• Payment Date (Date): When the client actually paid (leave blank until received)
• Notes (Text): Optional field for payment method, purchase order numbers, or follow-up details

Add a few sample invoices to see how the database looks with real data. Fill in the invoice number, select a client, enter an amount, and set the status.

Step 2: Link Invoices to Clients or Projects

If you already have a Clients database in Notion, create a relation property in your Invoices database that connects to it. Click the + icon to add a new property, choose “Relation,” and select your Clients database.

Now when you create an invoice, you can link it to a specific client. This pulls in client details automatically and lets you see all invoices for a given client in one place.

You can also create a second relation to a Projects database if you bill per project. This way, each invoice ties back to the work it’s for. For more on linking databases, read our tutorial on Notion relations and rollups for project tracking.

Step 3: Add Calculated Properties

Formulas and rollups help you track totals and aging invoices without manual math. Here are three useful calculated properties:

Days Until Due (Formula): Shows how many days are left before the due date. Use this formula:

dateBetween(prop("Due Date"), now(), "days")

A negative number means the invoice is overdue.

Days Overdue (Formula): Displays the number of days past the due date for unpaid invoices. Adjust the formula to show zero if the invoice is paid or not yet due:

if(prop("Status") == "Paid", 0, if(dateBetween(now(), prop("Due Date"), "days") > 0, dateBetween(now(), prop("Due Date"), "days"), 0))

Total Outstanding (Rollup): In your Clients database, add a rollup that sums all unpaid invoice amounts for each client. This shows you which clients owe you money at a glance.

Step 4: Create Filtered Views

Views let you slice your invoices by status, due date, or client. Click “Add a view” at the top of your database and create the following:

• Unpaid: Table view filtered to show only invoices with status “Sent” or “Overdue,” sorted by due date ascending
• Overdue: Table view filtered to show invoices where status is not “Paid” and due date is before today
• Paid This Month: Table view filtered to show invoices with status “Paid” and payment date in the last 30 days
• By Client: Board view grouped by client, so you can see all invoices for each client in columns

These views save you from scrolling through every invoice to find what you need. Switch between them depending on whether you’re following up on late payments or reviewing recent income.

Step 5: Design an Invoice Template Page

Notion databases store the data, but you’ll want a formatted invoice page to share with clients. Inside your Invoices database, open any invoice entry and click “Open as page.”

Add the following sections to the page body:

• Your business details: Name, address, email, and any registration numbers (use a template block or callout so you can duplicate it for new invoices)
• Client details: Pull these from the related client database property or type them manually
• Invoice number and dates: Display the invoice number, issue date, and due date at the top
• Line items table: Create a simple inline table with columns for Description, Quantity, Rate, and Amount
• Total: Add a bold line at the bottom showing the invoice total
• Payment instructions: Include your bank details, payment terms, or a link to online payment (Stripe, PayPal, etc.)

Once you’ve designed one invoice page, duplicate it as a template so every new invoice starts with the same layout. Click the ⋮ menu in your Invoices database, select “New template,” and paste your formatted invoice structure. For step-by-step help customizing templates, see our guide on how to customise a Notion template in 15 minutes.

Step 6: Export or Share Invoices with Clients

Notion doesn’t send invoices directly, so you’ll need to export or share them. Open the invoice page, click the ⋮ menu in the top right, and choose “Export.” Select PDF format and download the file to send via email or cloud storage.

Alternatively, you can share a public link to the invoice page. Click “Share,” toggle “Share to web,” and copy the link. The client can view the invoice in their browser without logging into Notion. If you want a more polished client-facing experience, consider setting up a Notion client portal where clients can access all their invoices, project updates, and files in one secure space.

Automate Invoice Tracking with Rollups and Relations

Once your invoices are linked to clients and projects, you can automate summaries and totals. Use rollup properties to calculate how much each client owes, how much you’ve earned this quarter, or which project generated the most revenue.

For example, in your Clients database, add a rollup that sums all invoices where status is not “Paid.” This gives you an instant view of outstanding balances per client. In your Projects database, roll up paid invoices to see which projects were most profitable.

If you also track expenses, you can build a simple profit-and-loss view by creating a second database for expenses and using rollups to calculate net income. For freelancers who want smarter automation, check out our guide on AI invoice and expense tracking, which covers tools that use AI to read receipts and categorize spending.

Track Payment Status and Follow-Ups

Keeping invoices up to date is easier if you have a routine. Set a weekly reminder to review your “Unpaid” and “Overdue” views. Update the status as payments come in, and add notes about any follow-up emails you sent.

You can also add a Follow-Up Date property (Date type) to schedule when you’ll check in with the client if payment hasn’t arrived. Sort your Unpaid view by follow-up date so you never miss a reminder.

If you’re managing multiple clients and want a more structured follow-up process, our Notion client onboarding checklist includes templates for milestone emails and payment reminders that you can adapt for invoicing workflows.

Connect Invoices to Your Broader Freelance Workflow

A standalone invoice tracker is useful, but it’s even better when it connects to the rest of your freelance business. If you already use Notion for project management, client notes, or contract tracking, link your Invoices database to those systems.

For example, you can create a dashboard page with linked views of upcoming project deadlines, unpaid invoices, and recent client conversations. This gives you a full picture of your business in one glance.

If you run an agile workflow with sprints and backlogs, you might also want to track billable hours or invoice milestones inside your sprint board. The Scrum Board PRO template includes sprint planning, backlog management, and reporting tools that you can customize to add billing milestones or link to your invoices database.

For a comprehensive overview of freelance templates—including client trackers, project boards, and invoice systems—see our roundup of Notion templates for freelancers.

When to Use Notion for Invoices (and When Not To)

Notion works well if you send a few invoices each month, want them linked to your client and project data, and don’t need automated payment reminders or accounting integrations. It’s ideal for freelancers who already live in Notion and want one less app to manage.

You’ll want dedicated invoicing software if you need features like automatic late-payment emails, recurring invoices, online payment buttons, or direct syncs to QuickBooks or Xero. Tools like FreshBooks, Wave, or Zoho Invoice handle those workflows better.

That said, you can use both: generate and track invoices in Notion, then export PDFs to send through a service that handles payment processing. This hybrid approach gives you Notion’s flexibility for tracking and a specialist tool for collections.

Tips for Maintaining Your Notion Invoice System

Once your template is set up, keep it useful with these habits:

• Update status immediately when a payment arrives. Don’t let your Unpaid view fill up with stale data.
• Archive old invoices by adding a “Year” property and filtering views to show only current-year invoices. This keeps your main views fast and focused.
• Back up your database by exporting it as a CSV or Markdown file every quarter. Notion is reliable, but you’ll want a local copy of your financial records.
• Review your invoice template annually to update payment details, terms, or formatting. If you change your business address or add a VAT number, update the template so new invoices reflect the latest info.

If you’re tracking other aspects of your freelance business in Notion—like goals, expenses, or project roadmaps—consider building a unified workspace that links everything together. For more on structuring a complete Notion system, explore our Notion templates collection.

Final Thoughts

A Notion invoice template won’t replace a full accounting system, but it gives you a centralized, visual way to create invoices, track payments, and link billing to your client and project data. You can see what’s overdue, follow up on unpaid invoices, and review your income—all without leaving the workspace where you manage your freelance business.

Start with the basic database structure in this guide, then customize it to fit your workflow. Add views for quarterly earnings, link invoices to time tracking, or build a dashboard that shows your revenue pipeline at a glance. The more you connect invoices to the rest of your Notion workspace, the more useful the system becomes.

Frequently asked questions

Can I accept payments directly through a Notion invoice?

No, Notion doesn't process payments. You'll need to include payment instructions (bank details, PayPal link, or Stripe invoice link) in your Notion invoice page, then export or share it with the client. They'll pay through your chosen method, and you update the invoice status in Notion once the payment arrives.

How do I automatically mark overdue invoices in Notion?

Use a formula property to calculate days overdue, or filter your database views to show invoices where the due date is before today and status is not "Paid." Notion doesn't send automatic reminders, so you'll need to check your Overdue view manually or set a recurring reminder in your calendar.

Can I send invoices from Notion to my accounting software?

Notion doesn't have direct integrations with accounting tools like QuickBooks or Xero. You can export your Invoices database as a CSV and import it into your accounting software, or manually enter invoice data. For automated syncing, you'll need a dedicated invoicing app or a third-party integration tool like Zapier.

Is a Notion invoice template legally valid?

Yes, as long as your invoice includes the required information for your country and business type—typically your business name and address, client details, invoice number, date, itemized services or products, total amount, and payment terms. Check local tax regulations to see if you need to add VAT numbers, tax rates, or other legal details.

How do I duplicate an invoice template in Notion?

Open your Invoices database, click the ⋮ menu, and select "New template." Design your invoice layout inside the template editor, then save it. When you create a new database entry, click the template name to start with your pre-formatted invoice structure.

Can I track expenses in the same Notion workspace as invoices?

Yes, create a separate Expenses database with properties for date, amount, category, and description. You can link expenses to projects or clients using relations, then use rollup formulas to calculate profit (total invoices minus total expenses) per client or project. This gives you a simple profit-and-loss view in one workspace.