A cleaner 13-week cash flow forecast for Excel and Sheets.
Start with a simple forecast shape: opening cash, inflows, outflows, ending cash, actuals, and variance. Then connect BankSync when you are ready to automate the bank-data tabs.
Map bank data into the source tabs your 13-week forecast expects.
11,000+ institutions, one treasury model.
Connect banks, credit unions, cards, loans, brokerages, and retirement providers across the US, Canada, Australia, the UK, and Europe through regulated data providers.
Start simple without the weekly rebuild.
A useful forecast does not need a giant system. It needs a clear shape and current actuals.
Blank sheets slow teams down
Start from a practical structure instead of debating tabs and categories.
Actuals are the bottleneck
Manual bank exports are the part BankSync removes when the template is ready.
Variance needs context
Keep forecast, actual, variance, and notes close together.
Build the forecast once.
Use the template structure first, then plug in live data when the workflow is proven.
Set opening cash
Use connected balances as the starting point for each forecast week.
Plan inflows
Forecast receipts, capital calls, transfers, and other incoming cash.
Plan outflows
Forecast payroll, vendors, debt service, fees, and operating spend.
Compare actuals
Feed actual data from BankSync to see variance without rebuilding the sheet.
the consolidated cash position
Template tabs not just transactions.
Keep the model readable. Source data comes in one place; decision tabs stay clean.
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.
Turn it live your way.
The template is useful on its own. BankSync makes the actuals update themselves.
Wire the template when you are ready. Real product proof.
These docs show the source pieces behind an automated forecast: bank connection, feed creation, field mapping, and schedule.
- Read-only bank connections. BankSync cannot move money.
- Customer banking data is not used inside the BankSync Boundary to train AI.
- Field mapping lets your model keep its own schema.
Connect a bank
See how read-only bank connections work before you wire treasury data into a model.
Learn more →Create your first feed
Connect accounts, choose a destination, map fields, and run the first sync.
Learn more →Field mappings
Map balances, transactions, holdings, and labels into the schema your model expects.
Learn more →Security
Review read-only access, provider-based auth, encryption, and data-handling details.
Learn more →Treasury FAQs
What is a 13-week cash flow forecast?+
Can the template use live bank data?+
Can BankSync support multiple banks and entities?+
Does BankSync move money?+
Is our banking data used to train AI?+
Automate the bank data feeding it.
Connect your first treasury feed in minutes, then expand into Excel, Sheets, dashboards, databases, API, or MCP as your team grows.