Spreadsheet: 851513d1701730284-formula-to-copy-all-data-from-one-tab-to-the-other-tab-test-p-and-l
Sheet: TOTAL BY MONTH

 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00
Income
CHSP - Participant Fees | 11919.95 | 14594.65 | 10724.2 | 11335.8 | 13200 | 13200 | 13200 | 13200 | 13200 | 13200 | 13200 | 13200
Gifts & Donations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 16817.9 | 16817.9 | 17111.86 | 17111.84 | 16817.87333333333 | 16817.87333333333 | 18794.38666666667 | 18794.38666666667 | 18794.38666666667 | 18794.38666666667 | 18794.38666666667 | 21733.90666666667
[NAME] | 36990.67 | 38954.99 | 52167.08 | 52167.09 | 52167.08575757575 | 52167.08575757575 | 52167.08575757575 | 52167.08575757575 | 52167.08575757575 | 52167.08575757575 | 52167.08575757575 | 28954.98575757576
Fee for Service - NDIS | 117202.14 | 126681.75 | 102263.18 | 100350.86 | 135000 | 98000 | 137000 | 137000 | 137000 | 142000 | 162000 | 166000
Fee for Service - KM Travel | 0 | 0 | 0 | 7720.370000000001 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 25328.56 | 25328.55 | 25328.54 | 25328.54 | 25328.54416666667 | 25328.54416666667 | 25328.54416666667 | 25328.54416666667 | 24935.45916666666 | 24935.45916666666 | 24935.45916666666 | 24935.45916666666
Client - Admin Fee HCL2 | 20423.12 | 20258.35 | 27564.12 | 28747.1 | 20500 | 20500 | 22960 | 22960 | 22960 | 22960 | 22960 | 22960
Client - Case Management HCL2 | 27130.85 | 26988.23 | 20674.87 | 21398.67 | 26500 | 26500 | 29680 | 29680 | 29680 | 29680 | 29680 | 29680
Client - Service & Support HCL2 | 55710.85 | 59699.94 | 56867.17 | 57840.5 | 56000 | 56000 | 57000 | 57000 | 57000 | 57000 | 57000 | 57000
Clients - Travel recharge | 1808.52 | 2003.04 | 1674.6 | 1914.72 | 1900 | 1900 | 1900 | 1900 | 1900 | 1900 | 1900 | 1900
Client - Contribution Fees HCL2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Clinical Assessment | 0 | 0 | 0 | 0 | 0 | 600 | 0 | 0 | 600 | 0 | 0 | 600
[NAME] | 240623 | 201142.99 | 185767.03 | 282391.86 | 240604.97 | 240604.97 | 240604.97 | 240604.97 | 240604.97 | 240604.97 | 240604.97 | 240604.97
DOH Income Prior Years | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 9973.71 | 9973.7 | 9973.7 | 9973.71 | 9973.703333333333 | 9973.703333333333 | 9973.703333333333 | 9973.703333333333 | 9973.703333333333 | 9973.703333333333 | 9973.703333333333 | 9973.703333333333
Miscellaneous Income | 0 | 0 | 0 | 69.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Participants Fees General | 0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Profit/Loss on disposal of asset | 0 | 13636.36 | 0 | 0 | 38230.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rent and Utilities Income | 23147 | 22467 | 24967 | 25367 | 25367 | 25367 | 25367 | 25367 | 25367 | 25367 | 25367 | 30367
Transitional/Enhancement Funding | 0 | 0 | 0 | 1204.24 | 0 | 0 | 0 | 3000 | 0 | 5000 | 0 | 7795.76
Tutor Training | 663.74 | 0 | 829.67 | 663.74 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 842.8500000000004
Total Income | 587740.01 | 578562.45 | 535913.0200000001 | 643585.9799999999 | 662089.2965909091 | 587459.1765909091 | 634475.6899242424 | 637475.6899242424 | 634682.6049242425 | 644082.6049242425 | 659082.6049242425 | 656548.6349242425
Gross Profit | 587740.01 | 578562.45 | 535913.0200000001 | 643585.9799999999 | 662089.2965909091 | 587459.1765909091 | 634475.6899242424 | 637475.6899242424 | 634682.6049242425 | 644082.6049242425 | 659082.6049242425 | 656548.6349242425
 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Plus Other Income
