Small Business Budget and Cash Flow (12-month workbook)
Digital Product · Free · 1 file
By casey_plates
A year of budget on one tab, what really happened on the next, and a cash line that warns you before a month runs short.
Set up your income and cost lines once, then enter what you expect each month. As months end, type in what really happened. The Cash flow sheet shows your bank balance at the end of every month, using real numbers where you have them and your budget for the rest, and marks any month that ends below zero.
Your year can start in any month. Example numbers for a made-up business are filled in to show how it works. This is a planning tool, not accounting or tax advice.
What is included:
• Setup: business name, first month, starting cash
• Budget: 5 income lines and 16 cost lines across 12 months
• Actual: the same lines, filled in as you go
• Cash flow: balance by month, lowest month, months that run short
• Budget vs actual for the months entered
• How to use page
• Excel file (.xlsx). Opens in Excel, Google Sheets and Numbers.
Set up your income and cost lines once, then enter what you expect each month. As months end, type in what really happened. The Cash flow sheet shows your bank balance at the end of every month, using real numbers where you have them and your budget for the rest, and marks any month that ends below zero.
Your year can start in any month. Example numbers for a made-up business are filled in to show how it works. This is a planning tool, not accounting or tax advice.
What is included:
• Setup: business name, first month, starting cash
• Budget: 5 income lines and 16 cost lines across 12 months
• Actual: the same lines, filled in as you go
• Cash flow: balance by month, lowest month, months that run short
• Budget vs actual for the months entered
• How to use page
• Excel file (.xlsx). Opens in Excel, Google Sheets and Numbers.