Airtable setup and field reference

Transactions and balances from 12k+ banks land as new records in your base, hourly, daily or weekly, mapped to the columns you already use.

Sample data: Chase Checking and Amex Gold in an example sync at 6:02am into the Finances base.

From bank to Airtable in three steps.

  1. 01

    Connect your bank

    Any of 12k+ banks, read-only, through your bank’s own consent screen.

    ChaseRead-only
    American ExpressRead-only
    ConsentBank’s own screen
  2. 02

    Link Airtable

    Authorise Airtable, pick a base and table, and map bank fields to its fields.

    MerchantDescription · Text
    AmountAmount · Currency
    CategoryCategory · Single select
    DateDate · Date
    AccountAccount · Link
  3. 03

    Pick a schedule

    Hourly, daily or weekly, or on demand. New transactions arrive as new records.

    HourlyDailyWeekly
    Next runTomorrow, 6:00am
    Last run● 3 new rows, 6:02am

Airtable, set up start to finish.

Setting up Airtable in BankSync, filmed with sample accounts.

What lands in your base.

Description
The description the bank gives the transaction. Whole Foods Market
Amount
Signed, in the account’s currency: money out is negative. -$86.42
Category
A spending category you can filter, group and chart by. Groceries
Date
The day the bank posted the transaction. 10/19/2026
Account
The account the row came from, so several banks share one table. Amex Gold
Map them onto the columns you already have, in any order. One row per transaction, keyed so a re-sync never writes it twice.

The same data can also go to spreadsheets, workspaces, AI assistants and your own code.

Airtable, in short.

Data
Transaction date, Amount, Merchant name, Category, Account name, Account balance, Transaction type, Notes, Currency, and Pending status, chosen per feed.
Schedule
Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
History
United States, Canada, and Australia up to 2 years and United Kingdom, Austria, Belgium, Bulgaria, Cyprus, Czechia, Germany, Denmark, Estonia, Spain, Finland, France, Greece, Croatia, Hungary, Ireland, Iceland, Italy, Liechtenstein, Lithuania, Luxembourg, Latvia, Malta, Netherlands, Norway, Poland, Portugal, Romania, Sweden, Slovenia, and Slovakia up to 60 days.
Access
Read-only, authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
Setup
About 10 minutes. Works with Airtable Free and paid plans.
Status
Available today.
Choosing a tool?
See how BankSync syncs bank transactions to Airtable, what it costs, and how it compares.

Questions, answered.

How does the BankSync Airtable integration work?

Connect your bank read-only, connect Airtable and pick where rows go, then map bank fields to your columns. Each scheduled run adds new transactions as new records.

Which fields can BankSync sync to Airtable?

Transaction date, Amount, Merchant name, Category, Account name, Account balance, Transaction type, Notes, Currency, and Pending status. You choose which ones to map, and to which column.

How often does Airtable update?

Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.

Will a re-sync create duplicate records in Airtable?

No. Every transaction is keyed by its bank transaction id, so a re-sync updates or skips it instead of writing it twice.

Can BankSync move money or see my bank password?

No. Access is read-only and authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.

Bank data in Airtable.

BankSync is not affiliated with, endorsed by, or an official partner of Airtable. Airtable trademarks belong to their respective owners.