Inquiries and reports

The Care Services inquiries and reports are in Care services > Inquiries and reports. Each inquiry opens an on-screen grid; each report opens a dialog where you set the parameters and output destination before it runs.

Daily client revenue

Navigate to: Care services > Inquiries and reports > Daily client revenue

The Daily client revenue inquiry shows the total daily revenue for each client, broken down by revenue source. One line is shown for each client service entry, with the billing schedule, funding schedule, accommodation payment and DMF revenue that makes up the daily total.

Field	Description	Where to find / set up
Payment method	The client’s payment method (for example Lumpsum or Combination).	The client’s accommodation payment record: Care services > Schedule > Accommodation payments.
Type	The accommodation payment status (for example RAD/DAP, Partially supported-RAC/DAC, Fully supported, Home care with means).	The Supported/Accommodation Payment Status on the client’s accommodation payment record: Care services > Schedule > Accommodation payments.
Agreed amount	The agreed accommodation payment amount.	The client’s accommodation payment record: Care services > Schedule > Accommodation payments.
Care type	The care type for the service (for example Residential, Home Care).	Care services > Setup > Care types.
Customer account	The customer account.	Care services > Customers > All customers.
Entry date	The client’s entry date for the service entry.	The client’s entry event: Care services > Schedule > Events.
Service code	The service (facility) code.	Care services > Setup > Service > All services.
Service entry	The client’s service entry.	The client’s service entry on the customer record: Care services > Customers > All customers.
Place	The place the client occupies.	Care services > Setup > Service > Places.
Billing schedule revenue	The daily revenue from the billing schedule.	Calculated from the client’s billing schedule lines: Care services > Schedule > Billing schedule.
Funding schedule revenue	The daily revenue from the funding schedule.	Calculated from the client’s funding schedule lines: Care services > Schedule > Funding schedule.
Accommodation payment revenue	The daily revenue from the accommodation payment.	Calculated from the client’s accommodation payment: Care services > Schedule > Accommodation payments.
DMF Revenue	The daily revenue from the Deferred Management Fee.	Calculated by the inquiry. The DMF is a retirement village fee; its ledger setup is the DMF journal in Care services > Setup > Care services parameters > Journals.
Total	The total daily revenue for the client (the sum of the revenue columns).	Calculated by the inquiry. Not set up anywhere.
Income/Means tested fees	The daily income or means tested fee.	Calculated by the inquiry from the client’s fees. There is no single setup field; it comes from the income/means tested fee billing on the client’s billing schedule.

In progress billing list

Navigate to: Care services > Inquiries and reports > In progress billing list

The In progress billing list is a report of customer billing transactions that have not yet been posted — the lines sitting in unposted Care Services billing journals. Use it to review what is waiting to be posted. The report takes no parameters of its own; choose the output destination and run it (or run it as a batch).

Field	Description	Where to find / set up
Client account	The client (customer) account the billing line is for.	Care services > Customers > All customers.
Customer name	The customer name.	From the customer record: Care services > Customers > All customers.
Billing Code	The billing code on the line.	Care services > Setup > Billing > Billing codes.
Service code	The service (facility) code.	Care services > Setup > Service > All services.
Service entry	The client’s service entry.	The client’s service entry on the customer record: Care services > Customers > All customers.
Value	The amount of the unposted billing line.	The billing journal line (from the billing schedule or entered manually): Care services > Journals > Billing journal.
Recurrence	The recurrence pattern for the line.	The billing schedule line / billing code recurrence: Care services > Schedule > Billing schedule; Care services > Setup > Billing > Billing codes.
Journal batch number	The batch number of the unposted billing journal the line belongs to.	Care services > Journals > Billing journal.
Modified by	The user who last modified the line.	Set by the system.
Voucher	The journal voucher for the line.	Set by the billing journal: Care services > Journals > Billing journal.

Service concessional/supported daily ratio

