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.

The controlled workbook on OneDrive: bank, brokerage and credit line balances for three entities on the Cash position tab, the forecast tabs untouched.

Feed the workbook once.

  1. 01

    Connect finance accounts

    Banks, cards, loans, brokerages and investment accounts connect read-only.

  2. 02

    Choose Excel

    Write into the workbook location your team uses in Microsoft 365.

  3. 03

    Map source tabs

    Keep raw data separate from formulas, charts, and reporting tabs.

  4. 04

    Refresh before reviews

    Schedule updates before cash meetings, board packs, and weekly forecasts.

Create a feed, map source data, and send clean rows into the model your team trusts.

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

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.

Automate the bank data feeding it.