Keep your Excel treasury model current automatically.
Excel is where serious finance models live. BankSync connects your banks and brokerages, writes clean source data into your workbook, and your formulas keep doing the work.
Feed the workbook once.
- 01
Connect finance accounts
Banks, cards, loans, brokerages and investment accounts connect read-only.
- 02
Choose Excel
Write into the workbook location your team uses in Microsoft 365.
- 03
Map source tabs
Keep raw data separate from formulas, charts, and reporting tabs.
- 04
Refresh before reviews
Schedule updates before cash meetings, board packs, and weekly forecasts.
One cash position. Every tool that needs it.
The workbook gets the full picture not just transactions.
- Bank balances
- Current account values for cash, cards, loans, and treasury accounts.
- Bank transactions
- Wires, deposits, card spend, fees, transfers, and operating activity.
- Brokerage positions
- Holdings, trades, cost basis, and sweep-account positions where supported.
- Entity fields
- Account and entity labels for group, fund, location, and department rollups.
- Backfill history
- Populate historical tabs for variance analysis and cash trend lines.
- Sync status
- See when data last refreshed and whether a feed needs attention.
- 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
Run Excel 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.
Treasury FAQs
Can BankSync sync treasury data into Excel?
Yes. BankSync writes bank balances, transactions, holdings, trades and loans into Excel workbooks, so the model refreshes from live source data instead of manual exports.
Can I keep my existing Excel model?
Yes. Map data into source tabs and keep your existing formulas, pivots, charts and board-pack tabs as they are.
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.
