Skip to content
Cashflow Calculator
Share
Explore

Cashflow Calculator

How to use the INCOME table:
This table outlines all of your revenue.
Change the examples to reflect your own business
Enter your numbers, to your best estimate, under each month
The total will auto calculate
Income
0
Search
Type
Totals
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
1
Example: Teaching
2
Example: Consulting
3
Other
There are no rows in this table
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
How to provide more detail:
Here is where you can fill out more detail around each type if needed. It can sometimes help to provide context to the above numbers, but slows down the overall process.
Change the type to the same as the above table.
Education
Current
Opportunity
INCOME: 6 weeks @ 12 students x 250 per student = $3000
COS: Room Hire = $70/hour x 2 hours x 6 weeks = $840
Consulting
Current
Opportunities
Other
How to use the COST OF SALES table:
This table details how much is costs to sell your product/provide your service.
It does not include miscellaneous activities such as general advertising, etc.
Change the examples to reflect your own business
Enter your numbers, to your best estimate, under each month
The total will auto calculate
The % of Income will auto calculate
Add more detail below, if required.
Cost of Sales
0
Search
Type
Totals
% of income
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
1
Example: Sub Contracting
2
Example: Room Hire
3
ExampleOther
There are no rows in this table
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
Sub Contracting
Developers
Graphic Design
Gross Profit
Here you learn about your Gross Profit, which is your Income/Revenue - your Cost of Sales.
Gross Profit
0
Search
Type
Totals
% of income
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
1
$0
0
0
0
0
0
0
0
0
0
0
0
0
There are no rows in this table

Expenses
This is all the things that you are paying for, beyond the immediate expenses to make your product/service.
You know what to do by now!
Expenses
0
Search
Type
Totals
% of income
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
1
Example: Phone
2
Example: Software Subscr.
3
Example: Insurance
4
Example: Vehicle
5
Example: Rent
6
Example: Salary
7
Example: Superannuation
8
Example: GST / BAS
There are no rows in this table
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
0
Sum
Phone
Plan $51/month
Software Subscription
Coda $140/year
Spotify $192/year (monthly)
Insurance
Public & Products Liability $401.04/year
Vehicle
Registration $888
Avg fuel $30/month

Here is where the magic numbers are!
Cashflow Projection
0
Search
Type
Totals
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
1
$0
0
0
0
0
0
0
0
0
0
0
0
0
There are no rows in this table
Bank
Now you can see how the cashflow projection against the money in your bank.
You only need to edit the first JULY month and the rest will auto calculate.
Bank
0
Search
Type
N/A
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
1
Opening Bank
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
There are no rows in this table
Search
1
Surplus loss
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
There are no rows in this table
Search
1
Closing Bank
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
$10,000
There are no rows in this table

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.