Clients - Equipment Purch charge | 30044.74 | 33485.96 | 26361.13 | 28789.85 | 31500 | 31500 | 31500 | 31500 | 31500 | 31500 | 31500 | 31500
Interest Income | 3587.78 | 3518.3 | 4095.59 | 3904.8 | 2733.333333333333 | 2733.333333333333 | 2733.333333333333 | 2733.333333333333 | 2733.333333333333 | 2733.333333333333 | 2733.333333333333 | 2733.333333333333
Sundry Income | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
iCare for Workers Compensation Reimbursement | 2296 | 4366.28 | 2296 | 1881.6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Other Income | 35928.52 | 41370.54 | 32752.72 | 34576.25 | 34233.33333333334 | 34233.33333333334 | 34233.33333333334 | 34233.33333333334 | 34233.33333333334 | 34233.33333333334 | 34233.33333333334 | 34233.33333333334
 | 623668.53 | 619932.99 | 568665.7400000001 | 678162.2299999999 | 696322.6299242425 | 621692.5099242425 | 668709.0232575758 | 671709.0232575758 | 668915.9382575759 | 678315.9382575759 | 693315.9382575759 | 690781.9682575759
Less Operating Expenses
Accountancy Fees | 104.17 | 104.17 | 804.17 | -1076.39 | 881.9444444444445 | 881.9444444444445 | 881.9444444444445 | 881.9444444444445 | 881.9444444444445 | 881.9444444444445 | 881.9444444444445 | 881.9444444444445
Agent Fees | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Allowances - wages | 795.36 | 2225.47 | 1339.49 | 1838.61 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550 | 2550
Audit Fees | 1333.33 | 1333.33 | 3593.33 | 1560 | 1560 | 1560 | 1560 | 1560 | 7560 | 1560 | 1560 | 1560
Bad Debts | 0 | 0 | 0 | 251.33 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bank Charges | 114.75 | 100.67 | 116.07 | 140.85 | 237.5 | 237.5 | 237.5 | 237.5 | 237.5 | 237.5 | 237.5 | 237.5
Bonus | 3500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Bus Hire | 8333.67 | 8334 | 8334 | 8334 | 8333.67 | 8333.67 | 8333.67 | 8333.67 | 8333.67 | 8333.67 | 8333.67 | 8333.67
Cleaning | 2800 | 3351.5 | 4000 | 4700 | 3900 | 4700 | 3900 | 3900 | 4700 | 3900 | 3900 | 4700
Client package purchases | 27339.42 | 30543.12 | 24049.69 | 26289.75 | 28350 | 28350 | 28350 | 28350 | 28350 | 28350 | 28350 | 28350
Client Transport | 3615.56 | 3615.56 | 3615.55 | 3615.49 | 3615.49 | 3615.49 | 0 | 0 | 0 | 0 | 0 | 0
Computer support &  expenses | 5761.2 | 5677.9 | 6093.4 | 5464 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000 | 6000
Conferences & Seminars | 0 | 0 | 0 | 3097.63 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Consultancy | 0 | 0 | 0 | 0 | 1111.111111111111 | 1111.111111111111 | 1111.111111111111 | 1111.111111111111 | 1111.111111111111 | 1111.111111111111 | 1111.111111111111 | 2222.222222222222
Depreciation Expense | 10936.3 | 11849.12 | 11650.14 | 12183.19 | 12529.16 | 12987.49 | 12987.49 | 12987.49 | 13060.61 | 13060.61 | 13062.61 | 13338.39
Donations | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Doubtful Debts | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Electricity | 306.82 | 676.2500000000001 | 909.61 | 670.83 | 2000 | 1620 | 1620 | 1815 | 2030 | 2110 | 2210 | 2215
Enhancements | 0 | 0 | 295.15 | 909.09 | 0 | 0 | 0 | 3000 | 0 | 5000 | 0 | 2000
Equipment | 0 | 0 | 0 | 0 | 250 | 250 | 250 | 250 | 250 | 250 | 250 | 250
Fines/Penalties | 0 | 0 | 387 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Fringe Benefits Tax | 1462 | 1462 | 1462 | 1462 | 1462 | 1462 | 1462 | 1462 | 1462 | 1462 | 1462 | 1462
Fuel | 1713.37 | 1712.28 | 1720.49 | 1842.26 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2000 | 2412.35
Gas/AGL | 0 | 0 | 0 | 240 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Insurance - business | 129.75 | 2895.99 | 2895.98 | 2895.98 | 2895.98 | 3185.578 | 3185.578 | 3185.578 | 3185.578 | 3185.578 | 3185.578 | 3185.578
Interest Expense | 1320.95 | 1351.06 | 1337.21 | 1218.11 | 616.6522275000001 | 559.2200608333334 | 444.3557275 | 386.9235608333333 | 329.4913941666667 | 272.0592275 | 214.6270608333333 | 157.1948941666667
Internet & Voip Phone | 1339.37 | 2373.64 | 2124.54 | 1551.51 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100 | 2100
ISO 27001 | 1700 | 1700 | 1700 | 2006 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200 | 2200
Legal | 1272.73 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Long Service Leave/ Provision | -7447.880000000002 | 1913.08 | 1372.52 | 9114.93 | 3233.886750636985 | 3201.664625608031 | 3266.108875665938 | 3201.664625608031 | 3201.664625608031 | 3233.886750636985 | 3266.108875665938 | 3369.442500579077
Management Fee | 0 | 0 | 0 | 0 | 0 | 0 | 1057.195999999996 | 1057.195999999996 | 1057.196000000004 | 1057.196000000004 | 1057.196000000004 | 205.4760000000024
Meeting Costs | 0 | 0 | 0 | 0 | 300 | 300 | 300 | 300 | 300 | 300 | 300 | 900
Mobile Phones | 475.42 | 566.4200000000001 | 594.51 | 657.6800000000001 | 704.1398 | 704.1398 | 704.1398 | 704.1398 | 704.1398 | 704.1398 | 704.1398 | 704.1398
MV - Allowance | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
MV - Insurance | 2616.23 | 3301.94 | 2763.43 | 2924.84 | 3113 | 3113 | 3113 | 3113 | 3113 | 3113 | 3113 | 3113
MV - Registration | 257.36 | 599.18 | 341.98 | 393.59 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
MV - Service & Maintenance | 6287.570000000001 | 1148.31 | 796.3800000000001 | 4192.690000000001 | 2454.95 | 2454.95 | 2454.95 | 2454.95 | 2454.95 | 2454.95 | 2454.95 | 3454.95
Overhead Recharge | 26899.07 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Photocopy Lease | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Police Checks | 36.36 | 36.36 | 256.34 | 13.17 | 56.36 | 165.44 | 56.36 | 56.36 | 56.36 | 56.36 | 56.36 | 256.36
Postage | 0 | 116.37 | 0 | 431.56 | 475 | 475 | 475 | 475 | 475 | 475 | 475 | 475
Printing | 86.82 | 604.52 | 397.71 | 618.18 | 950 | 950 | 950 | 950 | 950 | 950 | 950 | 950
Program Costs | 18181.84 | 14818.78 | 11509.3 | 9737.34 | 16980 | 19980 | 17830 | 17830 | 17830 | 17830 | 17830 | 24952.01000000001
Promotions/Marketing | 998.84 | 4990.2 | 998.84 | 4112.74 | 19852.82 | 2250 | 2250 | 2250 | 2250 | 2250 | 2250 | 4277.23
Quality Assurance | 1200 | 1600 | 1600 | 1600 | 6430 | 6850 | 5800 | 1600 | 1600 | 1600 | 1600 | 1600
Rates | 225.84 | 225.83 | 225.83 | 225.84 | 230 | 230 | 230 | 230 | 230 | 230 | 230 | 230
Recruitment | 335 | 1015 | 12982 | 1095.01 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 1000 | 2783.92
Redundancy | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Rental of Premises | 0 | -145.84 | 0 | 0 | 95.28 | 95.28 | 95.28 | 95.28 | 95.28 | 95.28 | 95.28 | 95.28
Repairs & Maintenance | 5913.91 | 7709.51 | 2444.41 | 1783.01 | 1829.166666666667 | 1829.166666666667 | 1829.166666666667 | 1829.166666666667 | 1829.166666666667 | 1829.166666666667 | 1829.166666666667 | 1829.166666666667
Room/Hall Hire | 15448.27 | 16789.18 | 18281.36 | 18891.67 | 19333.33 | 19333.33 | 19733.33 | 19733.33 | 19733.33 | 19733.33 | 19733.33 | 25733.33
Safety Supplies | 400 | 1234.89 | 3785 | 1237 | 150 | 150 | 150 | 150 | 150 | 150 | 150 | 150
Security | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04 | 41.04
Software Subscriptions | 3983.23 | 3965.280000000001 | 4133.02 | 4117.049999999999 | 4704.122499999999 | 4704.122499999999 | 4704.122499999999 | 4704.122499999999 | 6074.122499999999 | 6074.122499999999 | 6074.122499999999 | 6074.122499999999
Staff Amenities | 497.23 | 2573.28 | 380.94 | 624.95 | 1350 | 10450 | 1350 | 1350 | 1350 | 1350 | 1350 | 7999.79
Staff Training | 960.91 | 880.8799999999999 | 1363.65 | 3139.54 | 3900 | 3300 | 3300 | 3300 | 3300 | 3300 | 3300 | 36656.49000000001
Staff Welfare | 436.66 | 1028.41 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Stationery & Office Supplies | 248.31 | 1080.74 | 955.58 | 1347.89 | 850 | 850 | 850 | 850 | 850 | 850 | 850 | 1704.59
Subscript/Regn/Memberships | 631.39 | 1335.97 | 1454.1 | 1385.96 | 1370.0225 | 1370.0225 | 1370.0225 | 1370.0225 | 1370.0225 | 1370.0225 | 1370.0225 | 1570.0225
Sundry Expenses | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Superannuation | 35693.73 | 40298.9 | 36629.5 | 40822.86 | 45510.737184557 | 44415.49296279534 | 44329.76324596364 | 42247.75629930814 | 46355.5089391267 | 44281.38521260564 | 47228.01412590316 | 49238.64798440908
Temp Staff [NAME] | 1756.79 | 210 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Toll/E-Way | 272.72 | 272.72 | 136.36 | 272.72 | 272.72 | 272.72 | 272.72 | 272.72 | 272.72 | 272.72 | 272.72 | 272.72
Translating/Interpreting | 27.7 | 27.7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 500
Travel - KM Reimbursement | 10559.36 | 17877.3 | 9919.6 | 9324.070000000002 | 14240.50689568806 | 12992.26991386301 | 14710.77464674387 | 14588.9799863701 | 14607.65452924763 | 14988.98974036991 | 16060.99949436971 | 15887.64477524782
Travel - Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tutor Training Costs | 0 | 0 | 0 | 0 | 500 | 500 | 500 | 500 | 500 | 500 | 500 | 500
Uniform / Protective Clothing | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 4000
[NAME] | 87.83 | 571.16 | 176.32 | 187.96 | 400 | 400 | 400 | 400 | 400 | 400 | 400 | 400
Wages and Salaries | 341260.9400000001 | 383913.93 | 311638.11 | 370364.18 | 406147.7144050636 | 395628.1987526849 | 395536.4976905785 | 383849.5918118922 | 421195.7976284245 | 402338.127387324 | 429126.6629627559 | 451575.752585537
Waste Removal/Recycling | 55.53 | 73.30000000000001 | 364.78 | 716.5699999999999 | 115 | 115 | 115 | 115 | 115 | 115 | 115 | 115
Water Rates | 134.52 | 216.26 | 265.31 | 235.14 | 0 | 650 | 0 | 0 | 675 | 0 | 0 | 700
Website | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5000
Wages Paid on iCare for Workers Compensation | 1836.8 | 2755.2 | 1836.8 | 1870.4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Workers Compensation | 14531.67 | 16197.67 | 16197.66 | 29067.03 | 16486.58447626172 | 16188.68731921982 | 16164.67982561131 | 15403.69370194314 | 16897.42193460444 | 16145.14146922077 | 17218.5892364984 | 19863.88978862858
Total Operating Expenses | 558809.7600000002 | 609149.53 | 520270.2 | 599746.85 | 656169.8889619296 | 639163.5286572266 | 624612.8010342855 | 608834.2310081772 | 657876.2800734001 | 634153.3308098795 | 661110.7427782486 | 761834.8646619015
Net Profit / (Loss) | 64858.76999999979 | 10783.45999999996 | 48395.54000000015 | 78415.37999999989 | 40152.74096231291 | -17471.01873298408 | 44096.22222329036 | 62874.79224939866 | 11039.65818417573 | 44162.60744769638 | 32205.19547932723 | -71052.89640432561