MongoDB integration

Transactions, balances, holdings and trades from 12k+ banks, written into a collection in your own MongoDB database on a schedule. Appended or upserted, ready to query.

mongosh · analytics3 rows upserted, 6:02am
analytics> db.transactions.find().sort({ date: -1 }).limit(2)[  {
    transaction_id: '10a4d071832649a',
    date: '2026-10-19',
    description: 'Stripe payout',
    amount: 4200,
    currency: 'USD',
    category: 'Income',
    account_name: 'Chase Checking',
    pending: false
  },  { transaction_id: '4bdd8e6931727cd', date: '2026-10-19', amount: -86.42, … }]
Chase Checking and Amex Gold, upserted at 6:02am into the transactions collection. A re-sync updates rows in place instead of adding them again.

From bank to MongoDB in three steps.

  1. 01

    Connect MongoDB

    Host, database and a least-privilege user, or paste a connection string. Test it before you save.

    Hostdb.acme.internal
    Port27017
    Userbanksync_writer
    SSL moderequire
    Test● Connection successful
  2. 02

    Pick a collection

    Choose a database and collection, or let BankSync create one. Append, or upsert on a key.

    Databaseanalytics
    Collectiontransactions
    AppendUpsert
    Match rows ontransaction_id
  3. 03

    Pick a schedule

    Hourly, daily or weekly, or on demand. Every run is on the record.

    HourlyDailyWeekly
    Next runTomorrow, 6:00am
    Last run● 3 new rows, 6:02am

MongoDB, set up start to finish.

Setting up MongoDB in BankSync, filmed with sample accounts.

What lands in your collection.

transaction_id
The bank’s stable id for the transaction. Your upsert key. 4bdd8e6931727cd
date
The day the bank posted it. 2026-10-19
description
The description the bank gives it. Whole Foods Market
amount
Signed, in the account’s currency: money out is negative. -86.42
currency
ISO 4217 code. USD
category
A spending category to group and filter by. Groceries
account_name
The account it came from, so many banks share one table. Amex Gold
pending
True until the bank posts it. false
Map bank fields onto the fields you already have, or let BankSync create the collection and its unique index for you.

The same data can also go to spreadsheets, workspaces, AI assistants and your own code.

MongoDB, in short.

Data
Transactions, balances, trades, holdings and loans, one data type per feed.
Works with
MongoDB Atlas and self-hosted MongoDB.
Write modes
Append inserts a row each sync. Upsert matches on the key columns you choose and updates in place.
Security
SSL mode disable, require or verify-full, a least-privilege user, and a small fixed set of BankSync IPs you can allowlist.
Schedule
Choose hourly, daily, or weekly automatic syncs based on your plan, or run a manual sync at any time.
Access
Read-only, authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.
Setup
About 10 minutes. Works with MongoDB Atlas and self-hosted MongoDB.
Status
Available today.

Questions, answered.

Which MongoDB hosts does BankSync work with?

Any reachable MongoDB database, including MongoDB Atlas and self-hosted MongoDB.

Should I use append or upsert?

Upsert, for most feeds. Append inserts a new row every sync, so re-syncs can duplicate. Upsert matches rows on the key columns you choose, such as transaction_id, and updates them in place.

Can BankSync create the collection for me?

Yes. "Set this up for me" creates a collection for the feed’s data type, maps every column, and adds the unique index upserts need.

How do I lock down access to my database?

Give BankSync a user that can only insert (and create, if BankSync should make the table), use SSL mode require or verify-full, and allowlist the fixed IP addresses BankSync connects from.

Can BankSync move money or see my bank password?

No. Bank access is read-only and authorised on your bank’s own consent screen. BankSync never stores your bank login and cannot move money.

Bank data in your MongoDB database.

BankSync is not affiliated with, endorsed by, or an official partner of MongoDB. MongoDB trademarks belong to their respective owners.