Skip to content
OpenInstall

Expenses

Open in Airtable

Purpose

Captures every company out‑of‑pocket cost—receipts, subscriptions, travel, services—so we can track profitability by client and feed monthly cash‑flow projections.

Fields

TypeFieldKey Options / FormulaNotes
A
Expense IDManual; suggest YYYYMMDD-vendor-seqHuman-readable slug that appears on the PDF receipt link.
DateFormat lUse receipt / invoice date, not payment date.
AmountPrecision 2Enter positive value; cash-flow layer flips sign.
Category▫︎ Office Supplies ▫︎ Travel ▫︎ Meals ▫︎ Utilities ▫︎ Miscellaneous ▫︎ ServicesExpand list as needed for reporting granularity.
AttachmentsUpload PDF or photo of receipt; name files sensibly.
ClientTag expense to a customer for pass-through or margin analysis. Optional.
Cashflow itemsCreated automatically via script; amount comes in as negative for cash analysis.

Relationships

Gotchas

  • Positive vs negative: keep Amount positive; downstream formula in Cashflow items multiplies by ‑1 so expenses appear as outflows.
  • Categorise consistently; dashboards rely on Category for cost‑centre charts. Create new options sparingly.
  • Client link is optional: Link only if the cost is project‑specific; leave blank for overheads.
  • Large file uploads (>5 MB) slow sync—compress images before attaching.

Calculated & AI fields

The Cashflow items linkage automatically creates negative cash flow entries for expense tracking, ensuring accurate financial projections. The Category field enables automated cost analysis and reporting across different business functions.