{"id":13035,"date":"2026-09-19T15:08:04","date_gmt":"2026-09-19T15:08:04","guid":{"rendered":"https:\/\/templacity.com\/?post_type=product&#038;p=13035"},"modified":"2026-10-17T09:17:40","modified_gmt":"2026-10-17T09:17:40","slug":"cash-flow-forecast-spreadsheet","status":"publish","type":"product","link":"https:\/\/templacity.com\/nl\/product\/cash-flow-forecast-spreadsheet\/","title":{"rendered":"Cash Flow Forecast Spreadsheet (Google Sheets + Excel)"},"content":{"rendered":"<p><span class=\"eyebrow\">\u2116 \u00b7 See the squeeze before it comes<\/span><\/p>\n<h2 id=\"a-twelve-month-cash-flow-forecast-that-names-the-month-your-cash-runs-short\">A twelve-month cash flow forecast that names the month your cash runs short<\/h2>\n<p>The Cash Flow Forecast is for owners of small businesses who are profitable on paper and still worried about the bank balance. On Settings, type the first month, the cash in the account that day and your cushion, the lowest balance you are comfortable with. On Forecast, name your lines and give each a first-month figure and a monthly growth rate; cost of sales lines take a percentage of sales instead. Type over any month for a one-off, a grant in or a quarterly bill out.<\/p>\n<h3>What it tells you<\/h3>\n<ul>\n<li><strong>Dashboard<\/strong>: cash now, the lowest point ahead and when, runway, break-even, and every month forecast below your cushion flagged tight, or SHORT below zero.<\/li>\n<li><strong>What If<\/strong>: the month you run out, beside two futures, a fixed cut to running costs or a monthly sales growth. Move either number and the chart moves.<\/li>\n<li><strong>Break-even<\/strong>: the sales a month needs to cover every cost, your safety margin and the sales a day it takes.<\/li>\n<li><strong>3-Year Plan<\/strong>: year one from the forecast and two more from your growth and margin, the page a lender or business plan asks for.<\/li>\n<\/ul>\n<p>Each month end, type the actuals; Forecast vs Actual marks every line over or under, green where it helps and red where it hurts. Cash is not profit: owner money, grants, equipment and draws go in the Other sections, so they move your cash without changing your break-even.<\/p>\n<p>The download is a short PDF with two Google Sheets buttons, one for a blank copy in your own Drive and one for a copy filled with an example, the same workbook as blank and example Excel files, and a one-page Quick Start for each.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>It names the month your cash runs out, in a sentence, then puts two futures beside it: cut your running costs, or grow your sales. Twelve months of cash in and out underneath, with runway, break-even and a three-year plan.<\/p>\n","protected":false},"featured_media":13260,"comment_status":"open","ping_status":"closed","template":"single-product-bundle.html","meta":{"rank_math_title":"Cash Flow Forecast Template for Google Sheets and Excel | Templacity","rank_math_description":"A cash flow forecast for Google Sheets and Excel that names the month your cash runs out, then shows two ways to fix it: cut costs or grow sales.","rank_math_seo_score":"10","_templacity_copy_live":"1","_templacity_faq":[{"q":"How do I build the forecast?","a":"Give each line a first-month figure and a monthly growth rate, 0 for flat. Cost of sales lines take a percentage of sales. Type over any single month that is different."},{"q":"What is the cash cushion?","a":"The lowest balance you are comfortable with. Months forecast below it are flagged tight, and below zero SHORT."},{"q":"Where do loans, grants and owner draws go?","a":"In the Other sections. They move your cash without changing your break-even, because cash is not profit."},{"q":"Does it compare the forecast with what happened?","a":"Yes. Type each month on Actuals as it closes, and Forecast vs Actual shows every line over or under the plan, month by month."},{"q":"Does it work in Excel?","a":"Yes. The download carries native .xlsx files, one blank and one filled with an example, for Excel 2010 and later, Excel for Mac and Microsoft 365. Every formula is ordinary Excel, with no macros to enable."},{"q":"Is there a year printed in it?","a":"No. No year is printed anywhere in the files, so it starts the day you do and keeps working next year."}]},"niche":[337],"template_type":[],"templacity_topic":[],"product_brand":[],"product_cat":[24],"product_tag":[44],"class_list":["post-13035","product","type-product","status-publish","has-post-thumbnail","niche-spreadsheets","product_cat-spreadsheets","product_tag-google-sheets","first","instock","downloadable","virtual","purchasable","product-type-simple"],"_links":{"self":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product\/13035","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product"}],"about":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/types\/product"}],"replies":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/comments?post=13035"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media\/13260"}],"wp:attachment":[{"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/media?parent=13035"}],"wp:term":[{"taxonomy":"niche","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/niche?post=13035"},{"taxonomy":"template_type","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/template_type?post=13035"},{"taxonomy":"templacity_topic","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/templacity_topic?post=13035"},{"taxonomy":"product_brand","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_brand?post=13035"},{"taxonomy":"product_cat","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_cat?post=13035"},{"taxonomy":"product_tag","embeddable":true,"href":"https:\/\/templacity.com\/nl\/wp-json\/wp\/v2\/product_tag?post=13035"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}