Airtable in your books

Airtable is a flexible database. In the ledger it's nothing at all, because no money moves through it and it never becomes an account. What it holds is the context around spending: which vendor was approved, who owns the contract, which department a purchase belongs to and when it renews.

An approval base is a good front door. It records what someone meant to spend before a card is charged or a bill arrives. That's also why its totals won't match the books: an approved purchase can be cancelled, come in higher, or land in a later month.

Any record can be edited or deleted, nothing forces it to balance, and a month you've already reported can change without a trace. The expense figures live in QuickBooks Online or Xero, where every entry has an audit trail. Treat the base as the request and the ledger as what happened.

After the books are closed, put the tracker's totals by vendor or department next to the same view from the ledger for the same month. Most gaps are timing. A bill that's approved but hasn't arrived may belong in accrued expenses, and a charge nobody logged needs a line in the tracker.

Write down each difference and what caused it. A gap you can explain is fine. One you can't is the first sign the tracker has drifted.

Accounts payable is where approved bills become real obligations. Google Sheets has the same limits as a ledger, and for the same reasons.