Management Reports
for
June 2017
PREPARED BY
POWERED BY
Contents
1. Management Reports
Cashflow Forecast
Actual vs Budget
P&L Forecast
Where Did Our Money Go?
Net Worth
2. Understanding your Reports
3. Bonus Pack
Cumulative Income to Budget
Wages to Turnover
Bank Movement
4. Understanding your Bonus Pack
5. How I came up with your numbers
Cashflow Forecast Chart — Your Company
JUL 2017 — JUN 2018
From The Invisible Accountant Page 1 of 103/07/2017 05:20
Actual vs Budget — Your Company
MONTH: MAR 2017
Budget -Annual Total
Budget - Next Month
VarianceYTD BudgetsYTD ActualsVarianceBudgetsActuals
Jul 2016 -Mar 2017Mar 2017
Income
1,696,500180,000137,6371,290,0001,427,63726,482135,000161,482 Sales
1,696,500180,000137,6371,290,0001,427,63726,482135,000161,482Total Income
Cost of Sales
759,00082,500(33,104)573,000606,104(5,709)60,00065,709 Cost of Sales
759,00082,500(33,104)573,000606,104(5,709)60,00065,709Total Cost of Sales
937,50097,500104,533717,000821,53320,77375,00095,773Gross Profit
Expense
201,75015,0005,285153,000147,715(1,427)15,00016,427 Admin Expenses
125,00010,41793,75093,750010,41710,4170 Depreciation
584,85045,00021,619451,500429,881(4,282)45,00049,282 Wages & Salaries
58,3354,5002,18145,15042,969(428)4,5004,928 Superannuation
969,93574,917122,835743,400620,5654,27974,91770,637Total Expense
(32,435)22,583227,368(26,400)200,96825,0528325,135Operating Profit
From The Invisible Accountant Page 1 of 203/07/2017 05:17
Budget -Annual Total
Budget - Next Month
VarianceYTD BudgetsYTD ActualsVarianceBudgetsActuals
Jul 2016 -Mar 2017Mar 2017
Other Expense
21,0001,500(1,304)16,50017,804(143)1,5001,643 Interest
21,0001,500(1,304)16,50017,804(143)1,5001,643Total Other Expense
(53,435)21,083226,064(42,900)183,16424,909(1,417)23,493Net Profit
Additional Information
2748(3)3538(3)3538Debtor Days
(3%)12%(16)(3%)13%(16)(1%)15%Net Profit Margin
From The Invisible Accountant Page 2 of 203/07/2017 05:17
P&L Forecast — Your Company
JUL 2016 -JUN 2017
ForecastForecastForecastActualsActualsActualsActualsActualsActualsActualsActualsActuals
ProjectedTotal
Jun 2017May 2017Apr 2017Mar 2017Feb 2017Jan 2017Dec 2016Nov 2016Oct 2016Sep 2016Aug 2016Jul 2016
Income
1,834,13793,000133,500180,000161,482115,713109,469183,029158,055159,365211,640166,350162,534 Sales
1,834,13793,000133,500180,000161,482115,713109,469183,029158,055159,365211,640166,350162,534Total Income
Cost of Sales
792,10440,50063,00082,50065,70945,51539,55879,47271,12571,71485,01474,85873,140 Cost of Sales
792,10440,50063,00082,50065,70945,51539,55879,47271,12571,71485,01474,85873,140Total Cost of Sales
1,042,03352,50070,50097,50095,77370,19869,911103,55786,93087,651126,62691,49389,394Gross Profit
Expense
196,46515,00018,75015,00016,42713,00412,17215,32315,80615,93726,15816,63516,253 Admin Expenses
31,25010,41710,41710,417000000000 Depreciation
563,23140,50047,85045,00049,28240,63833,47240,66347,41747,81071,93549,90548,760 Wages & Salaries
56,1544,0504,6354,5004,9284,0643,3474,0474,7424,7817,1934,9914,876 Superannuation
847,10069,96781,65274,91770,63757,70648,99160,03467,96468,527105,28671,53169,890Total Expense
194,933(17,467)(11,152)22,58325,13512,49320,92043,52318,96719,12421,34019,96219,504Operating Profit
Other Expense
From The Invisible Accountant Page 1 of 203/07/2017 05:18
ForecastForecastForecastActualsActualsActualsActualsActualsActualsActualsActualsActuals
ProjectedTotal
Jun 2017May 2017Apr 2017Mar 2017Feb 2017Jan 2017Dec 2016Nov 2016Oct 2016Sep 2016Aug 2016Jul 2016
22,3041,5001,5001,5001,6431,6261,5213,2821,5811,5943,2701,6641,625 Interest
22,3041,5001,5001,5001,6431,6261,5213,2821,5811,5943,2701,6641,625Total Other Expense
172,629(18,967)(12,652)21,08323,49310,86719,39940,24117,38617,53018,07018,29917,879Net Profit
Additional Information
44%44%46%45%46%46%47%42%43%44%44%47%48%Debt Ratio
244%244%229%232%224%224%226%226%225%226%228%218%219%Working Capital Ratio
From The Invisible Accountant Page 2 of 203/07/2017 05:18
Where Did Our Money Go? — Your CompanyJUL 2016 - JUN 2017
Summary Profit and Loss
MovementClosing Jun 2017Opening Jul 2016
1,002,788Income
5,998Cost of Sales
935,632Expense
0Other Income
0Other Expense
61,158Net Profit
Where Our Money Came From
24,15972,47748,318Loans Payable (21130)
20,839(29,018)(49,857)Superannuation Payable
15,12545,37530,250PAYG Withholding Payable
13,30721,2197,912GST
73,431Total
Where We’ve Spent Our Money104,159312,477208,318Short-Term Investments
29,396123,46294,066Undeposited Funds
2203,1002,880Accounts Receivable (11210)
2202200Cash at Bank - Restricted
133,995Total
How This Affected Your Bank
594(13,406)(14,000)Cash at Bank - Unrestricted
594Total
61,158Net Movement
POWERED BY Calxa Page 10 of 2013/07/2017 00:49
Net Worth — Your Company
03/07/2017 05:16 Page 1 of 1From The Invisible Accountant
Understanding your ReportsLet me walk you through your reports
Cashflow ForecastForecast your bank balance month by month into the future. This chart will help you plan and take action now to prevent problems while there is still time.
Actual vs BudgetMeasure and monitor your performance. Use this report to see what’s working in your business and prioritise what needs fixing.
Profit and Loss ForecastBased on what you’ve achieved so far this financial year and expectations for the remainder, use this report to predict your final results. Great for tax planning.
Where Did Our Money Go?Have you made a profit but there’s no money in the bank? This report will help you see where else it’s gone and how you’ve funded the business.
Net WorthThis is why you do all that hard work. The chart compares your total assets (what you own) to your total liabilities (what you owe to other people). You want to see the net equity line going upwards.
Bonus Pack
for
June 2017
PREPARED BY
POWERED BY
Income to Budget — Your Company
From The Invisible Accountant Page 1 of 103/07/2017 05:30
KPI Comparison — Your Company
42%44%46%48%49%49%44%46%45%46%46%47%Debt Ratio
84%88%92%99%99%99%102%112%110%111%110%110%Debt to Equity Ratio
265%256%246%233%237%236%244%229%232%224%224%226%Working Capital Ratio
Using Actual figures up to Mar 2017
From The Invisible Accountant Page 1 of 103/07/2017 05:43
Cumulative Net Profit to Budget — Your Company
Net Profit/LossAccount
From The Invisible Accountant Page 1 of 103/07/2017 06:00
Understanding your
Bonus PackLet’s review how these reports work
Cumulative Income to BudgetTrack how close your income is to your budget. Ideally you want the bars (representing actuals) higher than the line (the budget based on last year).
Wages to TurnoverPeople are the biggest cost for many businesses. This KPI will help you balance the need to keep costs down with your desire to service your customers well.
Bank MovementUnderstand the main flows through your business and what is affecting your bank balance. Looking at the trends will help you spot anything unusual.
How I came up with your numbers
I haven’t had the pleasure of meeting you yet but you have given me access to
your accounting information and that’s what I’ve used to prepare your reports.
For your budgets, I’ve simply taken what you did last year and for most
businesses this is a reasonable starting point.
You’ve told me how often you pay your taxes and other payroll expenses so
I’ve factored them into the cashflow forecast.
Then, I’ve looked at what your customers owe you and used this to estimate
your future receipts. Similarly, from your accounting information I can see how
quickly you usually pay your suppliers and I’ve used this to forecast future
payments.
Putting all that together, I can produce these reports to predict your future
cashflow, monitor your business performance and give you key insights into
what’s working and what’s not.
Yours truly,
P.S. If you find my reports limiting, you may want to consider Calxa for a more
flexible and customisable option.