Difference between revisions of "Benefits Report"

From Charitylog Manual
Jump to: navigation, search
m
(10 intermediate revisions by 3 users not shown)
Line 1: Line 1:
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]
  
''Location in standard build:'' '''''[[Reports Tab]] > "General" section > Benefits'''''
+
[[File:Menu_benefitsreport.png]]
  
 +
The benefits report displays details of the benefits entered on the [[Referral Closure and Outcome Details]] screen or the [[Benefits and Income]] link at the bottom of a persons record.
  
[[file:cl_BR_1.png|border]]
+
When specifying dates the report will return results that match the criteria.  If you use more than one set of dates then the data entered must match both date ranges.  If the date field is blank on the recorded benefit then this will not be displayed on the report if dates have been specified in the search criteria.  For branch systems select the branch tab to select which branches to report on.
 +
{{#ev:youtube|HvLJBC_IPDQ|790}}
  
 +
[[File:Reports_benefitscriteria.png]]
  
Charitylog's Benefits Report provides reports on data entered using the [[Benefits and Income]] feature, which is designed to hold details of a client's income/benefits and track and manage benefit applications.
+
* '''Date Applied - from''' - Includes benefits applied for from this date up to the 'to' date.
 +
* '''Date Applied - to''' - Includes benefits applied for up to this date from the 'from' date.
 +
* '''Date Awarded - from''' - Includes benefits awarded from this date up to the 'to' date.
 +
* '''Date Awarded - to''' - Includes benefits awarded up to this date from the 'from' date.
 +
* '''Date Ended - from''' - Includes benefits ending from this date up to the 'to' date.
 +
* '''Date Ended - to''' - Includes benefits ending up to this date from the 'from' date.
 +
* '''Date Notified (to us) - from''' - Includes benefits notified from this date up to the 'to' date.
 +
* '''Date Notified (to us) - to''' - Includes benefits notified up to this date from the 'from' date.
 +
* '''Benefit Obtained By Staff Member?''' - Select the user(s) you wish to report on.  This would be for benefits that your organisation has assisted with.
 +
* '''Means Tested?''' - Filter by means tested benefits if required.
 +
* '''Benefit''' - Allows you to filter by specific benefits.
 +
* '''Order By''' - Specifies the display order.
 +
* '''Benefits Obtained By Us?''' - Obtained by us is benefits that your organisation has assisted with.
 +
* '''Confirmed Or Estimated?''' - Filter by the status of the benefit:
 +
** '''Confirmed''' - Service user has been notified and your organisation has been notified that the claim was successful.
 +
** '''Unconfirmed''' -  The is known as a potential benefit, it has been applied for but no notification has been received.
 +
** '''No Entitlement''' - The service user has been notified that they are not entitled to the benefit that they applied for.
 +
** '''Rejected - Appealing''' - The service user has been informed that they are not entitled but are appealing against the decision.
 +
** '''No pursuit of claim''' - Generally when a claim is stalled for further details or investigation and the service user is no longer engaging in the claim.
 +
* '''Linked To Referrals For Which Project?''' - This filters by benefits linked to a referral of the selected project.  On All/Not linked this will return results for benefits that have been linked to a referral and benefits not linked to a referral.
  
The report format is similar to the [[Extension Database Reports|Extension Database Report]] in that there is essentially one filter per field in the "benefits" section.
+
Click the 'Display in Browser' button to run the report.
  
 +
[[File:Reports_benefitsrep.png]]
  
===Date filters===
+
The report will have a [[Blue Folder Lookup]] icon [[File:Icon_bluefolder.PNG|link=Blue Folder Lookup]] per sub totalled line and for the report total.
 
 
The report allows you to filter the output by various dates - there are options for '''Date Applied''', '''Date Awarded''', '''Date Ended''' and '''Date Notified'''. These correspond to date fields on the "benefits" section of [[Benefits and Income]].
 
 
 
If a date range is entered in these search fields, any records with blank dates will be excluded from the results (however, as is usual with Charitylog reports, if you leave all fields blank, the report will return all results with no filtering - even those with blank dates).
 
 
 
[[file:cl_BR_2.png|border]]
 
 
 
 
 
===Other filters===
 
 
 
[[file:cl_BR_3.png|border]]
 
 
 
 
 
* '''Benefit Obtained By Staff Member?''' - filter by which staff member is recorded as linked to the benefit data
 
* '''Means Tested?''' - choose to see means tested benefits, non means tested benefits, or both
 
* '''Benefits Obtained By Us?''' - you can record information in the [[Benefits and Income]] area about benefits that were obtained by other organisations, etc. Choose whether to see these in the reporting output or not.
 
* '''Confirmed or Estimated?'''
 
* '''Linked To Referrals For Which Project?''' - optionally, benefit data can be linked to a Referral, and therefore to a Project. You can choose here whether to view all data (which will include data which is not linked to any Referral), or only data linked to Referrals within a specific Project.
 
 
 
 
 
===Output options===
 
 
 
* '''Order By''' - choose from Benefit, Project, Client Name, any of the key dates, or Staff Member.
 
 
 
  
 
----
 
----
[[User:Rob Kay|Rob Kay - manual author]] ([[User talk:Rob Kay|talk]]) 16:55, 7 June 2017 (BST)
 
[[Category:Reporting]]
 
 
[[File:helpheader_small.png|right]]
 
[[File:helpheader_small.png|right]]

Revision as of 13:09, 13 April 2023

Helpheader small.png

Menu benefitsreport.png

The benefits report displays details of the benefits entered on the Referral Closure and Outcome Details screen or the Benefits and Income link at the bottom of a persons record.

When specifying dates the report will return results that match the criteria. If you use more than one set of dates then the data entered must match both date ranges. If the date field is blank on the recorded benefit then this will not be displayed on the report if dates have been specified in the search criteria. For branch systems select the branch tab to select which branches to report on.

Reports benefitscriteria.png

  • Date Applied - from - Includes benefits applied for from this date up to the 'to' date.
  • Date Applied - to - Includes benefits applied for up to this date from the 'from' date.
  • Date Awarded - from - Includes benefits awarded from this date up to the 'to' date.
  • Date Awarded - to - Includes benefits awarded up to this date from the 'from' date.
  • Date Ended - from - Includes benefits ending from this date up to the 'to' date.
  • Date Ended - to - Includes benefits ending up to this date from the 'from' date.
  • Date Notified (to us) - from - Includes benefits notified from this date up to the 'to' date.
  • Date Notified (to us) - to - Includes benefits notified up to this date from the 'from' date.
  • Benefit Obtained By Staff Member? - Select the user(s) you wish to report on. This would be for benefits that your organisation has assisted with.
  • Means Tested? - Filter by means tested benefits if required.
  • Benefit - Allows you to filter by specific benefits.
  • Order By - Specifies the display order.
  • Benefits Obtained By Us? - Obtained by us is benefits that your organisation has assisted with.
  • Confirmed Or Estimated? - Filter by the status of the benefit:
    • Confirmed - Service user has been notified and your organisation has been notified that the claim was successful.
    • Unconfirmed - The is known as a potential benefit, it has been applied for but no notification has been received.
    • No Entitlement - The service user has been notified that they are not entitled to the benefit that they applied for.
    • Rejected - Appealing - The service user has been informed that they are not entitled but are appealing against the decision.
    • No pursuit of claim - Generally when a claim is stalled for further details or investigation and the service user is no longer engaging in the claim.
  • Linked To Referrals For Which Project? - This filters by benefits linked to a referral of the selected project. On All/Not linked this will return results for benefits that have been linked to a referral and benefits not linked to a referral.

Click the 'Display in Browser' button to run the report.

Reports benefitsrep.png

The report will have a Blue Folder Lookup icon Icon bluefolder.PNG per sub totalled line and for the report total.


Helpheader small.png