How to connect Bank Accounts in Rows

Introduction

Rows connects to over 12,000+ bank accounts from the U.S. and European countries. Integrating your bank accounts brings the power of real-time financial data directly into your spreadsheets. You can seamlessly track transactions, analyze spending and create automated workflows that streamline your financial operations.

This guide will walk you through setting up bank integration in Rows, fetch balance from any of your accounts and automatically list transaction data in your spreadsheet.

Note: Currently, Bank Accounts supports connections to financial institutions in the United States and select European countries. Support for UK financial institutions is not yet available.

Requirements

• Access to a bank account from the U.S. or European countries
• A Rows.com account.

Connecting the Bank Accounts integration

1. Navigate to the Bank Accounts integration page.
2. Click on the Connect button
3. From the pop-up, click Connect again
4. Click Continue from Plaid’s pop-up
5. Search, select & connect to the bank of your choice

Bank Accounts functions

The Bank Accounts integration comes with 2 functions. Let’s check each of them.

Get Balance

1. Click on the Data Actions button

2. Search for Bank Account

3. Select the Get the balance from your bank account option

4. Review the connection and select the required bank account

5. Click Create Data Table button

Get Transactions

1. Click on the Data Actions button

2. Search for Bank Account

3. Select the Get transactions from your bank account option

4. Review the connection, select the required bank account & specify the date range

5. Click Create Data Table button

Use cases

Categorize and Report Expenses

In this video, you'll —

• Learn to connect your bank account to Rows, import transactions and categorize expenses.
• Discover how to customize your data, removing unwanted columns and creating weekly summaries.
• Visualize financial data using pivot tables and charts for insightful reporting.

Create a Finance Tracker in Notion

In this video, you'll —

• Learn to build an automated finance tracker in Notion with Rows.
• Discover how to customize and organize your financial data for easy management.
• Manage and customize financial reports in Notion for comprehensive tracking and insights.

Track your Balance over time

In this video, you'll —

• Learn to connect your bank account to Rows and set up a balance-over-time view.
• Use Rows' automation to log daily balances and track account history automatically.
• Visualize the balance over time data accumulated from the time this has been set up.

FAQs

Where is your data hosted?

We store your account and spreadsheet data in the Google Cloud Platform, exclusively on servers in the European Union, specifically in Belgium.

More on this can be found here.

Is Rows GDPR compliant?

In short: Yes 🙂

More on this can be found here.

Is my bank data secure?

Yes, your bank data is highly secure. Plaid, the provider we use for our Bank Accounts integration, is a trusted industry leader in financial data security and employs encryption and advanced security protocols to protect user data. Plaid operates with the same level of security as major banks, and data is encrypted at all stages of transfer.

Additionally, Rows does not store your bank login credentials — Plaid handles authentication directly, ensuring your credentials remain private.

Why do I have an error while refreshing data?

In order to stay compliant with various regulations across North America & Europe, you may need to reauthorize your Bank Accounts connection to continue accessing data via Plaid.

This is common in Europe, where consent typically expires after 180 days. However, you may also have the need to reauthorize after 60 days or 12 months (depending on the bank you're connecting to and the region).

You can read more about this on Plaid's approach to connecting to Bank Accounts data, as well as in their Data Transparency Messaging guide.

When and how do I reauthorize my connection?

Here are a few situations where you may need to disconnect / delete the connection that you've connected to Rows via our Bank Accounts integration —

• While adding a new account to the same bank
• When your authorisation consent expires

To reauthirze your connection, please follow the steps below —

1. From your Rows dashboard, navigate to Settings > Integration
2. Hover over the connection listed under the Bank Accounts integration
3. Click on the bin icon to delete the connection
4. Next, navigate to the Bank Accounts integration page
5. Click on the Connect button to reconnect your bank account

How far back can I access transaction data?

Plaid provides you with up to 24 months of transaction data.

Since we limit each data request to about 6MB in Rows, you may have to pull smaller chunks of data by specifying shorter intervals of time.

Conclusion

By connecting your bank accounts to Rows, you can leverage real-time financial data to simplify and automate your financial workflows.

With the power of the Bank Accounts integration, you can effortlessly monitor account balances, track recent transactions and create custom financial reports without manual updates. This not only saves time but also enables more accurate, up-to-date analysis, helping you make informed financial decisions faster.