Flowgrammer

Airtable Invoice Tracker

Build an Airtable AP invoice register from the published starter schema. No live Copy-base.

— Craig Major

Direct answer

An Airtable invoice tracker is an accounts-payable status register you import and run in Airtable. Each record stores the supplier, invoice number, status, owner, exceptions, and whether a person approved the bill. Airtable holds typed fields and views. It does not extract invoice fields from PDFs, create an accounting draft, certify approval, or send payment. Rebuild formulas after CSV import. Treat attachment download URLs as temporary.

This page implements the published Invoice Tracker in Airtable. The shared field list and sample rows live in the Invoice Tracker Starter Pack. The published Google Sheets Invoice Tracker is the spreadsheet twin. Extraction and destination drafts stay on Invoice Processing Automation. What to automate first stays on Document Processing Automation.

Who this is for

Use this when supplier invoices already arrive and the immediate job is one visible Airtable register: what came in, what is waiting, what is overdue, and what must not be entered twice.

Prerequisites:

  • One buying entity for the first base. The worked example is fictional Cedar and Quay Fabrication Ltd.
  • Agreement that this is an AP status list for bills you received, not a sales-invoice layout you send to customers
  • A named reviewer who can set approval_decision
  • A durable source_ref outside Airtable, because attachment download URLs expire
  • Agreement that posted_ref and paid_ref stay empty until a person confirms those actions in another system

Stay out of this first base: supplier bank-detail changes, tax filings, autonomous payment, OCR, and multi-entity matching.

Canada Planner alternatives data dated 8 September 2026 reported no distinct volume for "Airtable invoice tracker". "Airtable invoice template" sat in the 10-100 band and is usually a sendable customer invoice. This page does not invent demand for the tracker phrase.

This is not an Airtable invoice template

Many Airtable invoice templates are accounts-receivable layouts: logo, bill-to address, line items, and a printable or sendable invoice. That is a different job. This pack is an accounts-payable register for bills you received.

What Airtable implements

The starter pack defines the shared field list. This Airtable twin uses the same names so you can move data without remapping it.

Starter piece Airtable twin
Field dictionary Invoices fields, same names
Status model Single select on status
Duplicate key Formula on duplicate_key after import
Exceptions and roles Exceptions and Roles tables
Sample rows INV-TR-0001-0010 Same fictional Cedar and Quay rows
Dashboard metrics Count views at as-of 8 September 2026
Audit events AuditEvents table

Airtable-native additions that are not a second schema:

  • Single select for currency, status, exception_code, and approval_decision
  • Formula recipes for duplicate_key, amount_delta, days_overdue, aging_bucket, is_overdue, and posted_without_approval
  • Grid views for pending approval, exceptions, overdue, approved unposted, and duplicates
  • Optional attachment field beside durable source_ref
  • A Vendors linked record after you rebuild it

Airtable has no native unique constraint on vendor plus invoice number. The formula and a grouped Duplicates view only show the collision. A person sets status to duplicate.

Import and formula rebuild

Airtable documents CSV and Excel import (Importing third-party data into Airtable, accessed 10 September 2026). Native CSV import accepts files up to 100 MB. Native Excel import accepts files up to 5 MB. Owner or Creator permission is required to import into an existing base.

A CSV import does not create formula fields. Import values, then add the formula fields from the field map. If you import a column named duplicate_key, convert it to a formula after the text lands, or delete the imported column and create the formula field.

This package is a setup and CSV pack. No Flowgrammer public Copy-base or Universe listing was created or verified. Do not treat the download as a live duplicable base.

Attachment durability

Airtable documents that attachment download URLs expire and stay active for at least two hours (Airtable attachment URL behavior, accessed 10 September 2026). Airtable discourages using those URLs as a CDN. Keep a durable source_ref such as a file name, message id, or folder label. Optional source_url may point at Drive or SharePoint. Do not treat an Airtable download URL as the source of truth.

Worked example

Cedar and Quay Fabrication Ltd is a fictional Toronto buyer. Import the CSV pack. Keep the sample as-of date at 8 September 2026.

  1. INV-TR-0001, Ridgemont Industrial Supply Co, INV-TP-2401, CAD 452.00. Status pending_approval. After you rebuild the formula, duplicate_key is ridgemont industrial supply co|inv-tp-2401. No posted_ref. No paid_ref.
  2. INV-TR-0002 uses the same vendor and invoice number on a different file. Status duplicate. The first record is unchanged.
  3. INV-TR-0003, Ashbridge Print Works, blank invoice number. Status exception / missing_invoice_no. duplicate_key stays empty. Two blank numbers are not the same bill.
  4. INV-TR-0004, Prairie Bolt and Fastener Ltd. Printed total 185.00. Subtotal plus tax 220.50. Status exception / conflicting_total.
  5. INV-TR-0005, Humber Station Records Inc. Jordan Hale sets approval_decision to approve. posted_ref stays empty.
  6. INV-TR-0006 is approved and overdue. Follow-up owner is Priya Nair. Still not posted or paid.
  7. INV-TR-0007 has posted_ref QBO-BILL-FICTION-441 recorded after a person confirmed an external draft.
  8. INV-TR-0010 has no owner. Assign one before approval.

