I designed and built a custom Airtable platform — CRM, project management, and automated invoicing in one system — to show what a purpose-built tool can replace: it cut admin time by 90% and removed the need for any third-party CRM, task, or billing software.
Admin time reduction
90%
Invoicing and file sync run themselves.
Tools replaced
3
No third-party CRM, task tool, or billing software required.
Manual steps
Zero
Emails, PDFs, and records stay in sync automatically.
Running a small consulting or freelance operation across separate tools is expensive in ways that never show up on an invoice. A CRM in one place, a task manager in another, billing software in a third — managing projects, clients, and invoices across multiple tools is time-consuming, error-prone, and disconnected, with no single view of clients, budgets, or payments.
This is a system I designed and built to show what a custom Airtable platform can replace: a complete CRM, project management, and invoicing operation running in one base, with a background automation layer keeping everything in sync.
A custom Airtable platform combining five components:
The clients view puts everything about a client in one place: a quick read on client lifetime value (CLTV), key business and contract details, Google Drive files and notes, and direct links to every related project and invoice — all on fully customizable fields and layouts.
Projects live on a Kanban board organized by status, each with custom fields and contract terms. Budget used versus remaining is calculated automatically, and the same structure supports hourly, daily, or fixed-fee billing models. A task tracker underneath separates invoiced from non-invoiced work, auto-calculates billable units and budget usage, and keeps due dates and deliverables in one centralized view.
Invoicing takes care of itself. Invoice IDs are auto-generated with custom code, cumulative late fees apply automatically based on each contract's terms, currency conversion happens in real time via an AI lookup, and invoice data flows to accountants through automation.
Two dashboards close the loop: a project dashboard summarizing task status and timelines, and an invoices dashboard showing total invoiced, paid, outstanding, and overdue amounts alongside weekly, monthly, quarterly, and yearly invoicing trends.
The key differentiator sits behind the scenes: a Make.com scenario that keeps emails, files, and records flowing with no manual steps.
The platform cut admin time by 90% — invoicing and file sync run themselves. It provides real-time financial visibility across every client, project, and invoice from a single base. Invoicing is error-free, with late-fee logic applied automatically from contract terms. And it requires no third-party CRM, task tool, or billing software — three subscriptions replaced by one custom system.
Yes. This platform runs CRM, project and task management, and invoicing inside a single Airtable base, so no third-party CRM, task tool, or billing software is required. Clients, projects, tasks, and invoices are all linked records, which means client lifetime value, budget usage, and payment status update automatically as work happens.
Each invoice carries a late-fee percentage based on the contract terms, and the system applies cumulative late fees automatically as the invoice goes overdue. For multi-currency billing, an AI lookup converts the invoice amount to EUR in real time using the conversion rate at the moment the invoice is generated, so reporting stays consistent in one currency.
A background Make.com scenario watches for incoming invoice emails, iterates through the attachments and filters for invoice documents only, uploads the PDFs to Google Drive, parses the invoice text to match the correct records, and updates Airtable instantly with the invoice details and file links — zero manual steps.
Yes — this platform is a demo I designed and built to show what a custom Airtable tool can replace, and every part of it is adaptable: fields, views, billing models, late-fee rules, dashboards, and automations can all be shaped around how your business actually works.