Your Business Runs on AirtableAirtable. Your Finances Should Too.

Manage clients in Airtable? Track projects in Airtable? Now sync bank transactions too. Automatically link transactions to clients, projects, and invoices. Build custom financial views, automations, and reports - all in Airtable. Perfect for freelancers, agencies, and small businesses.

14-day free trial • 11k+ banks supported

ABC

Why Airtable for Business Finance

Client & Project Tracking

Link transactions to clients, projects, and invoices. Track expenses per client, calculate profitability, and automate billing workflows.

Custom Automation

Use Airtable automations to categorize expenses, send notifications, update budgets, and trigger workflows when transactions sync.

Powerful Views & Reports

Create custom views, charts, and dashboards. Group by category, filter by date range, and build financial reports with Airtable's interface.

Team Collaboration

Share bases with your team, assign expenses for review, add comments, and collaborate on financial data in real-time.

How much history you can backfill, by market

When you first connect an account, BankSync pulls the history the bank’s open banking provider is willing to return, then keeps it up to date in Airtable. How far back that reaches is decided by the market, not by us — so it differs a lot.

Maximum transaction history and consent renewal period by market
MarketConnected throughTransaction historyAccess renewal
AustraliaFiskil (AU)up to 7 years (2555 days)Re-authorize every year
United States and CanadaPlaid (US)up to 2 years (730 days)No scheduled re-authorization
United KingdomSaltEdge (UK)up to 90 days (90 days)Re-authorize every 180 days

Brokerage accounts are different: they have no transaction feed at all. SnapTrade returns investment activity up to 5 years.

These ceilings are set by each market’s open banking framework and the provider serving it — Australia’s CDR mandates seven years, the UK figure is the PSD2 floor — not by your BankSync plan. How far back an individual bank goes still varies by bank and provider, and long backfills are processed in 7-day chunks, so a multi-year first sync takes a while.

Frequently Asked Questions

Is the bank connection read-only?

Yes. BankSync can only read your financial data. It cannot move money or initiate transfers, change account settings or passwords, access trading features, or apply for financial products. You enter your bank login in the provider’s own secure window — Plaid, Fiskil or SnapTrade, depending on your institution — never in BankSync, and BankSync never sees or stores your bank password.

How often does BankSync sync to Airtable?

You pick the cadence on the feed’s Schedule tab, from four modes: Hourly, Daily, Weekly, or Manual. Which automatic cadences you can choose depends on your plan — Free and Starter run weekly, Standard adds daily, and Professional and above unlock hourly. A manual “Sync Now” works on every plan regardless of the schedule. Scheduled runs happen at the top of the hour in your local time zone, and new rows appear in Airtable when the source provider has made the data available.

What bank data can I sync to Airtable?

Transactions, balances, investment trades, holdings, open orders and loan data, plus receipts, invoices and documents — whichever of these the accounts you selected and their provider actually support. One feed carries exactly one data type, so to send both transactions and balances from the same accounts to Airtable you create two feeds. Investment accounts cannot be mixed with checking or savings accounts in the same feed.

Will re-syncing create duplicate rows in Airtable?

No. BankSync keys every record on the unique identifier the bank’s provider issues and skips records it has already written for that account, so overlapping date ranges, retried jobs and a manual sync minutes before a scheduled one are all safe. Two things to know: two different feeds writing the same account to the same place deduplicate independently, because each feed keeps its own history; and rows you edit or delete yourself are not re-detected. Deliberately re-running a feed from the beginning can create duplicates, so use that sparingly.

How much transaction history do I get on the first sync?

The first run backfills the history the bank’s provider will return, and how far back that reaches is set by the market rather than by your plan: Australia up to 7 years (Fiskil (AU)), United States and Canada up to 2 years (Plaid (US)), and United Kingdom up to 90 days (SaltEdge (UK)). Long backfills are processed in 7-day chunks, so a multi-year first sync takes a while, and how far back an individual bank goes still varies by bank and provider. Balances, holdings and loan data are point-in-time and cannot be backfilled at all — that history starts at your first sync and builds up from there.

How do I disconnect a bank, and what happens to the data already in Airtable?

Disconnect the bank from the Banks tab. If any feed still uses it, remove it from those feeds first. Disconnecting is a soft delete: the bank stays in your list, greyed out with a “Reactivate Bank” option, for about 30 days until the end-of-month cleanup runs. On permanent removal the underlying provider connection is revoked at the source. Data that past syncs already wrote into your Airtable is not touched by disconnecting — it stays exactly where it is.

Does BankSync categorize transactions before they reach Airtable?

Enrichments fill fields on transactions as they sync. Your own rules and the values BankSync has learned from your corrections are applied first; the AI Categorizer runs last and only fills fields that are still empty by then, so it handles the long tail of merchants nothing else could name. Merchant Cleanup does the same for the merchant name, turning a raw descriptor like “SQ *BLUE BTL COF 0442 OAK” into “Blue Bottle Coffee”. The AI Categorizer is in beta and available on Professional plans and above.

Is there a free trial?

All plans include a 14-day free trial. A card is collected at signup, but it is not charged during the trial, and you can cancel before it ends.

Which base and table does BankSync write to?

Airtable connects via OAuth: you authorize BankSync in an Airtable popup and choose which bases to grant access to, and BankSync can only see the bases you grant. In each feed’s Destination tab you then select Base, then Table, and BankSync shows the fields in that table for mapping. If a base is missing from the picker, it usually was not granted — re-run the authorization and add it, which refreshes access in place without disturbing existing feeds.

Start Building in Airtable

Automatic transaction sync from 11,000+ banks. Custom field mapping. Powerful automation. Start your free trial.

14-day free trial • Cancel anytime