Free cash flow spreadsheet
Log money in and out on this page and download the Excel file with the balance calculated. The running balance, the business or personal tags and the monthly totals are calculated automatically, and there is no signup.
Cash flow spreadsheet
| Date | Description | Money in | Money out | Balance | Business/Personal | Remove |
|---|---|---|---|---|---|---|
| 1,200 | ||||||
| 1,019.5 | ||||||
| 719.5 |
- In November 2026, money in is 1,200, money out is 480.5, and the balance is 719.5.
How to use the cash flow spreadsheet
- Log each movement on its own row: date, description, money in or money out. Use the button to add a row for each new entry.
- Tag whether the money is business or personal, to separate your shop's money from your personal money.
- The Balance column is calculated automatically, adding money in and subtracting money out, and the table shows totals for each month.
- Click Download filled (.xlsx) to save the file with your data, or Download template with formulas (.xlsx) to get the blank sheet with the formulas ready.
Each row's balance is the formula =Previous balance + Money in − Money out. For example, with a previous balance of $1,200.00, $300.00 in and $180.50 out, the new balance is 1,200.00 + 300.00 − 180.50 = $1,319.50.
How it works
The table runs in your browser, with no signup and nothing to install. You log money in and out, and each row's running balance and the monthly totals appear instantly.
- The data lives on the page, so download the .xlsx before closing the tab to keep your records.
- Download filled (.xlsx) saves the sheet with everything you typed. Download template with formulas (.xlsx) saves the blank sheet with the running-balance formulas ready.
- The file opens in Excel and Google Sheets, on desktop and on your phone.
What the spreadsheet includes
- Each row has date, description, money in and money out, and represents one movement of your shop's money.
- Each row has a running balance, calculated automatically with the formula =Previous balance + Money in − Money out.
- Each row has a Business or Personal tag, so you can see how much money is the shop's and how much is yours.
- The table adds up money in, money out and the balance for each month, and the numbers follow the format of your language, like $1,234.56.
Who it is for
- It works for anyone starting out who wants to know whether more money is coming in or going out.
- It works for small shops that mix business and personal money and want to see the two separately.
- It also works for anyone tired of retyping, because in Kyte every sale is recorded in your cash flow automatically, with stock updated at the same time.
Frequently asked questions about cash flow spreadsheets
Yes, it's free and you don't need an account. Log your movements on this page and download the Excel file as many times as you want, with your data or with just the formulas.
Click Download filled (.xlsx) to save the file with what you typed, or Download template with formulas (.xlsx) to save the blank sheet with the running-balance formulas ready. Both files open in Excel and Google Sheets.
Each row's balance is the previous row's balance plus money in, minus money out. For example, with a balance of $1,200.00, $300.00 in and $180.50 out, the new balance is $1,319.50. On the page and in the template, the formula does the math automatically.
The tag separates your business money from your personal money. You tag each entry as business or personal, so the balance shows how much the shop has, without personal withdrawals mixed in.
Yes. The table adds up money in, money out and the balance for each month, so you can compare month to month without building any formulas. The totals appear under the table as you log entries.
No. The table keeps your data only while the tab is open, and nothing is sent to any server. To keep your records, download the .xlsx before closing the page and pick up where you left off later.
Yes. The table works in your phone's browser, and the downloaded file opens in your phone's spreadsheet apps. For everyday use, Kyte records every sale in your cash flow from your phone, with no retyping.
Cash flow control on your phone with Kyte
In Kyte, every sale is recorded in your cash flow automatically, with stock updated at the same time. Create a free account and try it.