Spreadsheets
Small Business Cash Flow Template
This small business cash flow template Excel file is a cash-basis tracker. You log each payment you receive and each cost you pay. Monthly Cash Flow and Profit and Loss then total those rows for the year you set.

What this template does
- Settings holds your name or business name, currency, the year, starting cash on 1 January, and the income and expense categories used in the dropdowns.
- Income is one row per payment received: date, source, category, description, amount, and method.
- Expenses is one row per cost, with an optional Yes or No tag for costs you want totaled as tax-deductible. That tag is your label, not a tax determination.
- Monthly Cash Flow rolls the year forward. January opens with the starting cash from Settings. Each later month opens with the prior month's closing cash. Closing cash is opening cash plus income minus expenses.
- Profit and Loss groups income and expenses by category for the year and for the month you choose in Settings.
How to use it
The file works in Microsoft Excel and in Google Sheets. In Google Sheets, upload the workbook to Google Drive and open it there. Cream-colored cells are for you to edit. Grey or tinted cells hold formulas.
1. Set the year and starting cash
On Settings, enter the business name, currency symbol, year, and the cash balance on 1 January of that year. Edit the category lists so the dropdowns match how you want to group income and costs.
2. Log money in
On Income, add one row each time you are paid. Use a date in the year from Settings and pick a category from the dropdown. Leave unused rows blank.
3. Log money out
On Expenses, add one row per cost with the vendor, category, amount, and payment method. The tax-deductible column is only a reminder for your own totals.
4. Read the month
Open Monthly Cash Flow. Each month shows opening cash, income, expenses, net, and closing cash. The chart compares income and expenses by month. Figures include [EXAMPLE] rows until you delete them.
5. Read the profit and loss sheet
Profit and Loss is cash basis: an amount counts on the date you entered. Net profit on that sheet is income minus expenses for those dates. It is a record of what you typed, not a filed tax return.
Who it is for
Use it if you want a simple record of what came in, what went out, and what was left at the end of each month. It is aimed at a freelancer, sole proprietor, or other small business keeping its own cash records. It does not replace a bookkeeper or an accountant.
Download the workbook
The download is direct. There is no email form and no account.
Download LoanQuail-Free-Cash-Flow-Tracker.xlsxThese templates are provided as-is for informational purposes and are not financial, tax, or accounting advice.
Frequently asked questions
What does the cash flow tracker template show?
It logs income and expenses, then totals each month: opening cash, income, expenses, net, and closing cash. A profit and loss sheet groups the year by category. The monthly sheet also charts income and expenses.
Is this a small business cash flow template for Excel?
Yes. It is an Excel workbook, and the same file can be uploaded to Google Sheets. It is a cash-basis record: amounts are counted on the date you enter.
Does the tax-deductible column decide what I can deduct?
No. Yes or No is only your own tag so the profit and loss sheet can total those rows. It is not a determination of deductibility. These templates are provided as-is for informational purposes and are not financial, tax, or accounting advice.
Who is the cash flow tracker for?
It is for a freelancer, sole proprietor, or other small business that wants a simple record of money in and money out. It is not a substitute for a bookkeeper.
Other free tools
- Free Invoice Generator
- Profit Margin and Markup Calculator
- Break-Even Point Calculator
- Business Loan Calculator
- Factor Rate to APR Calculator
- MCA Cost Calculator
- Cash Runway Calculator
- Payroll Cost Calculator
- Restaurant Food Cost Calculator
- Contractor Bid Calculator
- Free Invoice Template for Small Business
- All free tools