Filetype Excel XLSX | Posted on 14 Aug 2022 | 4 years ago
Authentication
digital resources
328x Filetype XLSX File size 0.04 MB Source: www.health.gov.au
Sheet 1: HCP (I&E)
| ← | Home Care Package (HCP) Income & Expenditure Statement 2021-22 | ||||||
| Total Home Care | Centrally Held | Aged Care Planning Region 1 | Aged Care Planning Region 2 | ||||
| Income | |||||||
| ◦ Direct Care Services | |||||||
| - Domestic | $0.00 | $0.00 | $0.00 | ||||
| - Nursing | $0.00 | $0.00 | $0.00 | ||||
| - Allied Health | $0.00 | $0.00 | $0.00 | ||||
| - Other | $0.00 | $0.00 | $0.00 | ||||
| ◦ Sub-contracted Services | |||||||
| - Domestic | $0.00 | $0.00 | $0.00 | ||||
| - Nursing | $0.00 | $0.00 | $0.00 | ||||
| - Allied Health | $0.00 | $0.00 | $0.00 | ||||
| - Other | $0.00 | $0.00 | $0.00 | ||||
| ◦ Care Management Service Fees | $0.00 | $0.00 | $0.00 | ||||
| ◦ Package Management Service Fees | $0.00 | $0.00 | $0.00 | ||||
| ◦ Exit Amounts Deducted | $0.00 | $0.00 | $0.00 | ||||
| ◦ Fee charged to customers (for purchasing an item or service on the consumers behalf) | $0.00 | $0.00 | $0.00 | ||||
| ◦ COVID-19 Funding | $0.00 | $0.00 | $0.00 | ||||
| ◦ Other Income | $0.00 | $0.00 | $0.00 | ||||
| Total Income: | $0.00 | $0.00 | $0.00 | ||||
| Expenses | |||||||
| Internal Direct Service Costs | |||||||
| ◦ Wages and Salaries - Employee | |||||||
| - Registered nurses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Enrolled and licensed nurses (registered with the NMBA) | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Personal care staff/Other unlicensed nurses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Allied health | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Other employee staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal - Wages and Salaries - Employee | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Labour Cost - Agency Care Staff | |||||||
| - Registered nurses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Enrolled and licensed nurses (registered with the NMBA) | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Personal care staff/Other unlicensed nurses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Allied health | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Other Agency staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal - Labour Cost - Agency Care Staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Payroll Tax - Care Staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Care Related Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Motor Vehicle Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Other Internal Direct Service Costs | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Total Internal Direct Service Costs Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| External Direct Service Costs | |||||||
| ◦ Sub-contracted or Brokered Client Services | |||||||
| - Organisation (Other Home Care Providers, etc) | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Self Employed Individual | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Brokering Agency | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Subtotal - Sub-contracted or Brokered Client Services | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Consumables | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Home Modifications | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Client Capital Purchases | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Transport Services | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Franchise Fee | |||||||
| - Royalty | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Advertising | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Other Franchise Fee | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Other External Direct Service Costs | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Total External Direct Service Costs Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Care Management | |||||||
| ◦ Wages and Salaries - Care Management Staff | |||||||
| ◦ Payroll Tax - Care Management Staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Motor Vehicle Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Total Case Management Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Administration & Support | |||||||
| ◦ Wages and Salaries - Administration & Non-Care Staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Workers Compensation insurance | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Payroll Tax - Administration & Non-Care Staff | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Administration Costs and Management Fees | |||||||
| - Education/Training & Quality Control Expense | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - General Insurances | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Rent, Utilities and Property Outgoings | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - IT and Communication Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Corporate Recharge | $0.00 | $0.00 | $0.00 | $0.00 | |||
| - Other Administration Costs | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Depreciation Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Interest Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ COVID-19 Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| ◦ Other Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Total Administration & Support Expenses | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Total Expenses: | $0.00 | $0.00 | $0.00 | $0.00 | |||
| Net Profit/(Loss) Before Tax: | $0.00 | $0.00 | $0.00 | $0.00 | |||
| From Consolidated Client Statement: | |||||||
| ◦ Unspent Package Funds Opening Balance | $0.00 | $0.00 | $0.00 | ||||
| ◦ Commonwealth Subsidies and Supplements | $0.00 | $0.00 | $0.00 | ||||
| ◦ Client Fees - Basic Daily Fee | $0.00 | $0.00 | $0.00 | ||||
| ◦ Client Fees - Income Tested Care Fees | $0.00 | $0.00 | $0.00 | ||||
| ◦ Client Fees - Other | $0.00 | $0.00 | $0.00 | ||||
| ◦ Funds Transferred in With New Clients | $0.00 | $0.00 | $0.00 | ||||
| ◦ Funds Transferred Out With Existing Clients | |||||||
| - Transferred to Another Provider | $0.00 | $0.00 | $0.00 | ||||
| - Returned to the Client/Estate | $0.00 | $0.00 | $0.00 | ||||
| - Returned to the Commonwealth | $0.00 | $0.00 | $0.00 | ||||
| ◦ Package Funds Spent | $0.00 | $0.00 | $0.00 | ||||
| ◦ Unspent Package Funds Closing Balance | $0.00 | $0.00 | $0.00 | ||||
| Unspent Package Funds Closing Balance by Level | Amount of Funded Packages ($) | Number of Funded Packages | |||||
| - Level 1 Packages | $0.00 | 0 | |||||
| - Level 2 Packages | $0.00 | 0 | |||||
| - Level 3 Packages | $0.00 | 0 | |||||
| - Level 4 Packages | $0.00 | 0 | |||||
| Total Unspent Package Funds Closing Balance | $0.00 | 0 | |||||
| Check (should be zero) | $0.00 | ||||||
| From Approved Provider Balance Sheet: | |||||||
| ◦ Cash and Liquid Assets (Current) | $0.00 | $0.00 | Linked | ||||
| Other Information | |||||||
| ◦ Total number of care recipients who have been means tested to pay an income tested care fee | 0 | 0 | 0 | ||||
| ◦Total number of care recipients for who you have waived all or part of the income tested care fees | 0 | 0 | 0 | ||||
| Home Care Labour Paid Hours | |||||||
| Labour Paid Hours - Internal Direct Care - Employee | |||||||
| ◦ Registered nurses | - | - | - | - | |||
| ◦ Enrolled and licensed nurses (registered with the NMBA) | - | - | - | - | |||
| ◦ Personal care staff/Other unlicensed nurses | - | - | - | - | |||
| ◦ Allied health | - | - | - | - | |||
| ◦ Other employee staff | - | - | - | - | |||
| Total Labour Paid Hours - Internal Direct Care - Employee | - | - | - | - | |||
| Labour Paid Hours - Internal Direct Care - Agency Care Staff | |||||||
| ◦ Registered nurses | - | - | - | - | |||
| ◦ Enrolled and licensed nurses (registered with the NMBA) | - | - | - | - | |||
| ◦ Personal care staff/Other unlicensed nurses | - | - | - | - | |||
| ◦ Allied health | - | - | - | - | |||
| ◦ Other Agency staff | - | - | - | - | |||
| Total Labour Paid Hours - Internal Direct Care - Agency Care Staff | - | - | - | - | |||
| External Hours - Sub-contracted/Brokered | |||||||
| ◦ Sub-contracted or Brokered Client Services Hours | - | - | - | - | |||
| Labour Paid Hours - Care Management | |||||||
| ◦ Wages and Salaries - Care Management Staff | - | - | - | - | |||
| Labour Paid Hours - Administration & Support | |||||||
| ◦ Wages and Salaries - Administration & Non-Care Staff | - | - | - | - | |||
| Total Labour Paid Hours and External Service Hours | - | - | - | - | |||
| ← | Approved Provider Income & Expenditure Statement 2021-22 | |||
| Income | ||||
| Operating Income: | ||||
| ◦ Operating Income | $0.00 | |||
| Total Operating Income | $0.00 | calculated | ||
| Investment Income: | ||||
| ◦ Investment Income (Loss) Realised | $0.00 | |||
| ◦ Interest Income | ||||
| - Related Parties | $0.00 | |||
| - Non Related Parties | $0.00 | |||
| Total Investment Income | $0.00 | calculated | ||
| Total Recurrent Income | $0.00 | calculated | ||
| Non-Recurrent Income: | ||||
| ◦ Donations, Bequests and Fundraising | $0.00 | |||
| ◦ Fair Value Gains on Financial Assets | $0.00 | |||
| ◦ Fair Value Gains on Non-Current Assets | $0.00 | |||
| ◦ Grants Received | $0.00 | |||
| ◦ Impairment Gain | $0.00 | |||
| ◦ Realised Gains on Disposal of Assets | $0.00 | |||
| ◦ Effect of Adoption of AASB 16 Leases | $0.00 | |||
| ◦ COVID-19 Funding | $0.00 | |||
| ◦ Other Non-Recurrent Income | $0.00 | |||
| Total Non-Recurrent Income | $0.00 | calculated | ||
| Total Income | $0.00 | calculated | ||
| Expenses | ||||
| ◦ Salaries and Employee Benefits | $0.00 | |||
| ◦ Depreciation | $0.00 | |||
| ◦ Amortisation | $0.00 | |||
| ◦ Rent for Buildings | ||||
| - Related Parties | $0.00 | |||
| - Non Related Parties | $0.00 | |||
| ◦ Management Fees | ||||
| - Related Parties | $0.00 | |||
| - Non Related Parties | $0.00 | |||
| ◦ Finance Expenses | ||||
| - Related Parties | $0.00 | |||
| - Non Related Parties | $0.00 | |||
| ◦ Other Expenses | $0.00 | |||
| Total Recurrent Expenses: | $0.00 | calculated | ||
| Non-Recurrent Expenses: | ||||
| ◦ Fair Value Losses on Financial Assets | $0.00 | |||
| ◦ Fair Value Losses on Non-Current Assets | $0.00 | |||
| ◦ Impairment Loss | $0.00 | |||
| ◦ Realised Losses on Disposal of Assets | $0.00 | |||
| ◦ Effect of Adoption of AASB 16 Leases | $0.00 | |||
| ◦ COVID-19 Expenses | $0.00 | |||
| ◦ Other Non-Recurrent Expenses | $0.00 | |||
| Total Non-Recurrent Expenses | $0.00 | calculated | ||
| Total Expenses | $0.00 | calculated | ||
| Net Profit (Loss) before Tax: | $0.00 | calculated | ||
| Other Items: | ||||
| ◦ Income Tax Expense (Benefit) | $0.00 | |||
| ◦ Other Comprehensive Income (Loss) | $0.00 | |||
| Total Comprehensive Income / (Loss) for the Year: | $0.00 | calculated | ||
| Check (GPFS Net Profit) | check | |||
| Distributions/Dividends: | ||||
| ◦ Paid or Proposed | $0.00 |
| ← | Approved Provider Balance Sheet 2021-22 | |||
| Assets | ||||
| Receivable Within 12 months: | ||||
| ◦ Cash and Cash Equivalents | $0.00 | input | ||
| ◦ Financial Assets | $0.00 | linked | ||
| ◦ Trade Receivables (less Provision for Doubtful Debts) | $0.00 | input | ||
| ◦ Refundable Loans Receivable |
$0.00 | linked | ||
| ◦ Loans Receivable - Related Parties | $0.00 | linked | ||
| ◦ Loans Receivable - Non-Related Parties | $0.00 | linked | ||
| ◦ Other Assets | $0.00 | input | ||
| Total Receivable Within 12 months | $0.00 | calculated | ||
| Receivable After 12 months: | ||||
| ◦ Financial Assets | $0.00 | linked | ||
| ◦ Loans Receivable - Related Parties | $0.00 | linked | ||
| ◦ Loans Receivable - Non-Related Parties | $0.00 | linked | ||
| ◦ Capital Work in Progress | $0.00 | linked | ||
| ◦ Property, Plant and Equipment | $0.00 | linked | ||
| ◦ Right-of-use Assets | $0.00 | linked | ||
| ◦ Investment Properties | $0.00 | linked | ||
| ◦ Intangible Assets | ||||
| - Bed Licences | $0.00 | linked | ||
| - Goodwill | $0.00 | linked | ||
| - Other | $0.00 | linked | ||
| ◦ Other Assets | $0.00 | input | ||
| Total Receivable After 12 months | $0.00 | calculated | ||
| Total Assets | $0.00 | calculated | ||
| Liabilities | ||||
| Payable Within 12 months: | ||||
| ◦ Refundable Resident Loans | $0.00 | linked | ||
| ◦ Loans Payable - Related Parties | $0.00 | linked | ||
| ◦ Borrowings - External | $0.00 | linked | ||
| ◦ Employee Benefits/Provisions | $0.00 | input | ||
| ◦ Unspent Home Care Package Funds | $0.00 | linked | ||
| ◦ Unspent CHSP Grants | $0.00 | input | ||
| ◦ Lease Liabilities | $0.00 | input | ||
| ◦ Other Liabilities | $0.00 | input | ||
| Total Payable Within 12 months | $0.00 | calculated | ||
| Payable After 12 months: | ||||
| ◦ Refundable Resident Loans | $0.00 | linked | ||
| ◦ Loans Payable - Related Parties | $0.00 | linked | ||
| ◦ Borrowings - External | $0.00 | linked | ||
| ◦ Employee Benefits/Provisions | $0.00 | input | ||
| ◦ Lease Liabilities | $0.00 | input | ||
| ◦ Other Liabilities | $0.00 | input | ||
| Total Payable After 12 months | $0.00 | calculated | ||
| Total Liabilities | $0.00 | calculated | ||
| Net Assets | $0.00 | calculated | ||
| Equity | ||||
| ◦ Issued Capital | $0.00 | input | ||
| ◦ Reserves | $0.00 | input | ||
| ◦ Retained Earnings (Losses) | $0.00 | input | ||
| Total Equity | $0.00 | calculated | ||
| External Lines of Credit | ||||
| Refunding Refundable Accommodation Payments/Accommodation Bonds | ||||
| ◦ Drawn | $0.00 | input | ||
| ◦ Undrawn | $0.00 | input | ||
| Other | ||||
| ◦ Drawn | $0.00 | input | ||
| ◦ Undrawn | $0.00 | input | ||
| Key Ratios | ||||
| Liquidity ratio | #DIV/0! | calculated | ||
| Capital adequacy ratio | #DIV/0! | calculated | ||
| Check (GPFS Net Assets) | check | |||
no reviews yet
Please Login to review.
