Cash Flow and Tax Planner Excel Template | Cash Flow, Money In, Money Out, Tax Pot and Deadlines

For self employed people and small business owners who want to stop guessing about cash and tax. Log money in and money out, and the cash flow builds month by month with your live bank balance. It works out what to put aside for tax each month and counts down to every deadline. Set your numbers once and every tab uses them.

What it covers

• Monthly cash flow with a live bank balance, built from the money logs
• Money in log for payments, deposits and everything else
• Money out log for materials, wages and every other cost
• Monthly tax set aside so you know what to put in the tax pot
• Tax calendar with a live countdown to every deadline
• Easy setup where you set your numbers once

Who it is for

Suits sole traders, self employed tradespeople, freelancers, contractors and small business owners.

What is inside

• Easy Setup, your lists in one place so every dropdown matches how you work
• How To Use and Quick Start guides, from download to working in ten minutes
• Cash Flow
• Money In
• Money Out
• Tax Set Aside
• Tax Calendar
• Notes and Actions and Log and Diary tabs

How it works

Open the file in Microsoft Excel and start on the Easy Setup tab. Swap the sample lists for your own and every dropdown in the workbook updates. White cells are yours to type in and blue tinted cells calculate themselves, so there are no formulas to write. The example rows show every feature working, overtype them with your own figures and the totals and charts update as you go.

What you get

• One editable Excel (.xlsx) workbook with 10 tabs
• Built for Microsoft Excel, no macros and no formulas for you to write
• Example rows included so you can see every feature working
• Commercial licence, use in your own business, not for resale
• Instant digital download, no physical item shipped

Small print

Template only. The names, jobs and figures shown in the product images and in the example rows are examples only, overtype them with your own. A planning and record keeping aid, not professional advice, so check big decisions with the relevant professional.