Informar sobre este artículo a Etsy

Precio:MX$189.82

IVA incluido

Cash Flow Forecast Template, 12 Month Small Business Projection, Excel Google Sheets Spreadsheet

Incluye protección de compras de Etsy

Solo puedes hacer una oferta por compras de un único artículo

Puntos destacables

  • Decoración para fiestas para reuniones y celebraciones
  • Descarga digital
  • Tipos de archivos digitales: 1 archivo
Traducido por Microsoft
Ver en el idioma original
Traducir a español
Lo sentimos, no hemos podido traducir este anuncio al español.

Knowing what you made last month doesn't tell you whether you can make payroll in month three. This spreadsheet looks forward instead of back: list what cash you expect in and out over the next 12 months, and it shows you the month your balance gets tightest, before it happens. Formulas do the adding up.

WHAT YOU GET (4 connected tabs)

START HERE: A one-page walkthrough of the whole workbook (what to fill in, what to leave alone, and exactly how to clear the example data when you're ready).

SETTINGS: Your business name, a name for this forecast, your currency symbol, your starting bank balance, and the month the forecast should start from, entered once. Forecast and Summary read their values from this sheet; nothing is hardcoded anywhere else. Change the start month and every column header on the other tabs follows automatically.

FORECAST: Every expected source of cash in and cash out, one row each, with a column for each of the next 12 months. Pick Cash in or Cash out from the dropdown, then fill in the expected amount per month. 30 rows ready for your entries. The running balance at the bottom adds your starting balance to every month's net and carries it forward, so you see exactly where the balance gets thin.

SUMMARY: A complete overview with nothing to type. Total cash in, total cash out, your ending balance after 12 months, and the single lowest point the forecast reaches, with the month it happens in named automatically. A full month-by-month table mirrors Forecast underneath, plus a plain-language line telling you whether the forecast stays positive throughout or dips below zero somewhere.

HOW IT WORKS

1. Open Settings and fill in your business name, forecast name, currency symbol, starting balance and start month (once).
2. Go to Forecast, add a row for each expected cash in or cash out, pick the type from the dropdown, and fill in the expected amount for each of the 12 months.
3. Check Summary any time. Total cash in, total cash out, ending balance, and the lowest point the forecast reaches and when. All formulas, nothing to type.

WHAT YOU NEED

Microsoft Excel or Google Sheets with no macros, no add-ins, and no other software required. Colored cells are the only ones you ever touch; white cells are formulas. Nothing in this workbook is locked or password-protected, so you're always free to inspect or adjust a formula if you want to.

A note on Google Sheets: every formula in this workbook was checked individually and uses only functions Google Sheets also supports. No XLOOKUP, no dynamic arrays, nothing Excel-only. Upload it to Drive and open it with Google Sheets, not in Drive's preview window: the preview doesn't calculate, so a working file looks broken there. I build and test in Excel, so I won't promise you a pixel-perfect Sheets import. The Cash in/Cash out dropdown and the month headers on Forecast are worth a quick look after import, since the two programs render them differently.

WHAT THIS ISN'T

Not accounting software and not a guarantee of what will actually happen. This is a spreadsheet that adds up the numbers you give it; it doesn't pull transactions from your bank, doesn't know when a client will actually pay late, and doesn't replace a bookkeeper or accountant. A forecast is only as accurate as what you enter into it, and it won't warn you about a cost you never listed. Not a subscription. One file, yours to keep, with no login and no recurring fee.

INSTANT DOWNLOAD

You get one .xlsx file, delivered immediately after purchase with no waiting for an email. It arrives pre-filled with a realistic 12-month example (four income and expense lines, including a deliberate dip in month three) so you can see the running balance move before you change anything. Start Here tells you exactly which rows to clear first and which to leave alone. Before release, all 135 formulas were recalculated in Excel and checked cell by cell; zero error values anywhere in the workbook. Need something more (invoicing, expense tracking, a live dashboard)? Those live in the Small Business Finance Kit in this shop; it pairs well with this forecast but does not include it. Questions before you buy? Send a message; I'm happy to help you work out whether this fits how you actually run things.

Descarga inmediata

Los archivos estarán disponibles para descargar una vez que se confirme el pago.  Sigue estas instrucciones.

No se admiten cambios, devoluciones ni cancelaciones de los artículos de descarga inmediata. Ponte en contacto con el vendedor si tienes algún problema con tu pedido.

Protección de compras de Etsy
Compra con confianza en Etsy sabiendo que estamos a tu lado si surge un problema con un pedido que reúne los requisitos. Consulta las condiciones del programa

También podría interesarte

A los compradores con gustos similares les han gustado estos artículos

Mostrar más
Mostrar más
Fecha de publicación: 31 jul 2026
Página de inicio Papelería y artículos para fiestas Papel Artículos de papelería Diseños y plantillas Plantillas Plantillas para contabilidad