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.
Build the forecast once.
- 01
Set opening cash
Use connected balances as the starting point for each forecast week.
- 02
Plan inflows
Forecast receipts, capital calls, transfers, and other incoming cash.
- 03
Plan outflows
Forecast payroll, vendors, debt service, fees, and operating spend.
- 04
Compare actuals
Feed actual data from BankSync to see variance without rebuilding the sheet.
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
Turn it live when you are ready.
- Cash forecasting feeds Automate the bank-data actuals behind the forecast.
- Google Sheets treasury Run the forecast collaboratively in Sheets.
- Excel treasury Run the forecast in your controlled Microsoft workbook.
- 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
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.
