Treasury management in Google Sheets with live bank data.
Keep the cash position, 13-week forecast and entity rollups you built in Sheets. BankSync connects your banks and brokerages, maps the fields once, and keeps the model current.
Map your treasury sheet once.
- 01
Connect accounts
Link banks, cards, brokerages and loans with read-only access.
- 02
Pick the sheet
Choose the tab that already powers your treasury tracker.
- 03
Map columns
Send balance, account, entity, currency and timestamp fields where formulas expect them.
- 04
Refresh on schedule
Run hourly, daily or weekly syncs, or by hand.
One cash position. Every tool that needs it.
Balances, holdings, and cash flows not just transactions.
- Current balances
- Available and current balances for cash, card, loan, and brokerage accounts.
- Historical balances
- Build cash trend tabs without downloading end-of-month statements.
- Transactions
- Deposits, wires, card activity, fees, and transfers with account context.
- Holdings and trades
- Brokerage positions and trade activity for swept or invested cash.
- Entity labels
- Fund, legal entity, department, location, or cash-purpose tags.
- Source links
- Keep source documents and sync history close to the rows they support.
- Access
- Read-only bank connections. BankSync cannot move money.
- AI training
- Customer banking data is not used inside the BankSync Boundary to train AI.
- Coverage
- 12,000+ institutions: banks, credit unions, cards, loans, brokerages and retirement providers.US banksCanadian banksAustralian CDRUK open bankingEuropeBrokerages
Build the tracker your way.
- Venture capital treasury Fund accounts, management-company cash, brokerage positions and LP rollups.
- Enterprise controls Unlimited connections, SSO/SAML, audit logs, custom DPA and NDA/MNDA.
- Bank feeds Scheduled transactions, balances, holdings, trades and loans.
- Connect a bank How read-only bank connections work.
- Create your first feed Connect accounts, choose a destination, map fields, run the first sync.
- Field mappings Map balances, transactions, holdings and labels into your model’s schema.
- Security Read-only access, provider auth, encryption and data handling.
- Sync balances Balance feeds for trackers that care about current cash.
- Scheduling feeds Pick a cadence that matches your close and board reporting.
Treasury FAQs
Can Google Sheets be used for treasury management?
Yes. Many teams run cash position, runway and forecast models in Google Sheets, and BankSync keeps them current by syncing balances, transactions, holdings, trades and loans into the tabs and columns you choose.
Will BankSync overwrite my formulas?
No, you control the destination tab and field mapping. Most teams write BankSync data to source tabs and keep formulas, pivots and charts in separate model tabs.
Can BankSync support multiple banks and entities?
Yes. Tag accounts by entity, fund, purpose or workflow across banks, cards, brokerages and loans, so each feed lands cleanly in your model.
Does BankSync move money?
No. Connections are read-only: BankSync syncs balances, transactions, holdings, trades and loans, and cannot move funds.
Is our banking data used to train AI?
No. Customer banking data is not used inside the BankSync Boundary to train AI models; an AI tool you connect through API or MCP has its own terms.
