jagomart
digital resources
picture1_Spreadsheet For Expenses 40973 | Draft Aged Care Financial Report Expenditure Statement 2021 22 Draft Acfr Expenditure Statement 2021 22


 184x       Filetype XLSX       File size 0.04 MB       Source: www.health.gov.au


File: Spreadsheet For Expenses 40973 | Draft Aged Care Financial Report Expenditure Statement 2021 22 Draft Acfr Expenditure Statement 2021 22
sheet 1 hcp i amp e larr home care package hcp income amp expenditure statement 202122 total home care centrally held aged care planning region 1 aged care planning region ...

icon picture XLSX Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Partial file snippet.
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 - - - -


Sheet 2: AP (I&E)
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


Sheet 3: AP (Balance Sheet)
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






The words contained in this file might help you see if this file matches what you are looking for:

...Sheet hcp i amp e larr home care package income expenditure statement total centrally held aged planning region direct services domestic nursing allied health other subcontracted management service fees exit amounts deducted fee charged to customers for purchasing an item or on the consumers behalf covid funding expenses internal costs wages and salaries employee registered nurses enrolled licensed with nmba personal staffother unlicensed staff subtotal labour cost agency payroll tax related motor vehicle external brokered client organisation providers etc self employed individual brokering consumables modifications capital purchases transport franchise royalty advertising case administration support noncare workers compensation insurance educationtraining quality control expense general insurances rent utilities property outgoings it communication corporate recharge depreciation interest net profit loss before from consolidated unspent funds opening balance commonwealth subsidies supp...

no reviews yet
Please Login to review.