Skip to content
Gallery
Cashflow Calculator
About this doc
Cashflow Calculator
Share
Explore

icon picker
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
Type
Totals
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Example: Teaching
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Consulting
​
​
​
​
​
​
​
​
​
​
​
​
​
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
Type
Totals
% of income
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Example: Sub Contracting
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Room Hire
​
​
​
​
​
​
​
​
​
​
​
​
​
​
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
Type
Totals
% of income
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
​
$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
Type
Totals
% of income
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
Example: Phone
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Software Subscr.
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Insurance
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Vehicle
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Rent
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Salary
​
​
​
​
​
​
​
​
​
​
​
​
​
​
Example: Superannuation
​
​
​
​
​
​
​
​
​
​
​
​
​
​
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
Type
Totals
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
​
$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
Type
N/A
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
Apr
May
Jun
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
⁠
Surplus loss
​
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
There are no rows in this table
⁠
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.