Cash Flow Template
A starter cash flow template for consulting. Download the .xlsx, then ask the Deckary AI Excel Agent to fit it to your numbers, your reporting structure, and your output sheets.
Free download. No signup required.
Sheets in this workbook
- 13-Week Cash Flow
- Monthly Cash Flow
- Client & AR Tracker
- Annual Summary
About cash flow templates
Cash flow templates give you the inflow / outflow structure already laid out. Plug it into Excel and ask the agent to build a 13-week projection, reconcile to the balance sheet, or stress-test a downside scenario.
What a good cash flow template should include
Most template downloads stop at the file. The useful part is whether the workbook has the sections, checks, and formulas needed for real Excel work.
Cash receipts and payments
A cash flow template should separate cash inflows, operating payments, financing activity, and ending cash by period.
Forecast assumptions
Collection timing, payment timing, payroll cadence, taxes, and one-off cash events should be visible inputs rather than hidden math.
Runway and stress testing
Useful cash flow workbooks show ending cash, minimum cash, runway, and downside scenarios when revenue or collections slip.
How to use this template in Excel
Start with beginning cash and make sure the template reflects how cash actually enters and leaves the business. Accounting profit is not enough; timing of collections, payroll, vendor payments, debt, and taxes drives the cash position.
Use separate sections for operating, investing, and financing activity when you need a formal statement. For short-term liquidity planning, add a 13-week view so expected receipts and payments can be reviewed week by week.
After mapping the first version, stress-test the assumptions. Ask Deckary to model slower collections, delayed funding, lower revenue, or larger one-time payments so the workbook shows when cash gets tight and which levers matter.
Customize these inputs first
- Beginning cash balance and bank account mapping.
- Customer collection timing and accounts receivable assumptions.
- Vendor payment timing, payroll dates, and tax payments.
- Capex, debt draws, repayments, and financing activity.
- Weekly or monthly reporting cadence.
Check before you rely on the output
- Ending cash rolls into the next period's beginning cash.
- Cash flow reconciles to the balance sheet cash movement.
- Receipts and payments are timing-based, not just P&L categories.
- Negative cash periods are visible in the summary view.
When to use this Excel template
Start with the closest workbook, then let Deckary adapt the structure to your actual data and reporting cadence.
13-week cash planning
Use the template as a starting point for weekly cash visibility, then ask Deckary to extend or restructure it around your actual payment cadence.
Board and lender reporting
Create a summary view that explains cash movement, not just ending balance. Deckary can turn the workbook into a cleaner reporting output.
Downside scenario planning
Ask the agent to build stress cases for delayed collections, lower revenue, higher payroll, or large one-off expenses.
Common mistakes to avoid
These are the problems that usually make an Excel template look complete while still being hard to trust, update, or explain.
Confusing profit with cash
A profitable month can still consume cash if customers pay late or inventory is purchased early. The template should model timing, not only income statement rows.
Forgetting financing activity
Debt, equity, repayments, and owner distributions can move cash materially. Leaving them out makes the ending cash balance unreliable.
Using monthly detail for weekly decisions
If payroll or vendor payments create short-term pressure, monthly cash flow is too coarse. Add a 13-week view for operational liquidity decisions.
What the template will not solve by itself
A cash flow template will not know payment timing unless you give it timing rules. Customer receipts, payroll dates, vendor terms, tax payments, loan repayments, and funding events need dates or assumptions before the cash view is reliable.
It also will not replace bank and accounting reconciliation. The workbook should tie to actual cash balances, but source errors, missing transactions, and timing differences still need to be checked against the bank, ledger, or treasury report.
The template can show pressure points, but it cannot choose the operational response. Slower hiring, delayed spend, faster collections, debt, or equity are management decisions that should be tested in scenarios before action is taken.
Templates get you 30% there.
The other 70% — fitting it to your business, your data, your actuals, your reporting structure — is what the Deckary AI Excel Agent does.
Available cash flow templates by industry
Pick the closest industry starter, download the .xlsx, then ask the Deckary AI Excel Agent to adjust line items, formulas, and outputs to your business.
What to ask the agent once you've opened the template
Templates handle the layout. Paste any of these into the Deckary AI Excel Agent and it will do the customization, audit, or output work for you.
Run a 13-week cash flow projection from the latest balance.
Audit which inflows and outflows are hardcoded vs formula-driven.
Add a stress-test tab showing the cash position if revenue drops 20%.
Reconcile beginning and ending cash to the balance sheet.
Adapt the categories to match my treasury team's reporting structure.
Cash Flow Templates FAQ
What should a cash flow template include?
It should include starting cash, cash receipts, payroll, vendor payments, operating expenses, financing items, ending cash, and runway or minimum cash checks. Forecast versions should expose timing assumptions clearly.
Is this a cash flow statement or a cash flow forecast?
The workbook can support both. A statement explains historical cash movement; a forecast projects future cash based on assumptions. Deckary can help convert a historical layout into a forward-looking forecast.
Can Deckary build a 13-week cash flow forecast?
Yes. Open the template and ask Deckary to create weekly periods, add cash categories, link assumptions, and calculate ending cash and runway.
Can I reconcile cash flow to the balance sheet?
Yes. Deckary can inspect the workbook and add checks that tie beginning and ending cash to the relevant balance sheet cells.
Keep going inside Excel
The template is the starting point. The Deckary AI Excel Agent builds on it, audits it, and reshapes it to match your business.