Dashboard counts must match the starter as-of 8 September 2026 verification. Do not invent savings numbers from those counts.

Workflow

  1. Create an empty base. Add Invoices, Vendors, Exceptions, Roles, and AuditEvents tables.
  2. Import the CSVs. Map columns by exact header names.
  3. Rebuild formula fields from the field map.
  4. Create the seven views listed in the setup guide.
  5. Share the reviewer as Editor or weaker as needed. Commenter cannot change status.
  6. Drop a new bill into received or validating with a durable source_ref.
  7. A person sets approval_decision before anyone types posted_ref or paid_ref.
  8. Optional automations may email a collaborator when a view fills. They must not approve, post, or pay.

Decision table

Signal Automatic Review Human-only
Required fields present, totals match Move toward pending_approval after validation Reviewer decides Do not auto-approve
Same vendor and invoice number Show duplicate_key group Person marks duplicate First row stays
Blank invoice number Empty duplicate_key Exception missing_invoice_no Do not invent a number
Conflicting total Flag amount_delta Person compares the source Do not overwrite the printed total
Attachment URL older than the documented window Treat as expired Recover from source_ref Do not use as CDN
Destination draft needed None None Person records posted_ref after the external write
Payment None None Person records paid_ref after the external payment

Human gates

A person sets approval_decision. A person judges whether a duplicate_key group is the same bill. A person confirms an external accounting draft before posted_ref. A person confirms payment before paid_ref. Airtable Single select, Collaborator, Interface, and automations are human or notify patterns. They are not a certified AP approval product.

Revision history depth is plan-dependent (Record-level revision history overview). Keep named decisions in AuditEvents. That table is not a financial audit certification.

Notify-only automations

Airtable automations can trigger on create, update, a condition, or a view (Getting started with Airtable automations, accessed 10 September 2026). Run limits and several actions are plan-gated. Free workspaces do not get scripting. Email actions are limited to collaborators on documented plans.

Allowed in this pack: notify a collaborator when Pending approval, Exceptions, or Overdue gains a record.

Forbidden in this pack: set approval_decision, set status to approved, write posted_ref or paid_ref, or call a payment or accounting API.

Do not publish current seat or automation prices from memory. Re-read the plan page on the day you buy.

Failure paths

  • CSV imported and formulas left as text: rebuild them before using views
  • Missing invoice number treated as a duplicate of another blank: keep the key empty
  • Expired attachment URL used as the only copy: recover from source_ref
  • Automation writes approval or posted_ref: remove it
  • Claimed live Copy-base or Universe URL: this pack does not have one
  • OCR or payment connector added: out of scope
  • Unique-constraint claim: Airtable does not provide one on this key

Retry means: fix the source or the mapping, then update the same record_id. Do not create a second invoice record for the same vendor and invoice number.

Test cases

Case Input Expected Acceptance
Clean received INV-TR-0001 pending_approval, empty posted_ref duplicate_key rebuilt
Duplicate INV-TR-0002 status duplicate, first row unchanged Same key grouped
Missing invoice number INV-TR-0003 exception missing_invoice_no Empty key
Conflicting total INV-TR-0004 exception conflicting_total amount_delta flagged
Overdue approved INV-TR-0006 Overdue view Follow-up owner set
Posted after human confirm INV-TR-0007 posted_ref present approval_decision already approve
Missing owner INV-TR-0010 exception missing_owner Cannot approve

Cost and measurement

Count open, exception, overdue, and approved-unposted rows. Those are planning counts. They are not cash savings. Airtable automation runs and revision-history depth depend on the plan in force on the day you check. This page does not invent those numbers.

Asset instructions

Download the Airtable Invoice Tracker Base. Open Setup.md. Import the CSVs. Rebuild the formula fields. Create the seven views. Use the fictional samples as-is. The public resources slug is airtable-invoice-tracker-base so it does not collide with this article slug airtable-invoice-tracker.

Cross-check field names against the live Invoice Tracker Starter Pack. If you want the same schema in a spreadsheet first, use the Google Sheets Invoice Tracker Workbook.

Next step

When one Airtable base, one reviewer, and one destination are no longer enough, the next paid step is a Document Intake and Approval System. Book a fit call when owners, intake paths, or destination writes need a designed workflow. If you are still choosing the first document family, stay on Document Processing Automation.

Sources

FAQ

Does Airtable extract invoice fields from a PDF?

No. Airtable stores or links the file. Extraction stays on the invoice-processing guide and its test pack.

Can I use an attachment URL in an automation or a public page?

Not as a durable file store. Airtable says download URLs expire and should not be used as a CDN. Keep source_ref.

Is this a live Copy-base?

No. This release is a CSV and setup pack. No public Copy-base or Universe listing is claimed.