Welcome to Fintable! This comprehensive guide will help you understand and effectively use Fintable to manage your financial data in Airtable and Google Sheets.

🚀 Getting Started

What is Fintable?

Fintable automatically syncs your bank transactions, account balances, and financial data directly into Airtable or Google Sheets. It connects to your bank accounts, investment providers, credit cards, and other financial institutions securely and keeps your spreadsheets up to date without manual data entry.

High-Level Overview

Getting started with Fintable involves a few simple steps.

Sign up at Fintable.io
Connect your bank accounts through our secure connection process
Set up your Airtable base or Google Sheets integration
Watch your transactions sync automatically every day

That's it! We try to do one thing, and do it well: reliably sync your financial data into your spreadsheets.

🏦 Bank Connections

Comparing Providers (Plaid, GoCardless (Nordigen), Akoya, etc.)

Plaid

Only supports US and Canadian banks
Realtime syncs and scheduled syncs are available but expensive. We need to calculate a charge for this based on your usage.
Usually only 2 years of historical data available
The largest bank network in the US and Canada, but still many connection issues with major banks like Chase and American Express.
Currently we do not support investment holdings data or Liabilities through Plaid, but we are working on this.

GoCardless (Nordigen)

Supports EU banks through Open Banking
Usually 7+ years of historical data available
Does not support frequent syncs, but allows for daily syncs. Rate limits apply (officially 4 requests per day), although in practice this is usually twice per day.
Need to be reconnected every 90 days due to Open Banking regulations. Sometimes duplicates occur when reconnecting.

Akoya

Supports US banks through Open Banking (more secure than Plaid)
Supports realtime syncs and scheduled syncs
Support investment holdings data for institutions like Fidelity

SnapTrade

Only supports investment accounts (stocks, ETFs, etc.)

Tabs

Fintable's in-house bank connections built by directly connecting to bank APIs
Usually the fastest and most reliable connections with support for very frequent syncs
Supports only two banks at the moment (Mercury and PrivatBank for Business), but more coming soon

Connecting Your Bank

To connect your bank account:

Log into your Fintable Dashboard
Click the Connect button from the main dashboard or "New Connection" from the left sidebar
Search for your bank or financial institution
Follow the secure authentication process through your bank's website. This part is not handled by Fintable but by our bank connection providers (Plaid or GoCardless (Nordigen)).
Select which accounts you want to sync. This is usually done on the bank's website during the authentication process, but you can also disable accounts later in the Connection Settings.
Set your Sync Start Date (how far back you want transactions). See the Sync Start Date section below for details.
Run a manual sync to fetch your initial data.

Sync Start Date: Retrieving Historical Transactions

When you connect a new account, Fintable only fetches 30 days of transaction history by default. However, you can adjust this to retrieve more historical data.

Note that the maximum historical data available depends on your bank and the connection provider. Most providers like Plaid can retrieve about 2 years of history. Some like GoCardless may be able to provide up to 7 years or more.

Set the Sync Start Date for all accounts

Click the dropdown next to Connect button
Select Sync Start Date
Choose the date you want to start syncing
Click Save to apply the changes, and then run a manual sync

Set the Sync Start Date for specific accounts

Click a specific bank connection
Go to Connection Settings
Adjust the Sync Start Date field for each account separate or modify the Sync Start Date for all accounts in the connection
Allow up to one hour for historical data to sync

After setting the Sync Start Date, you will need to re-run a manual sync.

How and When to Run a Sync

1. Automatic Daily Sync

Your accounts sync automatically every 6-23 hours. The system varies the timing to distribute load and comply with bank API limits. Currently we are not able to adjust the daily sync time, but this is a feature we are considering for the future.

2. Manual Retry Daily Sync

If you adjust the Sync Start Date, add a new spreadsheet integration, or adjust other settings, you can manually trigger a sync from your dashboard. This will not actually fetch new transactions from the bank data provider but will simply re-run the sync process to reflect your new settings.