Navigate to: Care services > Inquiries and reports > Service concessional / supported daily ratio

The Service concessional/supported daily ratio inquiry shows, for each service (facility), the proportion of supported/concessional residents and whether it meets the threshold for the full accommodation supplement. The ratios are updated by the periodic Concessional/Supported ratio calculation job (Care services > Periodic > Concessional/Supported ratio calculation). One line is shown per service per calculated period.

Field	Description	Where to find / set up
Service	The service (facility) the ratio is for.	Care services > Setup > Service > All services.
Date	The date of the calculated period.	Set by the Concessional/Supported ratio calculation job (its Calculation date): Care services > Periodic > Concessional/Supported ratio calculation.
Threshold	The minimum supported/concessional resident ratio the service must meet to receive the full accommodation supplement (shown as a percentage).	Applied by the calculation from the legislated concessional-resident ratio. Not set on a Care Services setup field. (confirm with product/finance)
Discount	The reduction applied to the accommodation supplement when the service is below the threshold (shown as a percentage).	Applied by the calculation from the legislated reduction rate. Not set on a Care Services setup field. (confirm with product/finance)
Actual ratio	The service’s actual supported/concessional resident ratio for the period.	Calculated by the Concessional/Supported ratio calculation job.
Daily concessional support ratio id	The identifier of the calculated ratio record.	Generated by the system when the calculation runs.
Period type	Whether the ratio is calculated Daily or Monthly.	Set by the calculation.

Resident information

Navigate to: Care services > Inquiries and reports > Resident information

The Resident information inquiry lists each resident with their service entry, place, personal and demographic details, entry and departure dates, and contact information. One line is shown per resident service entry. It is a wide inquiry — use the column options to show or hide the columns you need.

The columns are grouped below.

Service and place

Field	Description	Where to find / set up
Service code / Service description / Service type	The service (facility) the resident is in.	Care services > Setup > Service > All services.
Service entry	The resident’s service entry.	The customer’s service entry: Care services > Customers > All customers.
Place / Place description / Place type	The place the resident occupies.	Care services > Setup > Service > Places.

Resident

Field	Description	Where to find / set up
Resident number	The customer account for the resident.	Care services > Customers > All customers.
Resident salutation / first / middle / last name	The resident’s name.	The customer record: Care services > Customers > All customers.
Customer statement name	The name used on statements, when set.	The customer record (used when Use customer statement name is on).
Partnered	Whether the resident is partnered.	The customer record.
Customer group	The resident’s customer group.	Care services > Customers > All customers (customer group).
Customer status	The resident’s status (for example Active).	Set by the system from the resident’s service entries.
Resident gender	The resident’s gender.	The customer record.
Date of birth / Resident age	The resident’s date of birth and current age.	The customer record (age is calculated from date of birth).
Method of payment	The resident’s method of payment.	The customer record / accommodation payment.

Stay

Field	Description	Where to find / set up
Entry date	The resident’s entry date.	The resident’s entry event: Care services > Schedule > Events.
Departure date	The resident’s departure date (blank if still in care).	The resident’s departure event: Care services > Schedule > Events.
Departure reason	The reason for departure.	Care services > Setup > Service > Departure reasons.
Number of days	The length of stay in days.	Calculated by the inquiry.

Resident contact details

Field	Description	Where to find / set up
Resident address	The resident’s address.	The customer’s addresses: Care services > Customers > All customers.
Resident email / Resident phone	The resident’s email and phone.	The customer’s contact information: Care services > Customers > All customers.
Purpose	The address/contact purpose shown.	Address and contact purposes (standard D365 contact purposes).

Contacts 1–4

The inquiry shows up to four of the resident’s related contacts. Each contact (Contact 1 to Contact 4) has the same set of fields: Salutation, First name, Middle name, Last name, Contact type, Email, Address and Phone.

