A cleaner 13-week cash flow forecast for Excel and Sheets.

Start with a simple shape: opening cash, inflows, outflows, ending cash, actuals and variance. Connect BankSync when you are ready to automate the bank-data tabs.

Start from the forecast shape. When you connect BankSync, last week’s receipts and payments fill the Actuals tab on schedule.

Build the forecast once.

  1. 01

    Set opening cash

    Use connected balances as the starting point for each forecast week.

  2. 02

    Plan inflows

    Forecast receipts, capital calls, transfers, and other incoming cash.

  3. 03

    Plan outflows

    Forecast payroll, vendors, debt service, fees, and operating spend.

  4. 04

    Compare actuals

    Feed actual data from BankSync to see variance without rebuilding the sheet.

Map bank data into the source tabs your 13-week forecast expects.

One cash position. Every tool that needs it.

Template tabs that stay readable.

Cash position
Current balances by account, entity, and purpose.
Forecast lines
Expected inflows and outflows by week.
Actuals
Synced bank activity used for comparison.
Variance
Formula-ready deltas between forecast and actual movement.
Entity rollup
Cash totals by fund, company, location, or department.
Notes
A place for assumptions, approvals, and review context.
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

What is a 13-week cash flow forecast?

A rolling quarter-length view of expected cash inflows, outflows and ending cash. Treasury teams use it because it is long enough to plan with and short enough to keep accurate.

Can the template use live bank data?

Yes. BankSync feeds actual balances and transactions into source tabs, and the forecast formulas compare planned and actual cash movement.

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.