To manually trigger a sync: use the "Sync Now" button in your dashboard beside each bank connection.

3. Realtime Sync

Office and Enterprise users can trigger "on-demand" or "realtime" syncs from their dashboard for immediate updates. This will make an attempt to fetch new transactions from the bank data provider immediately, including transactions that were made in the past hour. Note that this is not guaranteed to work for all banks, as some banks may not provide real-time data updates, and providers such as GoCardless have rate limits of 4 requests per day.

4. Sync Schedule Requests

If you need more frequent syncs, or need to run a sync at a specific time, you can request a custom sync schedule. This is available for Office and Enterprise plans. To do this, go to your Connection Settings and click the Request a Custom Sync Schedule button. Our team will review your request and get back to you.

Re-Authenticating Bank Connections

Banks require periodic re-authentication for security, or if the connection fails.

EU Banks: Re-authenticate every 90 days due to Open Banking regulations.

To re-authenticate:

Go to Connection Settings
Look for connections marked with a red indicator
Click Reconnect and follow the prompts
Complete the authentication through your bank's website

You may also delete and re-add the connection if you prefer to start fresh. However, take care to either adjust the Sync Start Date or delete the existing data first, to avoid duplicate transactions.

MFA or Two-Factor Authentication

If your bank is connected through Plaid, and you have multi-factor authentication (MFA) enabled, you may need to reconnect your bank every day or every sync. This is a limitation of Plaid's connection method and is not something we can control.

💰 Data Fields (Columns)

We attempt to standardize and aggregate data from different banks and providers into a simple format documented below. Some fields are optional and need to be configured and added manually - they are NOT synced by default.

Currently, Fintable does not allow you to rename any of the required or optional fields in Airtable. In Google Sheets, however, you can rename the columns as you wish.

If you can't find a field, check the Raw Data

If you are looking for a data point not listed here, first check the optional columns section below, and then check the raw data from the provider to see if that data point is available. Common data points that our customers look for include: "IBAN number of counterparty", "reference number", "invoice IDs" or other metadata to reconcile and settle payments. Unfortunately, these data points are not always available from the bank data providers, but if they are, we can help you add them as a custom column.

Transaction Raw Data

The raw transaction data is available in the Raw Data column in Airtable or Google Sheets. It is also available in the Transaction Details section in the Fintable dashboard. Find the transaction you are interested in, and click the "..." dropdown to find the "View Raw Data" button.

Account Raw Data

The raw account data is available in the Connection Settings section in the Fintable dashboard. Under the Account Settings section, click the Settings button next to the account you are interested in, and then click the "Raw data from Account API provider" accordion.

Default Fields (Required)

Fintable only updates specific fields (marked with *asterisks in Airtable)
Fields with a single asterisk (*) are never overwritten by Fintable if you modify them, but fields with two asterisks (**) are overwritten upon a Force Re-Sync

To see whether your fields/columns are set up correctly, you can use the Validate button in your Airtable or Google Sheets integration settings.

Account Fields:

**Account Name: The name of your bank account (may be edited on the dashboard)
**XXX Balance: Current account balance where XXX is the currency code (e.g., USD, EUR, GBP)
**Institution: Bank or financial institution name (may be edited on the dashboard)
**Last Update: When account was last synced with the provider (manual retry syncs will not update this)
**Account ID: Unique account identifier

Transaction Fields:

*Name: Transaction description
**Date: Transaction date
**XXX: Transaction amount in account currency (where XXX is the currency code, e.g., USD, EUR, GBP)
**Account: Which account the transaction belongs to
**Category: Transaction category
**Plaid TX ID: Unique transaction identifier (for legacy reasons, still called Plaid TX ID, but it actually applies to all providers)

Optional Fields (Add Manually)

Available Balance Fields:

**USD Available: Current available balance for spending
**EUR Available: Available balance for EUR accounts
**GBP Available: Available balance for GBP accounts

Additional Transaction Fields:

