X9.4 Release Notes - January 2024
      Back to home
      1. Entire OnHire Knowledge Base
      2. What's New - Release Notes
      3. X9.4 Release Notes - January 2024

      9.4 - BETA Feature - Client Portal Financial Reporting

      Introduction

      The Financial Reporting Beta feature in the Client Portal 2.0 generates the finance report related to Booking and Invoice details. The Booking and Invoice records are extracted based on the provided filter details. The client can view, download, and email the required invoices/ timesheets.

      How to Generate Financial Report?

      To generate the Financial Reporting Details:

      • Provide the Service Location, Delivery Location, Date Search, Date Range, and Grouping filters
      • Check/ Uncheck the Include checkbox for the Invoiced/ Uninvoiced report
      • Click Get Report
      • Based on the Grouping applied, the Financial Reporting details are generated for the Invoiced/ Uninvoiced data
      • The Report shows the Record(s) Count, Tax, and Amount details

      FinancialREporting1-1

      Filters in Financial Reporting

      The Financial Reporting Filters retrieve specific reports based on the filter criteria provided. You must select the required filters to extract the financial report as per your requirement and it is mandatory to select the filter marked with a red asterisk.

      Filter Name

      Description

      1. Service Location

      Select the Service Location(s).

      The Service Locations linked with the different branches cannot be selected together and if selected locations are linked with different branches, a validation message is displayed. 

      2. Delivery Location

      Select the Delivery Location(s) associated with the selected Service Location.
      3. Date Search

      Select the Date Search as Shift Work Date or Invoice Date.

      • Shift Work Date fetches all the shifts available for the selected date range.
      • Invoice Date fetches all the shifts that are invoiced for the selected date range.
      4. Date Range

      Select the Date Range by clicking the Date Range Link.

      The Date Range can be Custom Date Range, This Week, This Month, This Quarter, This Financial Year, Last Week, Last Month, Last Quarter, Last Financial Year, Month to Date, Quarter To Date, or Year To Date.

      For the Custom Date Range, provide the Start Date and End Date.
      5. Grouping

      Select the Grouping options required for the data.

      Grouping facilitates to organise the data into related sets. The grouping options available are Invoice Number, Qualification, Members, Delivery Location, Order Number, or None.

      Based on the selected Grouping, the data is arranged and displayed.
      6. Include

      Select the Invoiced and Uninvoiced checkboxes. You can select any or both the options. 

       

      FinancialREporting2

      When you provide the filter criteria and click Get Report, the data extracted can be further filtered based on the subset filters selected. The financial report data is filtered and displayed by clicking any of the subset filters.

      Filter Name

      Description
      1. Total Shifts/ Hours (hh:mm) Filters data based on Total Shifts/ Hours.
      2. Invoiced Shifts Filters data based on Shifts that are invoiced.
      3. Uninvoiced Shifts Filters data based on Shifts that are not invoiced.
      4. Members Worked Filters data based on members who worked in the shifts.
      5. Total Invoices Filters data based on the number of invoices raised.
      6. Invoices Amt (incl. Tax) Filters data based on the amount of invoices including taxes.
      7. Qualifications Booked Filters data based on the booked qualifications of the members.

       

      FinancialREporting3

      Grouping in Financial Reporting

      Depending on the Grouping filter selected (Invoice Number, Qualification, Members, Delivery Location, Order Number, or None), the Grouping Applied is shown with the Invoiced/ Uninvoiced data.

      FinancialREporting4

      On clicking the Get Report for the selected filters, the Invoiced/ Uninvoiced records show the Service Location, Delivery Location, Invoice Email, Invoice Sent on, Shift Hours (hh: mm), Number of Shift(s), Status, Tax, Invoice Date, Invoice No, Due Date, and Amount details for each record.

      For the Uninvoiced Shifts, the invoiced details will not be shown.

      Field Name

      Description

      Service Location

      Shows the Service Location.

      Delivery Location

      Shows the Delivery Location(s) associated with the selected Service Location (if any).
      Invoice Mail

      Shows the recipient's email address to whom the email was sent.
      Invoice Sent on Shows the date on which the invoice was sent.
      Shift Hours (hh:mm) Shows the total number of Shift Hours.
      Number of Shift(s) Shows the total count of shifts that are available in the record.
      Status

      Shows the Status as Invoiced or Uninvoiced.

      Invoiced Status is highlighted in Green and Uninvoiced Status is highlighted in Red.
      Tax Shows the total applicable tax amount.
      Invoice Date Shows the date of the invoice.
      Invoice No

      Shows the Invoice Number with the link (when the Status is Invoiced). Click the link to view the invoice details. In the Invoice Viewer, you can:

      1. Email - To send this invoice by email, click Email and enter the recipient's email address.

      2. Download - To download this invoice, click Download.
      FinancialREporting6-1

      Due Date

      		 Shows the due date for payment of the invoice.
      Amount Shows the total invoice amount.

       

      FinancialREporting5

      For detailed documentation, click this link.