Spreadsheet

Find out where your money really goes with the practical Cash-Basis Income Statement spreadsheet

Run your analysis now!

Cover: Cash-Basis Income Statement (DRE)

Selling a lot on paper doesn't pay the bills at the end of the month. The secret of a healthy company is tracking money as it actually comes in and goes out, at the exact moment it happens. The Cash-Basis Income Statement organizes your finances on a cash basis, revealing what is really left over and stopping hidden financial bleeding.

What's inside

A ready-made cash-basis structure: track the real money that came in and went out month by month
Automated totals: pre-built formulas for net revenue, gross profit, contribution margin and EBITDA
Strict separation of spending: clear classification between direct costs, sales and marketing expenses and G&A
CAPEX & liability adjustments: a clear view of loan repayments, dividends and capital investments
Financial health indicators: instant calculation of operating cash margin and closing cash

Built for daily use and quick decisions, without complications

The template is 100% editable and customizable to your business. Just rename the lines to match your revenue and expenses, fill in the monthly entries and let the automatic totals calculate your margins in real time.

Real net revenue: Frequency: Monthly · Priority: High · Purpose: operating inflows net of direct taxes and discounts
Contribution margin: Frequency: Monthly · Priority: High · Purpose: measures what is left to cover the fixed structure after costs and selling expenses
Operating EBITDA: Frequency: Monthly · Priority: High · Purpose: measures the cash-generating capacity of the core operations
Operating cash flow: Frequency: Weekly / Monthly · Priority: Critical · Purpose: result after financial expenses, CAPEX and debt
Closing cash & final margin: Frequency: Weekly / Monthly · Priority: Critical · Purpose: the real net balance available for investment or distribution

Get the material

Get the material for free

Fill in the form and get the material in your email.

Questions

What is the difference between an accounting income statement and a cash-basis one?

The accounting income statement works on an accrual basis (the date the sale was made or the invoice issued). The cash-basis income statement only considers the money that actually came into the account or was paid out in the month, reflecting the real treasury balance.

Do I need advanced Excel skills to use the spreadsheet?

No. The spreadsheet includes step-by-step explanations on each line, a clear visual structure and pre-built formulas. You only need to fill in your business data and adapt the categories.

Does the spreadsheet work for my type of company?

Yes. The template is versatile and works for services, retail, e-commerce, technology and small manufacturers. Since the chart of accounts is customizable, you adapt the names to your reality.

How can Vispe Capital help my company beyond the template?

We work on controlling restructuring, ERP setup, budget planning and CFO as a Service for small and mid-sized companies that want to increase profitability and the value of the business.

How do I get the material?

The material is free. Fill out the form on this page and you will receive the download link by email within a few minutes. If you can't find it, check your spam folder or contact Vispe on WhatsApp.

Is the material available in English?

This page is in English, but the spreadsheet itself is in Brazilian Portuguese.

Find out where your money really goes with the practical Cash-Basis Income Statement spreadsheet

What's inside

Built for daily use and quick decisions, without complications

Get the material for free

Questions

More free materials

Cost Center Spreadsheet

Cash Cycle and Working Capital Simulator

Contribution Margin and Operating Leverage