Field	Description	Where to find / set up
Contact 1–4 (Salutation, First/Middle/Last name, Contact type, Email, Address, Phone)	The resident’s related contacts (for example next of kin, representative).	The contacts set up against the customer record: Care services > Customers > All customers. Contact type: Care services > Setup > Customers > Contact type.
Associated customer no / Associated customer name	The customer associated with the resident (for example a third party being billed).	The customer record / client associations: Care services > Customers > All customers.

Care services billing statement

Navigate to: Care services > Inquiries and reports > Care services billing statement

The Care services billing statement is a report of a resident/client’s billing transactions, payments and drawdowns from the accommodation payment, for a chosen period. Set the parameters, choose the output destination, and run it (or run it as a batch).

Parameter	Description	Default / notes
From date	First date of the statement period.	Defaults to the first day of the current month.
To date	Last date of the statement period.	Defaults to the last day of the current month.
Direct debit date	The direct debit date shown on the statement.	Defaults to the last day of the current month.
Legal entity for branding	The legal entity whose address and branding appear on the statement.	Legal entities: Organisation administration > Organisations > Legal entities.
Use print management destination	Yes uses the print management destination set up for the statement instead of the Print destination below.	Default No.
Apply invoice number	Yes shows an invoice number on the statement.	Default No.
Reference number type	The reference number type to show.	Care services > Setup > Customers > Reference number type.
Exclude marked transactions	Yes leaves out transactions marked to be excluded from invoices/statements.	Default Yes.
Print destination / Run in the background	Standard D365 output destination and batch options.	Default destination Screen.

Care services accommodation payment statement

Navigate to: Care services > Inquiries and reports > Care services accommodation payment statement

The Care services accommodation payment statement is a report of a resident/client’s accommodation payment transactions — lumpsum invoices, payments and drawdowns from the accommodation payment — for a chosen period.

Parameter	Description	Default / notes
From date	First date of the statement period.	Defaults to the first day of the current month.
To date	Last date of the statement period.	Defaults to the last day of the current month.
Legal entity for branding	The legal entity whose address and branding appear on the statement.	Legal entities: Organisation administration > Organisations > Legal entities.
Use print management destination	Yes uses the print management destination set up for the statement instead of the Print destination below.	Default No.
Print destination / Run in the background	Standard D365 output destination and batch options.	Default destination Screen.

Accommodation payment register

Navigate to: Care services > Inquiries and reports > Accommodation payment register

The Accommodation payment register is a report of resident/client accommodation payment agreed amounts, invoices, refunds, balances and refund due dates, as at a chosen date.

Parameter	Description	Default / notes
Register as at	The date to report the accommodation payment balances as at.	Enter the reporting date.
Full refund date	The date used to determine full refunds.	Enter the refund cut-off date.
Print destination / Run in the background	Standard D365 output destination and batch options.	Default destination Screen.

Refundable accommodation deposit balances

Navigate to: Care services > Inquiries and reports > Refundable accommodation deposit balances

The Refundable accommodation deposit balances inquiry shows the refundable accommodation payment balance for each resident, by balance date. The balances are produced by the periodic Calculate refundable accommodation deposit balances job (Care services > Periodic > Calculate refundable accommodation deposit balances).

Field	Description	Where to find / set up
Balance date	The date the balance is calculated for.	Set by the Calculate refundable accommodation deposit balances job.
Customer account	The customer account.	Care services > Customers > All customers.
Client id	The client identifier.	The customer/client record: Care services > Customers > All customers.
Service code	The service (facility) code.	Care services > Setup > Service > All services.
Accommodation payment type	The accommodation payment type.	The client’s accommodation payment record: Care services > Schedule > Accommodation payments.
Payment method	The client’s payment method (for example Lumpsum, Combination).	The client’s accommodation payment record: Care services > Schedule > Accommodation payments.
Refundable accommodation payment balance	The refundable accommodation deposit balance as at the balance date.	Calculated by the job from the client’s accommodation payment transactions.

