Get all Bank Account Information in Google Sheets™ using the FINICOM_GET_ACCOUNTS formula

Get all bank account information in Google Sheets™ using the FINICOM_GET_ACCOUNTS formula in Finicom.

FINICOM_GET_ACCOUNTS

The FINICOM_GET_ACCOUNTS formula lists all bank accounts connected to your Finicom account. It provides detailed information about each account including balances, account types, and more.

Syntax

=FINICOM_GET_ACCOUNTS(columns, includeHeaders)

Parameters

ParameterTypeRequiredDefaultDescription
columnsstring[] or stringNoAll columnsArray of column names to include in output
includeHeadersbooleanNotrueWhether to include column headers as first row

Available Columns

  • Account ID - Unique identifier for the account
  • Institution - Name of the financial institution
  • Account Name - Display name of the account
  • Last 4 Digits - Last 4 digits of the account number
  • Account Type - Type of account (e.g., checking, savings)
  • Current Balance - Current balance in the account
  • Available Balance - Available balance that can be withdrawn
  • Currency - Currency code of the account
  • Last Updated - Timestamp of last account update

Examples

Basic Usage

Get all account information with default headers:

=FINICOM_GET_ACCOUNTS()

Select Specific Columns

Get only account names and balances:

=FINICOM_GET_ACCOUNTS({"Account Name", "Current Balance", "Currency"})

Without Headers

Get specific columns without header row:

=FINICOM_GET_ACCOUNTS({"Account Name", "Current Balance", "Currency"}, FALSE)

Tips

  • If no columns are specified, all available columns will be included
  • Column names are case-sensitive
  • The formula returns a dynamic array that can expand based on the number of accounts
  • Results are automatically updated when account information changes

Related