Overview
For businesses that invoice outside of QuickBooks or Xero, Airtable makes a powerful invoice tracking system. This setup creates a central invoice database with automatic overdue alerts and optional automated reminder emails to clients. It's simple enough to set up in an afternoon and saves hours of manual tracking every week.
Before you start
- Airtable account (Pro recommended for automations)
- Invoice data to track
- Client email addresses
Step-by-step guide (4 steps)
Create your invoice tracker base
Set up an Airtable base with these fields: Invoice number, Client name, Client email, Invoice amount, Invoice date, Due date, Status (single select: Sent, Paid, Overdue, Disputed), Payment date, and Notes.
Create an overdue detection formula
Add a formula field: IF(AND(IS_AFTER(TODAY(), {Due date}), {Status}='Sent'), 1, 0). This returns 1 when an invoice is past due but unpaid. Use this field value in your automation conditions.
Add a 'Days Overdue' formula: IF({Status}='Sent', DATETIME_DIFF(TODAY(), {Due date}, 'days'), 0). This helps prioritize follow-ups.
Set up the overdue alert to yourself
Automation trigger: 'When record matches condition: Overdue formula equals 1.' Action: Send yourself an email with the client name, invoice amount, and days overdue. This ensures no invoice goes unnoticed.
Add automated client reminder emails
Create a second automation at 7 days overdue: send an email to the client email field with a friendly payment reminder including the invoice number, amount due, and payment instructions.
What you'll get
Never forget to follow up on overdue invoices
Clients receive consistent, professional reminders
Full invoice history in one searchable database
Quickly see total outstanding receivables at a glance
Common mistakes to avoid
Not setting a Status field (can't distinguish paid from unpaid)
Setting the automation to fire on every record change (use conditions to prevent duplicate alerts)
Forgetting to update Status to Paid after receiving payment
Frequently asked questions
Do I need coding experience to set up this Airtable automation?
No coding is required. This guide walks you through everything using Airtable's built-in features and Zapier's visual interface. If you can follow a recipe, you can follow this guide.
How long does this automation take to set up?
Most users complete this setup in 30–60 minutes on their first try. Once set up, it runs completely automatically with zero ongoing effort.
What happens if the automation fails?
Zapier and Make both have error notifications and task history, so you'll know immediately if something goes wrong. We cover troubleshooting steps in the guide above.
Can I customize this automation for my specific business?
Absolutely. The guide includes notes on common customizations. Most automations have multiple variation points — timing, conditions, notification recipients, and more.