**Auth Date: When transaction was authorized
**Category Header: Category grouping
*Vendor: Merchant name
*Sub-Account: Account holder name (for joint accounts)
**Check Number: For check transactions
*Notes: Additional transaction details

How to Add Optional Fields

For Airtable:

Go to your Airtable base
Add a new field with the exact name (e.g., "**USD Available")
Set the field type correctly (Currency for balance fields)
The field will automatically populate on the next sync

For Google Sheets:

Optional fields are pre-defined in your template
Go to your integration settings
Enable the fields you want in the column mapping (you can also rename them)
Save your configuration

Pending Transactions

Important: Fintable does not sync pending transactions. Due to the nature of pending transactions, there may sometimes be a delay in transaction data appearing in your spreadsheets. So even though Fintable syncs your transactions daily, you may not see all recent transactions for 2-3 business days.

📊 Spreadsheet Integrations

Airtable Integration

Understanding Airtable Sync

Each Fintable account connects to one Airtable base
You may configure the name of the tables "Accounts" and "Transactions" in your Airtable base, but you cannot change the field names currently.
Need multiple Airtable bases? Use Sub Accounts (Office Plan feature)
Currently, Fintable does not allow you to rename any of the required or optional fields in Airtable.
Fintable only updates specific fields (marked with *asterisks in Airtable)
Fields with a single asterisk (*) are never overwritten by Fintable if you modify them, but fields with two asterisks (**) are overwritten upon a Force Re-Sync
You can add custom columns—they won't be affected
Sync is one-way: Fintable → Airtable
If you delete your bank connection, Fintable will not delete transactions in Airtable. You can manually delete them if needed.
During regular syncs, Fintable will NOT attempt to re-write a transaction that has already been synced before. However, if you run a Force Re-Sync, or remove and re-connect your Airtable, Fintable will re-write all transactions, including those that were previously written.

Balance-Only Sync Option

You may configure your Airtable integration to sync only account balances without syncing transactions.

When transaction sync is disabled:

Only account balances and basic account information will be synced
You may remove the Transactions table from your Airtable base

What Happens If You Delete Transactions in Airtable: If you delete a transaction directly in Airtable, it will not be re-synced immediately. However, if you run a Force Re-Sync, or disconnect and reconnect your Airtable integration, Fintable will re-sync all transactions, including the deleted ones.

Force Re-Sync

If you need to re-sync all transactions, including those that were previously written, you can use the Force Re-Sync button from the Airtable integration settings in your Fintable dashboard.

This will overwrite all existing transactions in Airtable with the latest data in Fintable, including restoring any transactions that may have been deleted in Airtable. Sometimes this is necessary after adding an optional field.

Google Sheets Integration

Quick Start Video for Google Sheets Integration

Common Issues:

Make sure you use the same Google Account to copy the Fintable template and connect your bank accounts. The "Use Template" will copy to your "main" Google account, but if this is not the account you use to connect to Fintable, this will not work.
By default, Fintable adds new rows to the bottom of your Google Sheet. You need to sort by date to see the most recent transactions at the top.

What You Can Do:

Add custom columns for notes, tags, or calculations
Create additional rows for summaries or categories
Use formulas and pivot tables
Add optional fields from the Custom Fields and Columns section above
Move the data around, so that you add rows above the Fintable data, for example. However, then you need to update the column mapping in the Fintable integration settings to match your new layout.

👥 Sub Accounts

A "Sub Account" is essentially just another Fintable account under a main Fintable account. People create multiple Fintable accounts for many reasons.

Share and/or collect data from multiple clients or business entities with separate data flows
Keep personal and business finances separate
Each sub-account inherits your billing plan but maintains separate connections and settings.
Connect different sets of bank accounts to different Airtable bases (since each Fintable account can connect to one Airtable)

The main advantages of Sub Accounts (instead of just creating multiple Fintable accounts yourself are):

Billed under one plan, so pay only for 1 account.
Easily switch between multiple Fintable accounts using the Quick Switcher, without logging out and logging back in.

