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.
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, … }]
From bank to MongoDB in three steps.
- 01
Connect MongoDB
Host, database and a least-privilege user, or paste a connection string. Test it before you save.
Hostdb.acme.internalPort27017Userbanksync_writerSSL moderequireTest● Connection successful - 02
Pick a collection
Choose a database and collection, or let BankSync create one. Append, or upsert on a key.
DatabaseanalyticsCollectiontransactionsAppendUpsertMatch rows ontransaction_id - 03
Pick a schedule
Hourly, daily or weekly, or on demand. Every run is on the record.
HourlyDailyWeeklyNext runTomorrow, 6:00amLast 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
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.