Billing exception analysis

Navigate to: Care services > Inquiries and reports > Billing exception analysis

The Billing exception analysis compares the current period’s billing with the prior period’s billing and lists the differences (exceptions). It opens a parameters dialog, then a view with four tabs: Billing exceptions, Current period billing, Prior period billing and Address exceptions.

See Billing exception analysis for the parameters, the four tabs and how exceptions are matched.

Events register

Navigate to: Care services > Inquiries and reports > Events register

The Events register inquiry is a read-only list of client care events (entries, departures and leave), with the event and leave type, client, service and dates. The underlying events are maintained on the Events form (Care services > Schedule > Events).

Field	Description	Where to find / set up
Event ID	The identifier of the event.	Generated by the system on the Events form: Care services > Schedule > Events.
Event type code / Event type description	The type of event (for example Entry, Departure, Leave).	Care services > Setup > Services Australia integration > Event types.
Leave type code / Leave type description	The leave type, for leave events.	Care services > Setup > Services Australia integration > Leave types.
Client / Client name	The client the event is for.	Care services > Customers > All customers.
Start date / End date	The start and end of the event.	The event on the Events form: Care services > Schedule > Events.
Service / Service name	The service (facility) the event relates to.	Care services > Setup > Service > All services.
Service entry	The client’s service entry.	The customer’s service entry: Care services > Customers > All customers.

Billing journal generation automation history

Navigate to: Care services > Inquiries and reports > Billing journal generation automation history

The Billing journal generation automation history inquiry lists the billing journals created by the billing journal generation automation, with their status and creation details. See Billing journal automation for the automation setup.

Field	Description	Where to find / set up
Automation Id	The identifier of the automation run.	Generated by the billing journal generation automation.
Journal batch number	The batch number of the billing journal created.	Care services > Journals > Billing journal.
Description	The description of the automation run.	Set by the automation: Care services > Setup > Billing journal generation automation.
Status	The status of the run.	Set by the system.
Created date and time	When the run was created.	Set by the system.
Created by	The user (or batch account) that created the run.	Set by the system.

Support at home claim

Navigate to: Care services > Inquiries and reports > Support at home claim

The Support at home claim inquiry lists Support at Home claims made to Services Australia, with the service provider, payment statement and claim status.

Field	Description	Where to find / set up
Support at home claim Id	The identifier of the claim.	Generated by the system when the claim is created.
Organisation id	The organisation making the claim.	Care services > Setup > Services Australia integration > PRODA / Provider Digital Access (PRODA) Organisations.
Service provider id	The service provider the claim is for.	Care services > Setup > Support at home > Support at home service providers.
NAPS Id (Department service id)	The Services Australia (NAPS) service identifier.	The service record / Services Australia integration.
Funding payment statement Id	The funding payment statement the claim is linked to.	Care services > Funding > Funding claim payment statement.
Payment date	The payment date.	From Services Australia on the payment statement.
Claim status	The status of the claim.	Set by the system.

Support at home invoice

Navigate to: Care services > Inquiries and reports > Support at home invoice

The Support at home invoice inquiry lists Support at Home invoices, with the service provider, invoice status and the funding claim form they belong to.

Field	Description	Where to find / set up
Invoice Id	The identifier of the invoice.	Generated by the system when the invoice is created.
Service provider id	The service provider the invoice is for.	Care services > Setup > Support at home > Support at home service providers.
NAPS Id (Department service id)	The Services Australia (NAPS) service identifier.	The service record / Services Australia integration.
Invoice status	The status of the invoice.	Set by the system.
Funding claim form Id	The funding claim form the invoice belongs to.	Care services > Funding > Funding claim form.
Created at date time	When the invoice was created.	Set by the system.
Updated at date time	When the invoice was last updated.	Set by the system.
Async in progress	Whether an asynchronous update is in progress for the invoice.	Set by the system.