Sub Accounts may be created for yourself (i.e. different countries or legal entities) or for other people (i.e. clients). Sub Accounts are only available on the Office plan, not the Personal plan.

Create and manage Sub Accounts

Create a Sub Account from the Sub Accounts Dashboard within the Fintable dashboard. All you need is a name and email.

Important: Anyone with access to the email address you use to create a Sub Account will be able to log into Fintable with that email, but they will only have access to their Sub Account, not your main account.

Once you have created a Sub Account you may quickly switch between your main account and your sub accounts using the Quick Switcher on the top-right of the dashboard.

If you have created a Sub Account for someone else (e.g. client), you should notify that person that they have a Fintable account active with that email address.

Fintable does NOT automatically notify them. Sub Accounts do not receive any email notifications by default.

They can login to their Sub Account at fintable.io/login using the email address you used to create the Sub Account.

They may use the Forgot Password feature to reset the password and login, or you may reset their password for them and share their login credentials (email/password) with them directly.

🛠 Troubleshooting

Connection Problems

Red Traffic Light Indicators: If you see red indicators in your Connection Settings:

Check the error message in your sync summary
Try the "Reconnect" button
Wait 24 hours and try again (some errors resolve automatically)
Contact support if the issue persists

Common Error Messages:

"Item login required" → Reconnect your account
"Invalid credentials" → Your bank password may have changed
"Problem connecting" → Usually resolves within 24 hours
"MFA required" → Complete multi-factor authentication
"Rate limit exceeded" → Wait 24 hours before retrying

📈 Usage and Limits

Bank Connection Limits

Your plan determines how many bank connections you can have:

Free Trial: 3 bank connections (limited to 30 days history). Contact support to ask for higher limits.
Personal: 10 bank connections
Office: 50 bank connections
Enterprise: By agreement

If you need more connections, you can upgrade your plan at any time, or contact support.

Transaction Volume

How Transactions Are Counted:

All transactions count toward your limit (incoming, outgoing, transfers)
Pending transactions are counted (even if they later disappear)
Internal transfers between your accounts are counted

Volume Limits by Plan:

Personal: $1,000,000 annual transaction volume
Office: Unlimited transaction volume

If you exceed your limit, you'll be notified and may need to upgrade your plan. We also consider requests to increase your limits on a case-by-case basis, when usage is clearly for non-commercial purposes on the Personal plan.

If you exceed your limits you won't lose any data, the sync will continue, but you will not be able to add any new bank connections.

🌐 Bank Coverage

To see an up-to-date list of supported banks, visit our Coverage page. We're constantly looking to add more banks and improve our coverage.

Requesting New Banks

If your bank isn't supported:

Submit a request through this form
We'll notify you if/when your bank becomes available

If you need an urgent API connection for a specific bank, please contact us for a custom integration quote. Typically this involves about a $5,000 one-time fee for the integration development on a two-week timeline.

📞 Support and Contact

Getting Help

Self-Service Options:

Use the Validate button to check your configuration
Check Connection Settings for error messages
Review this guide for common issues

Contact Us:

Email us at [email protected]. Make sure to send from the same email address you used to sign up for Fintable or we may ignore your request.
Alternatively, you can use the in-app chat form by clicking the chat icon in the bottom right corner of your dashboard.
Include your Link ID or Account ID for faster resolution
Screen recordings are helpful for complex issues

Restricted Countries

Fintable does not provide services to OFAC-sanctioned countries and customers in the following countries.

Afghanistan
Belarus
Burma (Myanmar)
Central African Republic
Cuba
Democratic Republic of the Congo
Ethiopia
Iran
Iraq
Israel
Libya
Mali
North Korea
Russia
Somalia
South Sudan
Sudan and Darfur
Syria
Venezuela

Customer Responsibility: Customers are responsible for ensuring compliance with applicable sanctions and export control laws in their jurisdiction.

Service Availability: Even if a country is not listed above, banking connections and services may still be limited based on the availability of supported financial institutions and local regulations.

For questions about service availability in specific countries, please contact our support team.

User Guide