Airtable Destination

Documentation on using Finicom's Airtable destination to sync bank account transactions directly into Airtable bases.


Introduction

Finicom’s Airtable destination allows you to sync financial transactions directly to a table in your Airtable base, enabling your team to create financial reports right in Airtable.

Finicom also has an Airtable Extension to allow direct viewing of your bank information within Airtable. Learn more here.

Example of Airtable Destination | Finicom

Setting Up an Airtable Destination

  1. Go to your organization's Destinations page.
  2. Click "Add Destination."
  3. Select "Airtable."
  4. Ensure your Airtable account is connected to Finicom. If not, use the "Airtable Connection" dropdown to select "Add a new Airtable" and follow Airtable’s connection flow.
  • Tip: Use our provided template to automatically set up a base and table with the required fields.
  • At least one base with edit access or greater must be shared with Finicom to successfully create a connection
  1. Choose the Airtable Base to sync into.
  • Note: Only Airtable bases that you have edit access to, or higher, will be selectable.
  1. Select the specific Table within that base.
  • Note: If a table you intend to sync to doesn't have all of our default fields, you'll need to manually map the fields in the "Airtable Field Mapping" section below.
  1. Complete adding details for your Airtable destination, including the source account and Airtable table.

  2. If necessary, map fields from your Airtable table to Finicom data fields. Finicom will sync your chosen data to those Airtable fields.

  • Note: "Transaction Id" must be mapped, but all other Finicom data is optional.

How It Works

  • New Transactions: Each new transaction will create a new record in the table.
  • Modified Transactions: When a transaction changes status (e.g., pending to posted), the record will update automatically. If the transaction doesn’t exist in your Airtable base yet, a new record will be created.
  • Removed Transactions: Voided transactions will delete the corresponding record.

Table Fields

If your Airtable tables has all of the below required fields, you won't need to manually map Finicom Data to Airtable fields.

The fields and their types are here:

Field NameField TypeDescription
Created AtDate & TimeDate and time when the transaction record was created
MerchantSingle line textName of the merchant for the transaction
DescriptionSingle line textDetails from your financial account related to the transaction
AmountCurrencyTransaction amount in its original currency
StatusStatusTransaction state (pending, posted, or void)
InstitutionSingle line textName of the financial institution (e.g., "Wells Fargo")
CategorySingle line textCategorization of the transaction (e.g., "Food and Drink: Restaurant")
AccountSingle line textSource account name (e.g., "Business Checking")
CurrencySingle line textCurrency code for the transaction
Transaction IdSingle line textUnique identifier for the transaction
Account IdSingle line textUnique identifier for the financial account

You can add extra fields, hide existing ones, or change sorting orders as needed, but the above fields must be present if your Finicom destination does not have a mapping.

We recommend copying our provided template's table to start with a valid table.